Error Message: TOK_ALLCOLREF is not supported in current context - while Using DISTINCT in HIVE

sql hadoop hive distinct bigdata
user3107144 picture user3107144 · Jan 13, 2014 · Viewed 24.8k times · Source

I'm using the simple command: SELECT DISTINCT * FROM first_working_table; in HIVE 0.11, and I'm receiving the following error message:

FAILED: SemanticException TOK_ALLCOLREF is not supported in current context.

Does anyone know why this is happening? How can we solve it?

Thank you, Gal.

Answer

Nigel Tufnel picture Nigel Tufnel · Jan 13, 2014

Hive doesn't support DISTINCT * syntax. You can manually specify every field of the table to get the same result:

SELECT DISTINCT field1, field2, ...., fieldN
  FROM first_working_table

Related questions

distinct vs group by which is better

for the simplest case we all refer to: select id from mytbl group by id and select distinct id from mytbl as we know, they generate same query plan which had been repeatedly mentioned in some items like Which is …

Read More
Hive insert query like SQL

I am new to hive, and want to know if there is anyway to insert data into hive table like we do in SQL. I want to insert my data into hive like INSERT INTO tablename VALUES (value1,value2..) I …

Read More
Inserting Data into Hive Table

I am new to hive. I have successfully setup a single node hadoop cluster for development purpose and on top of it, I have installed hive and pig. I created a dummy table in hive: create table foo (id int, …

Read More