[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&focusedCommentId=17439093#comment-17439093 ] Nemon Lou commented on HIVE-25671: -- I have create a demo for it. https://github.com/lou

[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 NullPoin

[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&focusedCommentId=17439012#comment-17439012 ] Nemon Lou commented on HIVE-25671: -- This bug seems related to kryo: Null pointer occurs

[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} CREAT

[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 H

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

2021-09-23 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 skew.

[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&focusedCommentId=17418562#comment-17418562 ] Nemon Lou commented on HIVE-24579: -- [~kkasa] Good job! After reading your PR, I have so

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

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

[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&focusedCommentId=17414659#comment-17414659 ] Nemon Lou commented on HIVE-3562: - [~girishsk] I reported a same issue , also with some an

[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&focusedCommentId=17414657#comment-17414657 ] Nemon Lou commented on HIVE-24579: -- Another user also reports the same issue :  https://

[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&focusedCommentId=17414151#comment-17414151 ] Nemon Lou commented on HIVE-24579: -- I think topn key operator has the same issue. What's

[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&focusedCommentId=17414006#comment-17414006 ] Nemon Lou commented on HIVE-24579: -- After debuging,I find the bug is quite intuitive: T

[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&focusedCommentId=17413502#comment-17413502 ] Nemon Lou commented on HIVE-24579: -- I have repoduce this issue.But data is too big to up

[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&focusedCommentId=17413481#comment-17413481 ] Nemon Lou edited comment on HIVE-24579 at 9/11/21, 7:11 AM: T

[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&focusedCommentId=17413481#comment-17413481 ] Nemon Lou edited comment on HIVE-24579 at 9/11/21, 7:02 AM: T

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

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

[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&focusedCommentId=17305966#comment-17305966 ] Nemon Lou commented on HIVE-24902: -- Thank you [~kgyrtkirk] FYI, Hive 2.3.7 can remove t

[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&focusedCommentId=17304780#comment-17304780 ] Nemon Lou commented on HIVE-24902: -- Here is the process how filter expression goes wrong

[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 NVL)

[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&focusedCommentId=17304572#comment-17304572 ] Nemon Lou commented on HIVE-24902: -- Sorry if I offended you. And thanks for your respons

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

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

[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 by

[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 by

[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 by

[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&focusedCommentId=17257932#comment-17257932 ] Nemon Lou commented on HIVE-24579: -- A workaround is hive.limit.pushdown.memory.usage=0 .

[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-22 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-18537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17219498#comment-17219498 ] Nemon Lou commented on HIVE-18537: -- This issue get fixed after upgrade calcite to 1.17.0

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

2020-10-22 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-22 Thread Nemon Lou (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17219496#comment-17219496 ] Nemon Lou commented on HIVE-24165: -- Not able to reproduce in master branch. After upgra

[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&focusedCommentId=17195807#comment-17195807 ] Nemon Lou commented on HIVE-24165: -- In fact , i reproduce this issue by apply HIVE-22448

[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` strin

[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` strin

[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&focusedCommentId=16061759#comment-16061759 ] Nemon Lou commented on HIVE-16839: -- Our system does not support concurrency. When users

[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&focusedCommentId=16050173#comment-16050173 ] Nemon Lou commented on HIVE-16907: -- Refer to this method : https://github.com/apache/hive

[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&focusedCommentId=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&focusedCommentId=16042020#comment-16042020 ] Nemon Lou commented on HIVE-16839: -- I have assigned it to you.Thanks. > Unbalanced calls

[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 th

[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&focusedCommentId=16040007#comment-16040007 ] Nemon Lou commented on HIVE-16839: -- Seems that we need a rollbackTransaction in method ge

[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 /hzsrc/external/writing_dc/ltgsm/1

[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&focusedCommentId=15963745#comment-15963745 ] Nemon Lou commented on HIVE-12614: -- [~stakiar] Thanks for taking it over. :) > RESET com

[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 skew

[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&focusedCommentId=15827388#comment-15827388 ] Nemon Lou commented on HIVE-15638: -- The following query will pass(adding a 'select * ' be

[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&focusedCommentId=15410830#comment-15410830 ] Nemon Lou commented on HIVE-14390: -- Thanks a lot. [~pxiong] [~ashutoshc] . I haven't mana

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

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

[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&focusedCommentId=15404176#comment-15404176 ] Nemon Lou commented on HIVE-14390: -- [~pxiong] Query plans for union15.q and union.9.q in

[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&focusedCommentId=15402036#comment-15402036 ] Nemon Lou commented on HIVE-14374: -- For my part,it will be fine to remove it. > BeeLine

[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&focusedCommentId=15402020#comment-15402020 ] Nemon Lou commented on HIVE-14374: -- [~pvary] Thanks for reminding this.If it was removed

[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&focusedCommentId=15398540#comment-15398540 ] Nemon Lou commented on HIVE-14353: -- The motivation of this jira ticket is that ,I found t

[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&focusedCommentId=15396893#comment-15396893 ] Nemon Lou edited comment on HIVE-14353 at 7/29/16 1:08 AM: --- ||qu

[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&focusedCommentId=15397041#comment-15397041 ] Nemon Lou commented on HIVE-14353: -- A preliminary analysis: Hive has a built in column pr

[jira] [Updated] (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:all-tabpanel ] Nemon Lou updated HIVE-14353: - Attachment: q46_cbo_projection_prune_explain.rar > Performance degradation after Projection Pruning in CB

[jira] [Updated] (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:all-tabpanel ] Nemon Lou updated HIVE-14353: - Attachment: q46_cbo_no_projection_prune_explain.txt > Performance degradation after Projection Pruning in

[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&focusedCommentId=15396922#comment-15396922 ] Nemon Lou commented on HIVE-14353: -- [~pxiong] Sorry for the misleading. Performance degr

[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&focusedCommentId=15396893#comment-15396893 ] Nemon Lou commented on HIVE-14353: -- ||queries||CBO_total_time||CBO_time_in_SelectOP|| |q2

[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&focusedCommentId=15361156#comment-15361156 ] Nemon Lou commented on HIVE-14143: -- [~pxiong] The "ids" passed in is just "sizeOfColumnsI

[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&focusedCommentId=15360057#comment-15360057 ] Nemon Lou commented on HIVE-14143: -- Referring to ORC and LazySimpleSerde, rawDataSize is

[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&focusedCommentId=15360049#comment-15360049 ] Nemon Lou commented on HIVE-14143: -- Agreed. As describe in TableScanDesc.java {code} /

[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&focusedCommentId=15359940#comment-15359940 ] Nemon Lou commented on HIVE-14143: -- [~pxiong] Thanks for your attention. RawDataSize for

[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&focusedCommentId=15316127#comment-15316127 ] Nemon Lou commented on HIVE-10815: -- Seems that no failure tests are related. [~thejas] wo

[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 HiveMetaStoreC

[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&focusedCommentId=15311563#comment-15311563 ] Nemon Lou commented on HIVE-5999: - Failure tests seem unrelated.This patch is ready for rev

[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-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: Open (was: Patch Available) > 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 table

[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&focusedCommentId=15303389#comment-15303389 ] Nemon Lou edited comment on HIVE-5999 at 5/27/16 3:05 AM: -- [~ashut

[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&focusedCommentId=15303389#comment-15303389 ] Nemon Lou commented on HIVE-5999: - [~ashutoshc] Do you plan to work on this? I have impleme

[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 Uni

[jira] [Updated] (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: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-16 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-16 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&focusedCommentId=15285941#comment-15285941 ] Nemon Lou commented on HIVE-10815: -- Seems that it fail to attract any volunteer to review

[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&focusedCommentId=15284045#comment-15284045 ] Nemon Lou commented on HIVE-13602: -- Thanks [~pxiong] .It will be nice to provide a patch

  1   2   3   >