产品概述
产品优势
应用场景
INSERT INTO table_name [ ( column [, ... ] ) ] query
INSERT INTO table_identifier [ partition_spec ] [ ( column_list ) ]{ VALUES ( { value | NULL } [ , ... ] ) [ , ( ... ) ] | query }
[ partition_spec ]：分区列和值。例如 dt='2021-06-01'。[ ( column [, ... ] ) ]：列的所有。[table_name] | table_identifier：表名。[query]：一个通用 Select 查询语句。INSERT INTO orders SELECT * FROM new_orders;
INSERT INTO cities VALUES (1, 'China');
INSERT INTO nation (nationkey, name, regionkey, comment)VALUES (26, 'POLAND', 3, 'no comment');
INSERT INTO students PARTITION (student_id = 444444) SELECT name, address FROM persons WHERE name = 'dlc'
INSERT INTO students PARTITION (student_id = 11215017) (address, name) VALUES ('Shen zhen, China', 'tester')
文档反馈