Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Contributor

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

avatar
Master 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

avatar
Master 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.

avatar
Master Guru

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