: user@hive.apache.org
Subject: Unexpected query result
Runnuning simple 'select count(*) from test_table' query returned me 500_000
result.
But when i run 'select count(distinct field) from test_table' query result is
500_001.
How it coud happen, that in table with 500_000
Runnuning simple '*select count(*) from test_table*' query returned me
500_000 result.
But when i run '*select count(distinct field) from test_table*' query
result is 500_001.
How it coud happen, that in table with 500_000 records have 500_001 unique
field values?
I'm using Hive from HDP 2.5.0 p
