question Re: Nifi: What is the best way to issue a SQL CREATE table command? in Archives of Support Questions (Read Only)

Nifi: What is the best way to issue a SQL CREATE table command?

ben_costanza — Fri, 12 Aug 2016 02:40:24 GMT

It seems that there are processor options for SQL INSERT, UPDATE and SELECT, but what about other commands? CREATE for example?

My understanding is that ExecuteSQL is not intended for this as it expects rows back (description states that it is for SELECT). So, how else would / should I do this (and similar, i.e, generic SQL commands that may not necessarily involve data directly)?

Re: Nifi: What is the best way to issue a SQL CREATE table command?

sunile_manjee — Fri, 12 Aug 2016 03:30:25 GMT

@Ben

An option to consider if you want to run other types of DDL is via executeprocess process. Within this processor you can script up the activities not perform OOB with NiFi.

Re: Nifi: What is the best way to issue a SQL CREATE table command?

mburgess — Fri, 12 Aug 2016 20:44:49 GMT

The PutSQL processor issues statements and does not expect a ResultSet to be returned, you can use that to issue DDL/DML commands.