Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

ORC error : failed to execute select statement with following error message:

ORC error : failed to execute select statement with following error message:

New Contributor

Failed with exception java.io.IOException:java.io.IOException: Somehow read -1 bytes trying to skip 6257 more bytes t o seek to position 6708, size: 1290047

Does anyone has any idea about how to fix this ?

3 REPLIES 3
Highlighted

Re: ORC error : failed to execute select statement with following error message:

Rising Star

Can you post a "desc formatted" for the table?

Re: ORC error : failed to execute select statement with following error message:

New Contributor

Here is describe extended:

hive> describe extended h_estimate_orczlib;OKuserid varchar(15) apptypeid varchar(15) ts string power decimal(38,18) ds string # Partition Information # col_name data_type comment ds string Detailed Table Information Table(tableName:h_estimate_orczlib, dbName:umbrella, owner:Revan, createTime:1476180746, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:userid, type:varchar(15), comment:null), FieldSchema(name:apptypeid, type:varchar(15), comment:null), FieldSchema(name:ts, type:string, comment:null), FieldSchema(name:power, type:decimal(38,18), comment:null), FieldSchema(name:ds, type:string, comment:null)], location:gs://<BucketName>/HiveDB/umbrella/h_estimate_orczlib, inputFormat:org.apache.hadoop.hive.ql.io.orc.OrcInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.ql.io.orc.OrcSerde, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{}), storedAsSubDirectories:false), partitionKeys:[FieldSchema(name:ds, type:string, comment:null)], parameters:{orc.compress=ZLIB, transient_lastDdlTime=1476180746, comment=this}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)Time taken: 0.094 seconds, Fetched: 12 row(s)hive>

Re: ORC error : failed to execute select statement with following error message:

New Contributor

Here is describe extended:

hive> describe extended h_estimate_orczlib;OKuserid varchar(15) apptypeid varchar(15) ts string power decimal(38,18) ds string # Partition Information # col_name data_type comment ds string Detailed Table Information Table(tableName:h_estimate_orczlib, dbName:umbrella, owner:Revan, createTime:1476180746, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:userid, type:varchar(15), comment:null), FieldSchema(name:apptypeid, type:varchar(15), comment:null), FieldSchema(name:ts, type:string, comment:null), FieldSchema(name:power, type:decimal(38,18), comment:null), FieldSchema(name:ds, type:string, comment:null)], location:gs://<BucketName>/HiveDB/umbrella/h_estimate_orczlib, inputFormat:org.apache.hadoop.hive.ql.io.orc.OrcInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.ql.io.orc.OrcSerde, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{}), storedAsSubDirectories:false), partitionKeys:[FieldSchema(name:ds, type:string, comment:null)], parameters:{orc.compress=ZLIB, transient_lastDdlTime=1476180746, comment=this}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)Time taken: 0.094 seconds, Fetched: 12 row(s)hive>

Don't have an account?
Coming from Hortonworks? Activate your account here