You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Kai Sasaki (JIRA)" <ji...@apache.org> on 2016/06/09 03:11:20 UTC

[jira] [Created] (HIVE-13976) UNION ALL which takes actual source table in one side failed

Kai Sasaki created HIVE-13976:
---------------------------------

             Summary: UNION ALL which takes actual source table in one side failed
                 Key: HIVE-13976
                 URL: https://issues.apache.org/jira/browse/HIVE-13976
             Project: Hive
          Issue Type: Bug
    Affects Versions: 0.13.0
         Environment: Ubuntu 12.04, JDK 7
            Reporter: Kai Sasaki


UNION ALL must take actual source table in both side or none exclusively.

UNION ALL with actual table in both side -> Succeed as expected
{code}
SELECT 
  1 AS id,
  'Alice' AS name
FROM
  table1
UNION ALL 
SELECT 
  2 AS id,
  'Bob' AS name
FROM
  table2
{code}

UNION ALL without actual table in both side -> Succeed as expected
{code}
SELECT 
  1 AS id,
  'Alice' AS name
UNION ALL 
SELECT 
  2 AS id,
  'Bob' AS name
{code}

UNION ALL with actual table on one side -> Failed
{code}
SELECT 
  1 AS id,
  'Alice' AS name
UNION ALL 
SELECT 
  2 AS id,
  'Bob' AS name
FROM
   some_table
{code}

The error message from map task is this.
{code}
Diagnostic Messages for this Task:
Error: java.lang.IllegalArgumentException: Can not create a Path from an empty string
	at org.apache.hadoop.fs.Path.checkPathArg(Path.java:127)
	at org.apache.hadoop.fs.Path.<init>(Path.java:135)
	at org.apache.hadoop.hive.ql.io.HiveInputFormat$HiveInputSplit.getPath(HiveInputFormat.java:116)
	at org.apache.hadoop.mapred.MapTask.updateJobWithSplit(MapTask.java:458)
{code}



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