Hey Manu,
the table exists in default database.
hive> use default;
OK
Time taken: 0.034 seconds
hive> show tables;
OK
customer1
Time taken: 0.034 seconds, Fetched: 1 row(s)
hive> describe customer1;
OK
id int
name string
city string
Time taken: 0.342 seconds, Fetched: 3 row(s)
hive> select count(*) from customer1;
Query ID = cloudera_20170912015757_ed855d4e-fb2e-49f6-91ec-13d15922d407
Total jobs = 1
Launching Job 1 out of 1
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>
Starting Job = job_1505161189626_0001, Tracking URL = http://quickstart.cloudera:8088/proxy/application_1505161189626_0001/
Kill Command = /usr/lib/hadoop/bin/hadoop job -kill job_1505161189626_0001
Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 1
2017-09-12 01:57:20,277 Stage-1 map = 0%, reduce = 0%
2017-09-12 01:57:31,879 Stage-1 map = 100%, reduce = 0%, Cumulative CPU 1.99 sec
2017-09-12 01:57:44,178 Stage-1 map = 100%, reduce = 100%, Cumulative CPU 4.73 sec
MapReduce Total cumulative CPU time: 4 seconds 730 msec
Ended Job = job_1505161189626_0001
MapReduce Jobs Launched:
Stage-Stage-1: Map: 1 Reduce: 1 Cumulative CPU: 4.73 sec HDFS Read: 7132 HDFS Write: 2 SUCCESS
Total MapReduce CPU Time Spent: 4 seconds 730 msec
OK
4
Time taken: 45.104 seconds, Fetched: 1 row(s)
