功能 | 是否支持 |
插入或覆写数据(INSERT INTO | INSERT OVERWRITE) | 支持insert {into|overwrite} table <table_name> [partition (<pt_spec>)] <select_statement> from <from_statement>; 支持指定列插入数据:insert into table <table_name> [partition (<pt_spec>)] (<col_name> ,<col_name> ...) <select_statement> from <from_statement>; 不支持插入数据排序:insert {into|overwrite} table <table_name> [partition (<pt_spec>)] [(<col_name> [,<col_name> ...)] <select_statement> from <from_statement> [zorder by <zcol_name> [, <zcol_name> ...]];
|
插入或覆写动态分区数据(DYNAMIC PARTITION) | 是 |
多路输出(MULTI INSERT) | 是 |
VALUES | 支持insert … values 不支持values table
|
LOAD | 否 |
COMMON TABLE EXPRESSION(CTE) | |
更新或删除数据(UPDATE | DELETE) | 支持delete from <table_name> [where <where_condition>] |
MERGE INTO | 是 |
DROP COLUMNS(删除表中列) | 是 |