[jira] [Commented] (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:comment-tabpanel&focusedCommentId=13529559#comment-13529559
]
Phabricator commented on HIVE-3045:
---
navis has abandoned the revision "HIVE-3045 [jira] Partition column values are
not valid if any of virtual columns is selected".
Fixed by HIVE-2925
REVISION DETAIL
https://reviews.facebook.net/D3351
To: JIRA, navis
> 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
> Attachments: HIVE-3045.D3351.2.patch
>
>
> 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
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=13527771#comment-13527771
]
Navis commented on HIVE-3045:
-
This is rather old issue and possibly could be fixed by other issues like
HIVE-2925. I'll check on it.
> 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
> Attachments: HIVE-3045.D3351.2.patch
>
>
> 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
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=13527766#comment-13527766
]
Ashutosh Chauhan commented on HIVE-3045:
I did the following:
{code}
$ svn co https://svn.apache.org/repos/asf/hive/trunk .
$ curl
https://issues.apache.org/jira/secure/attachment/12560133/HIVE-3045.D3351.2.patch
| patch -p0
$ svn revert ql/src/java/org/apache/hadoop/hive/ql/exec/MapOperator.java
$ ant package test -Dtestcase=TestCliDriver -Dqfile=virtual_column.q
:
$ BUILD SUCCESSFUL
Total time: 2 minutes 53 seconds
{code}
I was expecting test case to fail if I revert the code changes. Instead, it
succeeded. That is not what I was expecting.
Than I repeated the same process, except for svn revert step, test still
succeeded.
> 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
> Attachments: HIVE-3045.D3351.2.patch
>
>
> 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
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=13527258#comment-13527258
]
Ashutosh Chauhan commented on HIVE-3045:
Navis,
Patch looks good, but doesn't apply cleanly on trunk. Can you rebase the patch
and also upload it here on jira.
> 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
