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

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.4.1
    • Fix Version/s: 0.5.0
    • Component/s: Query Processor
    • Labels:
      None
    • Hadoop Flags:
      Reviewed
    • Release Note:
      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

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

              Dates

              • Created:
                Updated:
                Resolved: