Created 12-09-2016 05:33 AM
I have an external table with the keyword timestamp as one of the column name. Unlike hive shell that provides option to turnoff keyword validation like below, is there a way to execute the SELECT query in the above processor?
set hive.support.sql11.reserved.keywords=false;
I get the following error if I try to execute the query through the SelectHiveQL processor
Failed to recognize predicate 'timestamp'. Failed rule: 'identifier' in table or column identifier
Created 12-09-2016 01:53 PM
Have you tried adding this 'set' statement as the first line of the query, terminated by a semicolon with newline? Next, try quoting the column name, too.
Created 12-09-2016 01:53 PM
Have you tried adding this 'set' statement as the first line of the query, terminated by a semicolon with newline? Next, try quoting the column name, too.
Created 12-09-2016 05:08 PM
What does your SQL statement look like?
Created 12-10-2016 06:35 AM
select header.timestamp from temp