Hive UNION ALL requires both side to be having exact same number of columns and column names
This article explains the syntax requirement for UNION ALL clause in Hive in order for it to work. If you have a table with the following definition: And the following query: will give you the error: The reason is that UNION ALL clause requires that both sides to have exact …