Unable to work with SerDe in hive

#1

hive> describe extended emp01;
OK
id int
name string
sal int
moddate date

Detailed Table Information Table(tableName:emp01, dbName:sree, owner:jeevanthika, createTime:1562696414, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:id, type:int, comment:null), FieldSchema(name:name, type:string, comment:null), FieldSchema(name:sal, type:int, comment:null), FieldSchema(name:moddate, type:date, comment:null)], location:hdfs://nn01.itversity.com:8020/apps/hive/warehouse/sree.db/emp01, inputFormat:org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.avro.AvroSerDe, parameters:{serialization.format=, line.delim=
, field.delim=,}), bucketCols:[], sortCols:[], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{}), storedAsSubDirectories:false), partitionKeys:[], parameters:{transient_lastDdlTime=1562696475, totalSize=171, numRows=0, rawDataSize=0, numFiles=1}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
Time taken: 0.422 seconds, Fetched: 7 row(s)
hive> select * from emp01;
OK
Failed with exception java.io.IOException:java.io.IOException: Not a data file.

Not sure what serde names to be used for exploring different file formats. Can you please help me ?

0 Likes