[jira] [Commented] (HIVE-9537) string expressions on a fixed length character do not preserve trailing spaces

2015-02-18 Thread Jason Dere (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14327087#comment-14327087 ] Jason Dere commented on HIVE-9537: -- This was by design. The SQL spec didn't seem to have a

[jira] [Created] (HIVE-9721) Hadoop23Shims.setFullFileStatus should check for null

2015-02-18 Thread Brock Noland (JIRA)
Brock Noland created HIVE-9721: -- Summary: Hadoop23Shims.setFullFileStatus should check for null Key: HIVE-9721 URL: https://issues.apache.org/jira/browse/HIVE-9721 Project: Hive Issue Type: Bug

[jira] [Created] (HIVE-9720) Metastore does not properly migrate column stats when renaming a table across databases.

2015-02-18 Thread Alexander Behm (JIRA)
Alexander Behm created HIVE-9720: Summary: Metastore does not properly migrate column stats when renaming a table across databases. Key: HIVE-9720 URL: https://issues.apache.org/jira/browse/HIVE-9720

Re: [VOTE] Apache Hive 1.1.0 Release Candidate 3

2015-02-18 Thread Xuefu Zhang
+1 1. downloaded the src tarball and built w/ -Phadoop-1/2 2. verified no binary (jars) in the src tarball On Wed, Feb 18, 2015 at 8:56 PM, Brock Noland wrote: > +1 > > verified sigs, hashes, created tables, ran MR on YARN jobs > > On Wed, Feb 18, 2015 at 8:54 PM, Brock Noland wrote: > > Apach

Review Request 31178: Discrepancy in cardinality estimates between partitioned and un-partitioned tables

2015-02-18 Thread pengcheng xiong
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/31178/ --- Review request for hive and Ashutosh Chauhan. Repository: hive-git Descriptio

[jira] [Commented] (HIVE-9647) Discrepancy in cardinality estimates between partitioned and un-partitioned tables

2015-02-18 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326995#comment-14326995 ] Pengcheng Xiong commented on HIVE-9647: --- [~mmokhtar], the test failure is unrelated a

Re: [VOTE] Apache Hive 1.1.0 Release Candidate 3

2015-02-18 Thread Brock Noland
+1 verified sigs, hashes, created tables, ran MR on YARN jobs On Wed, Feb 18, 2015 at 8:54 PM, Brock Noland wrote: > Apache Hive 1.1.0 Release Candidate 3 is available here: > http://people.apache.org/~brock/apache-hive-1.1.0-rc3/ > > Maven artifacts are available here: > https://repository.apac

[VOTE] Apache Hive 1.1.0 Release Candidate 3

2015-02-18 Thread Brock Noland
Apache Hive 1.1.0 Release Candidate 3 is available here: http://people.apache.org/~brock/apache-hive-1.1.0-rc3/ Maven artifacts are available here: https://repository.apache.org/content/repositories/orgapachehive-1026/ Source tag for RC3 is at: http://svn.apache.org/repos/asf/hive/tags/release-1.

[jira] [Commented] (HIVE-9647) Discrepancy in cardinality estimates between partitioned and un-partitioned tables

2015-02-18 Thread Hive QA (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326927#comment-14326927 ] Hive QA commented on HIVE-9647: --- {color:red}Overall{color}: -1 at least one tests failed H

[jira] [Commented] (HIVE-9561) SHUFFLE_SORT should only be used for order by query [Spark Branch]

2015-02-18 Thread Rui Li (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326921#comment-14326921 ] Rui Li commented on HIVE-9561: -- Thank you Xuefu! > SHUFFLE_SORT should only be used for order

Re: [VOTE] Apache Hive 1.1.0 Release Candidate 2

2015-02-18 Thread Eugene Koifman
I imagine it¹s possible but I¹m not sure it¹s worth the effort. webhcat-site.xml has to be edited during installation anyway since the tar files have to be copied to HDFS to a location that we don¹t know at build time. The values of these properties then depend on the name of the tar files on HDFS

[jira] [Reopened] (HIVE-9537) string expressions on a fixed length character do not preserve trailing spaces

2015-02-18 Thread N Campbell (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] N Campbell reopened HIVE-9537: -- The Hive documentation is vague at best with respect to when padding is preserved/ignored: "Char types are

[jira] [Commented] (HIVE-9719) Up calcite version on cbo branch

2015-02-18 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9719?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326850#comment-14326850 ] Julian Hyde commented on HIVE-9719: --- I just pushed the snapshot. It is based on https://

[jira] [Commented] (HIVE-9647) Discrepancy in cardinality estimates between partitioned and un-partitioned tables

2015-02-18 Thread Mostafa Mokhtar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326844#comment-14326844 ] Mostafa Mokhtar commented on HIVE-9647: --- Awesome :) I am happy we can fix this.

Re: [VOTE] Apache Hive 1.1.0 Release Candidate 2

2015-02-18 Thread Gopal Vijayaraghavan
On 2/18/15, 3:48 PM, "Brock Noland" wrote: >> >> Does any of the same compatibility issues occur when using a >>hive-exec.jar >> containing guava-14 on MRv2 (which has guava-11 in the classpath)? > >Not that I am aware of. I've tested it on top of MRv2 a number of >times and I think the unit tes

[jira] [Commented] (HIVE-9613) Left join query plan outputs wrong column when using subquery

2015-02-18 Thread Chao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326838#comment-14326838 ] Chao commented on HIVE-9613: Hi [~spyfree], sorry I was wrong before - in the upstream trunk I

[jira] [Updated] (HIVE-9647) Discrepancy in cardinality estimates between partitioned and un-partitioned tables

2015-02-18 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-9647: -- Status: Patch Available (was: Open) > Discrepancy in cardinality estimates between partitioned a

[jira] [Updated] (HIVE-9647) Discrepancy in cardinality estimates between partitioned and un-partitioned tables

2015-02-18 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong updated HIVE-9647: -- Attachment: HIVE-9647.01.patch Current HIVE implements the NDV using Flajolet-Martin algorithm. I

[jira] [Commented] (HIVE-8807) Obsolete default values in webhcat-default.xml

2015-02-18 Thread Lefty Leverenz (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-8807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326827#comment-14326827 ] Lefty Leverenz commented on HIVE-8807: -- This also needs to be done for release 1.1.0,

Re: [VOTE] Apache Hive 1.1.0 Release Candidate 2

2015-02-18 Thread Brock Noland
We should be able to generate those values in webhcat-default.xml. Eugene? On Wed, Feb 18, 2015 at 4:43 PM, Lefty Leverenz wrote: > Four configuration values in webhcat-default.xml need to be updated (same > as HIVE-8807 updated in > the patch for

[jira] [Assigned] (HIVE-9647) Discrepancy in cardinality estimates between partitioned and un-partitioned tables

2015-02-18 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong reassigned HIVE-9647: - Assignee: Pengcheng Xiong (was: Gunther Hagleitner) > Discrepancy in cardinality estimate

Re: [VOTE] Apache Hive 1.1.0 Release Candidate 2

2015-02-18 Thread Lefty Leverenz
Four configuration values in webhcat-default.xml need to be updated (same as HIVE-8807 updated in the patch for release 1.0.0 ): - templeton.pig.path - templeton.hive.p

[jira] [Commented] (HIVE-9703) Merge from Spark branch to trunk 02/16/2015

2015-02-18 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9703?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326814#comment-14326814 ] Xuefu Zhang commented on HIVE-9703: --- No doc is needed for this JIRA. Any doc impact shoul

[jira] [Commented] (HIVE-9703) Merge from Spark branch to trunk 02/16/2015

2015-02-18 Thread Lefty Leverenz (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9703?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326776#comment-14326776 ] Lefty Leverenz commented on HIVE-9703: -- Does any of this need documentation, or can we

Re: [VOTE] Apache Hive 1.1.0 Release Candidate 2

2015-02-18 Thread Brock Noland
Yeah that is really strange. I have seen that before, a long time back, and but not found the root cause. I think it's a bug in either antlr or how we use antlr. I will re-generate the binaries and start another vote. Note the source tag will be the same which is technically what we vote on.. On

Re: [VOTE] Apache Hive 1.1.0 Release Candidate 2

2015-02-18 Thread Chao Sun
I tested apache-hive.1.1.0-bin and I also got the same error as Szehon reported. On Wed, Feb 18, 2015 at 3:48 PM, Brock Noland wrote: > Hi, > > > > On Wed, Feb 18, 2015 at 2:21 PM, Gopal Vijayaraghavan > wrote: > > Hi, > > > > From the release branch, I noticed that the hive-exec.jar now contai

Re: [VOTE] Apache Hive 1.1.0 Release Candidate 2

2015-02-18 Thread Brock Noland
Hi, On Wed, Feb 18, 2015 at 2:21 PM, Gopal Vijayaraghavan wrote: > Hi, > > From the release branch, I noticed that the hive-exec.jar now contains a > copy of guava-14 without any relocations. > > The hive spark-client pom.xml adds guava as a lib jar instead of shading > it in. > > https://githu

Re: [VOTE] Apache Hive 1.1.0 Release Candidate 2

2015-02-18 Thread Szehon Ho
Checked the md5 and the signature of both. Built src and ran a few queries with CLI/Beeline. Something very strange.. with the bin I cannot create any table at all (says FAILED: SemanticException Line 1:13 Invalid table name..), I am not sure what is wrong, as it works using the one I build from s

[jira] [Updated] (HIVE-9719) Up calcite version on cbo branch

2015-02-18 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9719?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-9719: --- Attachment: HIVE-9719.cbo.patch > Up calcite version on cbo branch > --

[jira] [Created] (HIVE-9719) Up calcite version on cbo branch

2015-02-18 Thread Ashutosh Chauhan (JIRA)
Ashutosh Chauhan created HIVE-9719: -- Summary: Up calcite version on cbo branch Key: HIVE-9719 URL: https://issues.apache.org/jira/browse/HIVE-9719 Project: Hive Issue Type: Task Co

[jira] [Comment Edited] (HIVE-7292) Hive on Spark

2015-02-18 Thread Lefty Leverenz (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326644#comment-14326644 ] Lefty Leverenz edited comment on HIVE-7292 at 2/18/15 10:49 PM: -

[jira] [Commented] (HIVE-7292) Hive on Spark

2015-02-18 Thread Lefty Leverenz (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326675#comment-14326675 ] Lefty Leverenz commented on HIVE-7292: -- Doc note: See comments on HIVE-9257 and HIVE-

Re: [VOTE] Apache Hive 1.1.0 Release Candidate 2

2015-02-18 Thread Prasad Mujumdar
Sounds good. +1 Verified checksums of source and binary tarballs Compiled with hadoop-1 and hadoop-2 profiles with distributions Ran maven verify thanks Prasad On Wed, Feb 18, 2015 at 12:50 PM, Brock Noland wrote: > Good idea... since it's not a blocker I will add that for 1.1.1 and 1.2.0

Re: [VOTE] Apache Hive 1.1.0 Release Candidate 2

2015-02-18 Thread Gopal Vijayaraghavan
Hi, >From the release branch, I noticed that the hive-exec.jar now contains a copy of guava-14 without any relocations. The hive spark-client pom.xml adds guava as a lib jar instead of shading it in. https://github.com/apache/hive/blob/branch-1.1/spark-client/pom.xml#L111 That seems to be a g

Re: VOTE Bylaw for having branch committers in hive

2015-02-18 Thread Lefty Leverenz
> > Should I change the bylaw for this type of vote happening to dev list > instead of the user mailing list as it is currently stated? > Sounds good to me. On the other hand, here are some arguments in favor of keeping this type of vote on the user mailing list: (1) wider distribution increases

Re: VOTE Bylaw for having branch committers in hive

2015-02-18 Thread Vikram Dixit K
Hi Carl, Here is the list of 17 active PMC members: Brock Noland Carl Steinbach Edward Capriolo Alan Gates Gunther Hagleitner Ashutosh Chauhan Jason Dere Lefty Leverenz Navis Ryu Owen O'Malley Prasad Suresh Mujumdar Prasanth J Harish Butani Szehon Ho Thejas Madhavan Nair Vikram Dixit K Xuefu Zhan

[jira] [Updated] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-02-18 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-3454: --- Attachment: (was: HIVE-3454.4.patch) > Problem with CAST(BIGINT as TIMESTAMP) > ---

[jira] [Updated] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-02-18 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-3454: --- Attachment: HIVE-3454.4.patch > Problem with CAST(BIGINT as TIMESTAMP) > --

[jira] [Commented] (HIVE-9718) Insert into dynamic partitions with same column structure in the "distibute by" clause barfs

2015-02-18 Thread Gopal V (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9718?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326539#comment-14326539 ] Gopal V commented on HIVE-9718: --- The bug aside, the DISTRIBUTE BY will result in a sub-optima

Re: [VOTE] Apache Hive 1.1.0 Release Candidate 2

2015-02-18 Thread Brock Noland
Good idea... since it's not a blocker I will add that for 1.1.1 and 1.2.0. On Wed, Feb 18, 2015 at 10:37 AM, Prasad Mujumdar wrote: > I guess the README.txt can list Apache Spark as query execution > framework along with MapReduce and Tez. > > thanks > Prasad > > > On Wed, Feb 18, 2015 at 8:2

[jira] [Commented] (HIVE-9613) Left join query plan outputs wrong column when using subquery

2015-02-18 Thread Chao (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326537#comment-14326537 ] Chao commented on HIVE-9613: OK, I was able to reproduce the issue on my cluster too. Previousl

[jira] [Updated] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-02-18 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-3454: --- Status: In Progress (was: Patch Available) > Problem with CAST(BIGINT as TIMESTAMP) >

[jira] [Updated] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-02-18 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-3454: --- Attachment: (was: HIVE-3454.3.patch) > Problem with CAST(BIGINT as TIMESTAMP) > ---

Re: VOTE Bylaw for having branch committers in hive

2015-02-18 Thread Carl Steinbach
Hi Vikram, Can you please post the names of the 17 currently active PMC members so that we have it for the records? Also, according to the bylaws this vote was supposed to happen on the user@hive list. Maybe we want to change this? Thanks. - Carl On Wed, Feb 18, 2015 at 12:25 PM, Vikram Dixit

Re: VOTE Bylaw for having branch committers in hive

2015-02-18 Thread Vikram Dixit K
Yes. The vote passes with 12 +1s out of 17 currently active PMC members. I will update the wiki with the new bylaws. On Wed, Feb 18, 2015 at 11:15 AM, Ashutosh Chauhan wrote: > Seems like there is consensus all around. > Vikram, > would you like to update the wiki with new bylaws? > > Thanks, >

[jira] [Updated] (HIVE-9718) Insert into dynamic partitions with same column structure in the "distibute by" clause barfs

2015-02-18 Thread Pavan Srinivas (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9718?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pavan Srinivas updated HIVE-9718: - Description: Sample reproducible query: {code} SET hive.exec.dynamic.partition.mode=nonstrict; SET

[jira] [Updated] (HIVE-9718) Insert into dynamic partitions with same column structure in the "distibute by" clause barfs

2015-02-18 Thread Pavan Srinivas (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9718?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pavan Srinivas updated HIVE-9718: - Description: Sample reproducible query: {code} SET hive.exec.dynamic.partition.mode=nonstrict; SET

[jira] [Updated] (HIVE-9718) Insert into dynamic partitions with same column structure in the "distibute by" clause barfs

2015-02-18 Thread Pavan Srinivas (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9718?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pavan Srinivas updated HIVE-9718: - Description: Sample reproducible query: {code} SET hive.exec.dynamic.partition.mode=nonstrict; SET

[jira] [Updated] (HIVE-9718) Insert into dynamic partitions with same column structure in the "distibute by" clause barfs

2015-02-18 Thread Pavan Srinivas (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9718?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pavan Srinivas updated HIVE-9718: - Description: Sample reproducible query: {code} SET hive.exec.dynamic.partition.mode=nonstrict; SET

[jira] [Updated] (HIVE-9718) Insert into dynamic partitions with same column structure in the "distibute by" clause barfs

2015-02-18 Thread Pavan Srinivas (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9718?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pavan Srinivas updated HIVE-9718: - Description: Sample reproducible query: {code} SET hive.exec.dynamic.partition.mode=nonstrict; SET

[jira] [Updated] (HIVE-9718) Insert into dynamic partitions with same column structure in the "distibute by" clause barfs

2015-02-18 Thread Pavan Srinivas (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9718?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pavan Srinivas updated HIVE-9718: - Priority: Critical (was: Major) > Insert into dynamic partitions with same column structure in the

[jira] [Updated] (HIVE-9718) Insert into dynamic partitions with same column structure in the "distibute by" clause barfs

2015-02-18 Thread Pavan Srinivas (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9718?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pavan Srinivas updated HIVE-9718: - Attachment: nation.tbl patch.txt > Insert into dynamic partitions with same column

[jira] [Created] (HIVE-9718) Insert into dynamic partitions with same column structure in the "distibute by" clause barfs

2015-02-18 Thread Pavan Srinivas (JIRA)
Pavan Srinivas created HIVE-9718: Summary: Insert into dynamic partitions with same column structure in the "distibute by" clause barfs Key: HIVE-9718 URL: https://issues.apache.org/jira/browse/HIVE-9718

[jira] [Assigned] (HIVE-9717) The max/min function used by AggrStats for decimal type is not what we expected

2015-02-18 Thread Pengcheng Xiong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pengcheng Xiong reassigned HIVE-9717: - Assignee: Pengcheng Xiong > The max/min function used by AggrStats for decimal type is not

[jira] [Updated] (HIVE-9188) BloomFilter support in ORC

2015-02-18 Thread Prasanth Jayachandran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9188?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasanth Jayachandran updated HIVE-9188: Release Note: Support for Bloom Filters in ORC internal index. > BloomFilter support

[jira] [Created] (HIVE-9717) The max/min function used by AggrStats for decimal type is not what we expected

2015-02-18 Thread Pengcheng Xiong (JIRA)
Pengcheng Xiong created HIVE-9717: - Summary: The max/min function used by AggrStats for decimal type is not what we expected Key: HIVE-9717 URL: https://issues.apache.org/jira/browse/HIVE-9717 Project

Re: VOTE Bylaw for having branch committers in hive

2015-02-18 Thread Ashutosh Chauhan
Seems like there is consensus all around. Vikram, would you like to update the wiki with new bylaws? Thanks, Ashutosh On Wed, Feb 18, 2015 at 8:58 AM, Prasad Mujumdar wrote: > +1 > > thanks > Prasad > > > On Mon, Feb 9, 2015 at 2:43 PM, Vikram Dixit K > wrote: > > > Hi Folks, > > > > We seem

[jira] [Commented] (HIVE-9188) BloomFilter support in ORC

2015-02-18 Thread Prasanth Jayachandran (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326408#comment-14326408 ] Prasanth Jayachandran commented on HIVE-9188: - [~leftylev] Thanks for the doc e

[jira] [Updated] (HIVE-9617) UDF from_utc_timestamp throws NPE if the second argument is null

2015-02-18 Thread Alan Gates (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alan Gates updated HIVE-9617: - Resolution: Fixed Status: Resolved (was: Patch Available) Patch committed. Thanks Alexander for t

[jira] [Commented] (HIVE-9556) create UDF to calculate the Levenshtein distance between two strings

2015-02-18 Thread Jason Dere (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326401#comment-14326401 ] Jason Dere commented on HIVE-9556: -- +1 > create UDF to calculate the Levenshtein distance

[jira] [Commented] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-02-18 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326352#comment-14326352 ] Aihua Xu commented on HIVE-3454: Yeah. I have tested with an MR job and it picks up the hiv

[jira] [Comment Edited] (HIVE-7292) Hive on Spark

2015-02-18 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326336#comment-14326336 ] Xuefu Zhang edited comment on HIVE-7292 at 2/18/15 6:37 PM: For

Re: [VOTE] Apache Hive 1.1.0 Release Candidate 2

2015-02-18 Thread Prasad Mujumdar
I guess the README.txt can list Apache Spark as query execution framework along with MapReduce and Tez. thanks Prasad On Wed, Feb 18, 2015 at 8:26 AM, Xuefu Zhang wrote: > +1 > > 1. downloaded the src and bin, and verified md5. > 2. built the src with -Phadoop-1 and -Phadoop-2. > 3. ran a

[jira] [Updated] (HIVE-9716) Map job fails when table's LOCATION does not have scheme

2015-02-18 Thread Brock Noland (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9716?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Brock Noland updated HIVE-9716: --- Description: When a table's location (the value of column 'LOCATION' in SDS table in metastore) does n

[jira] [Commented] (HIVE-7292) Hive on Spark

2015-02-18 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326336#comment-14326336 ] Xuefu Zhang commented on HIVE-7292: --- Formerly 0.15, now 1.1 is going to be release soon.

[jira] [Commented] (HIVE-7292) Hive on Spark

2015-02-18 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326335#comment-14326335 ] Xuefu Zhang commented on HIVE-7292: --- Formerly 0.15, now 1.1 is going to be release soon.

Re: [VOTE] Apache Hive 1.1.0 Release Candidate 1

2015-02-18 Thread Prasad Mujumdar
I guess the README.txt can list Apache Spark as query execution framework along with MapReduce and Tez. thanks Prasad On Tue, Feb 17, 2015 at 1:07 PM, Brock Noland wrote: > Thank you Alan. That is my mistake actually. We can delete this now and > will do so here: https://issues.apache.org/ji

[jira] [Updated] (HIVE-9716) Map job fails when table's LOCATION does not have scheme

2015-02-18 Thread Yongzhi Chen (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9716?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yongzhi Chen updated HIVE-9716: --- Description: When a table's location (the value of column 'LOCATION' in SDS table in metastore) does n

[jira] [Created] (HIVE-9716) Map job fails when table's LOCATION does not have scheme

2015-02-18 Thread Yongzhi Chen (JIRA)
Yongzhi Chen created HIVE-9716: -- Summary: Map job fails when table's LOCATION does not have scheme Key: HIVE-9716 URL: https://issues.apache.org/jira/browse/HIVE-9716 Project: Hive Issue Type: B

[jira] [Commented] (HIVE-7292) Hive on Spark

2015-02-18 Thread Peter Lin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-7292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326302#comment-14326302 ] Peter Lin commented on HIVE-7292: - Would love to use this production, is it going to releas

[jira] [Resolved] (HIVE-9546) Create table taking substantially longer time when other select queries are run in parallel.

2015-02-18 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu resolved HIVE-9546. Resolution: Duplicate You are hitting HIVE-9199. If you think it's not such issue, please reopen and provide

Re: VOTE Bylaw for having branch committers in hive

2015-02-18 Thread Prasad Mujumdar
+1 thanks Prasad On Mon, Feb 9, 2015 at 2:43 PM, Vikram Dixit K wrote: > Hi Folks, > > We seem to have quite a few projects going around and in the interest of > time and the project as a whole, it seems good to have branch committers > much like what is there in the Hadoop project. I am pro

[jira] [Comment Edited] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-02-18 Thread Brock Noland (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326158#comment-14326158 ] Brock Noland edited comment on HIVE-3454 at 2/18/15 4:40 PM: - H

[jira] [Commented] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-02-18 Thread Brock Noland (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326158#comment-14326158 ] Brock Noland commented on HIVE-3454: Have we tested this as part of an MR job? I don't

[jira] [Comment Edited] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-02-18 Thread Brock Noland (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326158#comment-14326158 ] Brock Noland edited comment on HIVE-3454 at 2/18/15 4:40 PM: - H

[jira] [Commented] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-02-18 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326137#comment-14326137 ] Aihua Xu commented on HIVE-3454: The test failure is unrelated to the change. > Problem wi

Re: [VOTE] Apache Hive 1.1.0 Release Candidate 2

2015-02-18 Thread Xuefu Zhang
+1 1. downloaded the src and bin, and verified md5. 2. built the src with -Phadoop-1 and -Phadoop-2. 3. ran a few unit tests Thanks, Xuefu On Tue, Feb 17, 2015 at 3:14 PM, Brock Noland wrote: > Apache Hive 1.1.0 Release Candidate 2 is available here: > http://people.apache.org/~brock/apache-hi

[jira] [Updated] (HIVE-9706) HBase handler support for snapshots should confirm properties before use

2015-02-18 Thread Brock Noland (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9706?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Brock Noland updated HIVE-9706: --- Resolution: Fixed Fix Version/s: (was: 1.1.0) Status: Resolved (was: Patch Availa

[jira] [Assigned] (HIVE-9659) 'Error while trying to create table container' occurs during hive query case execution when hive.optimize.skewjoin set to 'true' [Spark Branch]

2015-02-18 Thread Jimmy Xiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jimmy Xiang reassigned HIVE-9659: - Assignee: Jimmy Xiang > 'Error while trying to create table container' occurs during hive query ca

[jira] [Commented] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-02-18 Thread Hive QA (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326065#comment-14326065 ] Hive QA commented on HIVE-3454: --- {color:red}Overall{color}: -1 at least one tests failed H

[jira] [Resolved] (HIVE-9537) string expressions on a fixed length character do not preserve trailing spaces

2015-02-18 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu resolved HIVE-9537. Resolution: Not a Problem If you think you have additional issue, please reopen or open a new one. > string

[jira] [Commented] (HIVE-9537) string expressions on a fixed length character do not preserve trailing spaces

2015-02-18 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326062#comment-14326062 ] Aihua Xu commented on HIVE-9537: [~the6campbells] I don't think it's a bug. The Char type h

[jira] [Assigned] (HIVE-9537) string expressions on a fixed length character do not preserve trailing spaces

2015-02-18 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu reassigned HIVE-9537: -- Assignee: Aihua Xu > string expressions on a fixed length character do not preserve trailing spaces > --

[jira] [Commented] (HIVE-9537) string expressions on a fixed length character do not preserve trailing spaces

2015-02-18 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326009#comment-14326009 ] Aihua Xu commented on HIVE-9537: [~the6campbells] Can you provide the HIVE version you have

[jira] [Assigned] (HIVE-9546) Create table taking substantially longer time when other select queries are run in parallel.

2015-02-18 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu reassigned HIVE-9546: -- Assignee: Aihua Xu > Create table taking substantially longer time when other select queries are > run

[jira] [Commented] (HIVE-9546) Create table taking substantially longer time when other select queries are run in parallel.

2015-02-18 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326007#comment-14326007 ] Aihua Xu commented on HIVE-9546: Try to set hive.exec.parallel=false to disable the paral

[jira] [Commented] (HIVE-9546) Create table taking substantially longer time when other select queries are run in parallel.

2015-02-18 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326005#comment-14326005 ] Aihua Xu commented on HIVE-9546: [~vbora] Seems you are hitting the issue HIVE-9199. > Cr

[jira] [Commented] (HIVE-9551) Unable to read Microsoft SQL Server timestamp column

2015-02-18 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9551?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14326002#comment-14326002 ] Aihua Xu commented on HIVE-9551: [~dilipg] Can you provide more details? Can you check what

[jira] [Updated] (HIVE-9561) SHUFFLE_SORT should only be used for order by query [Spark Branch]

2015-02-18 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9561?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xuefu Zhang updated HIVE-9561: -- Resolution: Fixed Fix Version/s: spark-branch Status: Resolved (was: Patch Available)

[jira] [Updated] (HIVE-9703) Merge from Spark branch to trunk 02/16/2015

2015-02-18 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9703?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xuefu Zhang updated HIVE-9703: -- Resolution: Fixed Fix Version/s: 1.2.0 Status: Resolved (was: Patch Available) Committ

[jira] [Updated] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-02-18 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-3454: --- Attachment: (was: HIVE-3454.3.patch) > Problem with CAST(BIGINT as TIMESTAMP) > ---

[jira] [Commented] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-02-18 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14325868#comment-14325868 ] Aihua Xu commented on HIVE-3454: Thanks [~jdere] for reviewing. Just updated the parameter

[jira] [Updated] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-02-18 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-3454: --- Release Note: The behaviors of converting from BOOLEAN/BYTE/SHORT/INT/BIGINT and converting from FLOAT/DOUBLE

[jira] [Commented] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-02-18 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14325867#comment-14325867 ] Aihua Xu commented on HIVE-3454: Thanks [~jdere] for reviewing. Just updated the parameter

[jira] [Updated] (HIVE-3454) Problem with CAST(BIGINT as TIMESTAMP)

2015-02-18 Thread Aihua Xu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aihua Xu updated HIVE-3454: --- Attachment: HIVE-3454.3.patch > Problem with CAST(BIGINT as TIMESTAMP) > --

[jira] [Commented] (HIVE-9613) Left join query plan outputs wrong column when using subquery

2015-02-18 Thread Li Xin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14325850#comment-14325850 ] Li Xin commented on HIVE-9613: -- thank you for your reply Chao. I just set up a new hive of v

[jira] [Updated] (HIVE-9613) Left join query plan outputs wrong column when using subquery

2015-02-18 Thread Li Xin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9613?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Li Xin updated HIVE-9613: - Attachment: test.sql this sql script i tested output the 4th column with wrong values > Left join query plan outpu

[jira] [Updated] (HIVE-9715) Add support for SSL keypass

2015-02-18 Thread Wellington Chevreuil (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Wellington Chevreuil updated HIVE-9715: --- Component/s: HiveServer2 > Add support for SSL keypass > --- >

[jira] [Created] (HIVE-9715) Add support for SSL keypass

2015-02-18 Thread Wellington Chevreuil (JIRA)
Wellington Chevreuil created HIVE-9715: -- Summary: Add support for SSL keypass Key: HIVE-9715 URL: https://issues.apache.org/jira/browse/HIVE-9715 Project: Hive Issue Type: Improvement

[jira] [Commented] (HIVE-9188) BloomFilter support in ORC

2015-02-18 Thread Lefty Leverenz (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-9188?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14325694#comment-14325694 ] Lefty Leverenz commented on HIVE-9188: -- Doc note: [~prasanth_j] documented this in th

  1   2   >