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 Bug
    • Status: Closed
    • Priority: Major 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
      
      1. hive-1072.patch
        7 kB
        He Yongqiang
      2. hive-1072.2.patch
        2 kB
        He Yongqiang

        Activity

        No work has yet been logged on this issue.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development