I have column in hive table like below Now I want to get the distinct values as a variable so I can use in another query. I have done like below when I do I get below error what the the mistake I am doing? What is the correct way of achieving my result? Note: I know I can use