[jira] Updated: (HIVE-516) Enable predicate pushdown

2009-06-23 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-516: --- Description: Enable predicate pushdown by default. (was: Enable predicate pushdown for junit tests by

[jira] Updated: (HIVE-516) Enable predicate pushdown for junit tests

2009-06-23 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-516: --- Attachment: hive-516.3.patch here is the latest patch for enabling partition pruning in hive

[jira] Created: (HIVE-571) add ability to rename a column.

2009-06-22 Thread Prasad Chakka (JIRA)
Reporter: Prasad Chakka Fix For: 0.4.0 currently only way to rename a column is to use 'REPLACE COLUMNS' which can be cumbersome if the table has lots of columns. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to

[jira] Commented: (HIVE-417) Implement Indexing in Hive

2009-06-22 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12722773#action_12722773 ] Prasad Chakka commented on HIVE-417: Schubert, We can run another map-reduce job

[jira] Commented: (HIVE-480) allow option to retry map-reduce tasks

2009-06-12 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12718928#action_12718928 ] Prasad Chakka commented on HIVE-480: if all queries go through Hive Server, it

[jira] Created: (HIVE-558) describe extended table/partition output is cryptic

2009-06-12 Thread Prasad Chakka (JIRA)
: Metastore Reporter: Prasad Chakka Fix For: 0.4.0 describe extended table prints out the Thrift metadata object directly. The information from it is not easy to read or parse. Output should be easily read and can be simple parsed to get table location etc by programs

[jira] Commented: (HIVE-470) Support COALESCE using GenericUDF

2009-06-11 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12718557#action_12718557 ] Prasad Chakka commented on HIVE-470: I don't see the new test case for COAL

[jira] Commented: (HIVE-527) Inserting into a partitioned table without specifying the partition field should fail

2009-06-11 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-527?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12718331#action_12718331 ] Prasad Chakka commented on HIVE-527: yeah, it should fail as well. > Inserting

[jira] Updated: (HIVE-544) predicate pushdown is not handling exprFieldNodeDesc correctly

2009-06-04 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-544?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-544: --- Status: Patch Available (was: Open) > predicate pushdown is not handling exprFieldNodeDesc correc

[jira] Updated: (HIVE-544) predicate pushdown is not handling exprFieldNodeDesc correctly

2009-06-04 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-544?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-544: --- Attachment: hive-544.patch > predicate pushdown is not handling exprFieldNodeDesc correc

[jira] Created: (HIVE-544) predicate pushdown is not handling exprFieldNodeDesc correctly

2009-06-04 Thread Prasad Chakka (JIRA)
Components: Query Processor Affects Versions: 0.4.0 Reporter: Prasad Chakka Fix For: 0.4.0 complex column fields are not handled correctly resulting in ClassCastException. -- This message is automatically generated by JIRA. - You can reply to this email to add a

[jira] Updated: (HIVE-516) Enable predicate pushdown for junit tests

2009-06-04 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-516: --- Attachment: hive-516.2.patch this one is from base dir. sorry about that. > Enable predicate pushd

[jira] Updated: (HIVE-516) Enable predicate pushdown for junit tests

2009-06-04 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-516: --- Attachment: hive-516.patch > Enable predicate pushdown for junit te

[jira] Updated: (HIVE-443) Remove deprecated functions from Hive.java

2009-06-04 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-443: --- Resolution: Fixed Status: Resolved (was: Patch Available) Committed by Ashish. > Rem

[jira] Commented: (HIVE-470) Support COALESCE using GenericUDF

2009-06-03 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12716125#action_12716125 ] Prasad Chakka commented on HIVE-470: also might want to remove @override tags which

[jira] Commented: (HIVE-470) Support COALESCE using GenericUDF

2009-06-03 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12716123#action_12716123 ] Prasad Chakka commented on HIVE-470: i don't see a test for all NULL args for

[jira] Commented: (HIVE-540) Restore the test.silent setting

2009-06-03 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-540?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12716122#action_12716122 ] Prasad Chakka commented on HIVE-540: oh.. ok, i will stop my tests then :) >

[jira] Created: (HIVE-539) Support range bucketing of hive tables/partitions

2009-06-03 Thread Prasad Chakka (JIRA)
: Metastore, Query Processor Affects Versions: 0.4.0 Reporter: Prasad Chakka Hive uses hash partitioner to distribute keys to reducers and thus creating hash bucketed tables/partitions. There are some cases where range partitioning will help in further query processing such as joins

[jira] Created: (HIVE-536) make all CLI commands go through parser.

2009-06-02 Thread Prasad Chakka (JIRA)
Affects Versions: 0.4.0 Reporter: Prasad Chakka currently lot of commands do not go through parser framework resulting in weird bugs/behavior from cli. couple of examples-- 1) comments can't be in side a query 2) having set after a comment line throws up errors things will be simpl

[jira] Updated: (HIVE-533) predicate clauses with rand() should not be pushed down

2009-06-02 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-533?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-533: --- Attachment: hive-533.patch > predicate clauses with rand() should not be pushed d

[jira] Updated: (HIVE-533) predicate clauses with rand() should not be pushed down

2009-06-02 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-533?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-533: --- Fix Version/s: 0.4.0 Status: Patch Available (was: Open) > predicate clauses with r

[jira] Commented: (HIVE-533) predicate clauses with rand() should not be pushed down

2009-06-02 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-533?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12715708#action_12715708 ] Prasad Chakka commented on HIVE-533: we didn't push rand() but we pushed

[jira] Updated: (HIVE-532) predicate clause with limit should not be pushed down.

2009-06-02 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-532: --- Status: Patch Available (was: Open) > predicate clause with limit should not be pushed d

[jira] Updated: (HIVE-532) predicate clause with limit should not be pushed down.

2009-06-02 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-532: --- Attachment: hive-532.patch made limit operator similar to that of script operator. predicates are not

[jira] Commented: (HIVE-460) Improve ColumnPruner to prune more aggressively and keep column information for input tables

2009-06-02 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12715667#action_12715667 ] Prasad Chakka commented on HIVE-460: then why not use 'a+b' for displa

[jira] Created: (HIVE-533) predicate clauses with rand() should not be pushed down

2009-06-02 Thread Prasad Chakka (JIRA)
: Query Processor Affects Versions: 0.4.0 Reporter: Prasad Chakka Assignee: Prasad Chakka in the following query, all predicates except the rand() is pushed down where in rand() is applied after filter which should not be the case. select a.* from srcpart a where rand(1

[jira] Created: (HIVE-532) predicate clause with limit should not be pushed down.

2009-06-02 Thread Prasad Chakka (JIRA)
Processor Affects Versions: 0.4.0 Reporter: Prasad Chakka Assignee: Prasad Chakka Fix For: 0.4.0 in queries like below , 'v.c2 > 20' shouldn't be pushed up. select * from (select * from t where t.c > 20 limit 20) v where v.c2 > 20

[jira] Updated: (HIVE-443) Remove deprecated functions from Hive.java

2009-06-01 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-443: --- Attachment: hive-443.2.patch here it is > Remove deprecated functions from Hive.j

[jira] Commented: (HIVE-460) Improve ColumnPruner to prune more aggressively and keep column information for input tables

2009-05-30 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12714813#action_12714813 ] Prasad Chakka commented on HIVE-460: Can't names be quoted like 'a

[jira] Updated: (HIVE-525) Hive on Eclipse is broken

2009-05-30 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-525: --- Status: Patch Available (was: Open) > Hive on Eclipse is bro

[jira] Updated: (HIVE-525) Hive on Eclipse is broken

2009-05-30 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-525: --- Attachment: hive-525.patch > Hive on Eclipse is bro

[jira] Created: (HIVE-525) Hive on Eclipse is broken

2009-05-30 Thread Prasad Chakka (JIRA)
Reporter: Prasad Chakka Assignee: Prasad Chakka Fix For: 0.4.0 Recent addition of MiniMRCluster broken Eclipse setup -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.

[jira] Updated: (HIVE-443) Remove deprecated functions from Hive.java

2009-05-30 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-443: --- Status: Patch Available (was: Open) > Remove deprecated functions from Hive.j

[jira] Updated: (HIVE-443) Remove deprecated functions from Hive.java

2009-05-30 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-443: --- Attachment: hive-443.patch > Remove deprecated functions from Hive.j

[jira] Updated: (HIVE-497) predicate pushdown fails if all columns are not selected

2009-05-30 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-497?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-497: --- Resolution: Fixed Hadoop Flags: [Reviewed] Status: Resolved (was: Patch Available

[jira] Updated: (HIVE-516) Enable predicate pushdown for junit tests

2009-05-30 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-516: --- Status: Patch Available (was: Open) > Enable predicate pushdown for junit te

[jira] Updated: (HIVE-516) Enable predicate pushdown for junit tests

2009-05-30 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-516: --- Attachment: hive-516.patch two tests that are interesting ql/src/test/results/clientpositive/order2

[jira] Commented: (HIVE-417) Implement Indexing in Hive

2009-05-28 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12714306#action_12714306 ] Prasad Chakka commented on HIVE-417: the plan looks good. i am not sure we nee

[jira] Updated: (HIVE-523) FIx PartitionPruner not to fetch all partitions at once

2009-05-28 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-523?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-523: --- Attachment: hive-523.2.patch there was a problem with test where output partitions are listed in

[jira] Updated: (HIVE-523) FIx PartitionPruner not to fetch all partitions at once

2009-05-28 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-523?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-523: --- Status: Patch Available (was: Open) running tests... > FIx PartitionPruner not to fetch

[jira] Updated: (HIVE-523) FIx PartitionPruner not to fetch all partitions at once

2009-05-28 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-523?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-523: --- Attachment: hive-523.patch Instead of fetching all the partition objects, fetch only partition names

[jira] Created: (HIVE-523) FIx PartitionPruner not to fetch all partitions at once

2009-05-28 Thread Prasad Chakka (JIRA)
: Metastore, Query Processor Affects Versions: 0.4.0 Reporter: Prasad Chakka Assignee: Prasad Chakka Fix For: 0.4.0 All partitions are fetched at once causing metastore to go OutOfMemory. -- This message is automatically generated by JIRA. - You can reply to

[jira] Commented: (HIVE-509) Support CREATE TABLE a LIKE b

2009-05-28 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-509?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12714050#action_12714050 ] Prasad Chakka commented on HIVE-509: EXTERNAL should default to that of the like t

[jira] Commented: (HIVE-489) compiler should check for validity of output paths before job submission

2009-05-26 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12713345#action_12713345 ] Prasad Chakka commented on HIVE-489: yeah, i didn't realize 489 was for direct

[jira] Commented: (HIVE-489) compiler should check for validity of output paths before job submission

2009-05-26 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12713115#action_12713115 ] Prasad Chakka commented on HIVE-489: 488 only creates parent directory before moving

[jira] Updated: (HIVE-488) loading into a partition with more than one partition column fails if the partition is not created before.

2009-05-26 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-488: --- Resolution: Fixed Fix Version/s: 0.4.0 Hadoop Flags: [Reviewed] Status: Resolved

[jira] Created: (HIVE-516) Enable predicate pushdown for junit tests

2009-05-25 Thread Prasad Chakka (JIRA)
Affects Versions: 0.4.0 Reporter: Prasad Chakka Assignee: Prasad Chakka Fix For: 0.4.0 Enable predicate pushdown for junit tests by default. this is first step in making predicate pushdown as default option in the next release. -- This message is automatically

[jira] Updated: (HIVE-514) partition key names should be case insensitive in alter table add partition statement.

2009-05-25 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-514?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-514: --- Release Note: This fix makes partition keys to be case insensitive and partition key values to be case

[jira] Updated: (HIVE-514) partition key names should be case insensitive in alter table add partition statement.

2009-05-25 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-514?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-514: --- Attachment: hive-514.2.patch added more tests to check that partition key names are case insensitive

[jira] Updated: (HIVE-514) partition key names should be case insensitive in alter table add partition statement.

2009-05-24 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-514?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-514: --- Assignee: Prasad Chakka Status: Patch Available (was: Open) > partition key names should

[jira] Updated: (HIVE-514) partition key names should be case insensitive in alter table add partition statement.

2009-05-24 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-514?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-514: --- Attachment: hive-514.patch fixed not lowercasing the partition key names in couple of places. added a

[jira] Commented: (HIVE-514) partition key names should be case insensitive in alter table add partition statement.

2009-05-24 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-514?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12712638#action_12712638 ] Prasad Chakka commented on HIVE-514: the second stmt above silently inserts '

[jira] Created: (HIVE-514) partition key names should be case insensitive in alter table add partition statement.

2009-05-24 Thread Prasad Chakka (JIRA)
: Hadoop Hive Issue Type: Bug Components: Metastore Affects Versions: 0.4.0 Reporter: Prasad Chakka Fix For: 0.4.0 create table testpc(a int) partitioned by (ds string, hr string); alter table testpc add partition (ds="1", hr="1&quo

[jira] Updated: (HIVE-417) Implement Indexing in Hive

2009-05-22 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-417: --- Attachment: hive-417.proto.patch patch built from hive prototype code. it compiles with hive code but

[jira] Commented: (HIVE-505) console.info should print to stderr

2009-05-21 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-505?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12711900#action_12711900 ] Prasad Chakka commented on HIVE-505: same as HIVE-484? > console.info should p

[jira] Updated: (HIVE-501) UDFLower is doing uppercase instead of lowercase

2009-05-20 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-501: --- Resolution: Fixed Fix Version/s: 0.4.0 Hadoop Flags: [Reviewed] Status: Resolved

[jira] Commented: (HIVE-501) UDFLower is doing uppercase instead of lowercase

2009-05-20 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12711450#action_12711450 ] Prasad Chakka commented on HIVE-501: running tests > UDFLower is doing up

[jira] Updated: (HIVE-497) predicate pushdown fails if all columns are not selected

2009-05-20 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-497?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-497: --- Attachment: hive-497.3.patch ok, another attempt. *sigh* > predicate pushdown fails if all colu

[jira] Commented: (HIVE-497) predicate pushdown fails if all columns are not selected

2009-05-20 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-497?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12711376#action_12711376 ] Prasad Chakka commented on HIVE-497: yes, we should turn on ppd. let's

[jira] Updated: (HIVE-497) predicate pushdown fails if all columns are not selected

2009-05-20 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-497?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-497: --- Attachment: hive-497.2.patch i forgot to update the ppd1.q.out file. attached is the updated version

[jira] Updated: (HIVE-498) UDFRegExp NullPointerException on empty replacement string

2009-05-20 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-498?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-498: --- Comment: was deleted (was: isn't the check 'p == null' redundant since p is set

[jira] Commented: (HIVE-498) UDFRegExp NullPointerException on empty replacement string

2009-05-20 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-498?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12711298#action_12711298 ] Prasad Chakka commented on HIVE-498: isn't the check 'p == null' r

[jira] Commented: (HIVE-497) predicate pushdown fails if all columns are not selected

2009-05-20 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-497?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12711246#action_12711246 ] Prasad Chakka commented on HIVE-497: actually "0" here is not a number bu

[jira] Resolved: (HIVE-496) UDFDate fails on null

2009-05-19 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka resolved HIVE-496. Resolution: Fixed Fix Version/s: 0.4.0 Hadoop Flags: [Reviewed] Thanks Zheng! > UDFD

[jira] Commented: (HIVE-496) UDFDate fails on null

2009-05-19 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-496?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12710983#action_12710983 ] Prasad Chakka commented on HIVE-496: looks good. running tests. > UDFDate fails

[jira] Commented: (HIVE-496) UDFDate fails on null

2009-05-19 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-496?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12710975#action_12710975 ] Prasad Chakka commented on HIVE-496: UDFDateAdd and UDFDateDiff also can throw sim

[jira] Updated: (HIVE-497) predicate pushdown fails if all columns are not selected

2009-05-19 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-497?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-497: --- Attachment: hive-497.patch > predicate pushdown fails if all columns are not selec

[jira] Updated: (HIVE-497) predicate pushdown fails if all columns are not selected

2009-05-19 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-497?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-497: --- Assignee: Prasad Chakka Status: Patch Available (was: Open) The select operator created by

[jira] Commented: (HIVE-497) predicate pushdown fails if all columns are not selected

2009-05-19 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-497?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12710950#action_12710950 ] Prasad Chakka commented on HIVE-497: I think the problem only happens if ColumPr

Re: Unknown exception:null on Predicate push down.

2009-05-19 Thread Prasad Chakka
, col30 string) STORED AS RCFILE; On 09-5-20 上午3:32, "Prasad Chakka" wrote: > There is a similar unit test ppd_join1.q but I suspect it is something todo > with schema. Please send in schema for tables in the join. > > > > From: Yongqiang

[jira] Created: (HIVE-497) predicate pushdown fails if all columns are not selected

2009-05-19 Thread Prasad Chakka (JIRA)
: Query Processor Affects Versions: 0.4.0 Reporter: Prasad Chakka Fix For: 0.4.0 predicate pushdown seems to fail in some scenarios... it is ok if all the columns are selected. create table ppda(a string, b string); select a from ppda where ppda.a > 10; --> fails

Re: Unknown exception:null on Predicate push down.

2009-05-19 Thread Prasad Chakka
There is a similar unit test ppd_join1.q but I suspect it is something todo with schema. Please send in schema for tables in the join. From: Yongqiang He Reply-To: Date: Tue, 19 May 2009 11:37:24 -0700 To: Subject: Unknown exception:null on Predicate push down

[jira] Commented: (HIVE-417) Implement Indexing in Hive

2009-05-19 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12710741#action_12710741 ] Prasad Chakka commented on HIVE-417: Yes, mostly the block/pos size will be small b

[jira] Commented: (HIVE-442) Partition is created before data is moved thus creating a window where data is incomplete

2009-05-18 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-442?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12710556#action_12710556 ] Prasad Chakka commented on HIVE-442: it merges for me with some offsets and comp

[jira] Updated: (HIVE-486) concurrent modification exception in case of empty partitions

2009-05-18 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-486?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-486: --- Resolution: Fixed Fix Version/s: 0.4.0 Status: Resolved (was: Patch Available

[jira] Updated: (HIVE-488) loading into a partition with more than one partition column fails if the partition is not created before.

2009-05-18 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-488: --- Status: Patch Available (was: Open) > loading into a partition with more than one partition col

[jira] Commented: (HIVE-417) Implement Indexing in Hive

2009-05-18 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12710494#action_12710494 ] Prasad Chakka commented on HIVE-417: The above index is not a hash index since you c

[jira] Updated: (HIVE-493) automatically infer existing partitions of table from HDFS files.

2009-05-17 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-493: --- Description: Initially partition list for a table is inferred from HDFS directory structure instead

[jira] Created: (HIVE-493) automatically infer existing partitions of table from HDFS files.

2009-05-17 Thread Prasad Chakka (JIRA)
Feature Components: Metastore, Query Processor Affects Versions: 0.3.0, 0.3.1, 0.4.0 Reporter: Prasad Chakka Initially partition list for a table is inferred from HDFS directory structure instead of looking into metastore where partitions are created using 'alter

[jira] Resolved: (HIVE-491) Comments and ALTER TABLE

2009-05-17 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka resolved HIVE-491. Resolution: Fixed Assignee: Prasad Chakka Actually adding comments is allowed under a

[jira] Commented: (HIVE-417) Implement Indexing in Hive

2009-05-17 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12710204#action_12710204 ] Prasad Chakka commented on HIVE-417: 1) The question you raised applies only to B+

[jira] Commented: (HIVE-489) compiler should check for validity of output paths before job submission

2009-05-16 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12710172#action_12710172 ] Prasad Chakka commented on HIVE-489: shouldn't matter. both queries use

[jira] Commented: (HIVE-489) compiler should check for validity of output paths before job submission

2009-05-16 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12710168#action_12710168 ] Prasad Chakka commented on HIVE-489: HIVE-488 should fix the issue of not creating

[jira] Updated: (HIVE-417) Implement Indexing in Hive

2009-05-15 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-417: --- Assignee: He Yongqiang Thanks Yongqiang! > Implement Indexing in H

[jira] Commented: (HIVE-417) Implement Indexing in Hive

2009-05-15 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12709899#action_12709899 ] Prasad Chakka commented on HIVE-417: Here is a very rough outline as how this ca

[jira] Commented: (HIVE-467) Scratch data location should be on different filesystems for different types of intermediate data

2009-05-15 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-467?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12709859#action_12709859 ] Prasad Chakka commented on HIVE-467: > with the current code path - we can f

[jira] Commented: (HIVE-467) Scratch data location should be on different filesystems for different types of intermediate data

2009-05-13 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-467?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12709261#action_12709261 ] Prasad Chakka commented on HIVE-467: Good catch about overwriting external partit

[jira] Updated: (HIVE-488) loading into a partition with more than one partition column fails if the partition is not created before.

2009-05-13 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-488: --- Attachment: hive-488.patch if the partition is to be copied to a/b/c and if a/b doesn't

[jira] Updated: (HIVE-488) loading into a partition with more than one partition column fails if the partition is not created before.

2009-05-13 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-488: --- Attachment: hive-488.2.patch added the data file used in the test. > loading into a partition w

[jira] Commented: (HIVE-488) loading into a partition with more than one partition column fails if the partition is not created before.

2009-05-13 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12709224#action_12709224 ] Prasad Chakka commented on HIVE-488: a simple work around is to create the parti

[jira] Created: (HIVE-488) loading into a partition with more than one partition column fails if the partition is not created before.

2009-05-13 Thread Prasad Chakka (JIRA)
/jira/browse/HIVE-488 Project: Hadoop Hive Issue Type: Bug Reporter: Prasad Chakka Assignee: Prasad Chakka Following test fails on HDFS cluster but not on local file system. drop table hive_test_src; drop table hive_test_dst; create table hive_test_src

[jira] Updated: (HIVE-488) loading into a partition with more than one partition column fails if the partition is not created before.

2009-05-13 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-488: --- Component/s: Query Processor Affects Version/s: 0.4.0 > loading into a partition with m

Re: Trunk runtime errors

2009-05-13 Thread Prasad Chakka
inconsistent window. (Prasad Chakka via athusoo) Revision 772012 works fine for me. Essentially the partition directories are created but the data is never copied over. If I run the same job again, the data is copied to the target directory in HDFS. 2nd problem. When I try to do a select count(1) from a

[jira] Updated: (HIVE-483) comments not handled properly in trunk

2009-05-12 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-483: --- Resolution: Fixed Fix Version/s: 0.4.0 Hadoop Flags: [Reviewed] Status: Resolved

[jira] Commented: (HIVE-483) comments not handled properly in trunk

2009-05-12 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12708681#action_12708681 ] Prasad Chakka commented on HIVE-483: There are two failures {code} [junit] dif

[jira] Commented: (HIVE-483) comments not handled properly in trunk

2009-05-12 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12708652#action_12708652 ] Prasad Chakka commented on HIVE-483: i am running tests > comments not handled p

[jira] Updated: (HIVE-476) Add getTable and getPartition calls to the ReadEntity and WriteEntity objects in PreExecute hooks.

2009-05-08 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-476: --- Resolution: Fixed Fix Version/s: 0.4.0 Release Note: table and partition objects are

[jira] Commented: (HIVE-476) Add getTable and getPartition calls to the ReadEntity and WriteEntity objects in PreExecute hooks.

2009-05-07 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-476?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12707098#action_12707098 ] Prasad Chakka commented on HIVE-476: I am getting the following error even though p

[jira] Updated: (HIVE-476) Add getTable and getPartition calls to the ReadEntity and WriteEntity objects in PreExecute hooks.

2009-05-07 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-476: --- Status: Patch Available (was: Open) testing... > Add getTable and getPartition calls to

[jira] Updated: (HIVE-442) Partition is created before data is moved thus creating a window where data is incomplete

2009-05-05 Thread Prasad Chakka (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-442?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Chakka updated HIVE-442: --- Status: Patch Available (was: Open) > Partition is created before data is moved thus creatin

<    1   2   3   4   5   6   >