[jira] [Commented] (HIVE-3029) Update ShimLoader to work with Hadoop 2.x

2012-08-16 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3029?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13435843#comment-13435843 ] Namit Jain commented on HIVE-3029: -- @Carl, can you take care of this ? If you are busy, I

[jira] [Updated] (HIVE-3380) As a follow up for HIVE-3276, optimize union for dynamic partition queries

2012-08-16 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3380?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3380: - Resolution: Fixed Status: Resolved (was: Patch Available) Will do as part of HIVE-3276

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

2012-08-16 Thread Apache Jenkins Server
Changes for Build #1606 [cws] HIVE-2804. Task log retrieval fails on Hadoop 0.23 (Zhenxiao Luo via cws) Changes for Build #1607 [cws] HIVE-3337. Create Table Like should copy configured Table Parameters (Bhushan Mandhani via cws) Changes for Build #1608 Changes for Build #1609 [hashutosh]

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

2012-08-16 Thread Apache Jenkins Server
See https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21-keepgoing=false/107/ -- [...truncated 10116 lines...] [echo] Project: odbc [copy] Warning:

Re: Problem with Hive Indexing

2012-08-16 Thread Mahsa Mofidpoor
Hi, At lease the table size must be greater than 5GB to use the index for filter pushdown. Otherwise you have to comment the checkQuerySize method. Cheers, Mahsa On Mon, Jul 30, 2012 at 11:12 AM, Ablimit Aji abli...@gmail.com wrote: I have written a custom index handler and wanted to test it.

Re: Problem with Hive Indexing

2012-08-16 Thread Ablimit Aji
Thanks Mahsa ! I didn't know that there is such a constraint. Best, Ablimit On Thu, Aug 16, 2012 at 12:32 PM, Mahsa Mofidpoor mofidp...@gmail.comwrote: Hi, At lease the table size must be greater than 5GB to use the index for filter pushdown. Otherwise you have to comment the checkQuerySize

[jira] [Created] (HIVE-3390) Hive List Bucketing - DDL support - DB upgrade script for Derby, Postgres, and Oracle

2012-08-16 Thread Gang Tim Liu (JIRA)
Gang Tim Liu created HIVE-3390: -- Summary: Hive List Bucketing - DDL support - DB upgrade script for Derby, Postgres, and Oracle Key: HIVE-3390 URL: https://issues.apache.org/jira/browse/HIVE-3390

[jira] [Updated] (HIVE-3268) expressions in cluster by are not working

2012-08-16 Thread Kevin Wilfong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3268?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Wilfong updated HIVE-3268: Resolution: Fixed Fix Version/s: 0.10.0 Status: Resolved (was: Patch Available)

[jira] [Commented] (HIVE-3276) optimize union sub-queries

2012-08-16 Thread Kevin Wilfong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3276?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436105#comment-13436105 ] Kevin Wilfong commented on HIVE-3276: - Namit, is this ready for review? You mention

[jira] [Commented] (HIVE-138) Provide option to export a HEADER

2012-08-16 Thread Andrew Perepelytsya (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436115#comment-13436115 ] Andrew Perepelytsya commented on HIVE-138: -- Adam, it doesn't look like 'with

[jira] [Assigned] (HIVE-3388) Improve Performance of UDF PERCENTILE_APPROX()

2012-08-16 Thread Rongrong Zhong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3388?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rongrong Zhong reassigned HIVE-3388: Assignee: Rongrong Zhong Improve Performance of UDF PERCENTILE_APPROX()

[jira] [Updated] (HIVE-3276) optimize union sub-queries

2012-08-16 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3276: - Status: Open (was: Patch Available) optimize union sub-queries --

[jira] [Commented] (HIVE-3276) optimize union sub-queries

2012-08-16 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3276?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436176#comment-13436176 ] Namit Jain commented on HIVE-3276: -- I was able to run tests for hadoop 23. I will upload

Re: Possible patch to fix column comments with non-native SerDe

2012-08-16 Thread Jakob Homan
You'll need to update your serde to use the method call that takes comments. See https://github.com/jghoman/haivvreo/commit/29ead1fe101baafa8e9844eaf92022cbe4846c6f for an example. Sent with Sparrow (http://www.sparrowmailapp.com/?sig) On Tuesday, August 7, 2012 at 7:21 AM, Stephen R.

[jira] [Updated] (HIVE-3375) bucketed map join should check that the number of files match the number of buckets

2012-08-16 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3375: - Attachment: hive.3375.3.patch bucketed map join should check that the number of files match the

[jira] [Commented] (HIVE-3375) bucketed map join should check that the number of files match the number of buckets

2012-08-16 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436190#comment-13436190 ] Namit Jain commented on HIVE-3375: -- refreshed after few other commits

[jira] [Updated] (HIVE-3276) optimize union sub-queries

2012-08-16 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3276: - Attachment: hive.3276.3.patch optimize union sub-queries --

[jira] [Commented] (HIVE-3276) optimize union sub-queries

2012-08-16 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3276?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436202#comment-13436202 ] Namit Jain commented on HIVE-3276: -- @Kevin, this is ready for review.

[jira] [Updated] (HIVE-3276) optimize union sub-queries

2012-08-16 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3276: - Status: Patch Available (was: Open) ShimLoader changes are copied from HIVE-3029, only to run tests on

[jira] [Resolved] (HIVE-3390) Hive List Bucketing - DDL support - DB upgrade script for Derby, Postgres, and Oracle

2012-08-16 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach resolved HIVE-3390. -- Resolution: Invalid This work needs to be done as part of HIVE-3072. Hive

[jira] [Created] (HIVE-3391) Keep the original query in HiveDriverRunHookContextImpl

2012-08-16 Thread Dawid Dabrowski (JIRA)
Dawid Dabrowski created HIVE-3391: - Summary: Keep the original query in HiveDriverRunHookContextImpl Key: HIVE-3391 URL: https://issues.apache.org/jira/browse/HIVE-3391 Project: Hive Issue

[jira] [Commented] (HIVE-3375) bucketed map join should check that the number of files match the number of buckets

2012-08-16 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436227#comment-13436227 ] Carl Steinbach commented on HIVE-3375: -- +1 @Namit: Can you handle testing this and

[jira] [Commented] (HIVE-3228) unable to load null values that represent a timestamp value

2012-08-16 Thread Neha Tomar (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3228?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436245#comment-13436245 ] Neha Tomar commented on HIVE-3228: -- I don't think this issue is fixed as I am still seeing

[jira] [Commented] (HIVE-3390) Hive List Bucketing - DDL support - DB upgrade script for Derby, Postgres, and Oracle

2012-08-16 Thread Gang Tim Liu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436246#comment-13436246 ] Gang Tim Liu commented on HIVE-3390: @Carl, got you. do you have some instructions to

[jira] [Commented] (HIVE-3390) Hive List Bucketing - DDL support - DB upgrade script for Derby, Postgres, and Oracle

2012-08-16 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436251#comment-13436251 ] Carl Steinbach commented on HIVE-3390: -- Schema tool won't generate the upgrade script

[jira] [Commented] (HIVE-3390) Hive List Bucketing - DDL support - DB upgrade script for Derby, Postgres, and Oracle

2012-08-16 Thread Gang Tim Liu (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436253#comment-13436253 ] Gang Tim Liu commented on HIVE-3390: I see. will do it last. I am making changes and

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

2012-08-16 Thread Apache Jenkins Server
See https://builds.apache.org/job/Hive-0.9.1-SNAPSHOT-h0.21/107/ -- [...truncated 36653 lines...] [junit] POSTHOOK: query: select count(1) as cnt from testhivedrivertable [junit] POSTHOOK: type: DROPTABLE [junit] POSTHOOK: Input:

[jira] [Commented] (HIVE-3068) Add ability to export table metadata as JSON on table drop

2012-08-16 Thread Andrew Chalfant (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3068?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436323#comment-13436323 ] Andrew Chalfant commented on HIVE-3068: --- pingping Add ability to

[jira] [Commented] (HIVE-3268) expressions in cluster by are not working

2012-08-16 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3268?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436365#comment-13436365 ] Hudson commented on HIVE-3268: -- Integrated in Hive-trunk-h0.21 #1611 (See

[jira] [Created] (HIVE-3392) Hive unnecessarily validates table SerDes when dropping a table

2012-08-16 Thread Jonathan Natkins (JIRA)
Jonathan Natkins created HIVE-3392: -- Summary: Hive unnecessarily validates table SerDes when dropping a table Key: HIVE-3392 URL: https://issues.apache.org/jira/browse/HIVE-3392 Project: Hive

[jira] [Updated] (HIVE-3392) Hive unnecessarily validates table SerDes when dropping a table

2012-08-16 Thread Jonathan Natkins (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jonathan Natkins updated HIVE-3392: --- Description: natty@hadoop1:~$ hive hive add jar

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

2012-08-16 Thread Apache Jenkins Server
Changes for Build #1606 [cws] HIVE-2804. Task log retrieval fails on Hadoop 0.23 (Zhenxiao Luo via cws) Changes for Build #1607 [cws] HIVE-3337. Create Table Like should copy configured Table Parameters (Bhushan Mandhani via cws) Changes for Build #1608 Changes for Build #1609 [hashutosh]

[jira] [Updated] (HIVE-3268) expressions in cluster by are not working

2012-08-16 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3268?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-3268: - Component/s: Query Processor expressions in cluster by are not working

[jira] [Commented] (HIVE-3068) Add ability to export table metadata as JSON on table drop

2012-08-16 Thread Edward Capriolo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3068?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436416#comment-13436416 ] Edward Capriolo commented on HIVE-3068: --- Dude don't do that. The average patch sits

[jira] [Commented] (HIVE-3029) Update ShimLoader to work with Hadoop 2.x

2012-08-16 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3029?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436422#comment-13436422 ] Carl Steinbach commented on HIVE-3029: -- @Namit: Looking at this now. Will commit soon.

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

2012-08-16 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2925?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-2925: Attachment: HIVE-2925.3.patch.txt Support non-MR fetching for simple queries with select/limit/filter

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

2012-08-16 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2925?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-2925: Status: Patch Available (was: Open) Rebased on trunk. Sorry for late reply. Support non-MR

[jira] [Created] (HIVE-3393) get_json_object and json_tuple should use Jackson library

2012-08-16 Thread Kevin Wilfong (JIRA)
Kevin Wilfong created HIVE-3393: --- Summary: get_json_object and json_tuple should use Jackson library Key: HIVE-3393 URL: https://issues.apache.org/jira/browse/HIVE-3393 Project: Hive Issue

[jira] [Updated] (HIVE-3393) get_json_object and json_tuple should use Jackson library

2012-08-16 Thread Kevin Wilfong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Wilfong updated HIVE-3393: Attachment: HIVE-3393.1.patch.txt get_json_object and json_tuple should use Jackson library

[jira] [Updated] (HIVE-3393) get_json_object and json_tuple should use Jackson library

2012-08-16 Thread Kevin Wilfong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Wilfong updated HIVE-3393: Status: Patch Available (was: Open) get_json_object and json_tuple should use Jackson library

[jira] [Commented] (HIVE-3393) get_json_object and json_tuple should use Jackson library

2012-08-16 Thread Kevin Wilfong (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3393?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436466#comment-13436466 ] Kevin Wilfong commented on HIVE-3393: - Uploaded a diff here

[jira] [Updated] (HIVE-3029) Update ShimLoader to work with Hadoop 2.x

2012-08-16 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-3029: - Attachment: HIVE-3029.2.patch.txt Update ShimLoader to work with Hadoop 2.x

[jira] [Updated] (HIVE-3029) Update ShimLoader to work with Hadoop 2.x

2012-08-16 Thread Carl Steinbach (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-3029: - Resolution: Fixed Fix Version/s: 0.10.0 Hadoop Flags: Reviewed Status:

[jira] [Commented] (HIVE-3389) running tests for hadoop 23

2012-08-16 Thread Sushanth Sowmyan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3389?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436493#comment-13436493 ] Sushanth Sowmyan commented on HIVE-3389: Namit, I hit a similar issue a while back

[jira] [Commented] (HIVE-3385) fixing 0.23 test build

2012-08-16 Thread Sushanth Sowmyan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436496#comment-13436496 ] Sushanth Sowmyan commented on HIVE-3385: As commented on the HIVE-3389, that issue

[jira] [Commented] (HIVE-3226) ColumnPruner is not working on LateralView

2012-08-16 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3226?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436535#comment-13436535 ] Navis commented on HIVE-3226: - added comments ColumnPruner is not working on

[jira] [Commented] (HIVE-3387) meta data file size exceeds limit

2012-08-16 Thread Navis (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3387?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436544#comment-13436544 ] Navis commented on HIVE-3387: - Configurations set by set command is not propagated to JobConf

[jira] [Assigned] (HIVE-3391) Keep the original query in HiveDriverRunHookContextImpl

2012-08-16 Thread Dawid Dabrowski (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3391?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dawid Dabrowski reassigned HIVE-3391: - Assignee: Dawid Dabrowski Keep the original query in HiveDriverRunHookContextImpl

[jira] [Commented] (HIVE-3226) ColumnPruner is not working on LateralView

2012-08-16 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3226?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436549#comment-13436549 ] Namit Jain commented on HIVE-3226: -- +1 Running tests ColumnPruner is

[jira] [Resolved] (HIVE-3389) running tests for hadoop 23

2012-08-16 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3389?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain resolved HIVE-3389. -- Resolution: Fixed duplicate of HIVE-3029 running tests for hadoop 23

[jira] [Commented] (HIVE-3029) Update ShimLoader to work with Hadoop 2.x

2012-08-16 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3029?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13436571#comment-13436571 ] Hudson commented on HIVE-3029: -- Integrated in Hive-trunk-h0.21 #1612 (See

[jira] [Updated] (HIVE-3375) bucketed map join should check that the number of files match the number of buckets

2012-08-16 Thread Namit Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-3375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-3375: - Resolution: Fixed Status: Resolved (was: Patch Available) Committed (Thanks kevin and carl)