Hive Error : SemanticException TOK_ALLCOLREF

Hive Error : 

SemanticException TOK_ALLCOLREF is not supported in current context

Reason : 

Select Distinct * From <tablename>

Solution :

Hive doesn’t support  distinct *, so  mention the column names

Select Distinct col1, col2, col3… From <tablename>

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.