得到错误而执行蜂巢合并

2020年12月1日 63点热度 0条评论 来源: skaur

我运行下面的查询:得到错误而执行蜂巢合并

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"); 

两个表支持ACID属性。

我也试过表名为database_name.table_name在查询中,但它仍然给出相同的错误。

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

===========解决方案如下:

的JIRA票状态是 “进行中”

add support for MERGE statement

但似乎发展已经完成最近

Lefty Leverenz added a comment - 13/Jan/17 09:48
At this point MERGE is fully functional

    原文作者:skaur
    原文地址: https://stackoverflow.com/q/42132169
    本文转自网络文章,转载此文章仅为分享知识,如有侵权,请联系管理员进行删除。