[jira] Updated: (HIVE-675) add database/scheme support Hive QL

2009-09-19 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-675?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-675: -- Attachment: hive-675-2009-9-19.patch A new patch integrates Namit's comments (Thanks Namit!). 1. No

[jira] Commented: (HIVE-819) Add lazy decompress ability to RCFile

2009-09-17 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-819?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12756881#action_12756881 ] He Yongqiang commented on HIVE-819: --- Can you briefly summarize the current approach of how

[jira] Commented: (HIVE-675) add database/scheme support Hive QL

2009-09-15 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12755384#action_12755384 ] He Yongqiang commented on HIVE-675: --- There are two classes SessionState refers may block

[jira] Updated: (HIVE-675) add database/scheme support Hive QL

2009-09-15 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-675?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-675: -- Attachment: hive-675-2009-9-16.patch hive-675-2009-9-16.patch does not move SessionState from ql to

[jira] Updated: (HIVE-819) Add lazy decompress ability to RCFile

2009-09-12 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-819?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-819: -- Attachment: hive-819-2009-9-12.patch A draft version adding a call back to do lazy decompression. Need

[jira] Commented: (HIVE-819) Add lazy decompress ability to RCFile

2009-09-12 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-819?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12754659#action_12754659 ] He Yongqiang commented on HIVE-819: --- It turns out that changing the filter condition from 9

[jira] Updated: (HIVE-584) Clean up global and ThreadLocal variables in Hive

2009-09-10 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-584?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-584: -- Attachment: hive-584-2009-9-10.patch Attach a fix with appoach A. Clean up global and ThreadLocal

[jira] Commented: (HIVE-675) add database/scheme support Hive QL

2009-09-10 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12753520#action_12753520 ] He Yongqiang commented on HIVE-675: --- Talked offline with Zheng, will upload a new fix when

[jira] Commented: (HIVE-675) add database/scheme support Hive QL

2009-09-10 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12753897#action_12753897 ] He Yongqiang commented on HIVE-675: --- if approach A for HIVE-584 is chosen then shouldn't

[jira] Updated: (HIVE-584) Clean up global and ThreadLocal variables in Hive

2009-09-10 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-584?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-584: -- Attachment: hive-584-2009-9-11.patch Integrate Zheng's comments. Thanks, Zheng. Clean up global and

[jira] Updated: (HIVE-796) RCFile results missing columns from UNION ALL

2009-09-09 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-796: -- Attachment: hive-796-2009-9-9.patch Added a testcase. Thanks Zheng! RCFile results missing columns

[jira] Updated: (HIVE-667) Provide hive ql to check table/partition status, including size, creation and access timestamp

2009-09-09 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-667: -- Attachment: HIVE-667-2009-9-9.patch regenerated the patch. Provide hive ql to check table/partition

[jira] Commented: (HIVE-675) add database/scheme support Hive QL

2009-09-09 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12753245#action_12753245 ] He Yongqiang commented on HIVE-675: --- is hive always used with a SessionState? I think hive

[jira] Commented: (HIVE-675) add database/scheme support Hive QL

2009-09-09 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12753396#action_12753396 ] He Yongqiang commented on HIVE-675: --- Assuming Hive is an inner field of SessionState, we

[jira] Updated: (HIVE-675) add database/scheme support Hive QL

2009-09-08 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-675?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-675: -- Attachment: hive-675-2009-9-8.patch Thanks for the detailed comments, Prasad! bq. 1) more test

[jira] Commented: (HIVE-675) add database/scheme support Hive QL

2009-09-08 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12752888#action_12752888 ] He Yongqiang commented on HIVE-675: --- i thought all Hive.java functions that do not take

[jira] Commented: (HIVE-675) add database/scheme support Hive QL

2009-09-08 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12752891#action_12752891 ] He Yongqiang commented on HIVE-675: --- MetaStoreUtils.DEFAULT_DATABASE_NAME is sometimes

[jira] Created: (HIVE-819) Add lazy decompress ability to RCFile

2009-09-08 Thread He Yongqiang (JIRA)
Add lazy decompress ability to RCFile - Key: HIVE-819 URL: https://issues.apache.org/jira/browse/HIVE-819 Project: Hadoop Hive Issue Type: Improvement Components: Query Processor,

[jira] Commented: (HIVE-675) add database/scheme support Hive QL

2009-09-08 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-675?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12752904#action_12752904 ] He Yongqiang commented on HIVE-675: --- Prasad, when i am looking into deprecating methods in

[jira] Updated: (HIVE-675) add database/scheme support Hive QL

2009-09-07 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-675?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-675: -- Attachment: hive-675-2009-9-7.patch Added three new commands: 1) USE db_name to switch among existing

[jira] Updated: (HIVE-667) Provide hive ql to check table/partition status, including size, creation and access timestamp

2009-08-27 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-667: -- Attachment: hive-667-2009-08-27.patch sorry, there is not a 0.17 cluster around to allow me to access,

[jira] Updated: (HIVE-779) CREATE TYPE and use the TYPE in CREATE TABLE

2009-08-27 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-779: -- Attachment: hive-779-2009-08-27.patch patch a new file against truck, and refine the testcase according

[jira] Updated: (HIVE-667) Provide hive ql to check table/partition status, including size, creation and access timestamp

2009-08-25 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-667: -- Attachment: hive-667-2009-08-25.patch hive-667-2009-08-25.patch moved getAccessTime to HadoopShims.

[jira] Commented: (HIVE-777) CREATE TABLE with STRUCT type

2009-08-25 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12747413#action_12747413 ] He Yongqiang commented on HIVE-777: --- I just realized that in this case 'null' is correct.

[jira] Updated: (HIVE-792) support add archive in addition to add files and add jars

2009-08-25 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-792?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-792: -- Attachment: hive-792-2009-08-25.patch support add archive in addition to add files and add jars

[jira] Commented: (HIVE-790) race condition related to ScriptOperator + UnionOperator

2009-08-25 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-790?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12747455#action_12747455 ] He Yongqiang commented on HIVE-790: --- This query can not be compiled with the truck code.

[jira] Updated: (HIVE-796) RCFile results missing columns from UNION ALL

2009-08-25 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-796: -- Attachment: hive-796-2009-08-26.patch This is a bug in HiveInputFormat when setting read column ids.

[jira] Updated: (HIVE-792) support add archive in addition to add files and add jars

2009-08-25 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-792?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-792: -- Attachment: hive-792-2009-08-26.patch hive-792-2009-08-26.patch integrates Zheng's comments(Thanks

[jira] Commented: (HIVE-790) race condition related to ScriptOperator + UnionOperator

2009-08-25 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-790?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12747743#action_12747743 ] He Yongqiang commented on HIVE-790: --- Hi Ning, i uploaded a patch for hive-796. That is a

[jira] Commented: (HIVE-792) support add archive in addition to add files and add jars

2009-08-25 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12747746#action_12747746 ] He Yongqiang commented on HIVE-792: --- I think it is line 36 of AddResourceProcessor: if

[jira] Updated: (HIVE-777) CREATE TABLE with STRUCT type

2009-08-21 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-777: -- Attachment: hive-777-2009-8-21-2.patch hive-777-2009-8-21-2.patch integrates offline talk with Zheng.

[jira] Created: (HIVE-781) Integrate Zebra with Hive

2009-08-21 Thread He Yongqiang (JIRA)
Integrate Zebra with Hive - Key: HIVE-781 URL: https://issues.apache.org/jira/browse/HIVE-781 Project: Hadoop Hive Issue Type: New Feature Reporter: He Yongqiang This is raised for my research. --

[jira] Updated: (HIVE-779) CREATE TYPE and use the TYPE in CREATE TABLE

2009-08-21 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-779: -- Attachment: hive-779-2009-08-21.patch CREATE TYPE and use the TYPE in CREATE TABLE

[jira] Updated: (HIVE-777) CREATE TABLE with STRUCT type

2009-08-20 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-777: -- Attachment: hive-777-2009-8-29.patch struct table example: create table abc(strct structa int, b

[jira] Commented: (HIVE-777) CREATE TABLE with STRUCT type

2009-08-20 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12745768#action_12745768 ] He Yongqiang commented on HIVE-777: --- We can easily support both. User can either use SPACE

[jira] Updated: (HIVE-777) CREATE TABLE with STRUCT type

2009-08-20 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-777: -- Attachment: hive-777-2009-8-21.patch hive-777-2009-8-21.patch supports both SPACE and : as column name

[jira] Commented: (HIVE-773) remove lzocodec import from FileSinkOperator

2009-08-19 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-773?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12744989#action_12744989 ] He Yongqiang commented on HIVE-773: --- Thanks, Johan. Actually it is contributed by Samuel

[jira] Updated: (HIVE-759) add hive.intermediate.compression.codec option

2009-08-18 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-759: -- Attachment: hive-759-2009-08-18-2.patch talked with Zheng offline, and attached a new patch. Use

[jira] Commented: (HIVE-756) performance improvement for RCFile and ColumnarSerDe in Hive

2009-08-18 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12744456#action_12744456 ] He Yongqiang commented on HIVE-756: --- The new patch looks good for me. Remove set(..,

[jira] Commented: (HIVE-756) performance improvement for RCFile and ColumnarSerDe in Hive

2009-08-18 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12744801#action_12744801 ] He Yongqiang commented on HIVE-756: --- 15% - 20% overall query performance is great. Keep it

[jira] Commented: (HIVE-756) performance improvement for RCFile and ColumnarSerDe in Hive

2009-08-17 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12744029#action_12744029 ] He Yongqiang commented on HIVE-756: --- Changes for ColumnarStruct is good. @hive-756.patch:

[jira] Commented: (HIVE-756) performance improvement for RCFile and ColumnarSerDe in Hive

2009-08-17 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-756?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12744035#action_12744035 ] He Yongqiang commented on HIVE-756: --- {noformat} if (!currentValue.inited) {

[jira] Commented: (HIVE-645) A UDF that can export data to JDBC databases.

2009-08-17 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-645?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12744340#action_12744340 ] He Yongqiang commented on HIVE-645: --- Hi Edward, How do you deal with db connections. I saw

[jira] Updated: (HIVE-759) add hive.intermediate.compression.codec option

2009-08-17 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-759: -- Attachment: hive-759-2009-08-18.patch Attached a new patch integrates Zheng's suggestions (Thanks

[jira] Updated: (HIVE-759) add hive.intermediate.compression.codec option

2009-08-16 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-759: -- Attachment: hive-759-2009-08-17.patch Only tested on my mac (lzo not loaded), should test on a Linux

[jira] Commented: (HIVE-705) Let Hive can analyse hbase's tables

2009-08-10 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12741655#action_12741655 ] He Yongqiang commented on HIVE-705: --- Samuel, i am now in ShangHai attending a meeting. I

[jira] Commented: (HIVE-718) Load data inpath into a new partition without overwrite does not move the file

2009-08-05 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-718?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12739352#action_12739352 ] He Yongqiang commented on HIVE-718: --- Todd's patch looks good (at least better than mine).

[jira] Updated: (HIVE-720) Improve ByteStream by removing all synchronized method calls

2009-08-05 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-720: -- Attachment: HIVE-720.2.patch Improve ByteStream by removing all synchronized method calls

[jira] Commented: (HIVE-720) Improve ByteStream by removing all synchronized method calls

2009-08-04 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-720?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12738919#action_12738919 ] He Yongqiang commented on HIVE-720: --- Hive has its own HiveDataInputBuffer and

[jira] Updated: (HIVE-718) Load data inpath into a new partition without overwrite does not move the file

2009-08-04 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-718?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-718: -- Attachment: HIVE-718.2.patch the patch that passed tests in my local. Added the code to undo the copy

[jira] Updated: (HIVE-720) Improve ByteStream by removing all synchronized method calls

2009-08-04 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-720: -- Attachment: HIVE-720.1.patch HIVE-720.1.patch tries to reuse some io code. It passed tests in my local.

[jira] Updated: (HIVE-718) Load data inpath into a new partition without overwrite does not move the file

2009-08-03 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-718?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-718: -- Attachment: HIVE-718.1.patch patch. I will check and test it late tonight. Load data inpath into a

[jira] Commented: (HIVE-705) Let Hive can analyse hbase's tables

2009-07-29 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12736467#action_12736467 ] He Yongqiang commented on HIVE-705: --- Do we need to add a new serde for this? can you add

[jira] Commented: (HIVE-667) Provide hive ql to check table/partition status, including size, creation and access timestamp

2009-07-29 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12736948#action_12736948 ] He Yongqiang commented on HIVE-667: --- They are the same, only try to compatible with mysql.

[jira] Updated: (HIVE-667) Provide hive ql to check table/partition status, including size, creation and access timestamp

2009-07-28 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-667: -- Attachment: hive-667-2009-07-28.patch Upload another patch according to offline talk with Zheng, the

[jira] Assigned: (HIVE-678) Add support for building index table

2009-07-28 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-678?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang reassigned HIVE-678: - Assignee: He Yongqiang Thanks for the detailed review, Prasad. Will work a new one. Add support

[jira] Commented: (HIVE-667) Provide hive ql to check table/partition status, including size, creation and access timestamp

2009-07-28 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12736377#action_12736377 ] He Yongqiang commented on HIVE-667: --- The patch added two key words: STATUS and IN. Has the

[jira] Commented: (HIVE-667) Provide hive ql to check table/partition status, including size, creation and access timestamp

2009-07-28 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12736411#action_12736411 ] He Yongqiang commented on HIVE-667: --- HIVE-280 is committed and adds the key word IN. So i

[jira] Updated: (HIVE-667) Provide hive ql to check table/partition status, including size, creation and access timestamp

2009-07-28 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-667: -- Attachment: hive-667-2009-07-28-2.patch hive-667-2009-07-28-2.patch changes the command show table

[jira] Updated: (HIVE-667) Provide hive ql to check table/partition status, including size, creation and access timestamp

2009-07-27 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-667: -- Attachment: hive-667-2009-07-27.patch Added a new command SHOW TABLE STATUS [IN|FROM db_name] LIKE

[jira] Commented: (HIVE-667) Provide hive ql to check table/partition status, including size, creation and access timestamp

2009-07-26 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12735462#action_12735462 ] He Yongqiang commented on HIVE-667: --- can you list the information for the new command? bq.

[jira] Updated: (HIVE-667) Provide hive ql to check table/partition status, including size, creation and access timestamp

2009-07-25 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-667: -- Attachment: hive-667-2009-07-25-3.patch Incorporated Zheng and Hao's suggestions. It passed tests in my

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

2009-07-25 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12735271#action_12735271 ] He Yongqiang commented on HIVE-417: --- Created HIVE-678 for add support for building index.

[jira] Updated: (HIVE-678) Add support for building index table

2009-07-25 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-678?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-678: -- Attachment: hive-678-2009-07-25.patch Added three types: projection, summary, compact. Now the create

[jira] Updated: (HIVE-667) Provide hive ql to check table/partition status, including size, creation and access timestamp

2009-07-24 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-667: -- Attachment: localtest-2009-07-24.txt hive-667-2009-07-24.patch does not inclue new

[jira] Updated: (HIVE-667) Provide hive ql to check table/partition status, including size, creation and access timestamp

2009-07-24 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-667: -- Attachment: hive-667-2009-07-25.patch It is easy to indent file system information. But it is not very

[jira] Commented: (HIVE-678) Add support for building index table

2009-07-23 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12734734#action_12734734 ] He Yongqiang commented on HIVE-678: --- We published a document on hive-417 before. And after

[jira] Commented: (HIVE-667) Provide hive ql to check table/partition status, including size, creation and access timestamp

2009-07-23 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12734876#action_12734876 ] He Yongqiang commented on HIVE-667: --- It seems 'describe extended' command does not output

[jira] Commented: (HIVE-667) Provide hive ql to check table/partition status, including size, creation and access timestamp

2009-07-23 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12734881#action_12734881 ] He Yongqiang commented on HIVE-667: --- From the source code, it seems the 'describe extended'

[jira] Commented: (HIVE-667) Provide hive ql to check table/partition status, including size, creation and access timestamp

2009-07-23 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12734899#action_12734899 ] He Yongqiang commented on HIVE-667: --- How about adding the file system info to the output of

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

2009-07-22 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12734405#action_12734405 ] He Yongqiang commented on HIVE-417: --- 1) For a given key, we are using a sorted set for each

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

2009-07-18 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-417: -- Attachment: hive-417-2009-07-18.patch A Draft version of buiding(create/update) index. Still needs: 1)

[jira] Commented: (HIVE-599) Embedded Hive SQL into Python

2009-07-18 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12732907#action_12732907 ] He Yongqiang commented on HIVE-599: --- BaconSnake is a gorgeous feature that hive should also

[jira] Resolved: (HIVE-618) More human-readable error prompt of FunctionTask

2009-07-14 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-618?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang resolved HIVE-618. --- Resolution: Duplicate duplicate of 619. More human-readable error prompt of FunctionTask

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

2009-07-14 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12730833#action_12730833 ] He Yongqiang commented on HIVE-571: --- I would like to let the syntax looks like: alter table

[jira] Updated: (HIVE-580) command to list available UDF names

2009-07-14 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-580: -- Attachment: hive-580-2009-07-15.patch command to list available UDF names

[jira] Updated: (HIVE-580) command to list available UDF names

2009-07-14 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-580: -- Status: Patch Available (was: Open) command to list available UDF names

[jira] Commented: (HIVE-580) command to list available UDF names

2009-07-14 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-580?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12730953#action_12730953 ] He Yongqiang commented on HIVE-580: --- That's good. We should avoid adding all command

[jira] Commented: (HIVE-588) LIMIT n is slower than it needs to be

2009-07-14 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12731253#action_12731253 ] He Yongqiang commented on HIVE-588: --- SELECT a FROM t LIMIT 10; ...simply prints the output

[jira] Commented: (HIVE-588) LIMIT n is slower than it needs to be

2009-07-14 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-588?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12731277#action_12731277 ] He Yongqiang commented on HIVE-588: --- when any mapper has printed 10 rows, Hive should print

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

2009-07-14 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12731284#action_12731284 ] He Yongqiang commented on HIVE-571: --- so the syntax should be: alter table change [column]

[jira] Updated: (HIVE-626) Typecast bug in Join operator

2009-07-13 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-626?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-626: -- Attachment: hive-626-2009-07-13-2.patch Added a new testcase and removed keyinfor and valueinfo from

[jira] Updated: (HIVE-472) HiveFileFormatUtils's checkInputFormat does not include RCFile

2009-06-15 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-472: -- Attachment: hive-472-2009-06-15.patch Update a new patch, which passed tests in my local. The previous

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

2009-06-13 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-460: -- Attachment: hive-460-2009-06-13.patch Namit, Thanks for correction. Upload a new patch. I guess the

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

2009-06-12 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-460: -- Attachment: hive-460-2009-06-12.patch Added the new testcase, but join32 does not get diff in my local.

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

2009-06-11 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-527?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12718329#action_12718329 ] He Yongqiang commented on HIVE-527: --- Then what about the load overwrite data statement?

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

2009-06-11 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12718349#action_12718349 ] He Yongqiang commented on HIVE-460: --- One comment to the results of input20.q: the output

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

2009-06-11 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-527?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-527: -- Attachment: hive-527-2009-06-12.patch hive-527-2009-06-12.patch integrates Namit's suggestions.

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

2009-06-10 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-460: -- Attachment: hive-460-2009-06-10-2.patch A new patch against trunk code(hive-460-2009-06-10-2.patch) and

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

2009-06-09 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12717877#action_12717877 ] He Yongqiang commented on HIVE-460: --- Namit, which patch you applied?

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

2009-06-09 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12717893#action_12717893 ] He Yongqiang commented on HIVE-460: --- When I ran the tests, all TestParse tests failed

[jira] Commented: (HIVE-549) UNION ALL statements should be run in parallel

2009-06-08 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12717189#action_12717189 ] He Yongqiang commented on HIVE-549: --- Will hive consider replace its queue exection with a

[jira] Updated: (HIVE-472) HiveFileFormatUtils's checkInputFormat does not include RCFile

2009-06-08 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-472: -- Attachment: hive-472-2009-06-08.patch 1) added a new interface InputFormatChecker 2) added a new

[jira] Commented: (HIVE-549) UNION ALL statements should be run in parallel

2009-06-08 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12717338#action_12717338 ] He Yongqiang commented on HIVE-549: --- Since the generated tasks plan/task stages is a DAG,

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

2009-06-08 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12717510#action_12717510 ] He Yongqiang commented on HIVE-460: --- the assumption is that it is always a subset of the

[jira] Commented: (HIVE-472) HiveFileFormatUtils's checkInputFormat does not include RCFile

2009-06-07 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12717117#action_12717117 ] He Yongqiang commented on HIVE-472: --- Yes. It will be better if we can move this method out.

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

2009-06-03 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] He Yongqiang updated HIVE-460: -- Attachment: hive-460-2009-06-04-testcli-passed.patch hive-460-2009-06-04-testcli-passed.patch now works.

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

2009-06-01 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12715345#action_12715345 ] He Yongqiang commented on HIVE-417: --- Joydeep, Thanks for the concern. are we going to have

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

2009-05-30 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12714730#action_12714730 ] He Yongqiang commented on HIVE-417: --- Thanks for the suggestions, Seymour. I have also

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

2009-05-30 Thread He Yongqiang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12714815#action_12714815 ] He Yongqiang commented on HIVE-460: --- Currently 'a+b' is used whether there an alias or not.

<    1   2   3   4   5   6   7   >