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=43&rev2=44 -------------------------------------------------- {{{ 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 TABLE EXTENDED will list information for all tables matching the given regular expression. Users can not use regular expression for table name if a partition specification is present. This command's output includes basic 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 instead of table's file system information. === Show Functions === {{{
