hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Adam Kramer (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-871) UNION ALL schema errors are incorrect in multiple unions
Date Fri, 09 Oct 2009 08:50:31 GMT
UNION ALL schema errors are incorrect in multiple unions
--------------------------------------------------------

                 Key: HIVE-871
                 URL: https://issues.apache.org/jira/browse/HIVE-871
             Project: Hadoop Hive
          Issue Type: Bug
            Reporter: Adam Kramer


FAILED: Error in semantic analysis: Schema of both sides of union should match: Column time
is of type bigint on first table and type int on second table

...makes perfect sense, assuming that there are only two tables being unioned. However, UNION
ALL can be used to tie together many queries (more than 2). The above error was generated
when column "time" was of type bigint in the first, second, and third tables, and of type
int in the fourth.

This could be fixed either by adding a row/column number of where the errors occurred:

Column time is of type bigint at line 14:15 and type int at line 18:15

...or by using the actual table indices:

Column time is of type bigint on table 3 and type int on table 4.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message