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加上也没用的。
求解