[jira] [Created] (HIVE-4688) NPE in writing null values.

2013-06-07 Thread Jitendra Nath Pandey (JIRA)
Jitendra Nath Pandey created HIVE-4688: -- Summary: NPE in writing null values. Key: HIVE-4688 URL: https://issues.apache.org/jira/browse/HIVE-4688 Project: Hive Issue Type: Sub-task

[jira] [Resolved] (HIVE-4668) wrong results for query with modulo (%) in WHERE clause filter

2013-06-07 Thread Jitendra Nath Pandey (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jitendra Nath Pandey resolved HIVE-4668. Resolution: Fixed > wrong results for query with modulo (%) in WHERE clause filt

[jira] [Updated] (HIVE-4064) Handle db qualified names consistently across all HiveQL statements

2013-06-07 Thread caofangkun (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4064?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] caofangkun updated HIVE-4064: - Assignee: caofangkun > Handle db qualified names consistently across all HiveQL statements > -

Very slow insert performance on Amazon EMR when using Dynamic Partitions

2013-06-07 Thread Shaun Clowes
Hi All, I'm trying to track down the root cause of some terrible insert performance I'm seeing on Hive 0.8.1 in Amazon EMR. When I run an identical insert with a static partition I get around 15 times the the throughput (across the cluster) as I do when I use dynamic partitions. There are very few

[jira] [Commented] (HIVE-4055) add Date data type

2013-06-07 Thread Jason Dere (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4055?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678623#comment-13678623 ] Jason Dere commented on HIVE-4055: -- Also, I am willing to make those additions to your pat

[jira] [Commented] (HIVE-4667) tpch query 1 fails with java.lang.ClassCastException

2013-06-07 Thread Jitendra Nath Pandey (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678558#comment-13678558 ] Jitendra Nath Pandey commented on HIVE-4667: Patch uploaded. The patch includes

[jira] [Updated] (HIVE-4667) tpch query 1 fails with java.lang.ClassCastException

2013-06-07 Thread Jitendra Nath Pandey (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jitendra Nath Pandey updated HIVE-4667: --- Attachment: HIVE-4667.1.patch > tpch query 1 fails with java.lang.ClassCastExcepti

[jira] [Assigned] (HIVE-4667) tpch query 1 fails with java.lang.ClassCastException

2013-06-07 Thread Jitendra Nath Pandey (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jitendra Nath Pandey reassigned HIVE-4667: -- Assignee: Jitendra Nath Pandey > tpch query 1 fails with java.lang.ClassCast

[jira] [Commented] (HIVE-4245) Implement numeric dictionaries in ORC

2013-06-07 Thread Pamela Vagata (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4245?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678544#comment-13678544 ] Pamela Vagata commented on HIVE-4245: - My patch depends on the resolution to: HIVE-4324

[jira] [Commented] (HIVE-4588) Support session level hooks for HiveServer2

2013-06-07 Thread Shreepadma Venugopalan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678515#comment-13678515 ] Shreepadma Venugopalan commented on HIVE-4588: -- +1 (non-binding), LGTM.

Re: Review Request: HIVE-4588: Support session level hooks for HiveServer2

2013-06-07 Thread Shreepadma Venugopalan
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/11326/#review21599 --- LGTM! - Shreepadma Venugopalan On May 22, 2013, 6:41 a.m., Prasad

Re: Review Request: HIVE-4670. Authentication module should pass the instance part of the Kerberos principle

2013-06-07 Thread Shreepadma Venugopalan
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/11705/ --- (Updated June 7, 2013, 10:10 p.m.) Review request for hive, Ashutosh Chauhan an

[jira] [Updated] (HIVE-4670) Authentication module should pass the instance part of the Kerberos principle

2013-06-07 Thread Shreepadma Venugopalan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Shreepadma Venugopalan updated HIVE-4670: - Attachment: HIVE-4670.3.patch > Authentication module should pass the instance

[jira] [Updated] (HIVE-4678) second clause of AND, OR filter not applied for vectorized execution

2013-06-07 Thread Jitendra Nath Pandey (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4678?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jitendra Nath Pandey updated HIVE-4678: --- Summary: second clause of AND, OR filter not applied for vectorized execution (was: s

[jira] [Resolved] (HIVE-4680) second clause of OR filter not applied in vectorized query execution

2013-06-07 Thread Jitendra Nath Pandey (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4680?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jitendra Nath Pandey resolved HIVE-4680. Resolution: Duplicate It is same issue as HIVE-4678. > second claus

[jira] [Assigned] (HIVE-4678) second clause of AND filter not applied for vectorized execution

2013-06-07 Thread Jitendra Nath Pandey (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4678?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jitendra Nath Pandey reassigned HIVE-4678: -- Assignee: Jitendra Nath Pandey > second clause of AND filter not applied for

[jira] [Assigned] (HIVE-4680) second clause of OR filter not applied in vectorized query execution

2013-06-07 Thread Jitendra Nath Pandey (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4680?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jitendra Nath Pandey reassigned HIVE-4680: -- Assignee: Jitendra Nath Pandey > second clause of OR filter not applied in v

[jira] [Commented] (HIVE-4678) second clause of AND filter not applied for vectorized execution

2013-06-07 Thread Jitendra Nath Pandey (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678489#comment-13678489 ] Jitendra Nath Pandey commented on HIVE-4678: This issue is same as HIVE-4680, w

[jira] [Updated] (HIVE-4681) Fix ORC TimestampTreeReader.nextVector() to handle milli-nano math corectly

2013-06-07 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4681?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-4681: --- Resolution: Fixed Fix Version/s: vectorization-branch Status: Resolved (was:

[jira] [Resolved] (HIVE-4599) VectorGroupByOperator steals the non-vectorized children and crashes query if vectorization fails

2013-06-07 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan resolved HIVE-4599. Resolution: Fixed Fix Version/s: vectorization-branch Committed to branch. Thanks, Ji

[jira] [Updated] (HIVE-4687) incorrect result for max aggregate over int column

2013-06-07 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4687?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4687: -- Assignee: Remus Rusanu > incorrect result for max aggregate over int column > --

[jira] [Created] (HIVE-4687) incorrect result for max aggregate over int column

2013-06-07 Thread Eric Hanson (JIRA)
Eric Hanson created HIVE-4687: - Summary: incorrect result for max aggregate over int column Key: HIVE-4687 URL: https://issues.apache.org/jira/browse/HIVE-4687 Project: Hive Issue Type: Sub-task

[jira] [Commented] (HIVE-4676) Optimize COUNT(*) aggregate over vectorized ORC execution path

2013-06-07 Thread Remus Rusanu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678442#comment-13678442 ] Remus Rusanu commented on HIVE-4676: The count(*) aggregate is already optimized to jus

[jira] [Updated] (HIVE-4686) Max on float returning wrong results

2013-06-07 Thread Remus Rusanu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Remus Rusanu updated HIVE-4686: --- Assignee: Remus Rusanu > Max on float returning wrong results > --

[jira] [Commented] (HIVE-4686) Max on float returning wrong results

2013-06-07 Thread Tony Murphy (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678435#comment-13678435 ] Tony Murphy commented on HIVE-4686: --- i can provide a repro environment if necessary.

[jira] [Commented] (HIVE-4599) VectorGroupByOperator steals the non-vectorized children and crashes query if vectorization fails

2013-06-07 Thread Jitendra Nath Pandey (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678411#comment-13678411 ] Jitendra Nath Pandey commented on HIVE-4599: Those messages are logged at debug

[jira] [Created] (HIVE-4686) Max on float returning wrong results

2013-06-07 Thread Tony Murphy (JIRA)
Tony Murphy created HIVE-4686: - Summary: Max on float returning wrong results Key: HIVE-4686 URL: https://issues.apache.org/jira/browse/HIVE-4686 Project: Hive Issue Type: Sub-task Affects Ve

[jira] [Commented] (HIVE-4685) query using LIKE does not vectorize

2013-06-07 Thread Jitendra Nath Pandey (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678410#comment-13678410 ] Jitendra Nath Pandey commented on HIVE-4685: Those messages are now logged in d

[jira] [Commented] (HIVE-4599) VectorGroupByOperator steals the non-vectorized children and crashes query if vectorization fails

2013-06-07 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678332#comment-13678332 ] Eric Hanson commented on HIVE-4599: --- This patch appears to take out the printed messages

[jira] [Updated] (HIVE-3685) TestCliDriver (script_pipe.q) failed with IBM JDK

2013-06-07 Thread Renata Ghisloti Duarte de Souza (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Renata Ghisloti Duarte de Souza updated HIVE-3685: -- Affects Version/s: 0.11.0 > TestCliDriver (script_pipe.q) fa

[jira] [Updated] (HIVE-3685) TestCliDriver (script_pipe.q) failed with IBM JDK

2013-06-07 Thread Renata Ghisloti Duarte de Souza (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Renata Ghisloti Duarte de Souza updated HIVE-3685: -- Attachment: HIVE_3685.patch > TestCliDriver (script_pipe.q)

[jira] [Commented] (HIVE-3685) TestCliDriver (script_pipe.q) failed with IBM JDK

2013-06-07 Thread Renata Ghisloti Duarte de Souza (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678326#comment-13678326 ] Renata Ghisloti Duarte de Souza commented on HIVE-3685: --- This fix wor

[jira] [Updated] (HIVE-4640) CommonOrcInputFormat should be the default input format for Orc tables.

2013-06-07 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4640?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-4640: --- Resolution: Fixed Fix Version/s: vectorization-branch Status: Resolved (was:

[jira] [Comment Edited] (HIVE-4640) CommonOrcInputFormat should be the default input format for Orc tables.

2013-06-07 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678323#comment-13678323 ] Ashutosh Chauhan edited comment on HIVE-4640 at 6/7/13 7:09 PM: -

[jira] [Commented] (HIVE-4502) NPE - subquery smb joins fails

2013-06-07 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678314#comment-13678314 ] Ashutosh Chauhan commented on HIVE-4502: [~navis] Sorry earlier I didnt look at the

[jira] [Commented] (HIVE-4685) query using LIKE does not vectorize

2013-06-07 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678256#comment-13678256 ] Eric Hanson commented on HIVE-4685: --- 4599 appears to take out the printed messages saying

[jira] [Updated] (HIVE-4685) query using LIKE does not vectorize

2013-06-07 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Hanson updated HIVE-4685: -- Summary: query using LIKE does not vectorize (was: query using LIKE does not vectorize, then crashes)

[jira] [Commented] (HIVE-4685) query using LIKE does not vectorize, then crashes

2013-06-07 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678251#comment-13678251 ] Eric Hanson commented on HIVE-4685: --- I applied the patch for HIVE-4599 and now the query

[jira] [Commented] (HIVE-4685) query using LIKE does not vectorize, then crashes

2013-06-07 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678215#comment-13678215 ] Eric Hanson commented on HIVE-4685: --- The same error happens for query: select count(ddat

[jira] [Commented] (HIVE-4549) JDBC compliance change TABLE_SCHEMA to TABLE_SCHEM

2013-06-07 Thread Shreepadma Venugopalan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678217#comment-13678217 ] Shreepadma Venugopalan commented on HIVE-4549: -- +1 (non-committer). LGTM.

Re: Review Request: HIVE-4549: JDBC compliance change TABLE_SCHEMA to TABLE_SCHEM

2013-06-07 Thread Shreepadma Venugopalan
> On June 7, 2013, 5:52 p.m., Shreepadma Venugopalan wrote: > > Ship It! LGTM! It will break applications that assert on TABLE_SCHEMA, but then those asserts are incorrect in the first place. - Shreepadma --- This is an automatically g

Re: Review Request: HIVE-4549: JDBC compliance change TABLE_SCHEMA to TABLE_SCHEM

2013-06-07 Thread Shreepadma Venugopalan
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/11706/#review21586 --- Ship it! Ship It! - Shreepadma Venugopalan On June 7, 2013, 2:10

[jira] [Commented] (HIVE-4685) query using LIKE does not vectorize, then crashes

2013-06-07 Thread Jitendra Nath Pandey (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678206#comment-13678206 ] Jitendra Nath Pandey commented on HIVE-4685: I suspect this is same as HIVE-45

[jira] [Created] (HIVE-4685) query using LIKE does not vectorize, then crashes

2013-06-07 Thread Eric Hanson (JIRA)
Eric Hanson created HIVE-4685: - Summary: query using LIKE does not vectorize, then crashes Key: HIVE-4685 URL: https://issues.apache.org/jira/browse/HIVE-4685 Project: Hive Issue Type: Sub-task

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

2013-06-07 Thread Phabricator (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2206?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-2206: -- Attachment: HIVE-2206.D11097.5.patch yhuai updated the revision "HIVE-2206 [jira] add a new optimizer fo

[jira] [Created] (HIVE-4684) Query with filter constant on left of "=" and column expression on right does not vectorize

2013-06-07 Thread Eric Hanson (JIRA)
Eric Hanson created HIVE-4684: - Summary: Query with filter constant on left of "=" and column expression on right does not vectorize Key: HIVE-4684 URL: https://issues.apache.org/jira/browse/HIVE-4684 Pro

[jira] [Commented] (HIVE-4684) Query with filter constant on left of "=" and column expression on right does not vectorize

2013-06-07 Thread Eric Hanson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678189#comment-13678189 ] Eric Hanson commented on HIVE-4684: --- Similarly, this query does not vectorize: select dm

[jira] [Commented] (HIVE-4681) Fix ORC TimestampTreeReader.nextVector() to handle milli-nano math corectly

2013-06-07 Thread Sarvesh Sakalanaga (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4681?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678187#comment-13678187 ] Sarvesh Sakalanaga commented on HIVE-4681: -- +1 for the patch. Thanks for fixing th

Re: Review Request: HIVE-4670. Authentication module should pass the instance part of the Kerberos principle

2013-06-07 Thread Brock Noland
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/11705/#review21583 --- Hi, LGLT! There are two minor nit's I noticed while looking at the

[jira] [Assigned] (HIVE-4113) select count(1) reads all columns with RCFile

2013-06-07 Thread Brock Noland (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4113?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Brock Noland reassigned HIVE-4113: -- Assignee: Brock Noland > select count(1) reads all columns with RCFile > ---

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

2013-06-07 Thread Phabricator (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2206?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-2206: -- Attachment: HIVE-2206.D11097.4.patch yhuai updated the revision "HIVE-2206 [jira] add a new optimizer fo

[jira] [Resolved] (HIVE-4605) hive job fails when insert overwrite ORC table

2013-06-07 Thread Brock Noland (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Brock Noland resolved HIVE-4605. Resolution: Cannot Reproduce Assignee: Brock Noland I cannot reproduce this, it was either fix

[jira] [Commented] (HIVE-615) new user functions needed for HIVE

2013-06-07 Thread Brock Noland (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-615?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678122#comment-13678122 ] Brock Noland commented on HIVE-615: --- Functions still needed binary make_set quote substr

[jira] [Commented] (HIVE-684) add UDF make_set

2013-06-07 Thread Brock Noland (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678117#comment-13678117 ] Brock Noland commented on HIVE-684: --- This patch no longer applies. > add

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

2013-06-07 Thread Phabricator (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2206?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13678116#comment-13678116 ] Phabricator commented on HIVE-2206: --- brock has commented on the revision "HIVE-2206 [jira

[jira] [Updated] (HIVE-4115) Introduce cube abstraction in hive

2013-06-07 Thread Phabricator (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-4115: -- Attachment: HIVE-4115.D10689.4.patch Amareshwari updated the revision "HIVE-4115 [jira] Introduce cube a