PREHOOK: query: DESCRIBE FUNCTION in_file PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION in_file POSTHOOK: type: DESCFUNCTION in_file(str, filename) - Returns true if str appears in the file PREHOOK: query: EXPLAIN SELECT in_file("303", "../data/files/test2.dat"), in_file("304", "../data/files/test2.dat"), in_file(CAST(NULL AS STRING), "../data/files/test2.dat") FROM src LIMIT 1 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT in_file("303", "../data/files/test2.dat"), in_file("304", "../data/files/test2.dat"), in_file(CAST(NULL AS STRING), "../data/files/test2.dat") FROM src LIMIT 1 POSTHOOK: type: QUERY ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION in_file "303" "../data/files/test2.dat")) (TOK_SELEXPR (TOK_FUNCTION in_file "304" "../data/files/test2.dat")) (TOK_SELEXPR (TOK_FUNCTION in_file (TOK_FUNCTION TOK_STRING TOK_NULL) "../data/files/test2.dat"))) (TOK_LIMIT 1))) 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: src TableScan alias: src Select Operator expressions: expr: in_file('303', '../data/files/test2.dat') type: boolean expr: in_file('304', '../data/files/test2.dat') type: boolean expr: in_file(UDFToString(null), '../data/files/test2.dat') type: boolean outputColumnNames: _col0, _col1, _col2 Limit 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 PREHOOK: query: SELECT in_file("303", "../data/files/test2.dat"), in_file("304", "../data/files/test2.dat"), in_file(CAST(NULL AS STRING), "../data/files/test2.dat") FROM src LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: file:/var/folders/71/h_j6fpg10r33hvx1lcxlgttcw61_4s/T/jonchang/hive_2011-11-20_01-14-47_787_473222432824773238/-mr-10000 POSTHOOK: query: SELECT in_file("303", "../data/files/test2.dat"), in_file("304", "../data/files/test2.dat"), in_file(CAST(NULL AS STRING), "../data/files/test2.dat") FROM src LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: file:/var/folders/71/h_j6fpg10r33hvx1lcxlgttcw61_4s/T/jonchang/hive_2011-11-20_01-14-47_787_473222432824773238/-mr-10000 true false NULL