You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Navis (JIRA)" <ji...@apache.org> on 2012/05/23 15:09:41 UTC
[jira] [Created] (HIVE-3045) Partition column values are not valid
if any of virtual columns is selected
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
[jira] [Updated] (HIVE-3045) Partition column values are not valid
if any of virtual columns is selected
Posted by "Navis (JIRA)" <ji...@apache.org>.
[ 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