hive> use hive ;
OK
Time taken: 0.024 seconds
hive> show tables;
OK
Time taken: 0.057 seconds
hive> create table if not exists student(id int,name string,gender string, age int);
OK
Time taken: 2.353 seconds
hive> insert into student values(1,'xiaodou','B',28);
Query ID = appleyuchi_20180723151924_6c0d4df6-dc93-437c-ac57-369b1ae81f8b
Total jobs = 3
Launching Job 1 out of 3
Number of reduce tasks determined at compile time: 1
In order to change the average load for a reducer (in bytes):
set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
set mapreduce.job.reduces=<number>
Job running in-process (local Hadoop)
2018-07-23 15:19:34,222 Stage-1 map = 100%, reduce = 0%
2018-07-23 15:19:35,231 Stage-1 map = 100%, reduce = 100%
Ended Job = job_local987294937_0001
Stage-4 is selected by condition resolver.
Stage-3 is filtered out by condition resolver.
Stage-5 is filtered out by condition resolver.
Moving data to directory file:/user/hive/warehouse/hive.db/student/.hive-staging_hive_2018-07-23_15-19-24_550_1117852747909391579-1/-ext-10000
Loading data to table hive.student
MapReduce Jobs Launched:
Stage-Stage-1: HDFS Read: 0 HDFS Write: 0 SUCCESS
Total MapReduce CPU Time Spent: 0 msec
OK
Time taken: 11.673 seconds
hive> select * from student;
OK
1 xiaodou B 28
Time taken: 0.297 seconds, Fetched: 1 row(s
Hive添加+插入数据示例
最新推荐文章于 2024-08-13 23:22:16 发布