[jira] [Commented] (HIVE-28483) String date cast giving wrong result

[ https://issues.apache.org/jira/browse/HIVE-28483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17881930#comment-17881930 ] Aman Sinha commented on HIVE-28483: --- I believe we need to have a higher bar in order to

[jira] [Commented] (HIVE-27788) Exception in Sort Merge join with Group By + PTF Operator

[ https://issues.apache.org/jira/browse/HIVE-27788?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17783852#comment-17783852 ] Aman Sinha commented on HIVE-27788: --- {quote}A possible solution is to disable SMB join

[jira] [Commented] (HIVE-27176) EXPLAIN SKEW

[ https://issues.apache.org/jira/browse/HIVE-27176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17705103#comment-17705103 ] Aman Sinha commented on HIVE-27176: --- This would be a very useful feature. More details

[jira] [Commented] (HIVE-26659) TPC-DS query 16, 69, 94 return wrong results.

[ https://issues.apache.org/jira/browse/HIVE-26659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17698768#comment-17698768 ] Aman Sinha commented on HIVE-26659: --- CBO plan: {noformat} set hive.auto.convert.anti.jo

[jira] [Commented] (HIVE-26659) TPC-DS query 16, 69, 94 return wrong results.

[ https://issues.apache.org/jira/browse/HIVE-26659?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17698761#comment-17698761 ] Aman Sinha commented on HIVE-26659: --- I found that the wrong results happens if there is

[jira] [Comment Edited] (HIVE-26534) GROUPING() function errors out due to case-sensitivity of function name

[ https://issues.apache.org/jira/browse/HIVE-26534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17604875#comment-17604875 ] Aman Sinha edited comment on HIVE-26534 at 9/14/22 5:49 PM: M

[jira] [Resolved] (HIVE-26534) GROUPING() function errors out due to case-sensitivity of function name

[ https://issues.apache.org/jira/browse/HIVE-26534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha resolved HIVE-26534. --- Resolution: Fixed Marking this fixed since [~soumyakanti.das] PR has been merged. > GROUPING() funct

[jira] [Comment Edited] (HIVE-17342) Where condition with 1=0 should be treated similar to limit 0

[ https://issues.apache.org/jira/browse/HIVE-17342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17597947#comment-17597947 ] Aman Sinha edited comment on HIVE-17342 at 8/30/22 3:42 PM: A

[jira] [Comment Edited] (HIVE-17342) Where condition with 1=0 should be treated similar to limit 0

[ https://issues.apache.org/jira/browse/HIVE-17342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17597947#comment-17597947 ] Aman Sinha edited comment on HIVE-17342 at 8/30/22 3:40 PM: A

[jira] [Commented] (HIVE-17342) Where condition with 1=0 should be treated similar to limit 0

[ https://issues.apache.org/jira/browse/HIVE-17342?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17597947#comment-17597947 ] Aman Sinha commented on HIVE-17342: --- A slightly different example shows the limit 0 opt

[jira] [Resolved] (HIVE-24029) MV fails for queries with subqueries

[ https://issues.apache.org/jira/browse/HIVE-24029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha resolved HIVE-24029. --- Resolution: Cannot Reproduce Resolving based on above. > MV fails for queries with subqueries >

[jira] [Resolved] (HIVE-24028) MV query fails with CalciteViewSemanticException

[ https://issues.apache.org/jira/browse/HIVE-24028?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha resolved HIVE-24028. --- Resolution: Not A Bug Resolving based on above. > MV query fails with CalciteViewSemanticException >

[jira] [Commented] (HIVE-24029) MV fails for queries with subqueries

[ https://issues.apache.org/jira/browse/HIVE-24029?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17472418#comment-17472418 ] Aman Sinha commented on HIVE-24029: --- On a recent build, I don't see this issue. The CM

[jira] [Commented] (HIVE-24028) MV query fails with CalciteViewSemanticException

[ https://issues.apache.org/jira/browse/HIVE-24028?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17472416#comment-17472416 ] Aman Sinha commented on HIVE-24028: --- This is expected behavior because both CREATE MATE

[jira] [Commented] (HIVE-25822) Unexpected result rows in case of outer join contains conditions only affecting one side

[ https://issues.apache.org/jira/browse/HIVE-25822?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17462261#comment-17462261 ] Aman Sinha commented on HIVE-25822: --- +1 to calling it wrong results. Thanks for creati

[jira] [Assigned] (HIVE-24465) RuntimeException Invalid Stats number of null > no of tuples when fetch column stats is enabled

[ https://issues.apache.org/jira/browse/HIVE-24465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha reassigned HIVE-24465: - > RuntimeException Invalid Stats number of null > no of tuples when fetch > column stats is enabled