HomeHive

Hive Error : SemanticException TOK_ALLCOLREF

Like Tweet Pin it Share Share Email

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>

 

Comments (0)

Leave a Reply

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