How to drop duplicates using nifi selectHIVEQL ?

[#1]

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

Hope someone can help 

Thanks in advance 

[#2]

Hello

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

Maybe try SELECT DISTINCT?