Versions Compared

Old Version 13

changes.mady.by.user Lefty Leverenz

Saved on

compared with

New Version 14

changes.mady.by.user Lefty Leverenz

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: remove ALL from column alias section

...

Code Block
SELECT key FROM src
UNION
SELECT key FROM src1 
ORDER BY key LIMIT 10

Column Aliases for

...

Schema Matching

UNION ALL expects expects the same schema on both sides of the expression list. As a result, the following query may fail with an error message such as "FAILED: SemanticException 4:47 Schema of both sides of union should match."

...