hive 指定字段插入数据_① hive 不支持“insert into” ? ② hive的命令行中,使用insert into时,如何指定字段?...

Hive Session ID = 5ff46ac5-7b4a-4d92-b1fa-a9e7b53ad1e0

hive> use test;

OK

Time taken: 0.429 seconds

hive> CREATE TABLE students (name VARCHAR(64), age INT, gpa DECIMAL(3,2)) CLUSTERED BY (age) INTO 2 BUCKETS STORED AS ORC;

OK

Time taken: 1.015 seconds

hive> INSERT INTO TABLE students VALUES ('fred flintstone', 35, 1.28), ('barney rubble', 32, 2.32);

Query ID = root_20191015142651_77d7f998-081a-49ce-abd3-8b927a9256ab

Total jobs = 2

Launching Job 1 out of 2

Number of reduce tasks determined at compile time: 2

In order to change the average load for a reducer (in bytes):

set hive.exec.reducers.bytes.per.reducer=

In order to limit the maximum number of reducers:

set hive.exec.reducers.max=

In order to set a constant number of reducers:

set mapreduce.job.reduces=

insert into values,卡住了。没办法插入。

hive:3.1.2

hadoop:3.2.1

这三个参数我在hive-site.xml加上也没用的。

求解

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值