#Data I'm using
ID,fname,lname,age,Career
4000001,Kristina,Chung,55,Pilot
4000002,Paige,Chen,74,Teacher
4000003,Sherri,Melton,34,Firefighter
4000004,Gretchen,Hill,66,Computer hardware engineer
4000005,Karen,Puckett,74,Lawyer
4000006,Patrick,Song,42,Veterinarian
4000007,Elsie,Hamilton,43,Pilot
# Table Creation:
hive> create table foo(id string,fname string,lname string,age string,career string)
> ROW FORMAT DELIMITED
> FIELDS TERMINATED BY ' ';
# Copying Data:
hive> load data inpath '/API/demo1/customers.txt' overwrite into table foo;
Loading data to table default.foo
Deleted hdfs://172.16.56.136:10001/user/hive/warehouse/foo
Table default.foo stats: [num_partitions: 0, num_files: 1, num_rows: 0, total_size: 554, raw_data_size: 0]
OK
Time taken: 0.282 seconds
# Conversion
create table Jac(id string,fname string,lname string,age string,career string)
> STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
> WITH SERDEPROPERTIES ('hbase.columns.mapping' = ':key,cf1:fname,cf1:lname,cf1:age,cf1:career')
> TBLPROPERTIES('hbase.table.name' = 'j'); #error:
hive> INSERT OVERWRITE TABLE Jac SELECT * FROM foo;
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_201512091118_0019, Tracking URL = http://172.16.56.136:50030/jobdetails.jsp?jobid=j...
Kill Command = /usr/local/hadoop/libexec/../bin/hadoop job -kill job_201512091118_0019
Hadoop job information for Stage-0: number of mappers: 1; number of reducers: 0
2015-12-24 16:11:27,258 Stage-0 map = 0%, reduce = 0%
2015-12-24 16:11:44,312 Stage-0 map = 100%, reduce = 100%
Ended Job = job_201512091118_0019 with errors
Error during job, obtaining debugging information...
Job Tracking URL: http://172.16.56.136:50030/jobdetails.jsp?jobid=j...
Examining task ID: task_201512091118_0019_m_000002 (and more) from job job_201512091118_0019
Exception in thread "Thread-90" java.lang.RuntimeException: Error while reading from task log url
at org.apache.hadoop.hive.ql.exec.errors.TaskLogProcessor.getStackTraces(TaskLogProcessor.java:247)
at org.apache.hadoop.hive.ql.exec.JobDebugger.showJobFailDebugInfo(JobDebugger.java:285)
at org.apache.hadoop.hive.ql.exec.JobDebugger.run(JobDebugger.java:118)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.io.FileNotFoundException: http://hadoop:50060/tasklog?attemptid=attempt_201...
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1626)
at java.net.URL.openStream(URL.java:1041)
at org.apache.hadoop.hive.ql.exec.errors.TaskLogProcessor.getStackTraces(TaskLogProcessor.java:198)
... 3 more
FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
MapReduce Jobs Launched:
Job 0: Map: 1 HDFS Read: 0 HDFS Write: 0 FAIL
Total MapReduce CPU Time Spent: 0 msec
