Support Questions

Find answers, ask questions, and share your expertise

Table (in ORC) format showing as text file when running explain query?

Explorer

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?

3 REPLIES 3

Rising Star

@Akshat Mathur

Can you share the complete query and desc extended for the table.

Explorer

@rtrivedi

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  

New Contributor

@Akshat Mathur Did you ever get this resolved? I'm facing the same issue.