Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

NiFi: SelectHiveQL processor

avatar
Expert Contributor

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

1 ACCEPTED SOLUTION

avatar
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
3 REPLIES 3

avatar
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

avatar
Contributor

What does your SQL statement look like?

avatar
Expert Contributor

select header.timestamp from temp