[jira] [Updated] (HIVE-24100) Syntax compile failure occurs when INSERT table column Order by is greater than 2 columns when CBO is false

[ https://issues.apache.org/jira/browse/HIVE-24100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-24100: --- Description: Executing the following SQL will fail to compile {code:java} set hive.cbo.enable=false;

[jira] [Comment Edited] (HIVE-23545) Insert table partition(column) occasionally occurs when the target partition is not created

[ https://issues.apache.org/jira/browse/HIVE-23545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17154374#comment-17154374 ] LuGuangMing edited comment on HIVE-23545 at 7/9/20, 9:17 AM: -

[jira] [Commented] (HIVE-23545) Insert table partition(column) occasionally occurs when the target partition is not created

[ https://issues.apache.org/jira/browse/HIVE-23545?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17154374#comment-17154374 ] LuGuangMing commented on HIVE-23545: Hello Ashish Sharma # This problem occurs in Hi

[jira] [Updated] (HIVE-22753) Fix gradual mem leak: Operationlog related appenders should be cleared up on errors

[ https://issues.apache.org/jira/browse/HIVE-22753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22753: --- Description: In case of exception in SQLOperation, operational log does not get cleared up. This cau

[jira] [Updated] (HIVE-22753) Fix gradual mem leak: Operationlog related appenders should be cleared up on errors

[ https://issues.apache.org/jira/browse/HIVE-22753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22753: --- Description: In case of exception in SQLOperation, operational log does not get cleared up. This cau

[jira] [Updated] (HIVE-20983) Vectorization: Scale up small hashtables, when collisions are detected

[ https://issues.apache.org/jira/browse/HIVE-20983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-20983: --- Issue Type: Improvement (was: Bug) > Vectorization: Scale up small hashtables, when collisions are d

[jira] [Updated] (HIVE-22715) SkewJoin throws NullPointException.

[ https://issues.apache.org/jira/browse/HIVE-22715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22715: --- Attachment: sample.sql > SkewJoin throws NullPointException. > --- >

[jira] [Updated] (HIVE-22715) SkewJoin throws NullPointException.

[ https://issues.apache.org/jira/browse/HIVE-22715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22715: --- Attachment: (was: sample.sql) > SkewJoin throws NullPointException. > ---

[jira] [Updated] (HIVE-22715) SkewJoin throws NullPointException.

[ https://issues.apache.org/jira/browse/HIVE-22715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22715: --- Description: When hive.optimize.skewjoin=ture and hive.auto.convert.join=true it throws NullPointExc

[jira] [Updated] (HIVE-22715) SkewJoin throws NullPointException.

[ https://issues.apache.org/jira/browse/HIVE-22715?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22715: --- Description: When hive.optimize.skewjoin=ture and hive.auto.convert.join=true it throws NullPointExc

[jira] [Commented] (HIVE-22198) Execute unoin-all with childs Join in parallel

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16946392#comment-16946392 ] LuGuangMing commented on HIVE-22198: [~aditya-shah] ConditionalTask is not easily awa

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Attachment: image-2019-10-08-09-51-06-144.png > Execute unoin-all with childs Join in parallel >

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Status: Patch Available (was: In Progress) > Execute unoin-all with childs Join in parallel > --

[jira] [Updated] (HIVE-22098) Data loss occurs when multiple tables are join with different bucket_version

[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22098: --- Status: Patch Available (was: Reopened) > Data loss occurs when multiple tables are join with differ

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Attachment: HIVE-22198.patch > Execute unoin-all with childs Join in parallel > -

[jira] [Commented] (HIVE-22198) Execute unoin-all with childs Join in parallel

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16934132#comment-16934132 ] LuGuangMing commented on HIVE-22198: 【repair】 Fix the parent dependencies of childre

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Affects Version/s: (was: 3.0.0) (was: 1.2.0) > Execute unoin-all with

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Description: set parallel is true, set skewjoin is false, set auto convert join is false. run a unoi

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Description: set parallel is true, set skewjoin is false, set auto convert join is false. run a unoi

[jira] [Commented] (HIVE-22198) Execute unoin-all with childs Join in parallel

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16934016#comment-16934016 ] LuGuangMing commented on HIVE-22198: 【analyze】 explain  SELECT sum(1) as a  FROM tab

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Attachment: image-2019-09-20-11-39-30-347.png > Execute unoin-all with childs Join in parallel >

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Description: set parallel is true, set skewjoin is false, set auto convert join is false. run a unoi

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Attachment: image-2019-09-20-11-38-37-433.png > Execute unoin-all with childs Join in parallel >

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Affects Version/s: 1.2.0 3.0.0 > Execute unoin-all with childs Join in paralle

[jira] [Work started] (HIVE-22198) Execute unoin-all with childs Join in parallel

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on HIVE-22198 started by LuGuangMing. -- > Execute unoin-all with childs Join in parallel > -

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Description: set parallel is true, set skewjoin is false, set auto convert join is false. run a unoi

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Attachment: test-parallel.sql > Execute unoin-all with childs Join in parallel >

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Attachment: (was: test-parallel-skewJoin-unoinall.sql) > Execute unoin-all with childs Join in pa

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Description: it's missing a part of data. details check attatchment sql file   was: connect hives

[jira] [Updated] (HIVE-22198) Execute unoin-all with childs Join in parallel

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Summary: Execute unoin-all with childs Join in parallel (was: parallel to run unoin-all missing a pa

[jira] [Updated] (HIVE-22198) parallel to run unoin-all missing a part of data

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Summary: parallel to run unoin-all missing a part of data (was: set parallel to run an unoin-all SQL

[jira] [Assigned] (HIVE-22198) set parallel to run an unoin-all SQL and result missing a part of data

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing reassigned HIVE-22198: -- Assignee: LuGuangMing > set parallel to run an unoin-all SQL and result missing a part of data

[jira] [Updated] (HIVE-22198) set parallel to run an unoin-all SQL and result missing a part of data

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Summary: set parallel to run an unoin-all SQL and result missing a part of data (was: set parallel t

[jira] [Updated] (HIVE-22198) set parallel to run an unoin all SQL result loss data

[ https://issues.apache.org/jira/browse/HIVE-22198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22198: --- Description: connect hiveserver to set hive.auto.convert.join=false,hive.optimize.skewjoin=true,  hi

[jira] [Resolved] (HIVE-22098) Data loss occurs when multiple tables are join with different bucket_version

[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing resolved HIVE-22098. Target Version/s: 3.1.0 (was: 3.1.0, 3.2.0) Resolution: Fixed > Data loss occurs when mu

[jira] [Commented] (HIVE-22098) Data loss occurs when multiple tables are join with different bucket_version

[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16912911#comment-16912911 ] LuGuangMing commented on HIVE-22098: please check and verify this patch update, http

[jira] [Updated] (HIVE-22098) Data loss occurs when multiple tables are join with different bucket_version

[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22098: --- Attachment: HIVE-22098.1.patch > Data loss occurs when multiple tables are join with different bucket

[jira] [Updated] (HIVE-22098) Data loss occurs when multiple tables are join with different bucket_version

[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22098: --- Attachment: (was: HIVE-22098.1.patch) > Data loss occurs when multiple tables are join with diffe

[jira] [Work started] (HIVE-22098) Data loss occurs when multiple tables are join with different bucket_version

[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Work on HIVE-22098 started by LuGuangMing. -- > Data loss occurs when multiple tables are join with different bucket_version > ---

[jira] [Updated] (HIVE-22098) Data loss occurs when multiple tables are join with different bucket_version

[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22098: --- Attachment: HIVE-22098.1.patch > Data loss occurs when multiple tables are join with different bucket

[jira] [Commented] (HIVE-22098) Data loss occurs when multiple tables are join with different bucket_version

[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16905063#comment-16905063 ] LuGuangMing commented on HIVE-22098: Modifying the hashcode algorithm to get key is c

[jira] [Updated] (HIVE-22098) Data loss occurs when multiple tables are join with different bucket_version

[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22098: --- Attachment: image-2019-08-12-18-45-15-771.png > Data loss occurs when multiple tables are join with d

[jira] [Updated] (HIVE-22098) Data loss occurs when multiple tables are join with different bucket_version

[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22098: --- Summary: Data loss occurs when multiple tables are join with different bucket_version (was: Data los

[jira] [Updated] (HIVE-22098) Data loss occurs when joins occur on tables with different bucket_version

[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22098: --- Attachment: table_c_data.orc table_b_data.orc table_a_data.orc

[jira] [Updated] (HIVE-22098) Data loss occurs when joins occur on tables with different bucket_version

[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing updated HIVE-22098: --- Target Version/s: 3.1.0, 3.2.0 (was: 3.2.0) > Data loss occurs when joins occur on tables with diffe

[jira] [Assigned] (HIVE-22098) Data loss occurs when joins occur on tables with different bucket_version

[ https://issues.apache.org/jira/browse/HIVE-22098?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] LuGuangMing reassigned HIVE-22098: -- > Data loss occurs when joins occur on tables with different bucket_version >