Support Questions
Find answers, ask questions, and share your expertise

Impala distinct show not all rows

Explorer

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.

0 REPLIES 0