You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "dinesh (Jira)" <ji...@apache.org> on 2022/01/01 07:01:00 UTC
[jira] [Created] (HIVE-25838) Hive SQL using TEZ as execution engine not giving result on empty partition
dinesh created HIVE-25838:
-----------------------------
Summary: Hive SQL using TEZ as execution engine not giving result on empty partition
Key: HIVE-25838
URL: https://issues.apache.org/jira/browse/HIVE-25838
Project: Hive
Issue Type: Bug
Affects Versions: 3.1.0
Reporter: dinesh
Hive SQL's on empty partitions giving no result instead of 0 rows or actual value. For example -
--Create external Table
1) Create external table test_tbl ( name string) partitioned by ( company string, processdate string) stored as orc location '/my/some/random/location';
-- Add partion
2) Alter table test_tbl add partition ( company='aquaifer', processdate='20220101');
-- Execute following SQL's which returns no records.
3) select count(*), processdate from test_tbl group by processdate ;
4) select max(processdate ) from test_tbl ;
Same SQL (#3 & #4 above) , when execute with SPARK, returns '0' count and '20220101' respectively.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)