[jira] [Updated] (HIVE-20186) Incorrect results when hive.tez.cartesian-product.enabled=false and vectorization enabled

2022-10-21 Thread Stamatis Zampetakis (Jira) 


 [ 
https://issues.apache.org/jira/browse/HIVE-20186?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Stamatis Zampetakis updated HIVE-20186:
---
Fix Version/s: (was: 4.0.0)

I cleared the fixVersion field since this ticket is still open. Please review 
this ticket and if the fix is already committed to a specific version please 
set the version accordingly and mark the ticket as RESOLVED.

According to the [JIRA 
guidelines|https://cwiki.apache.org/confluence/display/Hive/HowToContribute] 
the fixVersion should be set only when the issue is resolved/closed.

> 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
>
> select
> CAST(180615145920496 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
(v8.20.10#820010)

[jira] [Updated] (HIVE-20186) Incorrect results when hive.tez.cartesian-product.enabled=false and vectorization enabled

2018-07-16 Thread Steve Yeom (JIRA) 


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