question Hive: Merge/union two tables with different definition. in Support Questions

Hive: Merge/union two tables with different definition.

kashifamirbanga — Thu, 08 Feb 2018 21:27:26 GMT

Hi,

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

How can i merge both tables?

Shu_ashu — Thu, 08 Feb 2018 21:49:41 GMT

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      |
+---------+--+

kashifamirbanga — Thu, 08 Feb 2018 22:23:41 GMT

Thank you, @Shu !