predicate pushdown does not work correctly with outer joins
---
Key: HIVE-1534
URL: https://issues.apache.org/jira/browse/HIVE-1534
Project: Hadoop Hive
Issue Type: Bug
[
https://issues.apache.org/jira/browse/HIVE-1534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12897587#action_12897587
]
Amareshwari Sriramadasu commented on HIVE-1534:
---
For a table input3 with
[
https://issues.apache.org/jira/browse/HIVE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
John Sichi updated HIVE-1495:
-
Status: Open (was: Patch Available)
supply correct information to hooks and lineage for index rebuild
[
https://issues.apache.org/jira/browse/HIVE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12897592#action_12897592
]
John Sichi commented on HIVE-1495:
--
I got failures in two tests:
i believe each mapper makes a copy since it reads in the data to be loaded into
the dbm.
this needs to be optimized at some point (ideally we should be putting the dbm
in distributed cache)
From: Gang Luo [lgpub...@yahoo.com.cn]
Sent: Tuesday, August 10,
i hate this message: 'THIS PAGE WAS MOVED TO HIVE XDOCS ! DO NOT EDIT!Join
Syntax'
why must edits to the wiki be banned if there are xdocs? hadoop has both.
there will always be things that are not captured in xdocs. it's pretty sad to
discourage free form edits by people who want to
Hi Bennie -
- i changed the default for this option to be false in a recent commit.
- what version of java/hadoop are u running? it seems that the job.xml can get
parsed on ur hadoop nodes, but not the client machine - so there must be some
difference in the xml parsing library (that's part of
[
https://issues.apache.org/jira/browse/HIVE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
He Yongqiang updated HIVE-1495:
---
Attachment: hive-1495.5.patch
Sorry, forgot to update outputs for these two testcases. Will be more
[
https://issues.apache.org/jira/browse/HIVE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12897612#action_12897612
]
John Sichi commented on HIVE-1495:
--
Rerunning with latest.
supply correct information to
On 2010-08-11 06:57:04, namit jain wrote:
ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g, line 572
http://review.cloudera.org/r/508/diff/2/?file=5203#file5203line572
remove KW_SCHEMAS
In MySQL SHOW SCHEMAS is a synonym for SHOW DATABASES as of version 5.0.2. I
think the
[
https://issues.apache.org/jira/browse/HIVE-675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12897625#action_12897625
]
HBase Review Board commented on HIVE-675:
-
Message from: Carl Steinbach
Hi,
I see that if a query has where clause, the FilterOperator is applied twice.
Can you tell me why is it done so?
It seems second operator is always filtering zero rows.
Explain on a query with where clause :
hive explain select * from input1 where input1.key != 10;
OK
ABSTRACT SYNTAX TREE:
Hi,
I found very interesting feature in hive version 0.6.0. Is there any
compatibility constraint with hadoop, If yes than which hadoop version
it supports?
Regards,
Jaydeep
The information contained in this communication is intended solely for the use
of the individual or entity to whom it
On Wed, Aug 11, 2010 at 9:15 PM, Ashish Thusoo athu...@facebook.com wrote:
Folks,
This question has come up in the PMC once again and would be great to hear
once more on this topic. What do people think? Are we ready to become a TLP?
Thanks,
Ashish
I thought of one more benefit. We can
Jaydeep,
Currently one build of hive works with hadoop 0.17,0.18,0.19,and 0.20.
However there is talk about dropping support for older versions and
moving completely to mapreduce api.
Edward
On Thu, Aug 12, 2010 at 8:29 AM, jaydeep vishwakarma
jaydeep.vishwaka...@mkhoj.com wrote:
Hi,
I found
See http://hudson.zones.apache.org/hudson/job/Hive-trunk-h0.17/516/changes
See http://hudson.zones.apache.org/hudson/job/Hive-trunk-h0.19/519/
--
[...truncated 13491 lines...]
[junit] OK
[junit] Copying data from
http://hudson.zones.apache.org/hudson/job/Hive-trunk-h0.19/ws/hive/data/files/srcbucket22.txt
[junit]
[
https://issues.apache.org/jira/browse/HIVE-1495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
John Sichi resolved HIVE-1495.
--
Hadoop Flags: [Reviewed]
Resolution: Fixed
Committed. Thanks Yongqiang!
supply correct
[
https://issues.apache.org/jira/browse/HIVE-1482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12897892#action_12897892
]
John Sichi commented on HIVE-1482:
--
Yeah, the problems may only show up with remoting
[
https://issues.apache.org/jira/browse/HIVE-1460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
John Sichi resolved HIVE-1460.
--
Resolution: Duplicate
Closing as dup.
JOIN should not output rows for NULL values
[
https://issues.apache.org/jira/browse/HIVE-1534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
John Sichi reassigned HIVE-1534:
Assignee: Amareshwari Sriramadasu
predicate pushdown does not work correctly with outer joins
[
https://issues.apache.org/jira/browse/HIVE-1534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12897909#action_12897909
]
John Sichi commented on HIVE-1534:
--
Definitely a bug. It happens regardless of the setting
See http://hudson.zones.apache.org/hudson/job/Hive-trunk-h0.20/342/
--
[...truncated 15704 lines...]
init:
install-hadoopcore:
install-hadoopcore-default:
ivy-init-dirs:
ivy-download:
[get] Getting:
[
https://issues.apache.org/jira/browse/HIVE-741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
John Sichi reassigned HIVE-741:
---
Assignee: Amareshwari Sriramadasu (was: Ning Zhang)
NULL is not handled correctly in join
[
https://issues.apache.org/jira/browse/HIVE-1534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12897912#action_12897912
]
John Sichi commented on HIVE-1534:
--
Assigning this to you in case you want to take a look
[
https://issues.apache.org/jira/browse/HIVE-1533?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
John Sichi updated HIVE-1533:
-
Fix Version/s: 0.7.0
Affects Version/s: 0.6.0
Use ZooKeeper from maven
[
https://issues.apache.org/jira/browse/HIVE-1293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12897917#action_12897917
]
John Sichi commented on HIVE-1293:
--
I think ZK default client port would be 2181; see
[
https://issues.apache.org/jira/browse/HIVE-1529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12897921#action_12897921
]
John Sichi commented on HIVE-1529:
--
src is a test fixture (automatically created for use by
[
https://issues.apache.org/jira/browse/HIVE-1293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12897946#action_12897946
]
John Sichi commented on HIVE-1293:
--
From testing: the parsed lock mode seems to be
[
https://issues.apache.org/jira/browse/HIVE-1512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12897948#action_12897948
]
Basab Maulik commented on HIVE-1512:
Quick clarification, the current code works fine
[
https://issues.apache.org/jira/browse/HIVE-1512?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
John Sichi reassigned HIVE-1512:
Assignee: Basab Maulik (was: John Sichi)
Need to get hive_hbase-handler to work with hbase
[
https://issues.apache.org/jira/browse/HIVE-1293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12897953#action_12897953
]
Basab Maulik commented on HIVE-1293:
Re: One lib question: Zookeeper
hbase-handler with
[
https://issues.apache.org/jira/browse/HIVE-1529?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pierre Huyn updated HIVE-1529:
--
Attachment: HIVE-1529.1.patch
This is the first release of 2 covariance generic UDAF: population
[
https://issues.apache.org/jira/browse/HIVE-1518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mayank Lahiri updated HIVE-1518:
Status: Open (was: Patch Available)
Found the source of the bug we were discussing -- the v1 patch
[
https://issues.apache.org/jira/browse/HIVE-1293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12897977#action_12897977
]
John Sichi commented on HIVE-1293:
--
Namit, I tried testing with a standalone zookeeper via
[
https://issues.apache.org/jira/browse/HIVE-1529?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pierre Huyn updated HIVE-1529:
--
Summary: Add ANSI SQL covariance aggregate functions: covar_pop and
covar_samp. (was: Add covariance
[
https://issues.apache.org/jira/browse/HIVE-1293?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
John Sichi updated HIVE-1293:
-
Status: Open (was: Patch Available)
Concurreny Model for Hive
-
[
https://issues.apache.org/jira/browse/HIVE-1529?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pierre Huyn updated HIVE-1529:
--
Tags: ANSI SQL covariance aggregation function (was: covariance
aggregation function)
Add ANSI SQL
[
https://issues.apache.org/jira/browse/HIVE-1518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mayank Lahiri updated HIVE-1518:
Status: Patch Available (was: Open)
context_ngrams() UDAF for estimating top-k contextual n-grams
[
https://issues.apache.org/jira/browse/HIVE-1293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12897988#action_12897988
]
John Sichi commented on HIVE-1293:
--
Here's a scenario which is not working correctly.
[
https://issues.apache.org/jira/browse/HIVE-1528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ning Zhang updated HIVE-1528:
-
Attachment: HIVE-1528.patch
JSON UDTF function
--
Key: HIVE-1528
[
https://issues.apache.org/jira/browse/HIVE-1528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ning Zhang updated HIVE-1528:
-
Status: Patch Available (was: Open)
Affects Version/s: 0.7.0
Fix Version/s: 0.7.0
[
https://issues.apache.org/jira/browse/HIVE-1530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12897993#action_12897993
]
Joydeep Sen Sarma commented on HIVE-1530:
-
removing the .xml files makes sense.
but
[
https://issues.apache.org/jira/browse/HIVE-1528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ning Zhang reassigned HIVE-1528:
Assignee: Ning Zhang
JSON UDTF function
--
Key: HIVE-1528
[
https://issues.apache.org/jira/browse/HIVE-1529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12898003#action_12898003
]
Mayank Lahiri commented on HIVE-1529:
-
Hi Pierre,
The numerical results appear to be
[
https://issues.apache.org/jira/browse/HIVE-1293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12898010#action_12898010
]
John Sichi commented on HIVE-1293:
--
After seeing some other issues, had a chat with Namit
[
https://issues.apache.org/jira/browse/HIVE-1293?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12898012#action_12898012
]
John Sichi commented on HIVE-1293:
--
Also, as a followup, need to add client info such as
[
https://issues.apache.org/jira/browse/HIVE-1529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12898022#action_12898022
]
Pierre Huyn commented on HIVE-1529:
---
Hi Mayank,
Thanks for reviewing. Please bear with
[
https://issues.apache.org/jira/browse/HIVE-1515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
He Yongqiang updated HIVE-1515:
---
Attachment: hive-1515.2.patch
Attache a possible fix.
Talked with Namit and Paul this afternoon
[
https://issues.apache.org/jira/browse/HIVE-1515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
He Yongqiang updated HIVE-1515:
---
Assignee: (was: He Yongqiang)
archive is not working when multiple partitions inside one table
[
https://issues.apache.org/jira/browse/HIVE-1530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12898030#action_12898030
]
Edward Capriolo commented on HIVE-1530:
---
I like the default xml. Hive has many
alter partition should throw exception if the specified partition does not
exist.
-
Key: HIVE-1535
URL: https://issues.apache.org/jira/browse/HIVE-1535
Project: Hadoop
[
https://issues.apache.org/jira/browse/HIVE-1532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
He Yongqiang reassigned HIVE-1532:
--
Assignee: He Yongqiang
Replace globStatus with listStatus inside Hive.java's replaceFiles.
[
https://issues.apache.org/jira/browse/HIVE-1522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
He Yongqiang reassigned HIVE-1522:
--
Assignee: He Yongqiang
replace columns should prohibit using partition column names.
[
https://issues.apache.org/jira/browse/HIVE-1531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12898032#action_12898032
]
John Sichi commented on HIVE-1531:
--
+1. Will commit when tests pass.
Make Hive build
[
https://issues.apache.org/jira/browse/HIVE-1528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ning Zhang updated HIVE-1528:
-
Attachment: HIVE-1528.2.patch
Based on offline discussion with Paul, added a new unit test of putting
[
https://issues.apache.org/jira/browse/HIVE-1528?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12898034#action_12898034
]
Paul Yang commented on HIVE-1528:
-
Looks good +1
JSON UDTF function
--
Adding implementation to JDBC driver
Key: HIVE-1536
URL: https://issues.apache.org/jira/browse/HIVE-1536
Project: Hadoop Hive
Issue Type: Improvement
Reporter: Sean Flatley
As a result of a
[
https://issues.apache.org/jira/browse/HIVE-1530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12898038#action_12898038
]
Carl Steinbach commented on HIVE-1530:
--
bq. but users may want to modify the
[
https://issues.apache.org/jira/browse/HIVE-1528?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12898039#action_12898039
]
John Sichi commented on HIVE-1528:
--
Will commit if tests pass.
JSON UDTF function
[
https://issues.apache.org/jira/browse/HIVE-1530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12898040#action_12898040
]
Carl Steinbach commented on HIVE-1530:
--
@Ed: In my opinion the ideal solution is to get
[
https://issues.apache.org/jira/browse/HIVE-1536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Carl Steinbach updated HIVE-1536:
-
Summary: Add support for JDBC PreparedStatements (was: Adding
implementation to JDBC driver)
[
https://issues.apache.org/jira/browse/HIVE-1428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Carl Steinbach updated HIVE-1428:
-
Attachment: HIVE-1428-0.6.0-patch.txt
ALTER TABLE ADD PARTITION fails with a remote Thrift
[
https://issues.apache.org/jira/browse/HIVE-1428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Carl Steinbach reopened HIVE-1428:
--
We need to backport this fix to 0.6.0
ALTER TABLE ADD PARTITION fails with a remote Thrift
[
https://issues.apache.org/jira/browse/HIVE-1428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Carl Steinbach updated HIVE-1428:
-
Fix Version/s: 0.6.0
(was: 0.7.0)
Affects Version/s: 0.5.0
[
https://issues.apache.org/jira/browse/HIVE-1428?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Carl Steinbach updated HIVE-1428:
-
Status: Patch Available (was: Reopened)
ALTER TABLE ADD PARTITION fails with a remote Thrift
[
https://issues.apache.org/jira/browse/HIVE-1535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
He Yongqiang updated HIVE-1535:
---
Attachment: hive-1535.1.patch
No negative tests included because hive is using local meta store, and
[
https://issues.apache.org/jira/browse/HIVE-1535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
He Yongqiang updated HIVE-1535:
---
Status: Patch Available (was: Open)
alter partition should throw exception if the specified
Allow users to specify LOCATION in CREATE DATABASE statement
Key: HIVE-1537
URL: https://issues.apache.org/jira/browse/HIVE-1537
Project: Hadoop Hive
Issue Type: New Feature
[
https://issues.apache.org/jira/browse/HIVE-1528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
John Sichi updated HIVE-1528:
-
Status: Resolved (was: Patch Available)
Hadoop Flags: [Reviewed]
Resolution: Fixed
[
https://issues.apache.org/jira/browse/HIVE-1530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12898080#action_12898080
]
Joydeep Sen Sarma commented on HIVE-1530:
-
ok - that makes sense. leave a
71 matches
Mail list logo