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

[#1]

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

[#2 · Accepted solution]

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

[#3]

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.

[#4]

Thank you for the quick reply, Matt