[
https://issues.apache.org/jira/browse/HIVE-20186?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Steve Yeom updated HIVE-20186:
------------------------------
Description:
select
CAST(1806151459200000496 AS BIGINT) AS IDP_AUDIT_ID
, CAST('2017-12-28' AS DATE) AS IDP_DATA_DATE
, fi.TEST_CODED
, inv.IDP_WAREHOUSE_ID
, inv.IDP_AUDIT_ID
, inv.baseline_is_current
, case when inv.baseline_is_current = '1' then 'Y' else 'N' end as
inv_baseline_is_current
, INV.PROJECT_KEY AS INV_KEY
from clarity__L3_SNAP_NUMBER snap, l3_monthly_dw_dimproject inv
LEFT OUTER JOIN L3_MONTHLY_FI_PROG_PROJ_NEWHIERARCHY hier
on INV.PROJECT_KEY = HIER.PROJECT_KEY AND HIER.IDP_DATA_DATE = '2017-12-28'
LEFT OUTER JOIN clarity__l3_monthly_dw_dimproject_fi fi
ON HIER.FUNDING_ITEM_KEY = FI.PROJECT_KEY AND FI.IDP_DATA_DATE = '2017-12-28'
INNER JOIN l3_dw_snapshot_control sc
ON 1=1 AND SC.IDP_DATA_DATE = '2017-12-28' AND SC.SNAPSHOT_ALIAS LIKE 'Month%'
WHERE INV.L3_SNAPSHOT_NUMBER= snap.L3_snapshot_number AND INV.IDP_DATA_DATE =
'2017-12-28'
order by idp_warehouse_id;
was:
select
CAST(1806151459200000496 AS BIGINT) AS IDP_AUDIT_ID
, CAST('2017-12-28' AS DATE) AS IDP_DATA_DATE
, fi.BMO_CODED
, inv.IDP_WAREHOUSE_ID
, inv.IDP_AUDIT_ID
, inv.baseline_is_current
, case when inv.baseline_is_current = '1' then 'Y' else 'N' end as
inv_baseline_is_current
, INV.PROJECT_KEY AS INV_KEY
from clarity__L3_SNAP_NUMBER snap, l3_monthly_dw_dimproject inv
LEFT OUTER JOIN L3_MONTHLY_FI_PROG_PROJ_NEWHIERARCHY hier
on INV.PROJECT_KEY = HIER.PROJECT_KEY AND HIER.IDP_DATA_DATE = '2017-12-28'
LEFT OUTER JOIN clarity__l3_monthly_dw_dimproject_fi fi
ON HIER.FUNDING_ITEM_KEY = FI.PROJECT_KEY AND FI.IDP_DATA_DATE = '2017-12-28'
INNER JOIN l3_dw_snapshot_control sc
ON 1=1 AND SC.IDP_DATA_DATE = '2017-12-28' AND SC.SNAPSHOT_ALIAS LIKE 'Month%'
WHERE INV.L3_SNAPSHOT_NUMBER= snap.L3_snapshot_number AND INV.IDP_DATA_DATE =
'2017-12-28'
order by idp_warehouse_id;
> Incorrect results when hive.tez.cartesian-product.enabled=false and
> vectorization enabled
> ------------------------------------------------------------------------------------------
>
> Key: HIVE-20186
> URL: https://issues.apache.org/jira/browse/HIVE-20186
> Project: Hive
> Issue Type: Bug
> Components: Vectorization
> Affects Versions: 4.0.0
> Reporter: Steve Yeom
> Priority: Major
> Fix For: 4.0.0
>
>
> select
> CAST(1806151459200000496 AS BIGINT) AS IDP_AUDIT_ID
> , CAST('2017-12-28' AS DATE) AS IDP_DATA_DATE
> , fi.TEST_CODED
> , inv.IDP_WAREHOUSE_ID
> , inv.IDP_AUDIT_ID
> , inv.baseline_is_current
> , case when inv.baseline_is_current = '1' then 'Y' else 'N' end as
> inv_baseline_is_current
> , INV.PROJECT_KEY AS INV_KEY
> from clarity__L3_SNAP_NUMBER snap, l3_monthly_dw_dimproject inv
> LEFT OUTER JOIN L3_MONTHLY_FI_PROG_PROJ_NEWHIERARCHY hier
> on INV.PROJECT_KEY = HIER.PROJECT_KEY AND HIER.IDP_DATA_DATE = '2017-12-28'
> LEFT OUTER JOIN clarity__l3_monthly_dw_dimproject_fi fi
> ON HIER.FUNDING_ITEM_KEY = FI.PROJECT_KEY AND FI.IDP_DATA_DATE = '2017-12-28'
> INNER JOIN l3_dw_snapshot_control sc
> ON 1=1 AND SC.IDP_DATA_DATE = '2017-12-28' AND SC.SNAPSHOT_ALIAS LIKE 'Month%'
> WHERE INV.L3_SNAPSHOT_NUMBER= snap.L3_snapshot_number AND INV.IDP_DATA_DATE =
> '2017-12-28'
> order by idp_warehouse_id;
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
