28790
DISCUSSIONS
102125
MEMBERS
3161
ARTICLES
Created 12-19-2014 04:13 AM
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.