Details
-
Bug
-
Status: Resolved
-
Minor
-
Resolution: Won't Fix
-
1.2.1
-
None
-
None
-
engine = mr
TBLPROPERTIES(
'auto.purge'='true',
'orc.compress'='ZLIB',
'serialization.null.format'=''
)
Description
Hi,
I have a table named "sau' with 1000 rows.
The table structure is :
col_name | data_type | comment |
---|---|---|
id | string | |
mnta | int | |
mntb | int |
select id, 'A' as info, mntA as mnt from sau
union
select id, 'B' as info, mntB as mnt from sau
==> return only rows with "info=B"
with
cte_union as (
select id, 'A' as info, mntA as mnt from sau
union
select id, 'B' as info, mntB as mnt from sau
)
select
count
from
cte_union
==> return 1000 but should be 2000
I don't know if this bug is fixed on new version.
Using "union all" clause, the result is correct.
Attachments
Issue Links
- is part of
-
HIVE-15680 Incorrect results when hive.optimize.index.filter=true and same ORC table is referenced twice in query
- Closed