MERGE in Hive Recipe

khairulfathi
khairulfathi Registered Posts: 11 ✭✭✭✭

Hello,

Does Hive recipe supports MERGE statement? Tried to write it but upon validation I'm getting 'Validation failed: Query has no SELECT statement'. I know SQL recipe has SQL Script option which supports it.

If its not supported, what will be the best way to INSERT if not matched and UPDATE when matched?

Thanks.

Answers

Setup Info
    Tags
      Help me…