Welcome to the Cloudera Community

Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

Impala distinct show not all rows

avatar
Contributor

Hi,

 

when you use Hue Impala query editor, and write select distinct query, it return only some of the values, and each time query is run the result differs. Although if you download result or count distinct values, you see correct values everytime. This might be just Hue Impala query editor displaying wrong values.

 

Query that returns different rows each time:

SELECT distinct string_column FROM partitioned_table

 

Query that returns correct rows each time:

SELECT count(distinct string_column) FROM partitioned_table

 

Using CDH5.2.0.

Who agreed with this topic