Hi Boris, True, multi-statements support has been added to SelectHiveQL, but not to ExecuteSQL/PutSQL. As a workaround you could try to specify config params on JDBC connection string when you define controller service:
jdbc:impala://Host:Port[/Schema];Property1=Value;Property2=Value;... If you can use Hive driver to access Impala: jdbc:hive2://host:port/;principal=principal_name;Property1=Value;Property2= Value;... Some params will be working after "?" in URL: jdbc:hive2://host:port/;principal=principal_name?Property1=Value;Property2= Value;... But, if you really can use Hive drivers, then you can use PutHiveQL and ExecuteHiveQL. Both support multi-statements. Regards. Ed. On Wed, Aug 15, 2018 at 11:11 AM Boris Tyukin <[email protected]> wrote: > Hi guys, > > I need to issue a query like below on Impala. it works fine from > impala-shell but NiFi seems not to like multiple statements like that. > > set max_row_size=7mb; > > create table blabla as > select blabla > from blablabla; > > > I thought it was addressed in 1.7 but I got it confused with Hive > processors and this Jira > https://issues.apache.org/jira/browse/NIFI-5044 > > Is there something in work already to address it or should I open a new > Jira? > > For now, I am going to use Groovy script but if anyone knows a better > workaround, please let me know. > > Boris >
