Created 03-02-2018 05:57 PM
when I run any query with explain on my table A (Hive 0.13). Below is a snapshot of result after a simple select query.
STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 is a root stage STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: temp_segments Statistics: Num rows: ****** Data size: ****** Basic stats: COMPLETE Column stats: NONE Select Operator expressions: column1 (type: string) outputColumnNames: _col0 Statistics: Num rows: ****** Data size: ****** Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: true Statistics: Num rows: ****** Data size: ****** Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator limit: -1
The table is in ORC for sure (verified). But here it is showing that table is text file. Any idea why is this there?
Created 03-06-2018 03:17 AM
Can you share the complete query and desc extended for the table.
Created 03-08-2018 08:38 AM
The qurey was a simple select a column query based on age.
# Detailed Table Information Database: a0m01lf Owner: cbb_interactions CreateTime: Thu Mar 01 01:20:27 PST 2018 LastAccessTime: UNKNOWN Protect Mode: None Retention: 0 Location: maprfs:/hive/a0m01lf.db/temp_segments Table Type: MANAGED_TABLE Table Parameters: last_modified_by a0m01lf last_modified_time 1519896138 transient_lastDdlTime 1519896138 # Storage Information SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat Compressed: No Num Buckets: -1 Bucket Columns: [] Sort Columns: [] Storage Desc Params: serialization.format 1
Created 06-12-2019 11:50 PM
@Akshat Mathur Did you ever get this resolved? I'm facing the same issue.