[
https://issues.apache.org/jira/browse/SQOOP-1334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14026284#comment-14026284
]
Souvik Bose commented on SQOOP-1334:
------------------------------------
Hi Venkat,
Please find below:
hdfs@ip-172-31-15-170:/home/ubuntu$ hcat -e "describe extended looqi_data"
Hive history
file=/tmp/hdfs/hive_job_log_852c034a-5ca4-4869-b54c-f1018d6051ef_1114093667.txt
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in
[jar:file:/opt/cloudera/parcels/CDH-4.4.0-1.cdh4.4.0.p0.39/lib/zookeeper/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/opt/cloudera/parcels/CDH-4.4.0-1.cdh4.4.0.p0.39/lib/hive/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
OK
time_stamp string from deserializer
hardware_status string from deserializer
original_body string from deserializer
software_version string from deserializer
looqiid string from deserializer
longitude string from deserializer
battery_voltage string from deserializer
latitude string from deserializer
original_filename string from deserializer
Detailed Table Information Table(tableName:looqi_data, dbName:default,
owner:hdfs, createTime:1400837765, lastAccessTime:0, retention:0,
sd:StorageDescriptor(cols:[FieldSchema(name:time_stamp, type:string,
comment:null), FieldSchema(name:hardware_status, type:string, comment:null),
FieldSchema(name:original_body, type:string, comment:null),
FieldSchema(name:software_version, type:string, comment:null),
FieldSchema(name:looqiid, type:string, comment:null),
FieldSchema(name:longitude, type:string, comment:null),
FieldSchema(name:battery_voltage, type:string, comment:null),
FieldSchema(name:latitude, type:string, comment:null),
FieldSchema(name:original_filename, type:string, comment:null)],
location:hdfs://ip-172-31-15-170.eu-west-1.compute.internal:8020/user/flume/gpslog/looqi_data,
inputFormat:org.apache.hadoop.mapred.TextInputFormat,
outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat,
compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null,
serializationLib:org.apache.hadoop.hive.contrib.serde2.JsonSerde,
parameters:{serialization.format=1}), bucketCols:[], sortCols:[],
parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[],
skewedColValueLocationMaps:{}), storedAsSubDirectories:false),
partitionKeys:[], parameters:{EXTERNAL=TRUE, transient_lastDdlTime=1400837765},
viewOriginalText:null, viewExpandedText:null, tableType:EXTERNAL_TABLE)
Time taken: 2.245 seconds
> Sqoop Hcatalog export failed with exception of Failed to load foster storage
> handler during map reduce
> ------------------------------------------------------------------------------------------------------
>
> Key: SQOOP-1334
> URL: https://issues.apache.org/jira/browse/SQOOP-1334
> Project: Sqoop
> Issue Type: Bug
> Components: hive-integration
> Affects Versions: 1.4.3
> Environment: CDH4.4.0 with cloudera manager.
> Reporter: Souvik Bose
> Priority: Blocker
> Labels: hcatalog, sqoop, storage-handler
> Attachments: Sqoop_Hcatalog_Export_Log_verbose.txt
>
>
> I tried to export a hive external table to mysql using sqoop hcatalog export
> command.
> sqoop export --connect jdbc:mysql://example.com:3306/demo1 --username
> demo-password demo1234 bd_sqoop1 --hcatalog-table test_data
> I have set the HCAT_HOME, HADOOP_CLASSPATH, HIVE_HOME and paths of Jars. Now
> the job is progressing upto the map reduce stage, but stops at map 0% reduce
> 0% with an exception as below:
> 14/06/04 13:27:21 INFO mapred.JobClient: Task Id :
> attempt_201406021302_0043_m_000002_1, Status : FAILED
> java.io.IOException: Error initializing HCat record reader
> at
> org.apache.sqoop.mapreduce.hcat.SqoopHCatRecordReader.initNextRecordReader(SqoopHCatRecordReader.java:146)
> at
> org.apache.sqoop.mapreduce.hcat.SqoopHCatRecordReader.<init>(SqoopHCatRecordReader.java:57)
> at
> org.apache.sqoop.mapreduce.hcat.SqoopHCatExportFormat.createRecordReader(SqoopHCatExportFormat.java:128)
> at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:644)
> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:330)
> at org.apache.hadoop.mapred.Child$4.run(Child.java:268)
> at java.security.AccessController.doPrivileged(Native Method)
> at javax.security.auth.Subject.doAs(Subject.java:396)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1408)
> at org.apache.hadoop.mapred.Child.main(Child.java:262)
> Caused by: java.io.IOException: Failed to load foster storage handler
> at
> org.apache.hcatalog.common.HCatUtil.getStorageHandler(HCatUtil.java:416)
> at org.apache.hcatalog.common.HCatUtil.getStorageHandl
--
This message was sent by Atlassian JIRA
(v6.2#6252)
