[jira] [Commented] (HIVE-25671) Hybrid Grace Hash Join NullPointer When query RCFile

2021-11-05 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25671?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17439093#comment-17439093 ] Nemon Lou commented on HIVE-25671: -- I have create a demo for it.

[jira] [Updated] (HIVE-25671) Hybrid Grace Hash Join NullPointer When query RCFile

2021-11-05 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-25671: - External issue URL: https://github.com/EsotericSoftware/kryo/issues/863 > Hybrid Grace Hash Join

[jira] [Commented] (HIVE-25671) Hybrid Grace Hash Join NullPointer When query RCFile

2021-11-04 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25671?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17439012#comment-17439012 ] Nemon Lou commented on HIVE-25671: -- This bug seems related to kryo: Null pointer occurs when JVM trying

[jira] [Updated] (HIVE-25671) Hybrid Grace Hash Join NullPointer When query RCFile

2021-11-04 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-25671: - Attachment: rcfile_kryo.patch > Hybrid Grace Hash Join NullPointer When query RCFile >

[jira] [Updated] (HIVE-25671) Hybrid Grace Hash Join NullPointer When query RCFile

2021-11-04 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-25671: - Description: Hive 3.1.0 kryo 3.0.3 tez engine the following sql can reproduce this issue {code:sql}

[jira] [Updated] (HIVE-25671) Hybrid Grace Hash Join NullPointer When query RCFile

2021-11-04 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-25671?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-25671: - Description: {noformat} 2021-11-04 10:02:47,553 [INFO] [TezChild] |exec.MapJoinOperator|: Hybrid Grace

[jira] [Assigned] (HIVE-22294) ConditionalWork cannot be cast to MapredWork When both skew.join and auto.convert is on.

2021-09-24 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22294?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou reassigned HIVE-22294: Assignee: Nemon Lou (was: Rui Li) > ConditionalWork cannot be cast to MapredWork When both

[jira] [Commented] (HIVE-24579) Incorrect Result For Groupby With Limit

2021-09-22 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17418562#comment-17418562 ] Nemon Lou commented on HIVE-24579: -- [~kkasa] Good job! After reading your PR, I have some concerns. 1.

[jira] [Commented] (HIVE-22294) ConditionalWork cannot be cast to MapredWork When both skew.join and auto.convert is on.

2021-09-15 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-22294?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17415338#comment-17415338 ] Nemon Lou commented on HIVE-22294: -- The following sql can reproduce this issue,with tpc-ds factor 2,

[jira] [Commented] (HIVE-3562) Some limit can be pushed down to map stage

2021-09-13 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-3562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17414659#comment-17414659 ] Nemon Lou commented on HIVE-3562: - [~girishsk] I reported a same issue , also with some analysis : 

[jira] [Commented] (HIVE-24579) Incorrect Result For Groupby With Limit

2021-09-13 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17414657#comment-17414657 ] Nemon Lou commented on HIVE-24579: -- Another user also reports the same issue : 

[jira] [Commented] (HIVE-24579) Incorrect Result For Groupby With Limit

2021-09-13 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17414151#comment-17414151 ] Nemon Lou commented on HIVE-24579: -- I think topn key operator has the same issue. What's your Opinion? 

[jira] [Commented] (HIVE-24579) Incorrect Result For Groupby With Limit

2021-09-13 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17414006#comment-17414006 ] Nemon Lou commented on HIVE-24579: -- After debuging,I find the bug is quite intuitive: There is no order 

[jira] [Commented] (HIVE-24579) Incorrect Result For Groupby With Limit

2021-09-11 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17413502#comment-17413502 ] Nemon Lou commented on HIVE-24579: -- I have repoduce this issue.But data is too big to upload(more than

[jira] [Updated] (HIVE-24579) Incorrect Result For Groupby With Limit

2021-09-11 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24579?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-24579: - Attachment: testdata.tar.7z.007 > Incorrect Result For Groupby With Limit >

[jira] [Updated] (HIVE-24579) Incorrect Result For Groupby With Limit

2021-09-11 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24579?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-24579: - Attachment: (was: testdata.tar.7z.007) > Incorrect Result For Groupby With Limit >

[jira] [Comment Edited] (HIVE-24579) Incorrect Result For Groupby With Limit

2021-09-11 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17413481#comment-17413481 ] Nemon Lou edited comment on HIVE-24579 at 9/11/21, 7:11 AM: Thanks [~kkasa] 

[jira] [Comment Edited] (HIVE-24579) Incorrect Result For Groupby With Limit

2021-09-11 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17413481#comment-17413481 ] Nemon Lou edited comment on HIVE-24579 at 9/11/21, 7:02 AM: Thanks [~kkasa] 

[jira] [Commented] (HIVE-24579) Incorrect Result For Groupby With Limit

2021-09-11 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17413481#comment-17413481 ] Nemon Lou commented on HIVE-24579: -- Thanks [~kkasa] for your attention. This issue only happens on a

[jira] [Assigned] (HIVE-24902) Incorrect result after fold CASE into COALESCE

2021-03-22 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24902?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou reassigned HIVE-24902: Assignee: Nemon Lou > Incorrect result after fold CASE into COALESCE >

[jira] [Commented] (HIVE-24902) Incorrect result after fold CASE into COALESCE

2021-03-22 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17305966#comment-17305966 ] Nemon Lou commented on HIVE-24902: -- Thank you [~kgyrtkirk] FYI, Hive 2.3.7 can remove the whole case by

[jira] [Commented] (HIVE-24902) Incorrect result after fold CASE into COALESCE

2021-03-19 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17304780#comment-17304780 ] Nemon Lou commented on HIVE-24902: -- Here is the process how filter expression goes wrong: Pre

[jira] [Updated] (HIVE-24902) Incorrect result after fold CASE into COALESCE

2021-03-19 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24902?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-24902: - Description: The following sql returns only one record (20210308) but expected two(20210308 20210309).

[jira] [Updated] (HIVE-24902) Incorrect result after fold CASE into COALESCE

2021-03-19 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24902?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-24902: - Summary: Incorrect result after fold CASE into COALESCE (was: Incorrect result after fold CASE into

[jira] [Updated] (HIVE-24902) Incorrect result after fold CASE into NVL

2021-03-19 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24902?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-24902: - Summary: Incorrect result after fold CASE into NVL (was: Incorrect result due to ReduceExpressionsRule)

[jira] [Commented] (HIVE-24902) Incorrect result due to ReduceExpressionsRule

2021-03-18 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17304572#comment-17304572 ] Nemon Lou commented on HIVE-24902: -- Sorry if I offended you. And thanks for your response. I'm trying to

[jira] [Commented] (HIVE-24902) Incorrect result due to ReduceExpressionsRule

2021-03-18 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17303874#comment-17303874 ] Nemon Lou commented on HIVE-24902: -- [~julianhyde] Would you mind taking a look? Calcite version is

[jira] [Updated] (HIVE-24579) Incorrect Result For Groupby With Limit

2021-01-03 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24579?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-24579: - Priority: Major (was: Critical) > Incorrect Result For Groupby With Limit >

[jira] [Updated] (HIVE-24579) Incorrect Result For Groupby With Limit

2021-01-03 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24579?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-24579: - Description: {code:sql} create table test(id int); explain extended select id,count(*) from test group

[jira] [Updated] (HIVE-24579) Incorrect Result For Groupby With Limit

2021-01-03 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24579?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-24579: - Description: {code:sql} create table test(id int); explain extended select id,count(*) from test group

[jira] [Updated] (HIVE-24579) Incorrect Result For Groupby With Limit

2021-01-03 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24579?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-24579: - Description: {code:sql} create table test(id int); explain extended select id,count(*) from test group

[jira] [Commented] (HIVE-24579) Incorrect Result For Groupby With Limit

2021-01-03 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17257932#comment-17257932 ] Nemon Lou commented on HIVE-24579: -- A workaround is hive.limit.pushdown.memory.usage=0 .   > Incorrect

[jira] [Commented] (HIVE-18537) [Calcite-CBO] Queries with a nested distinct clause and a windowing function seem to fail with calcite Assertion error

2020-10-23 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-18537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17219498#comment-17219498 ] Nemon Lou commented on HIVE-18537: -- This issue get fixed after upgrade calcite to 1.17.0 or higher.

[jira] [Resolved] (HIVE-24165) CBO: Query fails after multiple count distinct rewrite

2020-10-23 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou resolved HIVE-24165. -- Resolution: Invalid > CBO: Query fails after multiple count distinct rewrite >

[jira] [Commented] (HIVE-24165) CBO: Query fails after multiple count distinct rewrite

2020-10-23 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17219496#comment-17219496 ] Nemon Lou commented on HIVE-24165: -- Not able to reproduce in master branch. After upgrade calcite from

[jira] [Updated] (HIVE-24165) CBO: Query fails after multiple count distinct rewrite

2020-09-14 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-24165: - Attachment: HIVE-24165.patch > CBO: Query fails after multiple count distinct rewrite >

[jira] [Commented] (HIVE-24165) CBO: Query fails after multiple count distinct rewrite

2020-09-14 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17195807#comment-17195807 ] Nemon Lou commented on HIVE-24165: -- In fact , i reproduce this issue by apply HIVE-22448 back to Hive

[jira] [Updated] (HIVE-24165) CBO: Query fails after multiple count distinct rewrite

2020-09-14 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-24165: - Description: One way to reproduce:   {code:sql} CREATE TABLE test( `device_id` string, `level`

[jira] [Updated] (HIVE-24165) CBO: Query fails after multiple count distinct rewrite

2020-09-14 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-24165: - Description: One way to reproduce:   {code:sql} CREATE TABLE test( `device_id` string, `level`

[jira] [Updated] (HIVE-18537) [Calcite-CBO] Queries with a nested distinct clause and a windowing function seem to fail with calcite Assertion error

2020-09-14 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-18537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-18537: - Affects Version/s: 3.1.2 > [Calcite-CBO] Queries with a nested distinct clause and a windowing function

[jira] [Commented] (HIVE-16839) Unbalanced calls to openTransaction/commitTransaction when alter the same partition concurrently

2017-06-23 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16061759#comment-16061759 ] Nemon Lou commented on HIVE-16839: -- Our system does not support concurrency. When users submit both drop

[jira] [Commented] (HIVE-16907) "INSERT INTO" overwrite old data when destination table encapsulated by backquote

2017-06-15 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16050173#comment-16050173 ] Nemon Lou commented on HIVE-16907: -- Refer to this method :

[jira] [Commented] (HIVE-16907) "INSERT INTO" overwrite old data when destination table encapsulated by backquote

2017-06-15 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16050146#comment-16050146 ] Nemon Lou commented on HIVE-16907: -- AST with backquote: {noformat} | TOK_QUERY

[jira] [Commented] (HIVE-16839) Unbalanced calls to openTransaction/commitTransaction when alter the same partition concurrently

2017-06-07 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16042020#comment-16042020 ] Nemon Lou commented on HIVE-16839: -- I have assigned it to you.Thanks. > Unbalanced calls to

[jira] [Assigned] (HIVE-16839) Unbalanced calls to openTransaction/commitTransaction when alter the same partition concurrently

2017-06-07 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou reassigned HIVE-16839: Assignee: Vihang Karajgaonkar > Unbalanced calls to openTransaction/commitTransaction when alter

[jira] [Commented] (HIVE-16839) Unbalanced calls to openTransaction/commitTransaction when alter the same partition concurrently

2017-06-06 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16040007#comment-16040007 ] Nemon Lou commented on HIVE-16839: -- Seems that we need a rollbackTransaction in method getPartition for

[jira] [Updated] (HIVE-16839) Unbalanced calls to openTransaction/commitTransaction when alter the same partition concurrently

2017-06-06 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-16839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-16839: - Description: SQL to reproduce: prepare: {noformat} hdfs dfs -mkdir -p

[jira] [Commented] (HIVE-12614) RESET command does not close spark session

2017-04-10 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-12614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15963745#comment-15963745 ] Nemon Lou commented on HIVE-12614: -- [~stakiar] Thanks for taking it over. :) > RESET command does not

[jira] [Updated] (HIVE-14557) Nullpointer When both SkewJoin and Mapjoin Enabled

2017-03-15 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14557?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14557: - Status: Patch Available (was: Open) > Nullpointer When both SkewJoin and Mapjoin Enabled >

[jira] [Updated] (HIVE-14557) Nullpointer When both SkewJoin and Mapjoin Enabled

2017-03-15 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14557?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14557: - Attachment: HIVE-14557.patch HIVE-6520 gives a detailed explanation about this issue. This patch puts

[jira] [Commented] (HIVE-15638) ArrayIndexOutOfBoundsException when output Columns for UDTF are pruned

2017-01-17 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-15638?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15827388#comment-15827388 ] Nemon Lou commented on HIVE-15638: -- The following query will pass(adding a 'select * ' before UDTF hwrl)

[jira] [Updated] (HIVE-14662) Wrong Class Instance When Using Custom SERDE

2016-10-09 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14662?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14662: - Attachment: HIVE-14662.patch > Wrong Class Instance When Using Custom SERDE >

[jira] [Updated] (HIVE-14662) Wrong Class Instance When Using Custom SERDE

2016-10-09 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14662?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14662: - Status: Patch Available (was: Open) > Wrong Class Instance When Using Custom SERDE >

[jira] [Commented] (HIVE-14390) Wrong Table alias when CBO is on

2016-08-06 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15410830#comment-15410830 ] Nemon Lou commented on HIVE-14390: -- Thanks a lot. [~pxiong] [~ashutoshc] . I haven't managed to update

[jira] [Commented] (HIVE-10153) CBO (Calcite Return Path): TPC-DS Q15 in-efficient join order

2016-08-04 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15407306#comment-15407306 ] Nemon Lou commented on HIVE-10153: -- This filter prevents joining date_dim first: {noformat} (

[jira] [Commented] (HIVE-14390) Wrong Table alias when CBO is on

2016-08-02 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15404176#comment-15404176 ] Nemon Lou commented on HIVE-14390: -- [~pxiong] Query plans for union15.q and union.9.q in SparkCliDriver

[jira] [Commented] (HIVE-14374) BeeLine argument, and configuration handling cleanup

2016-08-01 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15402036#comment-15402036 ] Nemon Lou commented on HIVE-14374: -- For my part,it will be fine to remove it. > BeeLine argument, and

[jira] [Commented] (HIVE-14374) BeeLine argument, and configuration handling cleanup

2016-08-01 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15402020#comment-15402020 ] Nemon Lou commented on HIVE-14374: -- [~pvary] Thanks for reminding this.If it was removed by accident

[jira] [Assigned] (HIVE-14390) Wrong Table alias when CBO is on

2016-07-31 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou reassigned HIVE-14390: Assignee: Nemon Lou > Wrong Table alias when CBO is on > > >

[jira] [Updated] (HIVE-14390) Wrong Table alias when CBO is on

2016-07-31 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14390: - Status: Patch Available (was: Open) > Wrong Table alias when CBO is on >

[jira] [Updated] (HIVE-14390) Wrong Table alias when CBO is on

2016-07-30 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14390: - Attachment: HIVE-14390.patch HIVE-14390.patch can fix this.But I'm not sure it's the right way. [~pxiong]

[jira] [Updated] (HIVE-14390) Wrong Table alias when CBO is on

2016-07-30 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14390: - Attachment: explain.rar > Wrong Table alias when CBO is on > > >

[jira] [Updated] (HIVE-14353) Performance degradation after Projection Pruning in CBO

2016-07-28 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14353: - Attachment: q46_explain_cbo_vs_nocbo.tar.gz > Performance degradation after Projection Pruning in CBO >

[jira] [Commented] (HIVE-14353) Performance degradation after Projection Pruning in CBO

2016-07-28 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15398540#comment-15398540 ] Nemon Lou commented on HIVE-14353: -- The motivation of this jira ticket is that ,I found that query46 was

[jira] [Comment Edited] (HIVE-14353) Performance degradation after Projection Pruning in CBO

2016-07-28 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15396893#comment-15396893 ] Nemon Lou edited comment on HIVE-14353 at 7/29/16 1:08 AM: ---

[jira] [Commented] (HIVE-14353) Performance degradation after Projection Pruning in CBO

2016-07-28 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15397041#comment-15397041 ] Nemon Lou commented on HIVE-14353: -- A preliminary analysis: Hive has a built in column pruner, and column

[jira] [Updated] (HIVE-14353) Performance degradation after Projection Pruning in CBO

2016-07-28 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14353: - Attachment: q46_cbo_projection_prune_explain.rar > Performance degradation after Projection Pruning in

[jira] [Updated] (HIVE-14353) Performance degradation after Projection Pruning in CBO

2016-07-28 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14353?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14353: - Attachment: q46_cbo_no_projection_prune_explain.txt > Performance degradation after Projection Pruning

[jira] [Commented] (HIVE-14353) Performance degradation after Projection Pruning in CBO

2016-07-27 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15396922#comment-15396922 ] Nemon Lou commented on HIVE-14353: -- [~pxiong] Sorry for the misleading. Performance degradation is at

[jira] [Commented] (HIVE-14353) Performance degradation after Projection Pruning in CBO

2016-07-27 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15396893#comment-15396893 ] Nemon Lou commented on HIVE-14353: -- ||queries||CBO_total_time||CBO_time_in_SelectOP|| |q27| 266.494|251

[jira] [Assigned] (HIVE-14143) RawDataSize of RCFile is zero after analyze

2016-07-09 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou reassigned HIVE-14143: Assignee: Nemon Lou (was: Abhishek) > RawDataSize of RCFile is zero after analyze >

[jira] [Commented] (HIVE-14143) RawDataSize of RCFile is zero after analyze

2016-07-04 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15361156#comment-15361156 ] Nemon Lou commented on HIVE-14143: -- [~pxiong] The "ids" passed in is just "sizeOfColumnsInTableScan" in

[jira] [Issue Comment Deleted] (HIVE-14143) RawDataSize of RCFile is zero after analyze

2016-07-02 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14143: - Comment: was deleted (was: Patch updated.) > RawDataSize of RCFile is zero after analyze >

[jira] [Updated] (HIVE-14143) RawDataSize of RCFile is zero after analyze

2016-07-02 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14143: - Attachment: HIVE-14143.1.patch > RawDataSize of RCFile is zero after analyze >

[jira] [Updated] (HIVE-14143) RawDataSize of RCFile is zero after analyze

2016-07-02 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14143: - Attachment: HIVE-14143.1.patch Patch updated. > RawDataSize of RCFile is zero after analyze >

[jira] [Updated] (HIVE-14143) RawDataSize of RCFile is zero after analyze

2016-07-02 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14143: - Attachment: (was: HIVE-14143.1.patch) > RawDataSize of RCFile is zero after analyze >

[jira] [Commented] (HIVE-14143) RawDataSize of RCFile is zero after analyze

2016-07-02 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360057#comment-15360057 ] Nemon Lou commented on HIVE-14143: -- Referring to ORC and LazySimpleSerde, rawDataSize is calculated

[jira] [Commented] (HIVE-14143) RawDataSize of RCFile is zero after analyze

2016-07-02 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360049#comment-15360049 ] Nemon Lou commented on HIVE-14143: -- Agreed. As describe in TableScanDesc.java {code} // Both

[jira] [Commented] (HIVE-14143) RawDataSize of RCFile is zero after analyze

2016-07-01 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14143?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15359940#comment-15359940 ] Nemon Lou commented on HIVE-14143: -- [~pxiong] Thanks for your attention. RawDataSize for rcfile is a

[jira] [Updated] (HIVE-14143) RawDataSize of RCFile is zero after analyze

2016-07-01 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-14143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-14143: - Attachment: HIVE-14143.patch > RawDataSize of RCFile is zero after analyze >

[jira] [Updated] (HIVE-5999) Allow other characters for LINES TERMINATED BY

2016-06-12 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-5999: Status: Open (was: Patch Available) > Allow other characters for LINES TERMINATED BY >

[jira] [Commented] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2016-06-05 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15316127#comment-15316127 ] Nemon Lou commented on HIVE-10815: -- Seems that no failure tests are related. [~thejas] would you review

[jira] [Updated] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2016-06-01 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-10815: - Attachment: HIVE-10815.2.patch Now there are less failure tests.So trigger it again. > Let

[jira] [Updated] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2016-06-01 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-10815: - Status: Patch Available (was: Open) > Let HiveMetaStoreClient Choose MetaStore Randomly >

[jira] [Updated] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2016-06-01 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-10815: - Status: Open (was: Patch Available) > Let HiveMetaStoreClient Choose MetaStore Randomly >

[jira] [Commented] (HIVE-5999) Allow other characters for LINES TERMINATED BY

2016-06-01 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15311563#comment-15311563 ] Nemon Lou commented on HIVE-5999: - Failure tests seem unrelated.This patch is ready for review. > Allow

[jira] [Updated] (HIVE-5999) Allow other characters for LINES TERMINATED BY

2016-05-30 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-5999: Status: Patch Available (was: Open) > Allow other characters for LINES TERMINATED BY >

[jira] [Updated] (HIVE-5999) Allow other characters for LINES TERMINATED BY

2016-05-30 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-5999: Attachment: HIVE-5999.1.patch Fixing failure test. > Allow other characters for LINES TERMINATED BY >

[jira] [Updated] (HIVE-5999) Allow other characters for LINES TERMINATED BY

2016-05-28 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-5999: Status: Patch Available (was: Open) > Allow other characters for LINES TERMINATED BY >

[jira] [Updated] (HIVE-5999) Allow other characters for LINES TERMINATED BY

2016-05-28 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-5999: Attachment: HIVE-5999.patch Limitations: 1,"lines terminated by" only works with text file. 2,"Multiple

[jira] [Comment Edited] (HIVE-5999) Allow other characters for LINES TERMINATED BY

2016-05-26 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15303389#comment-15303389 ] Nemon Lou edited comment on HIVE-5999 at 5/27/16 3:05 AM: -- [~ashutoshc] Do you

[jira] [Commented] (HIVE-5999) Allow other characters for LINES TERMINATED BY

2016-05-26 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15303389#comment-15303389 ] Nemon Lou commented on HIVE-5999: - [~ashutoshc] Do you plan to work on this? I have implemented one based

[jira] [Updated] (HIVE-10417) Parallel Order By return wrong results for partitioned tables

2016-05-24 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-10417: - Status: Open (was: Patch Available) > Parallel Order By return wrong results for partitioned tables >

[jira] [Updated] (HIVE-13791) Fix failure Unit Test TestHiveSessionImpl.testLeakOperationHandle

2016-05-19 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-13791: - Attachment: HIVE-13791.patch I have run TestHiveSessionImpl successfully from local . > Fix failure

[jira] [Updated] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2016-05-17 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-10815: - Status: Patch Available (was: Open) Patch rebased to master. > Let HiveMetaStoreClient Choose MetaStore

[jira] [Updated] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2016-05-17 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-10815: - Attachment: HIVE-10815.1.patch > Let HiveMetaStoreClient Choose MetaStore Randomly >

[jira] [Updated] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2016-05-17 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nemon Lou updated HIVE-10815: - Status: Open (was: Patch Available) > Let HiveMetaStoreClient Choose MetaStore Randomly >

[jira] [Commented] (HIVE-10815) Let HiveMetaStoreClient Choose MetaStore Randomly

2016-05-16 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-10815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15285941#comment-15285941 ] Nemon Lou commented on HIVE-10815: -- Seems that it fail to attract any volunteer to review. Shall I

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

2016-05-15 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15284045#comment-15284045 ] Nemon Lou commented on HIVE-13602: -- Thanks [~pxiong] .It will be nice to provide a patch for branch-1,

[jira] [Commented] (HIVE-13602) TPCH q16 return wrong result when CBO is on

2016-04-25 Thread Nemon Lou (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15257398#comment-15257398 ] Nemon Lou commented on HIVE-13602: -- It's 24581 on my computer. I must have checked the wrong stages from

  1   2   3   >