You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Aviv (JIRA)" <ji...@apache.org> on 2015/09/29 03:11:05 UTC
[jira] [Created] (HIVE-11986) describe extended command is missing
tableType, while describe formatted outputs it
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://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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)