Hive: Merge/union two tables with different definition.

[#1]

Hi,

I've two tables in Hive which I want to merge/ union.

• Table A has an additional column p.
• Table B doesn't have the column p.

How can i merge both tables?

[#2 · Accepted solution]

@Kashif Amir

Cast the column p as null (or) some value and data types of the column p needs to match on both tables.

Example:-

hive# select cast("ta" as string)p
union
select cast("tb" as string)p;
+--------+--+
| p      |
+--------+--+
| ta     |
| tb     |
+--------+--+

In the example i'm having 2 tables having same column name(p) and datatype(String) after doing union we are getting merged results.

(or)

select "i" op
union
select "ji" p;
+---------+--+
| op      |
+---------+--+
| i       |
| ji      |
+---------+--+

[#3]

Thank you, @Shu !