Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.