[jira] Created: (HIVE-871) UNION ALL schema errors are incorrect in multiple unions

["Adam Kramer (JIRA)" <ji...@apache.org>]

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.