表结构
create table tableName
(
field1 string,
field2 string,
field3 string,
field4 string,
field5 string
)
插入hive中使用的格式如下:
- 插入一行(不带字段名)
insert into tableName values(‘x1’,‘x2’,‘x3’,‘x4’,‘x5’) - 插入一行(带字段名)
insert into tableName(field1,field2,field3,field4,field5) values(‘x1’,‘x2’,‘x3’,‘x4’,‘x5’) - 插入多行(不带字段名)
insert into tableName values
(‘x1’,‘x2’,‘x3’,‘x4’,‘x5’),
(‘o1’,‘o2’,‘o3’,‘o4’,‘o5’); - 插入多行(带字段名)
insert into tableName(field1,field2) values
(‘x1’,‘x2’,‘x3’,‘x4’,‘x5’),
(‘o1’,‘o2’,‘o3’,‘o4’,‘o5’);
遇到的问题
FAILED: SemanticException 1:46 ‘[field1, field2]’ in insert schema specification are not found among regular columns of databasesName.tableName nor dynamic partition columns… Error encountered near token ‘field2’
解决办法:
原sql
insert into tableName(Field1,Field2) values(‘x1’,‘x2’)
将sql中字段名改为小写
insert into tableName(field1,field2) values(‘x1’,‘x2’)