Using union in hive environment

Can’t we use union function in hive environment?

A warning message appears when using the DB Concatenate node in the hive environment.

And the row handling option is also disabled.

Please help if you know anything about it.

@mychoi Hive does not support a UNION command. You can use INSERT INTO with the SQL executor. You will have to make sure that the structure is the same. This might give you an idea:

Also you will have to take into account the specifics of Big Data tables which are different from other database systems. I would recommend you check out my workflow about the specifics of Hive

If you also use Impala you will have to make sure depending on the versions that you also care about statistics and formats (Parquet, CSV, EXTERNAL Tables, Kudu and the like).

1 Like

Thank you it helped me a lot!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.