Navis created HIVE-3045:
---------------------------

             Summary: 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
            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