[jira] [Updated] (HIVE-2426) Test that views with joins work properly

2011-09-07 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2426?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2426: - Resolution: Fixed Hadoop Flags: [Reviewed] Status: Resolved (was: Patch Available) +1

[jira] [Commented] (HIVE-2420) partition pruner expr is not populated due to some bug in ppd

2011-09-07 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2420?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13099939#comment-13099939 ] John Sichi commented on HIVE-2420: -- Yongqiang, didn't we already temporarily set

Re: mapred Vs mapreduce

2011-09-06 Thread John Sichi
On Sep 6, 2011, at 9:06 AM, Ashutosh Chauhan wrote: https://cwiki.apache.org/confluence/display/Hive/Roadmap lists mapred-mapreduce transition as one of the roadmap item. Is that still the plan of action? Or are we leaning towards mapred for a while. Supporting both simultaneously is a third

[jira] [Commented] (HIVE-2380) Add ByteArray Datatype

2011-09-06 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2380?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13098322#comment-13098322 ] John Sichi commented on HIVE-2380: -- You can find design doc examples here: https

[jira] [Commented] (HIVE-1143) CREATE VIEW followup: updatable views

2011-09-06 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13098413#comment-13098413 ] John Sichi commented on HIVE-1143: -- Charles, if you had a patch in progress for this one

[jira] [Updated] (HIVE-2426) Test that views with joins work properly

2011-09-06 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2426?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2426: - Attachment: HIVE-2426.3.patch Made a few minor improvements to the overlap handling code and comments

Review Request: HIVE-2426.3

2011-09-06 Thread John Sichi
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1732/ --- Review request for hive. Summary --- HIVE-2426 patch 3 This addresses

[jira] [Updated] (HIVE-2369) Minor typo in error message in HiveConnection.java (JDBC)

2011-09-06 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2369?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2369: - Resolution: Fixed Fix Version/s: 0.9.0 Hadoop Flags: [Reviewed] Status: Resolved

[jira] [Updated] (HIVE-2408) Perpetually degrading performance in checkPaths

2011-09-02 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2408: - Component/s: (was: HBase Handler) Query Processor Perpetually degrading performance

[jira] [Updated] (HIVE-1989) recognize transitivity of predicates on join keys

2011-09-02 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1989?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-1989: - Status: Open (was: Patch Available) I got failures in the following tests: index_auto_mult_tables

[jira] [Commented] (HIVE-1989) recognize transitivity of predicates on join keys

2011-09-02 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13096433#comment-13096433 ] John Sichi commented on HIVE-1989: -- +1. Will commit when tests pass. recognize

[jira] [Updated] (HIVE-1989) recognize transitivity of predicates on join keys

2011-09-02 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1989?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-1989: - Resolution: Fixed Fix Version/s: (was: 0.8.0) 0.9.0 Hadoop Flags

[jira] [Commented] (HIVE-2337) Predicate pushdown erroneously conservative with outer joins

2011-09-01 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13095607#comment-13095607 ] John Sichi commented on HIVE-2337: -- +1. Will commit when tests pass. Predicate

[jira] [Commented] (HIVE-1545) Add a bunch of UDFs and UDAFs

2011-09-01 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13095621#comment-13095621 ] John Sichi commented on HIVE-1545: -- I'm way behind on the PDK (probably not gonna make

[jira] [Commented] (HIVE-1989) recognize transitivity of predicates on join keys

2011-09-01 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13095643#comment-13095643 ] John Sichi commented on HIVE-1989: -- Charles, can you add a test case for the original

[jira] [Commented] (HIVE-2380) Add ByteArray Datatype

2011-09-01 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2380?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13095669#comment-13095669 ] John Sichi commented on HIVE-2380: -- Ashutosh, maybe we can discuss this one

[jira] [Updated] (HIVE-2401) Show functions with regex not working

2011-09-01 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2401?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2401: - Status: Open (was: Patch Available) The wiki already explains how to do this. I don't hink we need any

[jira] [Updated] (HIVE-2402) Function like with empty string is throwing null pointer exception

2011-09-01 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2402: - Status: Open (was: Patch Available) Function like with empty string is throwing null pointer exception

[jira] [Assigned] (HIVE-2369) Minor typo in error message in HiveConnection.java (JDBC)

2011-09-01 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2369?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi reassigned HIVE-2369: Assignee: Clément Notin Minor typo in error message in HiveConnection.java (JDBC

[jira] [Issue Comment Edited] (HIVE-2401) Show functions with regex not working

2011-09-01 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13095671#comment-13095671 ] John Sichi edited comment on HIVE-2401 at 9/1/11 11:31 PM

[jira] [Updated] (HIVE-2337) Predicate pushdown erroneously conservative with outer joins

2011-09-01 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2337: - Resolution: Fixed Hadoop Flags: [Reviewed] Status: Resolved (was: Patch Available

[jira] [Updated] (HIVE-2184) Few improvements in org.apache.hadoop.hive.ql.metadata.Hive.close()

2011-08-31 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2184?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2184: - Resolution: Fixed Fix Version/s: 0.9.0 Hadoop Flags: [Reviewed] Status: Resolved

[jira] [Updated] (HIVE-2383) Incorrect alias filtering for predicate pushdown

2011-08-31 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2383?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2383: - Resolution: Fixed Fix Version/s: (was: 0.8.0) 0.9.0 Hadoop Flags

[jira] [Resolved] (HIVE-1395) Table aliases are ambiguous

2011-08-31 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1395?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi resolved HIVE-1395. -- Resolution: Won't Fix We're fixing the bugs and sticking with the normal SQL rules, which allow

[jira] [Resolved] (HIVE-1342) Predicate push down get error result when sub-queries have the same alias name

2011-08-31 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi resolved HIVE-1342. -- Resolution: Fixed Fix Version/s: 0.9.0 Fixed by committing sub-issues (not the patches attached

[jira] [Commented] (HIVE-2383) Incorrect alias filtering for predicate pushdown

2011-08-31 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2383?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13095020#comment-13095020 ] John Sichi commented on HIVE-2383: -- Oh, um, also: +1. Incorrect alias filtering

Re: Review Request: HIVE-2337: Predicate pushdown erroneously conservative with outer joins

2011-08-31 Thread John Sichi
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1275/#review1710 ---

[jira] [Commented] (HIVE-2337) Predicate pushdown erroneously conservative with outer joins

2011-08-31 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2337?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13095105#comment-13095105 ] John Sichi commented on HIVE-2337: -- Charles, did you intentionally omit the new

[jira] [Updated] (HIVE-2382) Invalid predicate pushdown from incorrect column expression map for select operator generated by GROUP BY operation

2011-08-30 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2382: - Resolution: Fixed Fix Version/s: (was: 0.8.0) 0.9.0 Hadoop Flags

[jira] [Updated] (HIVE-2182) Avoid null pointer exception when executing UDF

2011-08-30 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2182?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2182: - Status: Open (was: Patch Available) Avoid null pointer exception when executing UDF

[jira] [Commented] (HIVE-2182) Avoid null pointer exception when executing UDF

2011-08-30 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13094195#comment-13094195 ] John Sichi commented on HIVE-2182: -- I agree with Chinna that in general we don't know

[jira] [Assigned] (HIVE-2402) Function like with empty string is throwing null pointer exception

2011-08-30 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi reassigned HIVE-2402: Assignee: Chinna Rao Lalam Function like with empty string is throwing null pointer exception

[jira] [Commented] (HIVE-2402) Function like with empty string is throwing null pointer exception

2011-08-30 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13094196#comment-13094196 ] John Sichi commented on HIVE-2402: -- I'm curious: why is it not possible to actually

[jira] [Updated] (HIVE-2412) Update Eclipse configuration to include Mockito dependency

2011-08-30 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2412: - Resolution: Fixed Fix Version/s: 0.9.0 Hadoop Flags: [Reviewed] Status: Resolved

[jira] [Commented] (HIVE-2184) Few improvements in org.apache.hadoop.hive.ql.metadata.Hive.close()

2011-08-30 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13094202#comment-13094202 ] John Sichi commented on HIVE-2184: -- +1. Will commit when tests pass. Few improvements

[jira] [Updated] (HIVE-2352) create empty files if and only if table is bucketed and hive.enforce.bucketing=true

2011-08-30 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2352?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2352: - Status: Open (was: Patch Available) create empty files if and only if table is bucketed

[jira] [Commented] (HIVE-2380) Add ByteArray Datatype

2011-08-30 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2380?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13094245#comment-13094245 ] John Sichi commented on HIVE-2380: -- Taking a look. Add ByteArray Datatype

[jira] [Commented] (HIVE-2382) Invalid predicate pushdown from incorrect column expression map for select operator generated by GROUP BY operation

2011-08-29 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13093366#comment-13093366 ] John Sichi commented on HIVE-2382: -- +1. Will commit when tests pass. Invalid predicate

Re: Hive patches need review and commit

2011-08-25 Thread John Sichi
Forwarding to other committers at dev. JVS On Aug 25, 2011, at 12:13 PM, Chinna chinna...@huawei.com wrote: Hi John, Pls take a look at these patches, HIVE-2017 HIVE-1996 HIVE-2184 Thanks, Chinna Rao Lalam

[jira] [Assigned] (HIVE-1643) support range scans and non-key columns in HBase filter pushdown

2011-08-24 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1643?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi reassigned HIVE-1643: Assignee: Vaibhav Aggarwal (was: John Sichi) support range scans and non-key columns in HBase

Re: Branch and Release Dates for Hive 0.8.0

2011-08-15 Thread John Sichi
Sounds good to me. JVS On Aug 15, 2011, at 3:26 PM, Carl Steinbach wrote: Hi, Hive 0.7.0, the last major version of Hive, was released more than four months ago on March 20th. This means that we're already overdue for a Hive 0.8.0 release since one of the policies of the project is to

[jira] [Commented] (HIVE-2365) SQL support for bulk load into HBase

2011-08-15 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2365?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13085477#comment-13085477 ] John Sichi commented on HIVE-2365: -- (Just realized I forgot to link the original doc where

[jira] [Commented] (HIVE-2373) Importing hive tables into hbase+hive requires a lot of work which often can be implied

2011-08-15 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13085478#comment-13085478 ] John Sichi commented on HIVE-2373: -- Posting the script somewhere and linking it from

[jira] [Updated] (HIVE-2171) Allow custom serdes to set field comments

2011-08-12 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2171?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2171: - Resolution: Fixed Fix Version/s: 0.8.0 Hadoop Flags: [Reviewed] Status: Resolved

[jira] [Commented] (HIVE-2171) Allow custom serdes to set field comments

2011-08-12 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2171?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13084349#comment-13084349 ] John Sichi commented on HIVE-2171: -- BTW, I noticed that the mockito jar ends up in build

[jira] [Commented] (HIVE-1360) Allow UDFs to access constant parameter values at compile time

2011-08-12 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1360?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13084366#comment-13084366 ] John Sichi commented on HIVE-1360: -- Checked with Carl; he said he'll review this one

[jira] [Updated] (HIVE-2344) filter is removed due to regression of HIVE-1538

2011-08-11 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2344?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2344: - Resolution: Fixed Release Note: When predicate pushdown is enabled, Hive would previously

HIVE-1538/HIVE-2344

2011-08-11 Thread John Sichi
I just committed the fix from Amareshwari, so after this gets pushed, it should be possible to back out the conf changes which were applied to avoid the bug from HIVE-1538. Read the release notes I added on HIVE-2344 and chime in with a new JIRA issue if you think there are cases where it's

Re: HIVE-1538/HIVE-2344

2011-08-11 Thread John Sichi
On Aug 11, 2011, at 1:21 PM, wrote: I just committed the fix from Amareshwari, so after this gets pushed, it should be possible to back out the conf changes which were applied to avoid the bug from HIVE-1538. (Oops, ignore this part...no conf changes were applied in Hive source, so this

HIVE-2282

2011-08-11 Thread John Sichi
The unit test sample_islocalmode_hook.q has been failing consistently for me with the diff below. Jenkins builds passed with it so I'm guessing it must be something environmental? Also, Siying, it looks like you committed this, but did not resolve it in JIRA? [junit] 97,98c97,98

Re: HIVE-2282

2011-08-11 Thread John Sichi
. On 8/11/11 4:49 PM, Siying Dong siyin...@fb.com wrote: Kevin, probably there are still some non-deterministic in your test case. Can you careful examine it? -Original Message- From: John Sichi Sent: Thursday, August 11, 2011 4:44 PM To: Siying Dong; Kevin Wilfong Cc: dev

[jira] [Commented] (HIVE-1989) recognize transitivity of predicates on join keys

2011-08-11 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13083887#comment-13083887 ] John Sichi commented on HIVE-1989: -- Usually when we add a new optimization, we add

[jira] [Commented] (HIVE-2171) Allow custom serdes to set field comments

2011-08-11 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2171?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13083907#comment-13083907 ] John Sichi commented on HIVE-2171: -- +1. Will commit when tests pass. Allow custom

[jira] [Commented] (HIVE-2344) filter is removed due to regression of HIVE-1538

2011-08-09 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2344?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13081991#comment-13081991 ] John Sichi commented on HIVE-2344: -- +1. Will commit when tests pass. filter is removed

[jira] [Updated] (HIVE-2344) filter is removed due to regression of HIVE-1538

2011-08-09 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2344?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2344: - Assignee: Ido Hadanny (was: Amareshwari Sriramadasu) Status: Open (was: Patch Available) I'm

[jira] [Updated] (HIVE-2138) Exception when no splits returned from index

2011-08-08 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2138: - Resolution: Fixed Fix Version/s: 0.8.0 Hadoop Flags: [Reviewed] Status: Resolved

[jira] [Commented] (HIVE-2356) Fix udtf_explode.q and udf_explode.q test failures

2011-08-08 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13081331#comment-13081331 ] John Sichi commented on HIVE-2356: -- +1. Will commit. Fix udtf_explode.q

[jira] [Updated] (HIVE-2356) Fix udtf_explode.q and udf_explode.q test failures

2011-08-08 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2356?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2356: - Resolution: Fixed Fix Version/s: 0.8.0 Hadoop Flags: [Reviewed] Status: Resolved

[jira] [Commented] (HIVE-2138) Exception when no splits returned from index

2011-08-05 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13080187#comment-13080187 ] John Sichi commented on HIVE-2138: -- Giving it another go now. Exception when no splits

Re: Review Request: HIVE-1694: Accelerate GROUP BY execution using indexes

2011-08-05 Thread John Sichi
/1194/ --- (Updated 2011-08-03 10:31:42) Review request for hive and John Sichi. Summary --- This patch has defined a new AggregateIndexHandler which is used to optimize the query plan for groupby queries

[jira] [Commented] (HIVE-1694) Accelerate GROUP BY execution using indexes

2011-08-05 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1694?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13080236#comment-13080236 ] John Sichi commented on HIVE-1694: -- Added some comments on Review Board. Thanks

[jira] [Commented] (HIVE-2310) CREATE EXTERNAL TABLE should require a valid LOCATION clause

2011-08-05 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2310?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13080270#comment-13080270 ] John Sichi commented on HIVE-2310: -- Non-native external tables (such as HBase tables

[jira] [Updated] (HIVE-2286) ClassCastException when building index with security.authorization turned on

2011-08-04 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2286: - Resolution: Fixed Fix Version/s: 0.8.0 Hadoop Flags: [Reviewed] Status: Resolved

[jira] [Updated] (HIVE-2138) Exception when no splits returned from index

2011-08-04 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2138: - Status: Open (was: Patch Available) index_auto_test_if_used.q should not be in this patch. Exception

[jira] [Commented] (HIVE-2318) Support multiple file systems

2011-08-04 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2318?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13079694#comment-13079694 ] John Sichi commented on HIVE-2318: -- Besides mock-based unit tests, it would also be useful

[jira] [Updated] (HIVE-2138) Exception when no splits returned from index

2011-08-04 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2138: - Status: Open (was: Patch Available) index_auto_empty needs its log updated: [junit] PREHOOK: type

[jira] [Commented] (HIVE-2342) mirror.facebook.net is 404ing

2011-08-03 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13078907#comment-13078907 ] John Sichi commented on HIVE-2342: -- There was some failure last night which hasn't been

[jira] [Commented] (HIVE-2286) ClassCastException when building index with security.authorization turned on

2011-08-03 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13078919#comment-13078919 ] John Sichi commented on HIVE-2286: -- lol, I'll give it a try ClassCastException when

Re: Hive dependencies removed from mirror.facebook.net?

2011-08-03 Thread John Sichi
There were some storage array failures; recovery attempts are still under way (no ETA yet). Once it's fixed everything will be back in the same place, but since I don't know how long that's going to take, it would be great if someone can test out an overridden version of build.properties so

[jira] [Commented] (HIVE-2342) mirror.facebook.net is 404ing

2011-08-03 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13079117#comment-13079117 ] John Sichi commented on HIVE-2342: -- We don't need to do anything about the other reference

[jira] [Commented] (HIVE-2171) Allow custom serdes to set field comments

2011-08-03 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2171?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13079135#comment-13079135 ] John Sichi commented on HIVE-2171: -- * Yes, please update RB * checkstyle: yeah, I think

[jira] [Updated] (HIVE-2342) mirror.facebook.net is 404ing

2011-08-03 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2342: - Resolution: Fixed Fix Version/s: 0.8.0 Assignee: Carl Steinbach Hadoop Flags

[jira] [Updated] (HIVE-2286) ClassCastException when building index with security.authorization turned on

2011-08-03 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2286: - Status: Open (was: Patch Available) The following tests failed: index_compression

becoming a Hive committer

2011-08-03 Thread John Sichi
I often get asked questions about this topic, so I've put together a wiki page which expresses some of my thoughts on it: https://cwiki.apache.org/confluence/display/Hive/BecomingACommitter Let me know if there are points you'd like to add, or where you see it differently. JVS

[jira] [Updated] (HIVE-2286) ClassCastException when building index with security.authorization turned on

2011-08-02 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2286: - Status: Open (was: Patch Available) Got failures in these three tests: index_auto_mult_tables

Re: Review Request: HIVE-2326: Turn off bitmap indexing when map-side aggregation is turned off

2011-08-01 Thread John Sichi
Albiz wrote: --- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1232/ --- (Updated 2011-07-31 00:26:44) Review request for hive, John

[jira] [Commented] (HIVE-2326) Turn off bitmap indexing when map-side aggregation is turned off

2011-08-01 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2326?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13073668#comment-13073668 ] John Sichi commented on HIVE-2326: -- Can you add a negative testcase? Turn off bitmap

[jira] [Commented] (HIVE-2100) virtual column references inside subqueries cause execution exceptions

2011-08-01 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13073670#comment-13073670 ] John Sichi commented on HIVE-2100: -- Click Submit Patch to get it in the review queue

[jira] [Commented] (HIVE-2330) Allow tables to warn on querying

2011-08-01 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13073675#comment-13073675 ] John Sichi commented on HIVE-2330: -- It might be possible to write a hook to accomplish

[jira] [Commented] (HIVE-2326) Turn off bitmap indexing when map-side aggregation is turned off

2011-08-01 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2326?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13073823#comment-13073823 ] John Sichi commented on HIVE-2326: -- +1. Will commit when tests pass. Turn off bitmap

[jira] [Assigned] (HIVE-2253) Merge failing of join tree in exceptional case

2011-08-01 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2253?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi reassigned HIVE-2253: Assignee: Navis Merge failing of join tree in exceptional case

[jira] [Assigned] (HIVE-2329) Not using map aggregation, fails to execute group-by after cluster-by with same key

2011-08-01 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2329?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi reassigned HIVE-2329: Assignee: Navis Not using map aggregation, fails to execute group-by after cluster-by with same

[jira] [Assigned] (HIVE-2138) Exception when no splits returned from index

2011-08-01 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi reassigned HIVE-2138: Assignee: Syed S. Albiz Syed, if you get time to look into this one, it's a good one to fix

Re: Review Request: HIVE-1694: Accelerate GROUP BY execution using indexes

2011-08-01 Thread John Sichi
On 2011-07-28 21:40:30, John Sichi wrote: ql/src/java/org/apache/hadoop/hive/ql/index/AggregateIndexHandler.java, line 61 https://reviews.apache.org/r/1194/diff/1/?file=27052#file27052line61 Please run ant checkstyle and fix all the formatting discrepancies it reports for your

[jira] [Commented] (HIVE-2331) Turn off compression when generating index intermediate results

2011-08-01 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2331?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13076038#comment-13076038 ] John Sichi commented on HIVE-2331: -- +1. Will commit when tests pass. Turn off

[jira] [Commented] (HIVE-2324) Enhancing local mode execution with non-HDFS related queries

2011-07-29 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2324?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13072970#comment-13072970 ] John Sichi commented on HIVE-2324: -- Currently the HBase handler returns 0 from its splits

[jira] [Updated] (HIVE-2183) In Task class and its subclasses logger is initialized in constructor

2011-07-29 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2183?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2183: - Resolution: Fixed Fix Version/s: 0.8.0 Hadoop Flags: [Reviewed] Status: Resolved

[jira] [Updated] (HIVE-2294) Allow ShimLoader to work with Hadoop 0.20-append

2011-07-29 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2294?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2294: - Status: Open (was: Patch Available) Typo: surfix - suffix Allow ShimLoader to work with Hadoop 0.20

Re: Review Request: HIVE-1694: Accelerate GROUP BY execution using indexes

2011-07-28 Thread John Sichi
. To reply, visit: https://reviews.apache.org/r/1194/ --- (Updated 2011-07-26 14:44:01) Review request for hive and John Sichi. Summary --- This patch has defined a new AggregateIndexHandler which is used to optimize

[jira] [Updated] (HIVE-2286) ClassCastException when building index with security.authorization turned on

2011-07-27 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2286: - Status: Open (was: Patch Available) A lot of the command types in the test results should

minutes for July 2011 Apache Hive contributor meetup

2011-07-27 Thread John Sichi
https://cwiki.apache.org/confluence/display/Hive/ContributorsMinutes110726 If you were there and spot anything incorrect or left out, please let me know or edit the wiki. JVS

[jira] [Commented] (HIVE-1218) CREATE TABLE t LIKE some_view should create a new empty base table, but instead creates a copy of view

2011-07-27 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1218?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13072084#comment-13072084 ] John Sichi commented on HIVE-1218: -- Can you fill in the release note field

Re: Review Request: HIVE-2286: ClassCastException when building index with security.authorization turned on

2011-07-26 Thread John Sichi
2011-07-25 23:03:22) Review request for hive, John Sichi and Ning Zhang. Summary --- Save the original HiveOperation/commandType when we generate the index builder task and restore it after we're done generating the task so that the authorization checks make the right decision

[jira] [Assigned] (HIVE-1143) CREATE VIEW followup: updatable views

2011-07-26 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi reassigned HIVE-1143: Assignee: Charles Chen (was: Carl Steinbach) CREATE VIEW followup: updatable views

[jira] [Assigned] (HIVE-1989) recognize transitivity of predicates on join keys

2011-07-26 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-1989?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi reassigned HIVE-1989: Assignee: Charles Chen recognize transitivity of predicates on join keys

[jira] [Commented] (HIVE-2123) CommandNeedRetryException needs release locks

2011-07-26 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2123?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13071327#comment-13071327 ] John Sichi commented on HIVE-2123: -- This one has been sitting in Patch Available queue

[jira] [Commented] (HIVE-2242) DDL Semantic Analyzer does not pass partial specification partitions to PreExecute hooks when dropping partitions

2011-07-26 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13071328#comment-13071328 ] John Sichi commented on HIVE-2242: -- This one has been sitting in Patch Available queue

[jira] [Commented] (HIVE-2065) RCFile issues

2011-07-26 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2065?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13071330#comment-13071330 ] John Sichi commented on HIVE-2065: -- This one has been sitting in Patch Available queue

[jira] [Updated] (HIVE-2128) Automatic Indexing with multiple tables

2011-07-25 Thread John Sichi (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] John Sichi updated HIVE-2128: - Status: Open (was: Patch Available) Reran with latest patch and still got failures in these three

Hudson builds

2011-07-25 Thread John Sichi
They've been failing consistently for 20 days. Seems like tests are often passing fine, but something else goes wrong, either right after (or during?) maven, where it is trying to spawn ant? See the very end of this log for an example:

<    1   2   3   4   5   6   7   8   9   10   >