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 (Created) (JIRA)" <ji...@apache.org> on 2012/04/17 07:33:35 UTC
[jira] [Created] (HIVE-2955) Queries consists of
metadata-only-query returns always empty value
Queries consists of metadata-only-query returns always empty value
------------------------------------------------------------------
Key: HIVE-2955
URL: https://issues.apache.org/jira/browse/HIVE-2955
Project: Hive
Issue Type: Bug
Reporter: Navis
Assignee: Navis
Priority: Minor
For partitioned table, simple query on partition column returns always null or empty value, for example,
{code}
create table emppart(empno int, ename string) partitioned by (deptno int);
.. load partitions..
select distinct deptno from emppart; // empty
select min(deptno), max(deptno) from emppart; // NULL and NULL
{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-2955) Queries consists of
metadata-only-query returns always empty value
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2955?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-2955:
-----------------------------
Status: Open (was: Patch Available)
minor comments on phabricator.
The diff is not applying cleanly.
> Queries consists of metadata-only-query returns always empty value
> ------------------------------------------------------------------
>
> Key: HIVE-2955
> URL: https://issues.apache.org/jira/browse/HIVE-2955
> Project: Hive
> Issue Type: Bug
> Reporter: Navis
> Assignee: Navis
> Priority: Minor
> Attachments: HIVE-2955.D2817.1.patch
>
>
> For partitioned table, simple query on partition column returns always null or empty value, for example,
> {code}
> create table emppart(empno int, ename string) partitioned by (deptno int);
> .. load partitions..
> select distinct deptno from emppart; // empty
> select min(deptno), max(deptno) from emppart; // NULL and NULL
> {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-2955) Queries consists of
metadata-only-query returns always empty value
Posted by "Navis (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2955?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Navis updated HIVE-2955:
------------------------
Status: Patch Available (was: Open)
passed all tests
> Queries consists of metadata-only-query returns always empty value
> ------------------------------------------------------------------
>
> Key: HIVE-2955
> URL: https://issues.apache.org/jira/browse/HIVE-2955
> Project: Hive
> Issue Type: Bug
> Reporter: Navis
> Assignee: Navis
> Priority: Minor
> Attachments: HIVE-2955.D2817.1.patch
>
>
> For partitioned table, simple query on partition column returns always null or empty value, for example,
> {code}
> create table emppart(empno int, ename string) partitioned by (deptno int);
> .. load partitions..
> select distinct deptno from emppart; // empty
> select min(deptno), max(deptno) from emppart; // NULL and NULL
> {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] [Commented] (HIVE-2955) Queries consists of
metadata-only-query returns always empty value
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2955?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13399537#comment-13399537 ]
Hudson commented on HIVE-2955:
------------------------------
Integrated in Hive-trunk-h0.21 #1504 (See [https://builds.apache.org/job/Hive-trunk-h0.21/1504/])
HIVE-2955 Queries consists of metadata-only-query returns always empty value
(Navis via namit) (Revision 1352771)
Result = SUCCESS
namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1352771
Files :
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/ExecDriver.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/MetadataOnlyOptimizer.java
* /hive/trunk/ql/src/test/queries/clientpositive/metadataonly1.q
* /hive/trunk/ql/src/test/results/clientpositive/metadataonly1.q.out
> Queries consists of metadata-only-query returns always empty value
> ------------------------------------------------------------------
>
> Key: HIVE-2955
> URL: https://issues.apache.org/jira/browse/HIVE-2955
> Project: Hive
> Issue Type: Bug
> Reporter: Navis
> Assignee: Navis
> Priority: Minor
> Attachments: HIVE-2955.D2817.1.patch
>
>
> For partitioned table, simple query on partition column returns always null or empty value, for example,
> {code}
> create table emppart(empno int, ename string) partitioned by (deptno int);
> .. load partitions..
> select distinct deptno from emppart; // empty
> select min(deptno), max(deptno) from emppart; // NULL and NULL
> {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-2955) Queries consists of
metadata-only-query returns always empty value
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2955?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-2955:
---------------------------------
Component/s: Query Processor
Fix Version/s: 0.10.0
@Namit: Please remember to set the fix version field when you mark a ticket as resolved. Thanks.
> Queries consists of metadata-only-query returns always empty value
> ------------------------------------------------------------------
>
> Key: HIVE-2955
> URL: https://issues.apache.org/jira/browse/HIVE-2955
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Navis
> Assignee: Navis
> Priority: Minor
> Fix For: 0.10.0
>
> Attachments: HIVE-2955.D2817.1.patch
>
>
> For partitioned table, simple query on partition column returns always null or empty value, for example,
> {code}
> create table emppart(empno int, ename string) partitioned by (deptno int);
> .. load partitions..
> select distinct deptno from emppart; // empty
> select min(deptno), max(deptno) from emppart; // NULL and NULL
> {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] [Commented] (HIVE-2955) Queries consists of
metadata-only-query returns always empty value
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2955?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13398903#comment-13398903 ]
Namit Jain commented on HIVE-2955:
----------------------------------
+1
Running tests
> Queries consists of metadata-only-query returns always empty value
> ------------------------------------------------------------------
>
> Key: HIVE-2955
> URL: https://issues.apache.org/jira/browse/HIVE-2955
> Project: Hive
> Issue Type: Bug
> Reporter: Navis
> Assignee: Navis
> Priority: Minor
> Attachments: HIVE-2955.D2817.1.patch
>
>
> For partitioned table, simple query on partition column returns always null or empty value, for example,
> {code}
> create table emppart(empno int, ename string) partitioned by (deptno int);
> .. load partitions..
> select distinct deptno from emppart; // empty
> select min(deptno), max(deptno) from emppart; // NULL and NULL
> {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-2955) Queries consists of
metadata-only-query returns always empty value
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2955?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-2955:
-----------------------------
Resolution: Fixed
Hadoop Flags: Reviewed
Status: Resolved (was: Patch Available)
Committed. Thanks Navis
> Queries consists of metadata-only-query returns always empty value
> ------------------------------------------------------------------
>
> Key: HIVE-2955
> URL: https://issues.apache.org/jira/browse/HIVE-2955
> Project: Hive
> Issue Type: Bug
> Reporter: Navis
> Assignee: Navis
> Priority: Minor
> Attachments: HIVE-2955.D2817.1.patch
>
>
> For partitioned table, simple query on partition column returns always null or empty value, for example,
> {code}
> create table emppart(empno int, ename string) partitioned by (deptno int);
> .. load partitions..
> select distinct deptno from emppart; // empty
> select min(deptno), max(deptno) from emppart; // NULL and NULL
> {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-2955) Queries consists of
metadata-only-query returns always empty value
Posted by "Phabricator (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2955?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Phabricator updated HIVE-2955:
------------------------------
Attachment: HIVE-2955.D2817.1.patch
navis requested code review of "HIVE-2955 [jira] Queries consists of metadata-only-query returns always empty value".
Reviewers: JIRA
DPAL-1108 Queries consists of metadata-only-query returns always empty value
For partitioned table, simple query on partition column returns always null or empty value, for example,
create table emppart(empno int, ename string) partitioned by (deptno int);
.. load partitions..
select distinct deptno from emppart; // empty
select min(deptno), max(deptno) from emppart; // NULL and NULL
TEST PLAN
EMPTY
REVISION DETAIL
https://reviews.facebook.net/D2817
AFFECTED FILES
ql/src/java/org/apache/hadoop/hive/ql/exec/ExecDriver.java
ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/MetadataOnlyOptimizer.java
ql/src/test/queries/clientpositive/metadataonly1.q
ql/src/test/results/clientpositive/metadataonly1.q.out
MANAGE HERALD DIFFERENTIAL RULES
https://reviews.facebook.net/herald/view/differential/
WHY DID I GET THIS EMAIL?
https://reviews.facebook.net/herald/transcript/6411/
Tip: use the X-Herald-Rules header to filter Herald messages in your client.
> Queries consists of metadata-only-query returns always empty value
> ------------------------------------------------------------------
>
> Key: HIVE-2955
> URL: https://issues.apache.org/jira/browse/HIVE-2955
> Project: Hive
> Issue Type: Bug
> Reporter: Navis
> Assignee: Navis
> Priority: Minor
> Attachments: HIVE-2955.D2817.1.patch
>
>
> For partitioned table, simple query on partition column returns always null or empty value, for example,
> {code}
> create table emppart(empno int, ename string) partitioned by (deptno int);
> .. load partitions..
> select distinct deptno from emppart; // empty
> select min(deptno), max(deptno) from emppart; // NULL and NULL
> {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-2955) Queries consists of
metadata-only-query returns always empty value
Posted by "Unnikrishnan V T (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2955?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Unnikrishnan V T updated HIVE-2955:
-----------------------------------
Status: Patch Available (was: Open)
> Queries consists of metadata-only-query returns always empty value
> ------------------------------------------------------------------
>
> Key: HIVE-2955
> URL: https://issues.apache.org/jira/browse/HIVE-2955
> Project: Hive
> Issue Type: Bug
> Reporter: Navis
> Assignee: Navis
> Priority: Minor
> Attachments: HIVE-2955.D2817.1.patch
>
>
> For partitioned table, simple query on partition column returns always null or empty value, for example,
> {code}
> create table emppart(empno int, ename string) partitioned by (deptno int);
> .. load partitions..
> select distinct deptno from emppart; // empty
> select min(deptno), max(deptno) from emppart; // NULL and NULL
> {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