Re: Error Using NiFi ExecuteSQL Process to set que...

Wevo · ‎03-12-2020

Thanks for the note @ask_bill_brooks, but the problem isn't with the Teradata statement that I'm submitting. The issue is with how the ExecuteSQL processor is parsing the statement. The statement itself works fine when subumitted in the SQL Select query area of the ExecuteSQL processor. The SQL pre-query is expecting a semicolon delimited list of statements and hence the semicolon in the set query band statement is causing an incomplete statement to be submitted.

Wevo · ‎03-11-2020

Hi, I'm trying to set a query band in Teradata using NiFi. Here's the statement: SET QUERY_BAND = 'LOB=LOB_NAME||Region=REGION_NAME||SourceApp=NiFi||AppName=${Job};' FOR SESSION When I run this in the SQL Pre-Query portion of the of the ExecuteSQL processor, I get a error saying the string the string is not terminated. The processor is splitting the string at the semicolon in the set query band statement (which is how the ExecuteSQL processor is supposed to work). Is there a way to force the processor to ignore the semicolon that exists in the middle of string?

Online	Offline
Last Visited	‎11-16-2021 05:11 PM

Date Registered	‎03-11-2020 03:26 PM
Last Visited	‎11-16-2021 05:11 PM
Total Messages Posted	2

Re: Error Using NiFi ExecuteSQL Process to set que...

Error Using NiFi ExecuteSQL Process to set query_b...