hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steve Yeom (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-20186) Incorrect results when hive.tez.cartesian-product.enabled=false and vectorization enabled
Date Mon, 16 Jul 2018 18:41:00 GMT

     [ 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)

Mime
View raw message