Support Questions

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

Joining tables by creating a view and querying the view using querydatabasetable

avatar
Expert Contributor

Hi All,

Thanks a lot this awesome community.

I read tha JOIN queries are not possible in NiFi,

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

so I thought of a workaround by creating a view in the database and then queriyng the view

so I will be using tablename as the view name in the properties of querydatabasetable, I do not have a sample database, is this something which can be done?

Thanks

1 ACCEPTED SOLUTION

avatar
Master Guru
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
3 REPLIES 3

avatar
Expert Contributor

@Shu

Thanks a lot for confirming, appreciate it.

avatar
Master Guru
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

avatar
Expert Contributor

@Shu Appreciate your help This is as clear an explanation as it can get Thanks again