Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Solved Go to solution
Highlighted

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

Explorer

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

1 ACCEPTED SOLUTION

Accepted Solutions

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

Master Guru
@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 REPLIES 3

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

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

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

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

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

Explorer

Thank you for the quick reply, Matt

Don't have an account?
Coming from Hortonworks? Activate your account here