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

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

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)?

1 ACCEPTED SOLUTION

Super Guru

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

View solution in original post

2 REPLIES 2

Super Guru
@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.

Super Guru

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

; ;