Script(s)

technology as-is

Hive Error : SemanticException TOK_ALLCOLREF

| 0 comments

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

Required fields are marked *.