Support Questions

Find answers, ask questions, and share your expertise

How to drop duplicates using nifi selectHIVEQL ?

avatar
Explorer

Hello Guys I'm using selecHiveQl to get data from Hive but I'm geting data repeatedly ?

Hope someone can help 

Thanks in advance 

totti1_0-1618944864421.png

 

 

1 REPLY 1

avatar
Expert Contributor

Hello

 

I am not sure the data in your Hive table got duplicates?

Maybe try SELECT DISTINCT?