INSERT INTO

功能描述

向表中添加一行或多行数据。

血缘解析支持的语法格式

INSERT INTO/INSERT OVERWRITE INTO {schema_name}.{table_name}

语句示例1

INSERT INTO mySchema.tbl_1(code, title) SELECT code, title FROM mySchema.tbl_2 WHERE date_prod < '2026-05-07';

语句示例2

INSERT INTO mySchema.inner_order (region, product, product_units, product_sales) 
WITH 
regional_sales AS (SELECT region, SUM(amount) AS total_sales FROM mySchema.orders_1 GROUP BY region), 
top_regions AS (SELECT region FROM regional_sales WHERE total_sales > (SELECT SUM(total_sales)/10 FROM regional_sales))
SELECT region, product,SUM(quantity) AS product_units, SUM(amount) AS product_sales FROM mySchema.orders WHERE region IN	(SELECT region FROM mySchema.top_regions) GROUP BY region, product;