I' ve added max( ) on a column you don' t have in your GROUP BY. I' m trying to create a query in Teradata but it gives me REPLACE VIEW Failed. 3706: Syntax error: expected something between ' ) ' and ', '. Hi TD newbie here, am getting the 3706: Syntax error: expected something between ' ) ' and ', '. for the following query SELECT. QueryEngine encountered error: Execute Query failed. Syntax error: expected something between ', ' and the end of the request. The error, SQL- 3706 is a generic error message relating to the syntax of the SQL. tbuild is a TPT ( Teradata Parallel Transporter) CLI, in the same manner bteq is a query CLI. You execute it from the command line, not from.
I' ve formatted your code and removed some redundant parentheses.