[ https://issues.apache.org/jira/browse/HIVE-9104?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xuefu Zhang updated HIVE-9104: ------------------------------ Resolution: Fixed Fix Version/s: 0.15.0 Status: Resolved (was: Patch Available) Committed to trunk. Thank Chao for the contribution and Harish for the review. > windowing.q failed when mapred.reduce.tasks is set to larger than one > --------------------------------------------------------------------- > > Key: HIVE-9104 > URL: https://issues.apache.org/jira/browse/HIVE-9104 > Project: Hive > Issue Type: Sub-task > Reporter: Chao > Assignee: Chao > Fix For: 0.15.0 > > Attachments: HIVE-9104.2.patch, HIVE-9104.patch > > > Test {{windowing.q}} is actually not enabled in Spark branch - in test > configurations it is {{windowing.q.q}}. > I just run this test, and query > {code} > -- 12. testFirstLastWithWhere > select p_mfgr,p_name, p_size, > rank() over(distribute by p_mfgr sort by p_name) as r, > sum(p_size) over (distribute by p_mfgr sort by p_name rows between current > row and current row) as s2, > first_value(p_size) over w1 as f, > last_value(p_size, false) over w1 as l > from part > where p_mfgr = 'Manufacturer#3' > window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding > and 2 following); > {code} > failed with the following exception: > {noformat} > java.lang.RuntimeException: Hive Runtime Error while closing operators: null > at > org.apache.hadoop.hive.ql.exec.spark.SparkReduceRecordHandler.close(SparkReduceRecordHandler.java:446) > at > org.apache.hadoop.hive.ql.exec.spark.HiveReduceFunctionResultList.closeRecordProcessor(HiveReduceFunctionResultList.java:58) > at > org.apache.hadoop.hive.ql.exec.spark.HiveBaseFunctionResultList$ResultIterator.hasNext(HiveBaseFunctionResultList.java:108) > at > scala.collection.convert.Wrappers$JIteratorWrapper.hasNext(Wrappers.scala:41) > at scala.collection.Iterator$class.foreach(Iterator.scala:727) > at scala.collection.AbstractIterator.foreach(Iterator.scala:1157) > at > org.apache.spark.rdd.AsyncRDDActions$$anonfun$foreachAsync$2.apply(AsyncRDDActions.scala:115) > at > org.apache.spark.rdd.AsyncRDDActions$$anonfun$foreachAsync$2.apply(AsyncRDDActions.scala:115) > at org.apache.spark.SparkContext$$anonfun$30.apply(SparkContext.scala:1390) > at org.apache.spark.SparkContext$$anonfun$30.apply(SparkContext.scala:1390) > at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:61) > at org.apache.spark.scheduler.Task.run(Task.scala:56) > at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:196) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) > Caused by: java.util.NoSuchElementException > at java.util.ArrayDeque.getFirst(ArrayDeque.java:318) > at > org.apache.hadoop.hive.ql.udf.generic.GenericUDAFFirstValue$FirstValStreamingFixedWindow.terminate(GenericUDAFFirstValue.java:290) > at > org.apache.hadoop.hive.ql.udf.ptf.WindowingTableFunction.finishPartition(WindowingTableFunction.java:413) > at > org.apache.hadoop.hive.ql.exec.PTFOperator$PTFInvocation.finishPartition(PTFOperator.java:337) > at org.apache.hadoop.hive.ql.exec.PTFOperator.closeOp(PTFOperator.java:95) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:598) > at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:610) > at > org.apache.hadoop.hive.ql.exec.spark.SparkReduceRecordHandler.close(SparkReduceRecordHandler.java:431) > ... 15 more > {noformat} > We need to find out: > - Since which commit this test started failing, and > - Why it fails -- This message was sent by Atlassian JIRA (v6.3.4#6332)