Support Questions
Find answers, ask questions, and share your expertise

NiFi: SelectHiveQL processor

Solved Go to solution
Highlighted

NiFi: SelectHiveQL processor

Rising Star

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

Accepted Solutions

Re: NiFi: SelectHiveQL processor

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.

View solution in original post

3 REPLIES 3

Re: NiFi: SelectHiveQL processor

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.

View solution in original post

Highlighted

Re: NiFi: SelectHiveQL processor

Cloudera Employee

What does your SQL statement look like?

Highlighted

Re: NiFi: SelectHiveQL processor

Rising Star

select header.timestamp from temp