Forum Discussion
Teradata Import Query Error
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.
Can you try SELECT EXTRACT(YEAR FROM DATE_FIELD)?
3 Replies
Can you try SELECT EXTRACT(YEAR FROM DATE_FIELD)?
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)?
