Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-11986

describe extended command is missing tableType, while describe formatted outputs it

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 0.13.0
    • None
    • Hive, HiveServer2, Thrift API
    • 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

      1. 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

      Attachments

        Activity

          People

            Unassigned Unassigned
            avivp Aviv
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: