Tuesday 12 July 2022

HIVE: describe extended table_name: Get extended table information

Syntax

describe extended table_name

 

Above statement return the extended table information.

hive> describe extended employee;
OK
id                    int                                       
name                  string                                    
hobbies               array<string>                             
technology_experience map<string,string>                        
gender_age            struct<gender:string,age:int>                     
     
Detailed Table Information  Table(tableName:employee, dbName:default, owner:krishna, createTime:1610699458, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:id, type:int, comment:null), FieldSchema(name:name, type:string, comment:null), FieldSchema(name:hobbies, type:array<string>, comment:null), FieldSchema(name:technology_experience, type:map<string,string>, comment:null), FieldSchema(name:gender_age, type:struct<gender:string,age:int>, comment:null)], location:hdfs://localhost:9000/user/hive/warehouse/employee, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{mapkey.delim=:, collection.delim=,, serialization.format=|, field.delim=|}), bucketCols:[], sortCols:[], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{}), storedAsSubDirectories:false), partitionKeys:[], parameters:{totalSize=0, numRows=0, rawDataSize=0, COLUMN_STATS_ACCURATE={\"BASIC_STATS\":\"true\",\"COLUMN_STATS\":{\"gender_age\":\"true\",\"hobbies\":\"true\",\"id\":\"true\",\"name\":\"true\",\"technology_experience\":\"true\"}}, numFiles=0, transient_lastDdlTime=1610699458, bucketing_version=2}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE, rewriteEnabled:false, catName:hive, ownerType:USER)  
Time taken: 0.072 seconds, Fetched: 7 row(s)

 

  

Previous                                                    Next                                                    Home

No comments:

Post a Comment