hive插入数据语句
时间: 2024-04-24 11:18:45 浏览: 27
Hive是一个基于Hadoop的数据仓库工具,用于处理大规模数据集。在Hive中,可以使用INSERT语句将数据插入到表中。以下是Hive插入数据的语法和示例:
1. 插入数据到表中:
```
INSERT INTO table_name [PARTITION (partition_column = partition_value, ...)]
[SELECT ...]
```
示例:
```
INSERT INTO my_table
SELECT col1, col2, col3
FROM another_table
WHERE condition;
```
2. 插入数据到分区表中:
```
INSERT INTO table_name PARTITION (partition_column = partition_value, ...)
[SELECT ...]
```
示例:
```
INSERT INTO my_table PARTITION (dt = '2022-01-01')
SELECT col1, col2, col3
FROM another_table
WHERE condition;
```
3. 插入常量值到表中:
```
INSERT INTO table_name [PARTITION (partition_column = partition_value, ...)]
VALUES (value1, value2, ...)
```
示例:
```
INSERT INTO my_table
VALUES ('John', 25, 'Male');
```