Saving all output to "!!{outputDirectory}!!/keyword_1.q.raw". Enter "record" with no arguments to stop it. >>> !run !!{qFileDirectory}!!/keyword_1.q >>> create table test_user (user string, `group` string); No rows affected >>> grant select on table test_user to user hive_test; No rows affected >>> >>> explain select user from test_user; 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME test_user))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL user)))))' '' '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:' ' test_user ' ' TableScan' ' alias: test_user' ' Select Operator' ' expressions:' ' expr: user' ' type: string' ' 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' '' '' 31 rows selected >>> >>> show grant user hive_test on table test_user; No rows affected >>> >>> drop table test_user; No rows affected >>> >>> create table test_user (role string, `group` string); No rows affected >>> grant select on table test_user to user hive_test; No rows affected >>> >>> explain select role from test_user; 'Explain' 'ABSTRACT SYNTAX TREE:' ' (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME test_user))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL role)))))' '' '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:' ' test_user ' ' TableScan' ' alias: test_user' ' Select Operator' ' expressions:' ' expr: role' ' type: string' ' 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' '' '' 31 rows selected >>> >>> show grant user hive_test on table test_user; No rows affected >>> >>> drop table test_user; No rows affected >>> !record