Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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.
Hi,
You will likely need to write your own full INSERT statement using INSERT OVERWRITE to handle this scenario, like mentioned in our documentation here:
https://doc.dataiku.com/dss/latest/code_recipes/hive.html#writing-more-complex-queries
Thanks,
Andrew