Saving all output to "!!{outputDirectory}!!/show_tablestatus.q.raw". Enter "record" with no arguments to stop it. >>> !run !!{qFileDirectory}!!/show_tablestatus.q >>> EXPLAIN SHOW TABLE EXTENDED IN default LIKE `src`; 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_SHOW_TABLESTATUS `src` default)' '' 'STAGE DEPENDENCIES:' ' Stage-0 is a root stage' ' Stage-1 is a root stage' '' 'STAGE PLANS:' ' Stage: Stage-0' '' ' Stage: Stage-1' ' Fetch Operator' ' limit: -1' '' '' 15 rows selected >>> >>> SHOW TABLE EXTENDED IN default LIKE `src`; 'tab_name' No rows selected >>> >>> SHOW TABLE EXTENDED from default LIKE `src`; 'tab_name' No rows selected >>> >>> SHOW TABLE EXTENDED LIKE `src`; 'tab_name' 'tableName:src' 'owner:!!{user.name}!!' 'location:!!{hive.metastore.warehouse.dir}!!/show_tablestatus.db/src' 'inputformat:org.apache.hadoop.mapred.TextInputFormat' 'outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' 'columns:struct columns { string key, string value}' 'partitioned:false' 'partitionColumns:' 'totalNumberFiles:1' 'totalFileSize:5812' 'maxFileSize:5812' 'minFileSize:5812' 'lastAccessTime:0' 'lastUpdateTime:!!UNIXTIMEMILLIS!!' '' 15 rows selected >>> >>> SHOW TABLE EXTENDED LIKE `src.?`; 'tab_name' No rows selected >>> >>> SHOW TABLE EXTENDED from default LIKE `src.?`; 'tab_name' No rows selected >>> >>> SHOW TABLE EXTENDED LIKE `^s.*`; 'tab_name' No rows selected >>> >>> SHOW TABLE EXTENDED from default LIKE `^s.*`; 'tab_name' No rows selected >>> >>> SHOW TABLE EXTENDED LIKE `srcpart` PARTITION(ds='2008-04-08', hr=11); 'tab_name' 'tableName:srcpart' 'owner:!!{user.name}!!' 'location:!!{hive.metastore.warehouse.dir}!!/show_tablestatus.db/srcpart/ds=2008-04-08/hr=11' 'inputformat:org.apache.hadoop.mapred.TextInputFormat' 'outputformat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' 'columns:struct columns { string key, string value}' 'partitioned:true' 'partitionColumns:struct partition_columns { string ds, string hr}' 'totalNumberFiles:1' 'totalFileSize:5812' 'maxFileSize:5812' 'minFileSize:5812' 'lastAccessTime:0' 'lastUpdateTime:!!UNIXTIMEMILLIS!!' '' 15 rows selected >>> >>> SHOW TABLE EXTENDED from default LIKE src; 'tab_name' No rows selected >>> !record