You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Ashutosh Chauhan (JIRA)" <ji...@apache.org> on 2012/12/09 19:39:21 UTC

[jira] [Updated] (HIVE-3045) Partition column values are not valid if any of virtual columns is selected

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

Ashutosh Chauhan updated HIVE-3045:
-----------------------------------

    Status: Open  (was: Patch Available)
    
> Partition column values are not valid if any of virtual columns is selected
> ---------------------------------------------------------------------------
>
>                 Key: HIVE-3045
>                 URL: https://issues.apache.org/jira/browse/HIVE-3045
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.10.0
>            Reporter: Navis
>            Assignee: Navis
>
> For example,
> {code}
> hive> select * from srcpart where key < 5;
> 0	val_0	2008-04-08	11
> 4	val_4	2008-04-08	11
> 0	val_0	2008-04-08	11
> 0	val_0	2008-04-08	11
> 2	val_2	2008-04-08	11
> 0	val_1	2008-04-09	12
> 4	val_5	2008-04-09	12
> 3	val_4	2008-04-09	12
> 2	val_3	2008-04-09	12
> 0	val_1	2008-04-09	12
> 1	val_2	2008-04-09	12
> hive> select *, BLOCK__OFFSET__INSIDE__FILE from srcpart where key < 5;
> 0	val_0	2008-04-09	11	968
> 4	val_4	2008-04-09	11	1218
> 0	val_0	2008-04-09	11	2088
> 0	val_0	2008-04-09	11	2632
> 2	val_2	2008-04-09	11	4004
> 0	val_1	2008-04-09	11	682
> 4	val_5	2008-04-09	11	1131
> 3	val_4	2008-04-09	11	1163
> 2	val_3	2008-04-09	11	2629
> 0	val_1	2008-04-09	11	4367
> 1	val_2	2008-04-09	11	5669
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira