[jira] [Commented] (HIVE-2930) Add license to the Hive files

2012-04-17 Thread Sohan Jain (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2930?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13255759#comment-13255759 ] Sohan Jain commented on HIVE-2930: -- I intended to license my patch for HIVE-2246 to

Review Request: HIVE-2242: DDL Semantic Analyzer does not pass partial specification partitions to PreExecute hooks when dropping partitions

2011-08-11 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1475/ --- Review request for hive and Paul Yang. Summary --- Currently, when dropping

Review Request: HIVE-2368: Determining whether a Column Descriptor is unused may take too long

2011-08-10 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1462/ --- Review request for hive and Paul Yang. Summary --- To determine if a column

[jira] [Created] (HIVE-2368) Determining whether a Column Descriptor is unused may take too long

2011-08-10 Thread Sohan Jain (JIRA)
Components: Metastore Reporter: Sohan Jain Attachments: HIVE-2368.1.patch To determine if a column descriptor is unused, we call listStorageDescriptorsWithCD(), which may return a big list of SDs. This can severely slow down dropping partitions. We can add a maximum

[jira] [Updated] (HIVE-2368) Determining whether a Column Descriptor is unused may take too long

2011-08-10 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2368: - Attachment: HIVE-2368.1.patch > Determining whether a Column Descriptor is unused may take too l

[jira] [Created] (HIVE-2367) Indexes' storage descriptors' columns are not deduped, and altering an index leaves behind an unused storage descriptor

2011-08-10 Thread Sohan Jain (JIRA)
URL: https://issues.apache.org/jira/browse/HIVE-2367 Project: Hive Issue Type: Bug Components: Metastore Reporter: Sohan Jain The metastore migration by HIVE-2246 does not dedupe the COLUMNS information for Indexes. That is, the IDXS table has

Review Request: HIVE-2366: Metastore upgrade scripts for HIVE-2246 do not migrate indexes nor rename the old COLUMNS table

2011-08-10 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1460/ --- Review request for hive, Ning Zhang and Paul Yang. Summary --- The upgrade

[jira] [Updated] (HIVE-2366) Metastore upgrade scripts for HIVE-2246 do not migrate indexes nor rename the old COLUMNS table

2011-08-10 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2366?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2366: - Attachment: HIVE-2366.1.patch > Metastore upgrade scripts for HIVE-2246 do not migrate indexes nor ren

[jira] [Created] (HIVE-2366) Metastore upgrade scripts for HIVE-2246 do not migrate indexes nor rename the old COLUMNS table

2011-08-10 Thread Sohan Jain (JIRA)
Project: Hive Issue Type: Bug Components: Metastore Reporter: Sohan Jain Assignee: Sohan Jain The upgrade scripts for the hive metastore in HIVE-2246 do not upgrade the indexes. They also need to rename the old COLUMNS table after migration

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

2011-08-08 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13081333#comment-13081333 ] Sohan Jain commented on HIVE-2356: -- @Carl: out of curiosity, what was the fix here

[jira] [Updated] (HIVE-2246) Dedupe tables' column schemas from partitions in the metastore db

2011-08-08 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2246: - Attachment: HIVE-2246.8.patch > Dedupe tables' column schemas from partitions in the meta

Re: Review Request: HIVE-2246: Dedupe tables' column schemas from partitions in the metastore db

2011-08-08 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1183/ --- (Updated 2011-08-08 21:29:23.722825) Review request for hive, Ning Zhang and Pau

Re: Review Request: HIVE-2246: Dedupe tables' column schemas from partitions in the metastore db

2011-08-08 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1183/ --- (Updated 2011-08-08 21:19:06.999293) Review request for hive, Ning Zhang and Pau

Re: Review Request: HIVE-2246: Dedupe tables' column schemas from partitions in the metastore db

2011-08-08 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1183/ --- (Updated 2011-08-08 20:55:11.546253) Review request for hive, Ning Zhang and Pau

[jira] [Updated] (HIVE-2322) Add ColumnarSerDe to the list of native SerDes

2011-08-05 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2322: - Attachment: HIVE-2322.5.patch Ah I apologize for this; including the patched query as well. >

Re: Review Request: HIVE-2246: Dedupe tables' column schemas from partitions in the metastore db

2011-08-05 Thread Sohan Jain
/ObjectStore.java <https://reviews.apache.org/r/1183/#comment2984> should read 1-N actually - Sohan On 2011-08-06 01:40:49, Sohan Jain wrote: > > --- > This is an automatically generated e-mail. To reply, visit: > https://re

Re: Review Request: HIVE-2246: Dedupe tables' column schemas from partitions in the metastore db

2011-08-05 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1183/ --- (Updated 2011-08-06 01:40:49.118616) Review request for hive, Ning Zhang and Pau

[jira] [Updated] (HIVE-2322) Add ColumnarSerDe to the list of native SerDes

2011-08-05 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2322: - Attachment: HIVE-2322.4.patch fixed the broken test cases > Add ColumnarSerDe to the list of nat

[jira] [Updated] (HIVE-2246) Dedupe tables' column schemas from partitions in the metastore db

2011-08-05 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2246: - Attachment: HIVE-2246.4.patch > Dedupe tables' column schemas from partitions in the meta

Re: Review Request: HIVE-2246: Dedupe tables' column schemas from partitions in the metastore db

2011-08-05 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1183/ --- (Updated 2011-08-05 20:49:19.127572) Review request for hive, Ning Zhang and Pau

Re: Review Request: HIVE-2246: Dedupe tables' column schemas from partitions in the metastore db

2011-08-05 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1183/ --- (Updated 2011-08-05 20:48:05.144312) Review request for hive, Ning Zhang and Pau

Re: Review Request: HIVE-2246: Dedupe tables' column schemas from partitions in the metastore db

2011-08-05 Thread Sohan Jain
> old partition will still have the old CDs. When we query the old partition, > > do we use the old partitons's CD or the table's CD? > > > > Also in the above case, when you run 'desc table partition > > ', do you return the old partition

Re: Review Request: HIVE-2246: Dedupe tables' column schemas from partitions in the metastore db

2011-08-05 Thread Sohan Jain
te the p1=1, p2=1 partition with some data now > alter table test add columns (b string) > select * from test where p1 = 1 and p2 = 1, it'd use the table's latest schema; i.e., return the column 'a's values and the column 'b' as all

[jira] [Updated] (HIVE-2322) Add ColumnarSerDe to the list of native SerDes

2011-08-04 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2322: - Attachment: HIVE-2322.3.patch Rebuilt patch > Add ColumnarSerDe to the list of native Ser

[jira] [Commented] (HIVE-2322) Add ColumnarSerDe to the list of native SerDes

2011-08-04 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2322?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13079537#comment-13079537 ] Sohan Jain commented on HIVE-2322: -- Yes, looks like some of the output.q files

[jira] [Updated] (HIVE-2319) Calling alter_table after changing partition comment throws an exception

2011-08-04 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2319: - Attachment: HIVE-2319.4.patch > Calling alter_table after changing partition comment throws an except

Re: Review Request: HIVE-2319: Calling alter_table after changing partition key comment throws an exception

2011-08-04 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1213/ --- (Updated 2011-08-04 17:05:08.413032) Review request for hive and Paul Yang. Ch

[jira] [Updated] (HIVE-2338) Alter table always throws an unhelpful error on failure

2011-08-03 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2338: - Attachment: HIVE-2338.2.patch > Alter table always throws an unhelpful error on fail

Re: Review Request: HIVE-2338: Alter table always throws an unhelpful error on failure

2011-08-03 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1276/ --- (Updated 2011-08-03 23:59:06.774216) Review request for hive and Paul Yang. Ch

[jira] [Updated] (HIVE-2322) Add ColumnarSerDe to the list of native SerDes

2011-08-03 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2322: - Attachment: HIVE-2322.2.patch Including the updated test query results in this patch. >

Re: Review Request: Add ColumnarSerDe to the list of native SerDes

2011-08-03 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1215/ --- (Updated 2011-08-03 20:47:48.616906) Review request for hive and Paul Yang. Ch

[jira] [Updated] (HIVE-2338) Alter table always throws an unhelpful error on failure

2011-08-02 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2338: - Attachment: HIVE-2338.1.patch > Alter table always throws an unhelpful error on fail

[jira] [Updated] (HIVE-2338) Alter table always throws an unhelpful error on failure

2011-08-02 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2338: - Status: Patch Available (was: Open) > Alter table always throws an unhelpful error on fail

Review Request: HIVE-2338: Alter table always throws an unhelpful error on failure

2011-08-02 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1276/ --- Review request for hive and Paul Yang. Summary --- Every failure in an alte

[jira] [Created] (HIVE-2338) Alter table always throws an unhelpful error on failure

2011-08-02 Thread Sohan Jain (JIRA)
: Metastore Reporter: Sohan Jain Assignee: Sohan Jain Priority: Minor Every failure in an alter table function always return a MetaException. When altering tables and catching exceptions, we throw a MetaException in the "finally" part of a try-catch-finally bl

[jira] [Updated] (HIVE-2319) Calling alter_table after changing partition comment throws an exception

2011-07-28 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2319: - Attachment: HIVE-2319.3.patch > Calling alter_table after changing partition comment throws an except

Re: Review Request: HIVE-2319: Calling alter_table after changing partition key comment throws an exception

2011-07-28 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1213/ --- (Updated 2011-07-28 23:26:15.868719) Review request for hive and Paul Yang. Ch

Re: Review Request: HIVE-2319: Calling alter_table after changing partition key comment throws an exception

2011-07-28 Thread Sohan Jain
is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1213/#review1215 --- On 2011-07-28 07:06:24, Sohan Jain wrote: > > --- > This is an automatically generated e-mail. To reply, visit: > https://reviews.ap

Review Request: Add ColumnarSerDe to the list of native SerDes

2011-07-28 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1215/ --- Review request for hive and Paul Yang. Summary --- We store metadata about

[jira] [Updated] (HIVE-2322) Add ColumnarSerDe to the list of native SerDes

2011-07-28 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2322: - Attachment: HIVE-2322.1.patch > Add ColumnarSerDe to the list of native Ser

[jira] [Updated] (HIVE-2322) Add ColumnarSerDe to the list of native SerDes

2011-07-28 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2322?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2322: - Status: Patch Available (was: Open) > Add ColumnarSerDe to the list of native Ser

[jira] [Created] (HIVE-2322) Add ColumnarSerDe to the list of native SerDes

2011-07-28 Thread Sohan Jain (JIRA)
/Deserializers Reporter: Sohan Jain Assignee: Sohan Jain We store metadata about ColumnarSerDes in the metastore, so it should be considered a native SerDe. Then, column information can be retrieved from the metastore instead of from deserialization. Currently, for non

[jira] [Updated] (HIVE-2319) Calling alter_table after changing partition comment throws an exception

2011-07-28 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2319: - Attachment: HIVE-2319.2.patch > Calling alter_table after changing partition comment throws an except

[jira] [Updated] (HIVE-2319) Calling alter_table after changing partition comment throws an exception

2011-07-28 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2319: - Assignee: Sohan Jain Status: Patch Available (was: Open) > Calling alter_table after chang

Re: Review Request: HIVE-2319: Calling alter_table after changing partition key comment throws an exception

2011-07-28 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1213/ --- (Updated 2011-07-28 07:06:24.236980) Review request for hive and Paul Yang. Ch

Review Request: HIVE-2319: Calling alter_table after changing partition key comment throws an exception

2011-07-27 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1213/ --- Review request for hive and Paul Yang. Summary --- Altering a table's parti

[jira] [Created] (HIVE-2319) Calling alter_table after changing partition comment throws an exception

2011-07-27 Thread Sohan Jain (JIRA)
: Bug Components: Metastore Reporter: Sohan Jain Altering a table's partition key comments raises an InvalidOperationException. The partition key name and type should not be mutable, but the comment should be able to get changed. -- This message is automatically gene

[jira] [Updated] (HIVE-2226) Add API to retrieve table names by an arbitrary filter, e.g., by owner, retention, parameters, etc.

2011-07-25 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2226?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2226: - Attachment: HIVE-2226.4.patch include auto-gen thrift files > Add API to retrieve table names by

[jira] [Updated] (HIVE-2246) Dedupe tables' column schemas from partitions in the metastore db

2011-07-21 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2246: - Attachment: HIVE-2246.3.patch Adding some missing files that I forgot to svn add > Dedupe tables'

Re: Review Request: HIVE-2246: Dedupe tables' column schemas from partitions in the metastore db

2011-07-21 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1183/ --- (Updated 2011-07-22 05:30:29.026246) Review request for hive, Ning Zhang and Pau

[jira] [Updated] (HIVE-2246) Dedupe tables' column schemas from partitions in the metastore db

2011-07-21 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2246: - Description: Note: this patch proposes a schema change, and is therefore incompatible with the current

[jira] [Updated] (HIVE-2246) Dedupe tables' column schemas from partitions in the metastore db

2011-07-21 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2246: - Attachment: HIVE-2246.2.patch See the latest review board. This patch is incompatible with the current

Review Request: HIVE-2246: Dedupe tables' column schemas from partitions in the metastore db

2011-07-21 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1183/ --- Review request for hive, Ning Zhang and Paul Yang. Summary --- This patch t

[jira] [Updated] (HIVE-2226) Add API to retrieve table names by an arbitrary filter, e.g., by owner, retention, parameters, etc.

2011-07-12 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2226?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2226: - Attachment: HIVE-2226.3.patch > Add API to retrieve table names by an arbitrary filter, e.g., by ow

Re: Review Request: HIVE-2226: Add API to metastore for table filtering based on table properties

2011-07-12 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/910/ --- (Updated 2011-07-12 18:29:23.959204) Review request for hive and Paul Yang. Cha

[jira] [Updated] (HIVE-2276) Fix Inconsistency between RB and JIRA patches for HIVE-2194

2011-07-08 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2276: - Status: Patch Available (was: Open) > Fix Inconsistency between RB and JIRA patches for HIVE-2

[jira] [Commented] (HIVE-2194) Add actions for alter table and alter partition events for metastore event listeners

2011-07-08 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2194?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13062243#comment-13062243 ] Sohan Jain commented on HIVE-2194: -- Please see HIVE-2276 > Add actions for alte

[jira] [Updated] (HIVE-2276) Fix Inconsistency between RB and JIRA patches for HIVE-2194

2011-07-08 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2276?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2276: - Attachment: HIVE-2276.1.patch > Fix Inconsistency between RB and JIRA patches for HIVE-2

[jira] [Created] (HIVE-2276) Fix Inconsistency between RB and JIRA patches for HIVE-2194

2011-07-08 Thread Sohan Jain (JIRA)
: Sohan Jain Assignee: Sohan Jain Attachments: HIVE-2276.1.patch The RB and JIRA patches for HIVE-2194 were out of sync. An outdated patch for HIVE-2194 was committed. This patch updates that patch to include the changes from RB. -- This message is automatically generated by

[jira] [Updated] (HIVE-2194) Add actions for alter table and alter partition events for metastore event listeners

2011-07-08 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2194?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2194: - Attachment: HIVE-2194.4.patch > Add actions for alter table and alter partition events for metast

[jira] [Commented] (HIVE-2219) Make "alter table drop partition" more efficient

2011-07-08 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13062167#comment-13062167 ] Sohan Jain commented on HIVE-2219: -- Ok, please refer to HIVE-2275 > Make "

[jira] [Updated] (HIVE-2275) Revert HIVE-2219 and apply correct patch to improve the efficiency of dropping multiple partitions

2011-07-08 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2275?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2275: - Status: Patch Available (was: Open) > Revert HIVE-2219 and apply correct patch to improve the efficie

[jira] [Updated] (HIVE-2275) Revert HIVE-2219 and apply correct patch to improve the efficiency of dropping multiple partitions

2011-07-08 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2275?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2275: - Attachment: HIVE-2275.1.patch > Revert HIVE-2219 and apply correct patch to improve the efficiency

[jira] [Created] (HIVE-2275) Revert HIVE-2219 and apply correct patch to improve the efficiency of dropping multiple partitions

2011-07-08 Thread Sohan Jain (JIRA)
-2275 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Sohan Jain Assignee: Sohan Jain HIVE-2219 applied an incorrect patch that fails unit tests. This patch reverts those changes and adds the intended changes to improve

[jira] [Updated] (HIVE-2219) Make "alter table drop partition" more efficient

2011-07-08 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2219: - Attachment: HIVE-2219.2.patch This patch is the correct one from ReviewBoard > Make "alter ta

RE: HIVE-2219

2011-07-08 Thread Sohan Jain
Sohan -Original Message- From: John Sichi Sent: Friday, July 08, 2011 11:28 AM To: Sohan Jain; Paul Yang Cc: dev@hive.apache.org Subject: HIVE-2219 I'm getting failures in these two tests after picking up the commit for that JIRA issue. drop_multi_partitions.q escape1.q Passes with r1143

[jira] [Updated] (HIVE-2256) Better error message in CLI on invalid column name

2011-07-07 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2256: - Status: Patch Available (was: Open) > Better error message in CLI on invalid column n

Review Request: HIVE-2256: Better error message in CLI on invalid column name

2011-07-07 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/1031/ --- Review request for hive. Summary --- In the CLI, if a user inputs an incorr

[jira] [Updated] (HIVE-2256) Better error message in CLI on invalid column name

2011-07-05 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2256: - Attachment: HIVE-2256.2.patch -Updated the outputs for unit tests. -Fixed the error message to include

[jira] [Assigned] (HIVE-2256) Better error message in CLI on invalid column name

2011-07-05 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain reassigned HIVE-2256: Assignee: Sohan Jain > Better error message in CLI on invalid column n

[jira] [Updated] (HIVE-2256) Better error message in CLI on invalid column name

2011-07-05 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2256: - Attachment: HIVE-2256.1.patch The patch will probably need to edit test cases as well to account for the

[jira] [Created] (HIVE-2256) Better error message in CLI on invalid column name

2011-07-05 Thread Sohan Jain (JIRA)
Processor Reporter: Sohan Jain In the CLI, if a user inputs an incorrect column name, we currently just print the bad column name in the query. Typically, the user needs to "describe" the table to figure out the correct column. This patch prints out a list of valid

Re: Review Request: HIVE-2226: Add API to metastore for table filtering based on table properties

2011-06-30 Thread Sohan Jain
Will do - Sohan --- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/910/#review928 --- On 2011-06-20 21:04:45, Sohan Jain wrote: > >

Review Request: HIVE-2246: Dedupe tables' column schemas from partitions in the metastore db

2011-06-30 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/985/ --- Review request for hive. Summary --- We can re-organize the JDO models to re

[jira] [Created] (HIVE-2246) Dedupe tables' column schemas from partitions in the metastore db

2011-06-30 Thread Sohan Jain (JIRA)
ement Components: Metastore Reporter: Sohan Jain Assignee: Sohan Jain We can re-organize the JDO models to reduce space usage to keep the metastore scalable for the future. Currently, partitions are the fastest growing objects in the metastore, and the metastore

Re: Review Request: HIVE-2194: Add actions to MetaStoreEventListener to be performed on alter table and alter partition operations.

2011-06-29 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/853/ --- (Updated 2011-06-29 20:48:43.096053) Review request for hive and Paul Yang. Cha

Re: Review Request: HIVE-2194: Add actions to MetaStoreEventListener to be performed on alter table and alter partition operations.

2011-06-29 Thread Sohan Jain
ut all of it's fields are set to null. This discrepancy comes from how we get the tables, but I think they should still be considered equal. - Sohan --- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/853/#review920 ---

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

2011-06-29 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2242: - Status: Patch Available (was: Open) > DDL Semantic Analyzer does not pass partial specificat

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

2011-06-29 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2242: - Attachment: HIVE-2242.1.patch - use db.getPartitions instead of db.getPartition to accommodate partial

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

2011-06-27 Thread Sohan Jain (JIRA)
://issues.apache.org/jira/browse/HIVE-2242 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Sohan Jain Assignee: Sohan Jain Currently, when dropping partitions, the DDL Semantic Analyzer only passes partitions that have a full

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

2011-06-27 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2242: - Description: Currently, when dropping partitions, the DDL Semantic Analyzer only passes partitions that

Review Request: HIVE-2219: Improve efficiency of dropping multiple partitions

2011-06-21 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/941/ --- Review request for hive and Paul Yang. Summary --- Improve the efficiency of

[jira] [Updated] (HIVE-2194) Add actions for alter table and alter partition events for metastore event listeners

2011-06-21 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2194?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2194: - Attachment: HIVE-2194.3.patch > Add actions for alter table and alter partition events for metast

Re: Review Request: HIVE-2194: Add actions to MetaStoreEventListener to be performed on alter table and alter partition operations.

2011-06-21 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/853/ --- (Updated 2011-06-21 20:25:04.600512) Review request for hive and Paul Yang. Cha

Re: Review Request: HIVE-2226: Add API to metastore for table filtering based on table properties

2011-06-20 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/910/ --- (Updated 2011-06-20 21:04:45.477266) Review request for hive and Paul Yang. Cha

[jira] [Commented] (HIVE-2213) Optimize get_partition_names_ps()

2011-06-17 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2213?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13051333#comment-13051333 ] Sohan Jain commented on HIVE-2213: -- I'd also like to point one more thing

Re: Review Request: HIVE-2213: Optimize get_partition_names_ps()

2011-06-17 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/878/ --- (Updated 2011-06-17 21:22:00.028428) Review request for hive and Paul Yang. Cha

[jira] [Commented] (HIVE-2219) Make "alter table drop partition" more efficient

2011-06-16 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2219?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13050874#comment-13050874 ] Sohan Jain commented on HIVE-2219: -- Ah sorry, after another round of testing, I real

[jira] [Updated] (HIVE-2219) Make "alter table drop partition" more efficient

2011-06-16 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2219: - Status: Open (was: Patch Available) > Make "alter table drop partition" m

Re: Review Request: HIVE-2261: Add API to metastore for table filtering based on table properties

2011-06-16 Thread Sohan Jain
an equality throws the same error as the one described in JDO-174. Trying to cast the result of map.get() to a String with ((String) this.parameters.get("keyName") > "value" throws the following seemingly unresolvable error: org.datanucleus.store.exceptions.NoTableManage

[jira] [Updated] (HIVE-2213) Optimize get_partition_names_ps()

2011-06-16 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2213: - Status: Patch Available (was: Open) > Optimize get_partition_names

[jira] [Updated] (HIVE-2213) Optimize get_partition_names_ps()

2011-06-16 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2213: - Attachment: HIVE-2213.3.patch -Fixed line that exceeded 100 chars > Optimize get_partition_names

Re: Review Request: HIVE-2213: Optimize get_partition_names_ps()

2011-06-16 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/878/ --- (Updated 2011-06-16 23:30:02.425588) Review request for hive and Paul Yang. Cha

Review Request: HIVE-2261: Add API to metastore for table filtering based on table properties

2011-06-15 Thread Sohan Jain
--- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/910/ --- Review request for hive and Paul Yang. Summary --- Create a function listTab

[jira] [Updated] (HIVE-2226) Add API to retrieve table names by an arbitrary filter, e.g., by owner, retention, parameters, etc.

2011-06-15 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2226?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2226: - Status: Patch Available (was: Open) > Add API to retrieve table names by an arbitrary filter, e.g.,

[jira] [Updated] (HIVE-2226) Add API to retrieve table names by an arbitrary filter, e.g., by owner, retention, parameters, etc.

2011-06-15 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2226?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2226: - Attachment: HIVE-2226.1.patch > Add API to retrieve table names by an arbitrary filter, e.g., by ow

[jira] [Created] (HIVE-2226) Add API to retrieve table names by an arbitrary filter, e.g., by owner, retention, parameters, etc.

2011-06-15 Thread Sohan Jain (JIRA)
-2226 Project: Hive Issue Type: Improvement Components: Metastore Reporter: Sohan Jain Assignee: Sohan Jain Create a function called get_table_names_by_filter that returns a list of table names in a database that match a certain filter

[jira] [Updated] (HIVE-2219) Make "alter table drop partition" more efficient

2011-06-14 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2219: - Attachment: HIVE-2219.1.patch Improves the time it takes to check whether a partition to delete exists in

[jira] [Updated] (HIVE-2219) Make "alter table drop partition" more efficient

2011-06-14 Thread Sohan Jain (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-2219?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sohan Jain updated HIVE-2219: - Status: Patch Available (was: Open) > Make "alter table drop partition" m

[jira] [Created] (HIVE-2219) Make "alter table drop partition" more efficient

2011-06-14 Thread Sohan Jain (JIRA)
nts: Query Processor Reporter: Sohan Jain The current function dropTable() that handles dropping multiple partitions is somewhat inefficient. For each partition you want to drop, it loops through each partition in the table to see if the partition exists. This is an _O(mn)_ operation, wh

  1   2   >