[jira] [Updated] (HIVE-2101) mapjoin sometimes gives wrong results if there is a filter in the on condition

2012-07-27 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-2101: - Resolution: Fixed Hadoop Flags: Reviewed Status: Resolved (was: Patch Available) Committe

[jira] [Commented] (HIVE-2101) mapjoin sometimes gives wrong results if there is a filter in the on condition

2012-07-27 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13423719#comment-13423719 ] Namit Jain commented on HIVE-2101: -- In this case, we had tests with wrong results checked

[jira] [Commented] (HIVE-3286) Explicit skew join on user provided condition

2012-07-27 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13423734#comment-13423734 ] Namit Jain commented on HIVE-3286: -- // distributes randomly, disperses non driving alias

[jira] [Commented] (HIVE-3286) Explicit skew join on user provided condition

2012-07-27 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13423735#comment-13423735 ] Namit Jain commented on HIVE-3286: -- Otherwise, I think this is generic and is useful for H

[jira] [Commented] (HIVE-2925) Support non-MR fetching for simple queries with select/limit/filter operations only

2012-07-27 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2925?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13423742#comment-13423742 ] Namit Jain commented on HIVE-2925: -- Sorry to have missed this. Will take a look now.

[jira] [Commented] (HIVE-2925) Support non-MR fetching for simple queries with select/limit/filter operations only

2012-07-27 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2925?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13423743#comment-13423743 ] Namit Jain commented on HIVE-2925: -- Can you refresh ? The patch is not applying cleanly a

[jira] [Commented] (HIVE-2925) Support non-MR fetching for simple queries with select/limit/filter operations only

2012-07-27 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2925?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13423754#comment-13423754 ] Namit Jain commented on HIVE-2925: -- Can you break it into 2 separate jiras -- reduce inp

[jira] [Created] (HIVE-3307) Hive Web Interfaces Wishes

2012-07-27 Thread Bertrand Dechoux (JIRA)
Bertrand Dechoux created HIVE-3307: -- Summary: Hive Web Interfaces Wishes Key: HIVE-3307 URL: https://issues.apache.org/jira/browse/HIVE-3307 Project: Hive Issue Type: Wish Componen

[jira] [Commented] (HIVE-3301) Fix quote printing bug in mapreduce_stack_trace.q testcase failure when running hive on hadoop23

2012-07-27 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13423778#comment-13423778 ] Hudson commented on HIVE-3301: -- Integrated in Hive-trunk-h0.21 #1570 (See [https://builds.apa

Hive-trunk-h0.21 - Build # 1570 - Fixed

2012-07-27 Thread Apache Jenkins Server
Changes for Build #1566 [cws] HIVE-3249 [jira] Upgrade guava to 11.0.2 (Zhenxiao Luo via Carl Steinbach) Summary: HIVE-3249: Upgrade guava to 11.0.2 Hadoop has upgraded to this new version of Guava. We should, too, so we don't have compatibility issues running on Hadoop 2.0+ currently, hive is

[jira] [Commented] (HIVE-2925) Support non-MR fetching for simple queries with select/limit/filter operations only

2012-07-27 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2925?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13423792#comment-13423792 ] Namit Jain commented on HIVE-2925: -- It would be very difficult to deploy it this way. In

[jira] [Commented] (HIVE-3286) Explicit skew join on user provided condition

2012-07-27 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13423808#comment-13423808 ] Navis commented on HIVE-3286: - Most of our queries are driven by big table (500G~) joining smal

[jira] [Commented] (HIVE-3286) Explicit skew join on user provided condition

2012-07-27 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13423825#comment-13423825 ] Namit Jain commented on HIVE-3286: -- But, if you know the skewed keys, cant you create a gr

[jira] [Commented] (HIVE-2925) Support non-MR fetching for simple queries with select/limit/filter operations only

2012-07-27 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2925?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13423832#comment-13423832 ] Namit Jain commented on HIVE-2925: -- I was thinking about it more - what I said above canno

Re: Custom SerDe and getting column comments

2012-07-27 Thread Stephen Scaffid
On Jul 26, 2012, at 9:05 PM, Travis Crawford wrote: > Currently you can't use comments with custom serde's. Look into > MetaStoreUtils.getFieldsFromDeserializer and you'll see "from > deserializer" is hard-coded as the comment. I found that. I also found in org.apache.hadoop.hive.ql.metadata.Ta

[jira] [Commented] (HIVE-3286) Explicit skew join on user provided condition

2012-07-27 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13423856#comment-13423856 ] Navis commented on HIVE-3286: - I cannot understand exactly what you said 'create group for each

[jira] [Commented] (HIVE-3307) Hive Web Interfaces Wishes

2012-07-27 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13423865#comment-13423865 ] Edward Capriolo commented on HIVE-3307: --- All good stuff. I would like to see the expl

[jira] [Commented] (HIVE-3307) Hive Web Interfaces Wishes

2012-07-27 Thread Bertrand Dechoux (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13423875#comment-13423875 ] Bertrand Dechoux commented on HIVE-3307: I have done tests with the CLI. Explain is

[jira] [Created] (HIVE-3308) Mixing avro and snappy gives null values

2012-07-27 Thread Bennie Schut (JIRA)
Bennie Schut created HIVE-3308: -- Summary: Mixing avro and snappy gives null values Key: HIVE-3308 URL: https://issues.apache.org/jira/browse/HIVE-3308 Project: Hive Issue Type: Bug Com

[jira] [Updated] (HIVE-3308) Mixing avro and snappy gives null values

2012-07-27 Thread Bennie Schut (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3308?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bennie Schut updated HIVE-3308: --- Attachment: HIVE-3308.patch1.txt Added a test to show the problem. Result of the test will show:

[jira] [Commented] (HIVE-3307) Hive Web Interfaces Wishes

2012-07-27 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13423881#comment-13423881 ] Edward Capriolo commented on HIVE-3307: --- The explain is not two parts it is a normal

[jira] [Created] (HIVE-3309) drop partition doesnot work for mixture of string and non-string columns for non-equality operatior

2012-07-27 Thread rohithsharma (JIRA)
rohithsharma created HIVE-3309: -- Summary: drop partition doesnot work for mixture of string and non-string columns for non-equality operatior Key: HIVE-3309 URL: https://issues.apache.org/jira/browse/HIVE-3309

connector ODBC hive (cloudera) and IBM cognos

2012-07-27 Thread Matouk Iftissen
Hello every one Is there any driver ODBC developed by cloudera or others (rather then ODBC developed for Tableau because it does not work on Windows Server 2008 R2 64bit) to use it with cognos BI server (8.4) for OS (on Windows Server 2008 R2 64bit). Thanks. Best regards. Matouk Iftissen

[jira] [Commented] (HIVE-2101) mapjoin sometimes gives wrong results if there is a filter in the on condition

2012-07-27 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13423934#comment-13423934 ] Hudson commented on HIVE-2101: -- Integrated in Hive-trunk-h0.21 #1571 (See [https://builds.apa

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

2012-07-27 Thread Apache Jenkins Server
Changes for Build #1571 [namit] HIVE-2101 mapjoin sometimes gives wrong results if there is a filter in the on condition (Navis via namit) 2 tests failed. REGRESSION: org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_stats_aggregator_error_1 Error Message: Forked Java V

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

2012-07-27 Thread Apache Jenkins Server
See -- [...truncated 5465 lines...] [mkdir] Created dir: /x1/jenkins/jenkins-slave/workspace/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/hive/build/pdk/classes [mkdir] Crea

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

2012-07-27 Thread Apache Jenkins Server
See -- [...truncated 67407 lines...] [junit] POSTHOOK: query: select count(1) as cnt from testhivedrivertable [junit] POSTHOOK: type: DROPTABLE [junit] POSTHOOK: Input: default@testhiv

[jira] [Commented] (HIVE-3309) drop partition doesnot work for mixture of string and non-string columns for non-equality operatior

2012-07-27 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13424001#comment-13424001 ] Ashutosh Chauhan commented on HIVE-3309: Which version of Hive are you using. This

[jira] [Assigned] (HIVE-3215) JobDebugger should use RunningJob.getTrackingURL

2012-07-27 Thread Bhushan Mandhani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3215?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bhushan Mandhani reassigned HIVE-3215: -- Assignee: Bhushan Mandhani (was: Ramkumar Vadali) > JobDebugger should use RunningJ

[jira] [Updated] (HIVE-3215) JobDebugger should use RunningJob.getTrackingURL

2012-07-27 Thread Bhushan Mandhani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3215?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bhushan Mandhani updated HIVE-3215: --- Attachment: HIVE-3215.3.patch.txt > JobDebugger should use RunningJob.getTrackingURL > --

[jira] [Updated] (HIVE-3215) JobDebugger should use RunningJob.getTrackingURL

2012-07-27 Thread Bhushan Mandhani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3215?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bhushan Mandhani updated HIVE-3215: --- Status: Patch Available (was: Open) > JobDebugger should use RunningJob.getTrackingURL >

[jira] [Commented] (HIVE-3215) JobDebugger should use RunningJob.getTrackingURL

2012-07-27 Thread Zhenxiao Luo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13424056#comment-13424056 ] Zhenxiao Luo commented on HIVE-3215: @Bhushan: Could you send a phabricator review req

[jira] [Commented] (HIVE-3310) [Regression] TestMTQueries test is failing on trunk

2012-07-27 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3310?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13424076#comment-13424076 ] Ashutosh Chauhan commented on HIVE-3310: I am able to reproduce this locally on ubu

[jira] [Created] (HIVE-3310) [Regression] TestMTQueries test is failing on trunk

2012-07-27 Thread Ashutosh Chauhan (JIRA)
Ashutosh Chauhan created HIVE-3310: -- Summary: [Regression] TestMTQueries test is failing on trunk Key: HIVE-3310 URL: https://issues.apache.org/jira/browse/HIVE-3310 Project: Hive Issue Type

[jira] [Commented] (HIVE-3215) JobDebugger should use RunningJob.getTrackingURL

2012-07-27 Thread Bhushan Mandhani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13424101#comment-13424101 ] Bhushan Mandhani commented on HIVE-3215: Phabricator diff is at https://reviews.fac

[jira] [Created] (HIVE-3311) Convert runtime exceptions to semantic exceptions for validation of alter table commands

2012-07-27 Thread Sambavi Muthukrishnan (JIRA)
Sambavi Muthukrishnan created HIVE-3311: --- Summary: Convert runtime exceptions to semantic exceptions for validation of alter table commands Key: HIVE-3311 URL: https://issues.apache.org/jira/browse/HIVE-3311

[jira] [Created] (HIVE-3312) Improve Hive Map to HBase column family

2012-07-27 Thread Swarnim Kulkarni (JIRA)
Swarnim Kulkarni created HIVE-3312: -- Summary: Improve Hive Map to HBase column family Key: HIVE-3312 URL: https://issues.apache.org/jira/browse/HIVE-3312 Project: Hive Issue Type: Improvemen

[jira] [Updated] (HIVE-3312) Improve Hive Map to HBase column family

2012-07-27 Thread Swarnim Kulkarni (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3312?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Swarnim Kulkarni updated HIVE-3312: --- Description: The documentation states the following way to use a map to access a whole column

Hive-trunk-h0.21 - Build # 1572 - Still Failing

2012-07-27 Thread Apache Jenkins Server
Changes for Build #1571 [namit] HIVE-2101 mapjoin sometimes gives wrong results if there is a filter in the on condition (Navis via namit) Changes for Build #1572 2 tests failed. FAILED: org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_script_broken_pipe1 Error Messag

[jira] [Commented] (HIVE-3311) Convert runtime exceptions to semantic exceptions for validation of alter table commands

2012-07-27 Thread Sambavi Muthukrishnan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3311?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13424223#comment-13424223 ] Sambavi Muthukrishnan commented on HIVE-3311: - Differential: https://reviews.fa

[jira] [Created] (HIVE-3313) Support tasklog retrieval for MRv2

2012-07-27 Thread Carl Steinbach (JIRA)
Carl Steinbach created HIVE-3313: Summary: Support tasklog retrieval for MRv2 Key: HIVE-3313 URL: https://issues.apache.org/jira/browse/HIVE-3313 Project: Hive Issue Type: Bug Compo

[jira] [Commented] (HIVE-3313) Support tasklog retrieval for MRv2

2012-07-27 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13424231#comment-13424231 ] Carl Steinbach commented on HIVE-3313: -- MRv2 replaced MRv1's TaskLogServlet with the J

[jira] [Updated] (HIVE-3313) Support tasklog retrieval for MRv2

2012-07-27 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3313?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-3313: - Component/s: Diagnosability > Support tasklog retrieval for MRv2 > ---

Re: Lisk Bucketing DDL Patch

2012-07-27 Thread Carl Steinbach
> Since we are close to release the first patch DDL. In a comment on the design doc you said that the first phase would involve implementing this feature for a single-column end-to-end (DML+DDL). Has that plan changed? Thanks. Carl On Wed, Jul 25, 2012 at 12:31 AM, Gang Tim Liu wrote: > Dear

[jira] [Commented] (HIVE-3313) Support tasklog retrieval for MRv2

2012-07-27 Thread Swarnim Kulkarni (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3313?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13424250#comment-13424250 ] Swarnim Kulkarni commented on HIVE-3313: The post here[1] explains other issues whi

[jira] [Created] (HIVE-3314) Extract global limit configuration to optimizer

2012-07-27 Thread Navis (JIRA)
Navis created HIVE-3314: --- Summary: Extract global limit configuration to optimizer Key: HIVE-3314 URL: https://issues.apache.org/jira/browse/HIVE-3314 Project: Hive Issue Type: Task Component

[jira] [Updated] (HIVE-3314) Extract global limit configuration to optimizer

2012-07-27 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-3314: Status: Patch Available (was: Open) https://reviews.facebook.net/D4419 > Extract global limit conf

Re: Lisk Bucketing DDL Patch

2012-07-27 Thread Namit Jain
Yes, that patch will become quiet big to be done a single shot. Moreover, the skew information can be used by a variety of use-cases. 1. List Bucketing 2. Skew Joins: https://cwiki.apache.org/Hive/skewed-join-optimization.html 3. Another variant of skew joins: https://issues.apache.org/jira/brows

Re: Lisk Bucketing DDL Patch

2012-07-27 Thread Gang Tim Liu
Yes, Namit has a great summary. thanks On 7/27/12 9:09 PM, "Namit Jain" wrote: >Yes, that patch will become quiet big to be done a single shot. > >Moreover, the skew information can be used by a variety of use-cases. > >1. List Bucketing >2. Skew Joins: https://cwiki.apache.org/Hive/skewed-join-

[jira] [Commented] (HIVE-3309) drop partition doesnot work for mixture of string and non-string columns for non-equality operatior

2012-07-27 Thread rohithsharma (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3309?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13424271#comment-13424271 ] rohithsharma commented on HIVE-3309: bq. Which version of Hive are you using.? I am usi