[ https://issues.apache.org/jira/browse/HIVE-10702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14555670#comment-14555670 ]
Hive QA commented on HIVE-10702: -------------------------------- {color:red}Overall{color}: -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12734646/HIVE-10702.patch {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 8967 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver_encryption_insert_partition_static {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3996/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/3996/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-3996/ Messages: {noformat} Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 1 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12734646 - PreCommit-HIVE-TRUNK-Build > COUNT(*) over windowing 'x preceding and y preceding' doesn't work properly > --------------------------------------------------------------------------- > > Key: HIVE-10702 > URL: https://issues.apache.org/jira/browse/HIVE-10702 > Project: Hive > Issue Type: Sub-task > Components: PTF-Windowing > Reporter: Aihua Xu > Assignee: Aihua Xu > Attachments: HIVE-10702.patch > > > Given the following query: > {noformat} > select ts, f, count(*) over (partition by ts order by f rows between 2 > preceding and 1 preceding) from over10k limit 100; > {noformat} > It returns the result > {noformat} > 2013-03-01 09:11:58.70307 3.17 0 > 2013-03-01 09:11:58.70307 10.89 0 > 2013-03-01 09:11:58.70307 14.54 1 > 2013-03-01 09:11:58.70307 14.78 1 > 2013-03-01 09:11:58.70307 17.85 1 > 2013-03-01 09:11:58.70307 20.61 1 > 2013-03-01 09:11:58.70307 28.69 1 > 2013-03-01 09:11:58.70307 29.22 1 > 2013-03-01 09:11:58.70307 31.17 1 > 2013-03-01 09:11:58.70307 38.35 1 > 2013-03-01 09:11:58.70307 38.61 1 > {noformat} > Mostly it should return count 2 rather than 1. -- This message was sent by Atlassian JIRA (v6.3.4#6332)