Aviv created HIVE-11986:
---------------------------
Summary: describe extended command is missing tableType, while
describe formatted outputs it
Key: HIVE-11986
URL: https://issues.apache.org/jira/browse/HIVE-11986
Project: Hive
Issue Type: Bug
Components: Hive, HiveServer2, Thrift API
Affects Versions: 0.13.0
Reporter: Aviv
Priority: Minor
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://eddhivet...@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://eddhivet...@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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
