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.

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

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

New Contributor

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
Highlighted

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

Contributor

@Akshat Mathur

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

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

New Contributor

@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  

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

New Contributor

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