SupportKB
Problem Description:When running a Hive query, NVL and COUNT functions are returning empty results for empty tables.
jdbc:hive2://c1122-node3.squadron-labs.com> select count(*) from test1 where col1 is not null; INFO : Session is already open INFO : Dag name: select count(*) from test1 where col1...null(Stage-1) +------+--+ | _c0 | +------+--+ +------+--+ No rows selected (0.458 seconds)
Cause:
This issue occurs in the following condition by default this property is false:
hive.fetch.task.aggr=true;
Solution:
To resolve this issue, set condition to:
hive.fetch.task.aggr=false;
About:
This article created by Hortonworks Support (Article: 000008049) on 2019-02-08 20:12
OS: Linux
Type: Configuration
Version: 2-6-5
Support ID: 000008049
