Getting error while executing hive merge

sheetal_khanuja — Thu, 09 Feb 2017 15:35:36 GMT

I am running below query:

MERGE INTO college_for_mrg AS T USING college AS S ON clg_name = clg_name WHEN MATCHED AND clg_id > 5 THEN UPDATE SET clg_loc = "ind" WHEN NOT MATCHED THEN INSERT VALUES(2,"sd","dsd","dsfs");

Both the tables support acid properties.

i have also tried table name as database_name.table_name in query but still its giving same error.

error: FAILED: ParseException line 3:0 cannot recognize input near 'MERGE' 'INTO' 'college_for_mrg'

please help.

Re: Getting error while executing hive merge

aervits — Thu, 09 Feb 2017 18:02:56 GMT

are you running merge command on HDP? It is not supported in any of the current releases. You need Apache Hive 2.2 for merge functionality. https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-Merge

question Re: Getting error while executing hive merge in Archives of Support Questions (Read Only)

Getting error while executing hive merge

Re: Getting error while executing hive merge