Steve Carlin created HIVE-26726:
-----------------------------------
Summary: tinyint column with windowing fn crashes at runtime
Key: HIVE-26726
URL: https://issues.apache.org/jira/browse/HIVE-26726
Project: Hive
Issue Type: Bug
Components: HiveServer2
Reporter: Steve Carlin
Using a tinyint column in a windowing function is causing a runtime exception.
The following SQL
{code:java}
CREATE TABLE t_test(
int_col int,
tinyint_col tinyint
);
insert into t_test values (1, 1);
select
count(int_col) over (order by tinyint_col)
from t_test;
{code}
produces this error:
{code:java}
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Internal Error:
attempt to setup a Window for typeString: 'tinyint'
at
org.apache.hadoop.hive.ql.udf.ptf.SingleValueBoundaryScanner.getBoundaryScanner(ValueBoundaryScanner.java:783)
at
org.apache.hadoop.hive.ql.udf.ptf.SingleValueBoundaryScanner.getScanner(ValueBoundaryScanner.java:719)
at
org.apache.hadoop.hive.ql.udf.ptf.ValueBoundaryScanner.getScanner(ValueBoundaryScanner.java:332)
at
org.apache.hadoop.hive.ql.udf.ptf.PTFRangeUtil.getRange(PTFRangeUtil.java:40)
at
org.apache.hadoop.hive.ql.exec.vector.ptf.VectorPTFGroupBatches.finishPartition(VectorPTFGroupBatches.java:442)
at
org.apache.hadoop.hive.ql.exec.vector.ptf.VectorPTFOperator.finishPartition(VectorPTFOperator.java:632)
at
org.apache.hadoop.hive.ql.exec.vector.ptf.VectorPTFOperator.closeOp(VectorPTFOperator.java:783){code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
