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

Navis updated HIVE-3045:
------------------------

    Affects Version/s: 0.10.0
               Status: Patch Available  (was: Open)

https://reviews.facebook.net/D3351
                
> 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: 
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Reply via email to