Saving all output to "!!{outputDirectory}!!/sample3.q.raw". Enter "record" with no arguments to stop it.
>>>  !run !!{qFileDirectory}!!/sample3.q
>>>  -- no input pruning, sample filter
>>>  EXPLAIN 
SELECT s.key 
FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 on key) s;
'Explain'
'ABSTRACT SYNTAX TREE:'
'  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME srcbucket) (TOK_TABLEBUCKETSAMPLE 1 5 (TOK_TABLE_OR_COL key)) s)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL s) key)))))'
''
'STAGE DEPENDENCIES:'
'  Stage-1 is a root stage'
'  Stage-0 is a root stage'
''
'STAGE PLANS:'
'  Stage: Stage-1'
'    Map Reduce'
'      Alias -> Map Operator Tree:'
'        s '
'          TableScan'
'            alias: s'
'            Filter Operator'
'              predicate:'
'                  expr: (((hash(key) & 2147483647) % 5) = 0)'
'                  type: boolean'
'              Select Operator'
'                expressions:'
'                      expr: key'
'                      type: int'
'                outputColumnNames: _col0'
'                File Output Operator'
'                  compressed: false'
'                  GlobalTableId: 0'
'                  table:'
'                      input format: org.apache.hadoop.mapred.TextInputFormat'
'                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
''
'  Stage: Stage-0'
'    Fetch Operator'
'      limit: -1'
''
''
35 rows selected 
>>>  
>>>  SELECT s.key 
FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 on key) s SORT BY key;
'key'
'0'
'0'
'0'
'0'
'0'
'5'
'5'
'5'
'5'
'10'
'10'
'15'
'15'
'15'
'15'
'20'
'20'
'20'
'30'
'30'
'35'
'35'
'35'
'35'
'35'
'35'
'40'
'40'
'50'
'60'
'65'
'65'
'65'
'70'
'70'
'70'
'70'
'75'
'80'
'80'
'85'
'85'
'90'
'90'
'90'
'95'
'95'
'100'
'100'
'100'
'100'
'105'
'105'
'105'
'110'
'120'
'120'
'120'
'125'
'125'
'125'
'135'
'135'
'135'
'140'
'145'
'150'
'155'
'160'
'160'
'165'
'165'
'165'
'170'
'170'
'175'
'175'
'175'
'175'
'180'
'185'
'190'
'195'
'195'
'200'
'200'
'205'
'205'
'205'
'215'
'230'
'230'
'230'
'230'
'230'
'235'
'235'
'240'
'245'
'245'
'255'
'255'
'260'
'260'
'260'
'265'
'265'
'265'
'275'
'275'
'275'
'280'
'280'
'285'
'285'
'295'
'295'
'300'
'300'
'305'
'305'
'310'
'310'
'310'
'310'
'315'
'325'
'325'
'330'
'335'
'335'
'335'
'340'
'345'
'355'
'355'
'360'
'360'
'365'
'375'
'375'
'375'
'375'
'375'
'375'
'385'
'385'
'390'
'390'
'390'
'395'
'395'
'395'
'395'
'400'
'405'
'410'
'415'
'425'
'430'
'430'
'430'
'430'
'435'
'435'
'440'
'440'
'450'
'450'
'455'
'455'
'455'
'460'
'470'
'470'
'475'
'475'
'480'
'480'
'480'
'480'
'480'
'485'
'485'
'485'
'490'
'490'
'495'
'495'
189 rows selected 
>>>  
>>>  !record