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

"show table extended like table partition(xxx) " will show the result of the whole table if the partition does not exist

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.4.1
    • 0.5.0
    • Query Processor
    • None
    • Reviewed
    • Hide
      HIVE-1072. Show table extended to error out when the partition does not exist. (Yongqiang He via zshao)
      Show
      HIVE-1072 . Show table extended to error out when the partition does not exist. (Yongqiang He via zshao)

    Description

      See the following example, we should output an error for the second command.

      hive> show table extended like member_count;
      OK
      tableName:member_count
      owner:null
      location:/user/hive/member_count
      inputformat:org.apache.hadoop.mapred.SequenceFileInputFormat
      outputformat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
      columns:struct columns { string count}
      partitioned:true
      partitionColumns:struct partition_columns { string ds}
      totalNumberFiles:233933
      totalFileSize:32802665
      maxFileSize:257
      minFileSize:140
      lastAccessTime:1264017438860
      lastUpdateTime:1263949909703
      
      Time taken: 125.104 seconds
      
      hive> show table extended like member_count partition(ds = '2009-10-11');
      OK
      tableName:member_count
      owner:null
      location:/user/hive/member_count
      inputformat:org.apache.hadoop.mapred.SequenceFileInputFormat
      outputformat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
      columns:struct columns { string count}
      partitioned:true
      partitionColumns:struct partition_columns { string ds}
      totalNumberFiles:233933
      totalFileSize:32802665
      maxFileSize:257
      minFileSize:140
      lastAccessTime:1264017438860
      lastUpdateTime:1263949909703
      
      Time taken: 24.618 seconds
      
      hive> show table extended like member_count partition(ds = '2009-12-11');
      OK
      tableName:member_count
      owner:null
      location:/user/hive/member_count
      inputformat:org.apache.hadoop.mapred.SequenceFileInputFormat
      outputformat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
      columns:struct columns { string count}
      partitioned:true
      partitionColumns:struct partition_columns { string ds}
      totalNumberFiles:3495
      totalFileSize:489417
      maxFileSize:257
      minFileSize:140
      lastAccessTime:1262676533852
      lastUpdateTime:1263949909703
      
      Time taken: 0.549 seconds
      

      Attachments

        1. hive-1072.2.patch
          2 kB
          He Yongqiang
        2. hive-1072.patch
          7 kB
          He Yongqiang

        Activity

          People

            he yongqiang He Yongqiang
            zshao Zheng Shao
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: