[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

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-

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

[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

[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] [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

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] [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 > ---

[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] [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-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

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] [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

[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] [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] [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-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-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] [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] [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] [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] [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] [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

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

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

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

[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

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] [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

[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] [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] [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] [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] [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-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

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-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

[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-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-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

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-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

[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-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] [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=13423742#comment-13423742 ] Namit Jain commented on HIVE-2925: -- Sorry to have missed this. Will take a look now.

[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-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] [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