Details
-
Bug
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
0.13.0
-
None
-
None
Description
The output of this command "describe extended" is missing the tableType: property for some tables. it is being truncated after "serialization.format= , field.delim="
The output for: describe extended hivesampletable is:
"Detailed Table Information Table(tableName:hivesampletable, dbName:default, owner:hdpinternaluser, createTime:1440859101, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:clientid, type:string, comment:null), FieldSchema(name:querytime, type:string, comment:null), FieldSchema(name:market, type:string, comment:null), FieldSchema(name:deviceplatform, type:string, comment:null), FieldSchema(name:devicemake, type:string, comment:null), FieldSchema(name:devicemodel, type:string, comment:null), FieldSchema(name:state, type:string, comment:null), FieldSchema(name:country, type:string, comment:null), FieldSchema(name:querydwelltime, type:double, comment:null), FieldSchema(name:sessionid, type:bigint, comment:null), FieldSchema(name:sessionpagevieworder, type:bigint, comment:null)], location:wasb://eddhivetest@eddhivetest.blob.core.windows.net/hive/warehouse/hivesampletable, 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:{serialization.format= , field.delim="
while the output for describe formatted hivesampletable is:
"# Detailed Table Information
Database: default
Owner: hdpinternaluser
CreateTime: Sat Aug 29 14:38:21 GMT 2015
LastAccessTime: UNKNOWN
Protect Mode: None
Retention: 0
Location: wasb://eddhivetest@eddhivetest.blob.core.windows.net/hive/warehouse/hivesampletable
Table Type: MANAGED_TABLE
Table Parameters:
COLUMN_STATS_ACCURATE true
numFiles 1
numRows 59793
rawDataSize 4895922
totalSize 5015508
transient_lastDdlTime 1441320153
- Storage Information
SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
InputFormat: org.apache.hadoop.mapred.TextInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Compressed: No
Num Buckets: -1
Bucket Columns: []
Sort Columns: []
Storage Desc Params:
field.delim \t
serialization.format \t "
I am using Azure HDInsight , which uses hive-0.13.0.2.1.15.1-0001