[jira] [Commented] (HIVE-3790) UDF to introduce an OFFSET(day,month or year) for a given date or timestamp

2013-08-27 Thread Jithin John (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3790?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13752149#comment-13752149 ] Jithin John commented on HIVE-3790: --- could some one review this and provide comments?

[jira] [Commented] (HIVE-5147) Newly added test TestSessionHooks is failing on trunk

2013-08-27 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13752073#comment-13752073 ] Hudson commented on HIVE-5147: -- SUCCESS: Integrated in Hive-trunk-h0.21 #2294 (See [https://b

[jira] [Commented] (HIVE-5144) HashTableSink allocates empty new Object[] arrays & OOMs - use a static emptyRow instead

2013-08-27 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13752072#comment-13752072 ] Hudson commented on HIVE-5144: -- SUCCESS: Integrated in Hive-trunk-h0.21 #2294 (See [https://b

[jira] [Commented] (HIVE-5128) Direct SQL for view is failing

2013-08-27 Thread Phabricator (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5128?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13752061#comment-13752061 ] Phabricator commented on HIVE-5128: --- ashutoshc has accepted the revision "HIVE-5128 [jira

[jira] [Commented] (HIVE-4460) Publish HCatalog artifacts for Hadoop 2.x

2013-08-27 Thread Thejas M Nair (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13752036#comment-13752036 ] Thejas M Nair commented on HIVE-4460: - Looks great! I have updated the reviewboard with

[jira] [Commented] (HIVE-5147) Newly added test TestSessionHooks is failing on trunk

2013-08-27 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13752026#comment-13752026 ] Hudson commented on HIVE-5147: -- FAILURE: Integrated in Hive-trunk-hadoop1-ptest #141 (See [ht

[jira] [Commented] (HIVE-5144) HashTableSink allocates empty new Object[] arrays & OOMs - use a static emptyRow instead

2013-08-27 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13752025#comment-13752025 ] Hudson commented on HIVE-5144: -- FAILURE: Integrated in Hive-trunk-hadoop1-ptest #141 (See [ht

[jira] [Created] (HIVE-5165) Evaluate the possibility of enabling feature similar to pinning tables in memory

2013-08-27 Thread Srikanth Sundarrajan (JIRA)
Srikanth Sundarrajan created HIVE-5165: -- Summary: Evaluate the possibility of enabling feature similar to pinning tables in memory Key: HIVE-5165 URL: https://issues.apache.org/jira/browse/HIVE-5165

[jira] [Commented] (HIVE-4601) WebHCat, Templeton need to support proxy users

2013-08-27 Thread Thejas M Nair (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13752007#comment-13752007 ] Thejas M Nair commented on HIVE-4601: - Looks good. +1 > WebHCat, Temp

[jira] [Updated] (HIVE-4888) listPartitionsByFilter doesn't support lt/gt/lte/gte

2013-08-27 Thread Sergey Shelukhin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4888?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-4888: --- Attachment: HIVE-4888.on-top-of-4914.patch preliminary, very simple patch on top of HIVE-4914.

[jira] [Updated] (HIVE-5158) allow getting all partitions for table to also use direct SQL path

2013-08-27 Thread Sergey Shelukhin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5158?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-5158: --- Status: Patch Available (was: Open) > allow getting all partitions for table to also use

[jira] [Updated] (HIVE-5158) allow getting all partitions for table to also use direct SQL path

2013-08-27 Thread Phabricator (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5158?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-5158: -- Attachment: HIVE-5158.D12573.1.patch sershe requested code review of "HIVE-5158 [jira] allow getting all

[jira] [Updated] (HIVE-4896) create binary backwards compatibility layer hcatalog 0.12 and 0.11

2013-08-27 Thread Eugene Koifman (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eugene Koifman updated HIVE-4896: - Description: 1. create a 011 dir in each HCat submodule to hold these classes 2. update build to p

[jira] [Updated] (HIVE-4896) create binary backwards compatibility layer hcatalog 0.12 and 0.11

2013-08-27 Thread Eugene Koifman (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eugene Koifman updated HIVE-4896: - Summary: create binary backwards compatibility layer hcatalog 0.12 and 0.11 (was: bring 0.11 vers

[jira] [Updated] (HIVE-5164) add Thejas Nair, Harish Butani to website as committers

2013-08-27 Thread Thejas M Nair (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thejas M Nair updated HIVE-5164: Resolution: Fixed Status: Resolved (was: Patch Available) > add Thejas Nair, Harish But

[jira] [Updated] (HIVE-5164) add Thejas Nair, Harish Butani to website as committers

2013-08-27 Thread Thejas M Nair (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thejas M Nair updated HIVE-5164: Attachment: HIVE-5164.3.patch HIVE-5164.3.patch - fixed typo > add Thejas Nair, Ha

[jira] [Updated] (HIVE-4331) Integrated StorageHandler for Hive and HCat using the HiveStorageHandler

2013-08-27 Thread Sushanth Sowmyan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4331?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sushanth Sowmyan updated HIVE-4331: --- Component/s: HBase Handler > Integrated StorageHandler for Hive and HCat using the HiveSto

[jira] [Updated] (HIVE-5164) add Thejas Nair, Harish Butani to website as committers

2013-08-27 Thread Thejas M Nair (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thejas M Nair updated HIVE-5164: Summary: add Thejas Nair, Harish Butani to website as committers (was: add Thejas Nair to website a

[jira] [Updated] (HIVE-4601) WebHCat, Templeton need to support proxy users

2013-08-27 Thread Eugene Koifman (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eugene Koifman updated HIVE-4601: - Attachment: HIVE-4601.5.patch > WebHCat, Templeton need to support proxy users > -

[jira] [Updated] (HIVE-4601) WebHCat, Templeton need to support proxy users

2013-08-27 Thread Eugene Koifman (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eugene Koifman updated HIVE-4601: - Attachment: (was: HIVE-4601.5.patch) > WebHCat, Templeton need to support proxy users > --

[jira] [Commented] (HIVE-5164) add Thejas Nair to website as a committer

2013-08-27 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5164?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751961#comment-13751961 ] Harish Butani commented on HIVE-5164: - +1 thanks [~thejas] > add Theja

[jira] [Updated] (HIVE-5164) add Thejas Nair to website as a committer

2013-08-27 Thread Thejas M Nair (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thejas M Nair updated HIVE-5164: Attachment: HIVE-5164.2.patch Adding Harish Butani to the list as well. > add Thej

[jira] [Updated] (HIVE-4601) WebHCat, Templeton need to support proxy users

2013-08-27 Thread Eugene Koifman (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eugene Koifman updated HIVE-4601: - Attachment: HIVE-4601.5.patch HIVE-4601.5.patch addresses RB comments > WebHCat,

[jira] [Updated] (HIVE-5164) add Thejas Nair to website as a committer

2013-08-27 Thread Thejas M Nair (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thejas M Nair updated HIVE-5164: Status: Patch Available (was: Open) > add Thejas Nair to website as a committer > -

[jira] [Updated] (HIVE-5164) add Thejas Nair to website as a committer

2013-08-27 Thread Thejas M Nair (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thejas M Nair updated HIVE-5164: Attachment: HIVE-5164.1.patch > add Thejas Nair to website as a committer >

[jira] [Updated] (HIVE-5164) add Thejas Nair to website as a committer

2013-08-27 Thread Thejas M Nair (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thejas M Nair updated HIVE-5164: Description: Update the website to add myself as a committer. NO PRECOMMIT TESTS was: Update the

[jira] [Created] (HIVE-5164) add Thejas Nair to website as a committer

2013-08-27 Thread Thejas M Nair (JIRA)
Thejas M Nair created HIVE-5164: --- Summary: add Thejas Nair to website as a committer Key: HIVE-5164 URL: https://issues.apache.org/jira/browse/HIVE-5164 Project: Hive Issue Type: Task

[jira] [Updated] (HIVE-4844) Add char/varchar data types

2013-08-27 Thread Jason Dere (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4844?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Dere updated HIVE-4844: - Attachment: HIVE-4844.8.patch Attaching HIVE-4844.8.patch. This adds more unit tests, and a few fixes to

[jira] [Updated] (HIVE-4844) Add char/varchar data types

2013-08-27 Thread Jason Dere (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4844?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Dere updated HIVE-4844: - Status: Patch Available (was: Open) > Add char/varchar data types > --- > >

[jira] [Created] (HIVE-5163) refactor org.apache.hadoop.mapred.HCatMapRedUtil

2013-08-27 Thread Eugene Koifman (JIRA)
Eugene Koifman created HIVE-5163: Summary: refactor org.apache.hadoop.mapred.HCatMapRedUtil Key: HIVE-5163 URL: https://issues.apache.org/jira/browse/HIVE-5163 Project: Hive Issue Type: Sub-t

[jira] [Commented] (HIVE-4460) Publish HCatalog artifacts for Hadoop 2.x

2013-08-27 Thread Eugene Koifman (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751866#comment-13751866 ] Eugene Koifman commented on HIVE-4460: -- Review board https://reviews.apache.org/r/1387

[jira] [Commented] (HIVE-4601) WebHCat, Templeton need to support proxy users

2013-08-27 Thread Eugene Koifman (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751838#comment-13751838 ] Eugene Koifman commented on HIVE-4601: -- https://reviews.apache.org/r/13870/

[jira] [Commented] (HIVE-4375) Single sourced multi insert consists of native and non-native table mixed throws NPE

2013-08-27 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751837#comment-13751837 ] Hudson commented on HIVE-4375: -- ABORTED: Integrated in Hive-trunk-hadoop2 #385 (See [https://

[jira] [Commented] (HIVE-4959) Vectorized plan generation should be added as an optimization transform.

2013-08-27 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751834#comment-13751834 ] Ashutosh Chauhan commented on HIVE-4959: You are walking the plan tree yourself in

[jira] [Commented] (HIVE-5147) Newly added test TestSessionHooks is failing on trunk

2013-08-27 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5147?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751825#comment-13751825 ] Hudson commented on HIVE-5147: -- FAILURE: Integrated in Hive-trunk-hadoop2-ptest #73 (See [htt

[jira] [Commented] (HIVE-5144) HashTableSink allocates empty new Object[] arrays & OOMs - use a static emptyRow instead

2013-08-27 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751824#comment-13751824 ] Hudson commented on HIVE-5144: -- FAILURE: Integrated in Hive-trunk-hadoop2-ptest #73 (See [htt

[jira] [Created] (HIVE-5162) Add mod(a, b) semantic for modular function

2013-08-27 Thread Xiu (JIRA)
Xiu created HIVE-5162: - Summary: Add mod(a, b) semantic for modular function Key: HIVE-5162 URL: https://issues.apache.org/jira/browse/HIVE-5162 Project: Hive Issue Type: Improvement Components

[jira] [Updated] (HIVE-3194) implement the JDBC canonical/ISO-SQL 2012 scalar functions

2013-08-27 Thread Xiu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3194?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xiu updated HIVE-3194: -- Affects Version/s: 0.11.0 Status: Patch Available (was: Open) This patch supplies information on canonic

[jira] [Updated] (HIVE-3194) implement the JDBC canonical/ISO-SQL 2012 scalar functions

2013-08-27 Thread Xiu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3194?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Xiu updated HIVE-3194: -- Attachment: Hive-3194.patch > implement the JDBC canonical/ISO-SQL 2012 scalar functions > -

[jira] [Created] (HIVE-5161) Additional SerDe support for varchar type

2013-08-27 Thread Jason Dere (JIRA)
Jason Dere created HIVE-5161: Summary: Additional SerDe support for varchar type Key: HIVE-5161 URL: https://issues.apache.org/jira/browse/HIVE-5161 Project: Hive Issue Type: Bug Compon

[jira] [Created] (HIVE-5160) HS2 should support .hiverc

2013-08-27 Thread Thejas M Nair (JIRA)
Thejas M Nair created HIVE-5160: --- Summary: HS2 should support .hiverc Key: HIVE-5160 URL: https://issues.apache.org/jira/browse/HIVE-5160 Project: Hive Issue Type: Improvement Compone

[jira] [Commented] (HIVE-5160) HS2 should support .hiverc

2013-08-27 Thread Thejas M Nair (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751777#comment-13751777 ] Thejas M Nair commented on HIVE-5160: - I mean a global .hiverc file is going to be usef

[jira] [Commented] (HIVE-5160) HS2 should support .hiverc

2013-08-27 Thread Thejas M Nair (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751776#comment-13751776 ] Thejas M Nair commented on HIVE-5160: - I am not sure if a user specific .hiverc would b

[jira] [Updated] (HIVE-4914) filtering via partition name should be done inside metastore server (implementation)

2013-08-27 Thread Phabricator (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Phabricator updated HIVE-4914: -- Attachment: HIVE-4914.D12561.1.patch sershe requested code review of "HIVE-4914 [jira] filtering via par

[jira] [Updated] (HIVE-4914) filtering via partition name should be done inside metastore server (implementation)

2013-08-27 Thread Sergey Shelukhin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-4914: --- Description: Currently, if the filter pushdown is impossible (which is most cases), the clien

[jira] [Updated] (HIVE-5159) Change the kind fields in ORC's proto file to optional

2013-08-27 Thread Owen O'Malley (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5159?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Owen O'Malley updated HIVE-5159: Component/s: File Formats > Change the kind fields in ORC's proto file to optional > ---

[jira] [Created] (HIVE-5159) Change the kind fields in ORC's proto file to optional

2013-08-27 Thread Owen O'Malley (JIRA)
Owen O'Malley created HIVE-5159: --- Summary: Change the kind fields in ORC's proto file to optional Key: HIVE-5159 URL: https://issues.apache.org/jira/browse/HIVE-5159 Project: Hive Issue Type: B

[jira] [Commented] (HIVE-4331) Integrated StorageHandler for Hive and HCat using the HiveStorageHandler

2013-08-27 Thread Viraj Bhat (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4331?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751700#comment-13751700 ] Viraj Bhat commented on HIVE-4331: -- Sushanth thanks for going through the HCat patch. I am

[jira] [Commented] (HIVE-4331) Integrated StorageHandler for Hive and HCat using the HiveStorageHandler

2013-08-27 Thread Sushanth Sowmyan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4331?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751697#comment-13751697 ] Sushanth Sowmyan commented on HIVE-4331: I've gone through the HCat section of the

Re: LIKE filter pushdown for tables and partitions

2013-08-27 Thread Stephen Sprague
Thanks Sergey for that. Good stuff. I can't speak for everybody here obviously but Hive partition elimination is critical - its gotta happen somehow. However, if JDOQL method isn't robust around the edges i'm fine with finding something better. So if I get you right you're saying by removing th

[jira] [Updated] (HIVE-5114) add a target to run tests without rebuilding them

2013-08-27 Thread Sergey Shelukhin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-5114: --- Status: Patch Available (was: Open) > add a target to run tests without rebuilding them >

[jira] [Updated] (HIVE-5029) direct SQL perf optimization cannot be tested well

2013-08-27 Thread Sergey Shelukhin (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Shelukhin updated HIVE-5029: --- Status: Patch Available (was: Open) > direct SQL perf optimization cannot be tested well

[jira] [Updated] (HIVE-5149) ReduceSinkDeDuplication can pick the wrong partitioning columns

2013-08-27 Thread Yin Huai (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yin Huai updated HIVE-5149: --- Status: Patch Available (was: Open) > ReduceSinkDeDuplication can pick the wrong partitioning columns > -

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

2013-08-27 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.22.patch yhuai updated the revision "HIVE-2206 [jira] add a new optimizer f

[jira] [Updated] (HIVE-5149) ReduceSinkDeDuplication can pick the wrong partitioning columns

2013-08-27 Thread Yin Huai (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yin Huai updated HIVE-5149: --- Component/s: Query Processor > ReduceSinkDeDuplication can pick the wrong partitioning columns > -

[jira] [Updated] (HIVE-5149) ReduceSinkDeDuplication can pick the wrong partitioning columns

2013-08-27 Thread Yin Huai (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yin Huai updated HIVE-5149: --- Affects Version/s: 0.12.0 0.11.0 > ReduceSinkDeDuplication can pick the wrong parti

[jira] [Updated] (HIVE-5149) ReduceSinkDeDuplication can pick the wrong partitioning columns

2013-08-27 Thread Yin Huai (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5149?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yin Huai updated HIVE-5149: --- Attachment: HIVE-5149.1.patch > ReduceSinkDeDuplication can pick the wrong partitioning columns >

[jira] [Commented] (HIVE-4959) Vectorized plan generation should be added as an optimization transform.

2013-08-27 Thread Jitendra Nath Pandey (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751567#comment-13751567 ] Jitendra Nath Pandey commented on HIVE-4959: Updated patch with serialization o

Review Request 13862: ReduceSinkDeDuplication can pick the wrong partitioning columns

2013-08-27 Thread Yin Huai
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/13862/ --- Review request for hive. Bugs: HIVE-5149 https://issues.apache.org/jira/bro

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

2013-08-27 Thread Yin Huai (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2206?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751563#comment-13751563 ] Yin Huai commented on HIVE-2206: the last patch was for HIVE-5149... > add

[jira] [Updated] (HIVE-4959) Vectorized plan generation should be added as an optimization transform.

2013-08-27 Thread Jitendra Nath Pandey (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jitendra Nath Pandey updated HIVE-4959: --- Attachment: HIVE-4959.2.patch > Vectorized plan generation should be added as an o

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

2013-08-27 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.21.patch yhuai updated the revision "HIVE-2206 [jira] add a new optimizer f

[jira] [Commented] (HIVE-5149) ReduceSinkDeDuplication can pick the wrong partitioning columns

2013-08-27 Thread Yin Huai (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5149?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751502#comment-13751502 ] Yin Huai commented on HIVE-5149: Another example, in reduce_deduplicate_extended.q, there i

[jira] [Created] (HIVE-5158) allow getting all partitions for table to also use direct SQL path

2013-08-27 Thread Sergey Shelukhin (JIRA)
Sergey Shelukhin created HIVE-5158: -- Summary: allow getting all partitions for table to also use direct SQL path Key: HIVE-5158 URL: https://issues.apache.org/jira/browse/HIVE-5158 Project: Hive

[jira] [Commented] (HIVE-4959) Vectorized plan generation should be added as an optimization transform.

2013-08-27 Thread Jitendra Nath Pandey (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751492#comment-13751492 ] Jitendra Nath Pandey commented on HIVE-4959: Review board entry: https://review

[jira] [Commented] (HIVE-4844) Add char/varchar data types

2013-08-27 Thread Jason Dere (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4844?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751486#comment-13751486 ] Jason Dere commented on HIVE-4844: -- Hi Xuefu, yes this patch has gotten pretty large. I th

Re: LIKE filter pushdown for tables and partitions

2013-08-27 Thread Sergey Shelukhin
This method is used to prune partitions for the job (separately from actually processing data). There are a few ways to get partitions from Hive for a query (to avoid reading all partitions when filtering involves partition columns) - get-by-filter that I want to modify is one of them. Hive itself

[jira] [Commented] (HIVE-4959) Vectorized plan generation should be added as an optimization transform.

2013-08-27 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751462#comment-13751462 ] Ashutosh Chauhan commented on HIVE-4959: Can you create a phabricator entry for thi

[jira] [Updated] (HIVE-5126) Make vector expressions serializable.

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

[jira] [Updated] (HIVE-5146) FilterExprOrExpr changes the order of the rows

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

[jira] [Updated] (HIVE-5144) HashTableSink allocates empty new Object[] arrays & OOMs - use a static emptyRow instead

2013-08-27 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5144?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan updated HIVE-5144: --- Resolution: Fixed Fix Version/s: 0.12.0 Status: Resolved (was: Patch Availab

[jira] [Resolved] (HIVE-5147) Newly added test TestSessionHooks is failing on trunk

2013-08-27 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ashutosh Chauhan resolved HIVE-5147. Resolution: Fixed Fix Version/s: 0.12.0 Committed to trunk. Thanks, Navis!

Pig vs Hive: GROUP BY

2013-08-27 Thread Benjamin Jakobus
Hi all, I am trying to understand the difference between how Pig implements the Group By operator and how Hive does it. My hypothesis is that Pig, being a procedural and lazy language and hence creates a aliases for each "stage" in the execution. Background: After benchmarking Hive and Pig, I fo

Re: LIKE filter pushdown for tables and partitions

2013-08-27 Thread Stephen Sprague
sorry to be dumb-ass but what does that translate into in the HSQL dialect? Judging from the name you use, getPartitionsByFilter, you're saying you want to remove the use case of using like clause on a partition column? if so, um, yeah, i would think that's surely used. On Mon, Aug 26, 2013 at

[jira] [Created] (HIVE-5157) ReduceSinkDeDuplication ignores hive.groupby.skewindata=true

2013-08-27 Thread Yin Huai (JIRA)
Yin Huai created HIVE-5157: -- Summary: ReduceSinkDeDuplication ignores hive.groupby.skewindata=true Key: HIVE-5157 URL: https://issues.apache.org/jira/browse/HIVE-5157 Project: Hive Issue Type: Bug

[jira] [Commented] (HIVE-4002) Fetch task aggregation for simple group by query

2013-08-27 Thread Phabricator (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751333#comment-13751333 ] Phabricator commented on HIVE-4002: --- yhuai has commented on the revision "HIVE-4002 [jira

[jira] [Commented] (HIVE-4002) Fetch task aggregation for simple group by query

2013-08-27 Thread Phabricator (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751330#comment-13751330 ] Phabricator commented on HIVE-4002: --- yhuai has commented on the revision "HIVE-4002 [jira

[jira] [Commented] (HIVE-4375) Single sourced multi insert consists of native and non-native table mixed throws NPE

2013-08-27 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751277#comment-13751277 ] Hudson commented on HIVE-4375: -- FAILURE: Integrated in Hive-trunk-h0.21 #2292 (See [https://b

[jira] [Commented] (HIVE-3562) Some limit can be pushed down to map stage

2013-08-27 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751276#comment-13751276 ] Navis commented on HIVE-3562: - I'm on vacation till next tuesday. Feel free to modify this patc

[jira] [Commented] (HIVE-5145) Fix TestCliDriver.list_bucket_query_multiskew_2.q on hadoop 0.23

2013-08-27 Thread Brock Noland (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751224#comment-13751224 ] Brock Noland commented on HIVE-5145: I also think the order by is probably required for

[jira] [Commented] (HIVE-5145) Fix TestCliDriver.list_bucket_query_multiskew_2.q on hadoop 0.23

2013-08-27 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751192#comment-13751192 ] Hudson commented on HIVE-5145: -- FAILURE: Integrated in Hive-trunk-h0.21 #2291 (See [https://b

[jira] [Created] (HIVE-5156) HiveServer2 jdbc ResultSet.close should free up resources on server side

2013-08-27 Thread Vaibhav Gumashta (JIRA)
Vaibhav Gumashta created HIVE-5156: -- Summary: HiveServer2 jdbc ResultSet.close should free up resources on server side Key: HIVE-5156 URL: https://issues.apache.org/jira/browse/HIVE-5156 Project: Hiv

[jira] [Work started] (HIVE-5156) HiveServer2 jdbc ResultSet.close should free up resources on server side

2013-08-27 Thread Vaibhav Gumashta (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5156?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on HIVE-5156 started by Vaibhav Gumashta. > HiveServer2 jdbc ResultSet.close should free up resources on server side > ---

[jira] [Commented] (HIVE-4844) Add char/varchar data types

2013-08-27 Thread Xuefu Zhang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4844?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751085#comment-13751085 ] Xuefu Zhang commented on HIVE-4844: --- [~jdere] Since this patch is fairly big and progress

[jira] [Commented] (HIVE-5155) Support secure proxy user access to HiveServer2

2013-08-27 Thread Prasad Mujumdar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751084#comment-13751084 ] Prasad Mujumdar commented on HIVE-5155: --- Review request at https://reviews.apache.org

Review Request 13845: HIVE-5155: Support secure proxy user access to HiveServer2

2013-08-27 Thread Prasad Mujumdar
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/13845/ --- Review request for hive. Bugs: HIVE-5155 https://issues.apache.org/jira/bro

[jira] [Updated] (HIVE-5155) Support secure proxy user access to HiveServer2

2013-08-27 Thread Prasad Mujumdar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Mujumdar updated HIVE-5155: -- Attachment: ProxyAuth.java Simple client application to test various direct and proxy connection

[jira] [Updated] (HIVE-5155) Support secure proxy user access to HiveServer2

2013-08-27 Thread Prasad Mujumdar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Mujumdar updated HIVE-5155: -- Attachment: HIVE-5155.1.patch HIVE-5155-1-nothrift.patch > Support secure pr

[jira] [Created] (HIVE-5155) Support secure proxy user access to HiveServer2

2013-08-27 Thread Prasad Mujumdar (JIRA)
Prasad Mujumdar created HIVE-5155: - Summary: Support secure proxy user access to HiveServer2 Key: HIVE-5155 URL: https://issues.apache.org/jira/browse/HIVE-5155 Project: Hive Issue Type: Impr

[jira] [Commented] (HIVE-4375) Single sourced multi insert consists of native and non-native table mixed throws NPE

2013-08-27 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751077#comment-13751077 ] Hudson commented on HIVE-4375: -- FAILURE: Integrated in Hive-trunk-hadoop1-ptest #140 (See [ht

[jira] [Commented] (HIVE-4375) Single sourced multi insert consists of native and non-native table mixed throws NPE

2013-08-27 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-4375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751071#comment-13751071 ] Hudson commented on HIVE-4375: -- FAILURE: Integrated in Hive-trunk-hadoop2-ptest #72 (See [htt

[jira] [Commented] (HIVE-5145) Fix TestCliDriver.list_bucket_query_multiskew_2.q on hadoop 0.23

2013-08-27 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751066#comment-13751066 ] Hudson commented on HIVE-5145: -- FAILURE: Integrated in Hive-trunk-hadoop2 #384 (See [https://