[ https://issues.apache.org/jira/browse/HIVE-9513?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14319569#comment-14319569 ]
Ashutosh Chauhan commented on HIVE-9513: ---------------------------------------- Interestingly, following succeeded for all 4 DB engines: {code} create table foo ( dummyfoo int ) ; create table bar ( dummybar int ) ; select * from ( select * from ( select 1 as id , dummyfoo from foo ) f union all select * from ( select 2 as id , dummybar from bar ) g ) e ; select * from ( select 1 as id , dummyfoo from foo f union all select 2 as id , dummybar from bar g ) e ; {code} This is from [~ErwanMAS] example in comments. > NULL POINTER EXCEPTION > ---------------------- > > Key: HIVE-9513 > URL: https://issues.apache.org/jira/browse/HIVE-9513 > Project: Hive > Issue Type: Bug > Components: CLI > Affects Versions: 0.13.1 > Reporter: ErwanMAS > Assignee: Navis > Attachments: HIVE-9513.1.patch.txt, HIVE-9513.2.patch.txt > > > NPE duting parsing of : > {noformat} > select * from ( > select * from ( select 1 as id , "foo" as str_1 from staging.dual ) f > union all > select * from ( select 2 as id , "bar" as str_2 from staging.dual ) g > ) e ; > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)