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