Hive
  1. Hive
  2. HIVE-871

UNION ALL schema errors are incorrect in multiple unions

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      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.

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Unassigned
            Reporter:
            Adam Kramer
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:

              Development