[jira] [Created] (HIVE-14736) It doesn't work WITH and UNION ALL

["Ryu Kobayashi (JIRA)" <ji...@apache.org>]

Ryu Kobayashi created HIVE-14736:
------------------------------------

             Summary: It doesn't work WITH and UNION ALL
                 Key: HIVE-14736
                 URL: https://issues.apache.org/jira/browse/HIVE-14736
             Project: Hive
          Issue Type: Bug
            Reporter: Ryu Kobayashi


When a combination of WITH and UNION ALL, may not work.
example:
{code}
with a as (
  select col1, col2 from table
), b as (
  select col1 from a where col2 is not null
), c as (
  select col1 from a
)
select col1 from b
union all
select col1 from c
{code}

Exception:
{code}
org.apache.hadoop.mapred.YarnChild: Exception running child : java.lang.RuntimeException: Hive Runtime Error while closing operators
	at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:207)
	at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61)
	at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:453)
	at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
	at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164)
	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:1698)
	at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
Caused by: java.lang.NullPointerException
	at org.apache.hadoop.hive.ql.exec.FileSinkOperator.closeOp(FileSinkOperator.java:1032)
	at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:682)
	at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:696)
	at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:696)
	at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:696)
	at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:189)
	... 8 more
{code}

{code}
      for (FSPaths fsp : valToPaths.values()) {
        fsp.closeWriters(abort);
        // before closing the operator check if statistics gathering is requested
        // and is provided by record writer. this is different from the statistics
{code}

This is caused when the #initializeOp is not initialized.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)