[
https://issues.apache.org/jira/browse/HIVE-15548?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15804555#comment-15804555
]
N Campbell commented on HIVE-15548:
-----------------------------------
Another case not involving null order specification
SELECT
`D1`.`C0` AS `rnum`,
`D1`.`C1` AS `c1`,
`D1`.`C2` AS `c2`,
SUM(`D1`.`C3`) OVER( PARTITION BY `D1`.`C4` ) AS `cx`
FROM
(
SELECT
`rnum` AS `C0`,
`c1` AS `C1`,
`c2` AS `C2`,
`c3` AS `C3`,
SUM(`c3`) OVER( PARTITION BY `c1` ORDER BY `c1` ASC ) AS `C4`
FROM `tolap`
)
`D1`
> TEZ exception error when NULL ordering specification used on cursor or window
> agg
> ---------------------------------------------------------------------------------
>
> Key: HIVE-15548
> URL: https://issues.apache.org/jira/browse/HIVE-15548
> Project: Hive
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.1.0
> Reporter: N Campbell
> Attachments: TOLAP, TSET1
>
>
> Hive server: 2.1.0.2.5.3.0-37
> select c1, c2 from tset1 order by c1 asc nulls last, c2 asc nulls first
> select rnum , c1 , c2 , sum( c3 ) over (partition by sum( c3 ) over
> (partition by c1 order by c1 )) from tolap
> i.e.
> Error: Error while processing statement: FAILED: Execution Error, return code
> 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed,
> vertexName=Reducer 2, vertexId=vertex_1483461312952_0011_11_01,
> diagnostics=[Task failed, taskId=task_1483461312952_0011_11_01_000000,
> diagnostics=[TaskAttempt 0 failed, info=[Error: Error while running task (
> failure ) :
> attempt_1483461312952_0011_11_01_000000_0:java.lang.RuntimeException:
> java.lang.RuntimeException: java.io.EOFException: Detail:
> "java.io.EOFException" occured for field 0 of 2 fields (INT, CHAR)
> at
> org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:211)
> at
> org.apache.hadoop.hive.ql.exec.tez.TezProcessor.run(TezProcessor.java:168)
> at
> org.apache.tez.runtime.LogicalIOProcessorRuntimeTask.run(LogicalIOProcessorRuntimeTask.java:370)
> at
> org.apache.tez.runtime.task.TaskRunner2Callable$1.run(TaskRunner2Callable.java:73)
> at
> org.apache.tez.runtime.task.TaskRunner2Callable$1.run(TaskRunner2Callable.java:61)
> at java.security.AccessController.doPrivileged(Native Method)
> at javax.security.auth.Subject.doAs(Subject.java:422)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1724)
> at
> org.apache.tez.runtime.task.TaskRunner2Callable.callInternal(TaskRunner2Callable.java:61)
> at
> org.apache.tez.runtime.task.TaskRunner2Callable.callInternal(TaskRunner2Callable.java:37)
> at org.apache.tez.common.CallableWithNdc.call(CallableWithNdc.java:36)
> at
> org.apache.hadoop.hive.llap.daemon.impl.StatsRecordingThreadPool$WrappedCallable.call(StatsRecordingThreadPool.java:110)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> at java.lang.Thread.run(Thread.java:745)
> table definitions:
> create table if not exists TSET1 (RNUM int , C1 int, C2 char(3))
> ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n'
> STORED AS textfile ;
> create table if not exists TOLAP (RNUM int , C1 char(3), C2 char(2), C3 int,
> C4 int)
> ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n'
> STORED AS textfile ;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
