[jira] [Commented] (HIVE-21533) Nested CTE's with join does not return any data.

[Vineet Garg (JIRA)]

[ 
https://issues.apache.org/jira/browse/HIVE-21533?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16814952#comment-16814952
 ] 

Vineet Garg commented on HIVE-21533:


[~ngangam] Is this only reproducible with 2.1? On upstream I am getting data.
{noformat}
201409  201409  AAA 2   201901  201409  1
{noformat}

> Nested CTE's with join does not return any data.
> 
>
> Key: HIVE-21533
> URL: https://issues.apache.org/jira/browse/HIVE-21533
> Project: Hive
>  Issue Type: Bug
>  Components: HiveServer2
>Affects Versions: 2.1.0
>Reporter: Naveen Gangam
>Priority: Major
> Attachments: testcase.sql
>
>
> Attached is the testcase to reproduce the issue. the join on CTE6 is causing 
> the problem.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (HIVE-21533) Nested CTE's with join does not return any data.

[Naveen Gangam (JIRA)]

[ 
https://issues.apache.org/jira/browse/HIVE-21533?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16814945#comment-16814945
 ] 

Naveen Gangam commented on HIVE-21533:
--

[~jcamachorodriguez] Do you have any thoughts on what might be the issue? Thank 
you

> Nested CTE's with join does not return any data.
> 
>
> Key: HIVE-21533
> URL: https://issues.apache.org/jira/browse/HIVE-21533
> Project: Hive
>  Issue Type: Bug
>  Components: HiveServer2
>Affects Versions: 2.1.0
>Reporter: Naveen Gangam
>Priority: Major
> Attachments: testcase.sql
>
>
> Attached is the testcase to reproduce the issue. the join on CTE6 is causing 
> the problem.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)