You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Namit Jain (JIRA)" <ji...@apache.org> on 2009/11/01 22:52:59 UTC

[jira] Commented: (HIVE-796) RCFile results missing columns from UNION ALL

    [ https://issues.apache.org/jira/browse/HIVE-796?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12772372#action_12772372 ] 

Namit Jain commented on HIVE-796:
---------------------------------

will merge if the tests pass

> RCFile results missing columns from UNION ALL
> ---------------------------------------------
>
>                 Key: HIVE-796
>                 URL: https://issues.apache.org/jira/browse/HIVE-796
>             Project: Hadoop Hive
>          Issue Type: Bug
>            Reporter: Ning Zhang
>            Assignee: He Yongqiang
>         Attachments: hive-796-2009-08-26.patch, hive-796-2009-9-9.patch
>
>
> create table tt(a int, b string, c string) row format serde "org.apache.hadoop.hive.serde2.column.ColumnarSerDe" stored as RCFile;
> load data:
>   1 b c
>   2 e f
>   3 i j
> select * from (
>   select b as cola from tt
>   union all
>   select c as cola from tt) s;
> results:
>   NULL
>   b
>   NULL
>   e
>   NULL
>   i

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.