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 platform. Table stored as ORC.