mercredi 14 octobre 2020

Hive IF THEN ELSE for executing different Hive Queries based on conditions

I want to do something like below,

IF table1 is not exists THEN

create table1 ();

ELSE 

insert overwrite table1
select ....

END

Is this achievable in hive ql ?

This is mainly for incremental load, also merge wont work because the record counts are billions.

Aucun commentaire:

Enregistrer un commentaire