Support Questions

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

Could NIfi - executeSQL process run sql to join tables from two differeent Databases?

avatar
Rising Star

Could NIfi Nifi - executeSQL process run sql to join two Databases?

1 ACCEPTED SOLUTION

avatar
Master Mentor
@Andy Liang

-

The ExecuteSQL processor only supports "Select" statements.

-

Also see:

https://community.hortonworks.com/questions/64667/joining-tables-within-nifi.html

-

Thank you,

Matt

-

If you found this Answer addressed your original question, please take a moment to login and click "Accept" below the answer.

View solution in original post

3 REPLIES 3

avatar
Master Mentor
@Andy Liang

-

The ExecuteSQL processor only supports "Select" statements.

-

Also see:

https://community.hortonworks.com/questions/64667/joining-tables-within-nifi.html

-

Thank you,

Matt

-

If you found this Answer addressed your original question, please take a moment to login and click "Accept" below the answer.

avatar
Master Guru

You can use a JOIN clause in the select statement, but it will only work for a single RDBMS. You may find you can join two tables from two databases/schemas in the same RDBMS (if that system lets you), but you can't currently join two tables from totally separate database systems. You could investigate Presto, it allows for joining of tables across multiple systems, and you could have a single connection to it from NiFi in ExecuteSQL. That way it will look like a single RDBMS to NiFi, but Presto can be configured to do the cross-DB join.

avatar
Rising Star

Thank you for the quick reply, Matt