Saving all output to "!!{outputDirectory}!!/stats9.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/stats9.q
>>>  set datanucleus.cache.collections=false;
No rows affected 
>>>  set hive.stats.autogather=false;
No rows affected 
>>>  
>>>  create table analyze_srcbucket like srcbucket;
No rows affected 
>>>  insert overwrite table analyze_srcbucket select * from srcbucket;
'key','value'
No rows selected 
>>>  
>>>  explain analyze table analyze_srcbucket compute statistics;
'Explain'
'ABSTRACT SYNTAX TREE:'
'  (TOK_ANALYZE (TOK_TAB (TOK_TABNAME analyze_srcbucket)))'
''
'STAGE DEPENDENCIES:'
'  Stage-0 is a root stage'
'  Stage-1 depends on stages: Stage-0'
''
'STAGE PLANS:'
'  Stage: Stage-0'
'    Map Reduce'
'      Alias -> Map Operator Tree:'
'        analyze_srcbucket '
'          TableScan'
'            alias: analyze_srcbucket'
''
'  Stage: Stage-1'
'    Stats-Aggr Operator'
''
''
19 rows selected 
>>>  analyze table analyze_srcbucket compute statistics;
'key','value'
No rows selected 
>>>  describe formatted analyze_srcbucket;
'col_name','data_type','comment'
'# col_name            ','data_type           ','comment             '
'','',''
'key                 ','int                 ','None                '
'value               ','string              ','None                '
'','',''
'# Detailed Table Information','',''
'Database:           ','stats9              ',''
'Owner:              ','!!{user.name}!!                ',''
'CreateTime:         ','!!TIMESTAMP!!',''
'LastAccessTime:     ','UNKNOWN             ',''
'Protect Mode:       ','None                ',''
'Retention:          ','0                   ',''
'Location:           ','!!{hive.metastore.warehouse.dir}!!/stats9.db/analyze_srcbucket',''
'Table Type:         ','MANAGED_TABLE       ',''
'Table Parameters:','',''
'','numFiles            ','1                   '
'','numPartitions       ','0                   '
'','numRows             ','1000                '
'','rawDataSize         ','10603               '
'','totalSize           ','11603               '
'','transient_lastDdlTime','!!UNIXTIME!!          '
'','',''
'# Storage Information','',''
'SerDe Library:      ','org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe',''
'InputFormat:        ','org.apache.hadoop.mapred.TextInputFormat',''
'OutputFormat:       ','org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat',''
'Compressed:         ','No                  ',''
'Num Buckets:        ','2                   ',''
'Bucket Columns:     ','[key]               ',''
'Sort Columns:       ','[]                  ',''
'Storage Desc Params:','',''
'','serialization.format','1                   '
32 rows selected 
>>>  !record