[jira] [Commented] (HIVE-58) [hive] join condition does not allow a simple filter

2021-04-10 Thread liguangyu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-58?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17318524#comment-17318524 ] liguangyu commented on HIVE-58: --- select from A join B ON A.a = B.b where A.x=10 > [hive]

[jira] [Commented] (HIVE-24078) result rows not equal in mr and tez

2021-04-09 Thread liguangyu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24078?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17317961#comment-17317961 ] liguangyu commented on HIVE-24078: -- Problem of execution order: To perform first:  WHER

[jira] [Commented] (HIVE-21574) return wrong result when execute left join sql

2021-04-09 Thread liguangyu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-21574?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17317957#comment-17317957 ] liguangyu commented on HIVE-21574: -- It's probably because 'distinct null' . When distin

[jira] [Commented] (HIVE-24740) Invalid table alias or column reference: Can't order by an unselected column

2021-04-09 Thread liguangyu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17317942#comment-17317942 ] liguangyu commented on HIVE-24740: -- The alias column1  could not be found. execution se

[jira] [Commented] (HIVE-24573) hive 3.1.2 drop table Sometimes it can't be deleted

2021-04-09 Thread liguangyu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17317939#comment-17317939 ] liguangyu commented on HIVE-24573: -- whether there is a space in the table name? > hive

[jira] [Commented] (HIVE-24993) AssertionError when referencing ROW__ID.writeId

2021-04-08 Thread liguangyu (Jira)
[ https://issues.apache.org/jira/browse/HIVE-24993?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17317581#comment-17317581 ] liguangyu commented on HIVE-24993: -- Hi [~kkasa]:       RuntimeException cannot find fie