[jira] [Commented] (HIVE-3652) Join optimization for star schema

2012-11-05 Thread Amareshwari Sriramadasu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13490506#comment-13490506 ] Amareshwari Sriramadasu commented on HIVE-3652: --- If we have series of

[jira] [Commented] (HIVE-3652) Join optimization for star schema

2012-11-05 Thread Amareshwari Sriramadasu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13490513#comment-13490513 ] Amareshwari Sriramadasu commented on HIVE-3652: --- bq. If we have series of

[jira] [Commented] (HIVE-3652) Join optimization for star schema

2012-11-05 Thread Amareshwari Sriramadasu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13490521#comment-13490521 ] Amareshwari Sriramadasu commented on HIVE-3652: --- bq. select /*+ MAPJOIN(b,c)

[jira] [Commented] (HIVE-3652) Join optimization for star schema

2012-11-05 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13490583#comment-13490583 ] Namit Jain commented on HIVE-3652: -- I think this will launch 2 map-only jobs in the

[jira] [Commented] (HIVE-3652) Join optimization for star schema

2012-11-05 Thread Amareshwari Sriramadasu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13490587#comment-13490587 ] Amareshwari Sriramadasu commented on HIVE-3652: --- Namit, Are you saying if we

Re: [DISCUSS] HCatalog becoming a subproject of Hive

2012-11-05 Thread 杨卓荦
+1 for that. I like it. 2012/11/5 Alexander Lorenz wget.n...@gmail.com: Like it too. +1 Thanks, Alex On Nov 5, 2012, at 5:35 AM, Namit Jain nj...@fb.com wrote: I like the idea of Hcatalog becoming a Hive sub-project. The enhancements/bugs in the serde/metastore areas can indirectly

[jira] [Created] (HIVE-3667) Umbrella jira for Correlation Optimizer

2012-11-05 Thread Yin Huai (JIRA)
Yin Huai created HIVE-3667: -- Summary: Umbrella jira for Correlation Optimizer Key: HIVE-3667 URL: https://issues.apache.org/jira/browse/HIVE-3667 Project: Hive Issue Type: New Feature

[jira] [Created] (HIVE-3668) Merge MapReduce jobs which share input tables and the same partitioning keys into a single MapReduce job

2012-11-05 Thread Yin Huai (JIRA)
Yin Huai created HIVE-3668: -- Summary: Merge MapReduce jobs which share input tables and the same partitioning keys into a single MapReduce job Key: HIVE-3668 URL: https://issues.apache.org/jira/browse/HIVE-3668

[jira] [Created] (HIVE-3669) Support queries in which input tables of correlated MR jobs involves intermediate tables

2012-11-05 Thread Yin Huai (JIRA)
Yin Huai created HIVE-3669: -- Summary: Support queries in which input tables of correlated MR jobs involves intermediate tables Key: HIVE-3669 URL: https://issues.apache.org/jira/browse/HIVE-3669 Project:

[jira] [Updated] (HIVE-3669) Support queries in which input tables of correlated MR jobs involves intermediate tables

2012-11-05 Thread Yin Huai (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3669?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yin Huai updated HIVE-3669: --- Assignee: Yin Huai Support queries in which input tables of correlated MR jobs involves intermediate

[jira] [Updated] (HIVE-3670) Optimize queries involving self join

2012-11-05 Thread Yin Huai (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yin Huai updated HIVE-3670: --- Assignee: Yin Huai Optimize queries involving self join

[jira] [Created] (HIVE-3670) Optimize queries involving self join

2012-11-05 Thread Yin Huai (JIRA)
Yin Huai created HIVE-3670: -- Summary: Optimize queries involving self join Key: HIVE-3670 URL: https://issues.apache.org/jira/browse/HIVE-3670 Project: Hive Issue Type: Sub-task

[jira] [Created] (HIVE-3671) If a query has been optimized by correlation optimizer, join auto convert cannot optimize it

2012-11-05 Thread Yin Huai (JIRA)
Yin Huai created HIVE-3671: -- Summary: If a query has been optimized by correlation optimizer, join auto convert cannot optimize it Key: HIVE-3671 URL: https://issues.apache.org/jira/browse/HIVE-3671

[jira] [Commented] (HIVE-2206) add a new optimizer for query correlation discovery and optimization

2012-11-05 Thread Yin Huai (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2206?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13490681#comment-13490681 ] Yin Huai commented on HIVE-2206: [~namit] Sure. I created the umbrella jira (HIVE-3667) for

Re: [DISCUSS] HCatalog becoming a subproject of Hive

2012-11-05 Thread Edward Capriolo
That is a good idea. I would really like to see hcatalog be a sub project and then have hive use remove it's metastore code in favour of hcatalog. How should we coordinate this? Edward On Mon, Nov 5, 2012 at 6:41 AM, Clark Yang (杨卓荦) clarkyzl-h...@yahoo.com.cn wrote: +1 for that. I like it.

Build failed in Jenkins: Hive-0.9.1-SNAPSHOT-h0.21 #189

2012-11-05 Thread Apache Jenkins Server
See https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21/189/ -- [...truncated 5328 lines...] [mkdir] Created dir: https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21/189/artifact/hive/build/shims [mkdir] Created dir:

Build failed in Jenkins: Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false #189

2012-11-05 Thread Apache Jenkins Server
See https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/189/ -- [...truncated 10093 lines...] [echo] Project: odbc [copy] Warning: https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/ws/hive/odbc/src/conf

[jira] [Commented] (HIVE-3652) Join optimization for star schema

2012-11-05 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13490750#comment-13490750 ] Namit Jain commented on HIVE-3652: -- Yes, it will not work automatically. You need to

[jira] [Commented] (HIVE-1362) column level statistics

2012-11-05 Thread Shreepadma Venugopalan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13490814#comment-13490814 ] Shreepadma Venugopalan commented on HIVE-1362: -- @Namit: I responded to your

[jira] [Commented] (HIVE-3621) Make prompt in Hive CLI configurable

2012-11-05 Thread Jingwei Lu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13490852#comment-13490852 ] Jingwei Lu commented on HIVE-3621: -- I do explicitly state that hiveconf can be used in the

[jira] [Commented] (HIVE-3621) Make prompt in Hive CLI configurable

2012-11-05 Thread Mark Grover (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13490856#comment-13490856 ] Mark Grover commented on HIVE-3621: --- Nevermind, I missed it. Looks good to me. Thanks!

[jira] [Commented] (HIVE-1868) ALTER TABLE ADD PARTITION can't handle partition key names that conflict with HQL keywords

2012-11-05 Thread Tamir Duberstein (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1868?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13490901#comment-13490901 ] Tamir Duberstein commented on HIVE-1868: 2 years - what's going on with this?

[jira] [Commented] (HIVE-895) Add SerDe for Avro serialized data

2012-11-05 Thread Mithun Radhakrishnan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-895?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13490912#comment-13490912 ] Mithun Radhakrishnan commented on HIVE-895: --- Jakob, a quick question: The JIRA

Hive-trunk-h0.21 - Build # 1774 - Failure

2012-11-05 Thread Apache Jenkins Server
Changes for Build #1764 [kevinwilfong] HIVE-3610. Add a command Explain dependency ... (Sambavi Muthukrishnan via kevinwilfong) Changes for Build #1765 Changes for Build #1766 [hashutosh] HIVE-3441 : testcases escape1,escape2 fail on windows (Thejas Nair via Ashutosh Chauhan) [kevinwilfong]

[jira] [Commented] (HIVE-895) Add SerDe for Avro serialized data

2012-11-05 Thread Jakob Homan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-895?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13490998#comment-13490998 ] Jakob Homan commented on HIVE-895: -- The fixed version is 9.1, but at least in the JIRA, I

[jira] [Created] (HIVE-3672) Support altering partition column type in Hive

2012-11-05 Thread Jingwei Lu (JIRA)
Jingwei Lu created HIVE-3672: Summary: Support altering partition column type in Hive Key: HIVE-3672 URL: https://issues.apache.org/jira/browse/HIVE-3672 Project: Hive Issue Type: Improvement

[jira] [Created] (HIVE-3673) Sort merge join not used when join columns have different names

2012-11-05 Thread Kevin Wilfong (JIRA)
Kevin Wilfong created HIVE-3673: --- Summary: Sort merge join not used when join columns have different names Key: HIVE-3673 URL: https://issues.apache.org/jira/browse/HIVE-3673 Project: Hive

[jira] [Commented] (HIVE-3673) Sort merge join not used when join columns have different names

2012-11-05 Thread Kevin Wilfong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13491030#comment-13491030 ] Kevin Wilfong commented on HIVE-3673: - https://reviews.facebook.net/D6483

[jira] [Updated] (HIVE-3673) Sort merge join not used when join columns have different names

2012-11-05 Thread Kevin Wilfong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Wilfong updated HIVE-3673: Attachment: HIVE-3673.1.patch.txt Sort merge join not used when join columns have different

[jira] [Updated] (HIVE-3673) Sort merge join not used when join columns have different names

2012-11-05 Thread Kevin Wilfong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Wilfong updated HIVE-3673: Status: Patch Available (was: Open) Sort merge join not used when join columns have different

[jira] [Created] (HIVE-3674) test case TestParse broken after recent checkin

2012-11-05 Thread Sambavi Muthukrishnan (JIRA)
Sambavi Muthukrishnan created HIVE-3674: --- Summary: test case TestParse broken after recent checkin Key: HIVE-3674 URL: https://issues.apache.org/jira/browse/HIVE-3674 Project: Hive

[jira] [Commented] (HIVE-3674) test case TestParse broken after recent checkin

2012-11-05 Thread Sambavi Muthukrishnan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13491063#comment-13491063 ] Sambavi Muthukrishnan commented on HIVE-3674: - Link to diff:

[jira] [Updated] (HIVE-3674) test case TestParse broken after recent checkin

2012-11-05 Thread Sambavi Muthukrishnan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sambavi Muthukrishnan updated HIVE-3674: Attachment: TestParseFix.1.patch test case TestParse broken after recent

[jira] [Updated] (HIVE-3674) test case TestParse broken after recent checkin

2012-11-05 Thread Sambavi Muthukrishnan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sambavi Muthukrishnan updated HIVE-3674: Affects Version/s: 0.9.0 Status: Patch Available (was: Open)

[jira] [Commented] (HIVE-3674) test case TestParse broken after recent checkin

2012-11-05 Thread Shreepadma Venugopalan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13491069#comment-13491069 ] Shreepadma Venugopalan commented on HIVE-3674: -- Thanks Sambavi for the patch.

[jira] [Commented] (HIVE-3674) test case TestParse broken after recent checkin

2012-11-05 Thread Kevin Wilfong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13491077#comment-13491077 ] Kevin Wilfong commented on HIVE-3674: - +1 Thanks Sambavi test case

[jira] [Updated] (HIVE-3649) Hive List Bucketing - enhance DDL to specify list bucketing table

2012-11-05 Thread Gang Tim Liu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3649?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gang Tim Liu updated HIVE-3649: --- Description: We need to differ normal skewed table from list bucketing table. we use an optional

[jira] [Updated] (HIVE-3649) Hive List Bucketing - enhance DDL to specify list bucketing table

2012-11-05 Thread Gang Tim Liu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3649?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gang Tim Liu updated HIVE-3649: --- Description: We need to differ normal skewed table from list bucketing table. we use an optional

[jira] [Commented] (HIVE-3229) null values being loaded as non-null values into Hive

2012-11-05 Thread Shengsheng Huang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13491160#comment-13491160 ] Shengsheng Huang commented on HIVE-3229: Do you mean you want the empty strings in

[jira] [Commented] (HIVE-895) Add SerDe for Avro serialized data

2012-11-05 Thread Ruslan Al-Fakikh (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-895?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13491177#comment-13491177 ] Ruslan Al-Fakikh commented on HIVE-895: --- Mithun, what distro do you use? Cloudera

[jira] [Commented] (HIVE-3674) test case TestParse broken after recent checkin

2012-11-05 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13491193#comment-13491193 ] Namit Jain commented on HIVE-3674: -- https://issues.apache.org/jira/browse/HIVE-3657 filed

[jira] [Commented] (HIVE-1362) column level statistics

2012-11-05 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13491194#comment-13491194 ] Namit Jain commented on HIVE-1362: -- I think you should wrap the error even if is being

[jira] [Updated] (HIVE-3673) Sort merge join not used when join columns have different names

2012-11-05 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3673: - Status: Open (was: Patch Available) comments on phabricator Sort merge join not used

[jira] [Updated] (HIVE-1362) column level statistics

2012-11-05 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-1362: - Status: Open (was: Patch Available) comments column level statistics

[jira] [Commented] (HIVE-3588) Get Hive to work with hbase 94

2012-11-05 Thread qipan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13491203#comment-13491203 ] qipan commented on HIVE-3588: - hi, I got an error when trying to use hive 0.9.0 import to

[jira] [Commented] (HIVE-3673) Sort merge join not used when join columns have different names

2012-11-05 Thread Kevin Wilfong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13491215#comment-13491215 ] Kevin Wilfong commented on HIVE-3673: - Addressed comments. Sort merge

[jira] [Updated] (HIVE-3673) Sort merge join not used when join columns have different names

2012-11-05 Thread Kevin Wilfong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Wilfong updated HIVE-3673: Attachment: HIVE-3673.2.patch.txt Sort merge join not used when join columns have different

[jira] [Updated] (HIVE-3673) Sort merge join not used when join columns have different names

2012-11-05 Thread Kevin Wilfong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Wilfong updated HIVE-3673: Status: Patch Available (was: Open) Sort merge join not used when join columns have different

[jira] [Created] (HIVE-3675) NaN does not work correctly for round(n)

2012-11-05 Thread Namit Jain (JIRA)
Namit Jain created HIVE-3675: Summary: NaN does not work correctly for round(n) Key: HIVE-3675 URL: https://issues.apache.org/jira/browse/HIVE-3675 Project: Hive Issue Type: Bug

[jira] [Commented] (HIVE-895) Add SerDe for Avro serialized data

2012-11-05 Thread Mithun Radhakrishnan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-895?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13491238#comment-13491238 ] Mithun Radhakrishnan commented on HIVE-895: --- @[~jghoman]: Thanks for clarifying.

[jira] [Commented] (HIVE-3673) Sort merge join not used when join columns have different names

2012-11-05 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13491242#comment-13491242 ] Namit Jain commented on HIVE-3673: -- +1 Sort merge join not used when

[jira] [Updated] (HIVE-3675) NaN does not work correctly for round(n)

2012-11-05 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3675?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3675: - Attachment: hive.3675.1.patch NaN does not work correctly for round(n)

[jira] [Created] (HIVE-3676) INSERT INTO regression caused by HIVE-3465

2012-11-05 Thread Carl Steinbach (JIRA)
Carl Steinbach created HIVE-3676: Summary: INSERT INTO regression caused by HIVE-3465 Key: HIVE-3676 URL: https://issues.apache.org/jira/browse/HIVE-3676 Project: Hive Issue Type: Bug

[jira] [Commented] (HIVE-3676) INSERT INTO regression caused by HIVE-3465

2012-11-05 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13491258#comment-13491258 ] Carl Steinbach commented on HIVE-3676: -- Prior to HIVE-3465 the following set of

[jira] [Updated] (HIVE-1362) column level statistics

2012-11-05 Thread Shreepadma Venugopalan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shreepadma Venugopalan updated HIVE-1362: - Status: Patch Available (was: Open) column level statistics

[jira] [Updated] (HIVE-1362) column level statistics

2012-11-05 Thread Shreepadma Venugopalan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shreepadma Venugopalan updated HIVE-1362: - Attachment: HIVE-1362_gen-thrift.10.patch.txt column level statistics

[jira] [Updated] (HIVE-1362) column level statistics

2012-11-05 Thread Shreepadma Venugopalan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shreepadma Venugopalan updated HIVE-1362: - Attachment: HIVE-1362.10.patch.txt column level statistics

[jira] [Commented] (HIVE-1362) column level statistics

2012-11-05 Thread Shreepadma Venugopalan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13491274#comment-13491274 ] Shreepadma Venugopalan commented on HIVE-1362: -- @Namit: The latest patch