Michael Bieniosek created HIVE-18786:
----------------------------------------
Summary: NPE in Hive windowing functions
Key: HIVE-18786
URL: https://issues.apache.org/jira/browse/HIVE-18786
Project: Hive
Issue Type: Bug
Affects Versions: 2.3.2
Reporter: Michael Bieniosek
When I run a Hive query with windowing functions, if there's enough data I get
an NPE.
For example something like this query might break:
select id, created_date, max(created_date) over (partition by id)
latest_created_any from ...
The only workaround I've found is to remove the windowing functions entirely.
The stacktrace looks suspiciously similar to HADOOP-2931, but I'm in hive-2.3.2
which appears to have the bugfix applied.
Caused by: java.lang.NullPointerException
at
org.apache.hadoop.hive.ql.exec.persistence.PTFRowContainer.first(PTFRowContainer.java:115)
at
org.apache.hadoop.hive.ql.exec.PTFPartition.iterator(PTFPartition.java:114)
at
org.apache.hadoop.hive.ql.udf.ptf.BasePartitionEvaluator.getPartitionAgg(BasePartitionEvaluator.java:200)
at
org.apache.hadoop.hive.ql.udf.ptf.WindowingTableFunction.evaluateFunctionOnPartition(WindowingTableFunction.java:155)
at
org.apache.hadoop.hive.ql.udf.ptf.WindowingTableFunction.iterator(WindowingTableFunction.java:538)
at
org.apache.hadoop.hive.ql.exec.PTFOperator$PTFInvocation.finishPartition(PTFOperator.java:349)
at
org.apache.hadoop.hive.ql.exec.PTFOperator.process(PTFOperator.java:123)
at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:897)
at
org.apache.hadoop.hive.ql.exec.SelectOperator.process(SelectOperator.java:95)
at
org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource$GroupIterator.next(ReduceRecordSource.java:356)
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
