[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15231840#comment-15231840 ] Lefty Leverenz commented on HIVE-9534: -- Thanks [~aihuaxu]! > incorrect result set for

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15230269#comment-15230269 ] Aihua Xu commented on HIVE-9534: [~leftylev] I just updated the doc. I also filed HIVE-13

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15227426#comment-15227426 ] Lefty Leverenz commented on HIVE-9534: -- Doc query: [~the6campbells] said in the secon

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15227037#comment-15227037 ] Sergey Shelukhin commented on HIVE-9534: Makes sense, thanks. > incorrect result s

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15227002#comment-15227002 ] Aihua Xu commented on HIVE-9534: That could be considered as new feature rather than bug,

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15226780#comment-15226780 ] Sergey Shelukhin commented on HIVE-9534: Does this need to be backported to 2.0.1?

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15145873#comment-15145873 ] Lefty Leverenz commented on HIVE-9534: -- Does the documentation still need to be improv

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15144744#comment-15144744 ] Aihua Xu commented on HIVE-9534: Thanks Yongzhi. Yeah. The current implementation will do a

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15143953#comment-15143953 ] Yongzhi Chen commented on HIVE-9534: As the Avg(distinct) is calculated after global so

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15143743#comment-15143743 ] Yongzhi Chen commented on HIVE-9534: It seems that your method need a global sorting fi

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15142326#comment-15142326 ] Hive QA commented on HIVE-9534: --- Here are the results of testing the latest attachment: htt

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15139661#comment-15139661 ] Aihua Xu commented on HIVE-9534: Attached patch-4: fix the unit test invalid_avg_syntax iss

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15139388#comment-15139388 ] Hive QA commented on HIVE-9534: --- Here are the results of testing the latest attachment: htt

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15135706#comment-15135706 ] Hive QA commented on HIVE-9534: --- Here are the results of testing the latest attachment: htt

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15132527#comment-15132527 ] Aihua Xu commented on HIVE-9534: Code review: https://reviews.apache.org/r/43192/. Somehow

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15101811#comment-15101811 ] Aihua Xu commented on HIVE-9534: Talked to Chaoyu. I will take a look at the issue. > inco

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14901818#comment-14901818 ] N Campbell commented on HIVE-9534: -- should say Netezza 7.2 and ORACLE 12. > incorrect res

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14901809#comment-14901809 ] N Campbell commented on HIVE-9534: -- IBM Netezza 7.2, IBM Big Insights, SAP Hana SP10, ORAC

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14529716#comment-14529716 ] Chaoyu Tang commented on HIVE-9534: --- Oracle 11.2 treats avg(distinct tsint.csint) over ()

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14529608#comment-14529608 ] N Campbell commented on HIVE-9534: -- re your comment about ORACLE select avg(distinct tsin

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14529304#comment-14529304 ] Chaoyu Tang commented on HIVE-9534: --- Looks like that the over(analytic_clause) part will

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14528903#comment-14528903 ] Chaoyu Tang commented on HIVE-9534: --- Actually as of Oracle 11.2 (the version I tested was

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14526193#comment-14526193 ] Chaoyu Tang commented on HIVE-9534: --- [~rhbutani] I have not looked deeply into code yet,

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14526190#comment-14526190 ] Chaoyu Tang commented on HIVE-9534: --- I tried the tests (distinct with window function) in

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14512997#comment-14512997 ] N Campbell commented on HIVE-9534: -- While Postgres may not support ISO-SQL syntax as shown

[jira] [Commented] (HIVE-9534) incorrect result set for query that projects a windowed aggregate

[ https://issues.apache.org/jira/browse/HIVE-9534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14512276#comment-14512276 ] Harsh J commented on HIVE-9534: --- Applying a similar SQL in PostgreSQL or Impala returns an er