Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The "Hive/LanguageManual/DDL" page has been changed by HeYongqiang. http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?action=diff&rev1=41&rev2=42 -------------------------------------------------- }}} SHOW PARTITIONS lists all the existing partitions for a given table. Partitions are listed in alphabetical order. + === Show Table/Partitions Extended=== + {{{ + SHOW TABLE EXTENDED [ IN|FROM database_name] LIKE identifier_with_wildcards [PARTITION(partition_desc)] + }}} + SHOW TABLE EXTENDED will list information for all the tables matching the given regular expression. If a partition specification is present, it will output table information plus given partition's file system information. Users can not use regular expression for table name if a partition specification is present. + This command's output includes table information and file system information like totalNumberFiles, totalFileSize, maxFileSize, minFileSize,lastAccessTime, and lastUpdateTime. If partition is present, it will output the given partition's file system information. + === Show Functions === {{{ SHOW FUNCTIONS "a.*"
