Raghav, This is not currently possible inside NiFi. However, you could use Presto [1] to set up connections to each database, then you could create a DBCPConnectionPool in NiFi to connect to Presto, and issue the JOIN query with ExecuteSQL. There is an example of joins across databases here [2].
Regards, Matt [1] https://prestodb.io/ [2] http://getindata.com/blog/tutorials/tutorial-using-presto-to-combine-data-from-hive-and-mysql-in-one-sql-like-query/ On Thu, Oct 27, 2016 at 11:49 AM, raghav130593 <raghav130...@gmail.com> wrote: > Hi, > So I have this use case where I want to get tables from different data > sources into NiFi and perform join operation between these tables and get > the results using the select query. For example, select query on one table > from teradata, select query on one from DB2, etc. and then be able to join > them and compare within NiFi. Is it possible to do a join after getting them > in using ExecuteSQL processor inside NiFi? I want to see if there is a way > without getting all necessary tables in a single datasource. > > Thanks, > Raghav > > > > -- > View this message in context: > http://apache-nifi-developer-list.39713.n7.nabble.com/is-it-possible-to-perform-DML-statements-on-data-from-different-database-products-that-has-been-loadi-tp13754.html > Sent from the Apache NiFi Developer List mailing list archive at Nabble.com.
