Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am able to run the query below in Teradata without any errors
SELECT YEAR(DATE_FIELD) AS DATE_YEAR ,A.FIELD_1 ,A.FIELD_2 ,B.FIELD_3 ,SUM(AMT_1) AS SUM_AMT_1 ,SUM(AMT_2) AS SUM_AMT_2 FROM TABLE_1 AS A LEFT JOIN TABLE_2 AS B ON A.FIELD_1 = B.FIELD_1 GROUP BY YEAR(DATE_FIELD),FIELD_1,FIELD_2,FIELD_3
but when entered into the SQL Statement section of the Teradata database connection window I get the an error that looks like a Teradata error saying:
DataSource.Error: Teradata: [Teradata Database] [3706] Syntax error: expected something between the 'SELECT' keyword and the 'YEAR' keyword.
I am using Import as the connection type. Is there a function other than YEAR() that should be used? What is the true cause of this error as I know the syntax is correct.
Solved! Go to Solution.
Thanks, that worked! Is there a reference or guide somewhere that outlines which functions do and do not work as with YEAR()? Because SUM() worked without any issue and I could not find any resources that said what I should use instead of YEAR().
I tried select year(from date_field) but I got the same error message. Perhaps your teradata client somehow translates it into extract(year from date_field)?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |