PREHOOK: query: EXPLAIN
FROM src_thrift
SELECT src_thrift.mstringstring['key_9'], lintstring.myint
WHERE src_thrift.mstringstring['key_9'] IS NOT NULL
      AND lintstring.myint IS NOT NULL
      AND lintstring IS NOT NULL
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
FROM src_thrift
SELECT src_thrift.mstringstring['key_9'], lintstring.myint
WHERE src_thrift.mstringstring['key_9'] IS NOT NULL
      AND lintstring.myint IS NOT NULL
      AND lintstring IS NOT NULL
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_thrift))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR ([ (. (TOK_TABLE_OR_COL src_thrift) mstringstring) 'key_9')) (TOK_SELEXPR (. (TOK_TABLE_OR_COL lintstring) myint))) (TOK_WHERE (AND (AND (TOK_FUNCTION TOK_ISNOTNULL ([ (. (TOK_TABLE_OR_COL src_thrift) mstringstring) 'key_9')) (TOK_FUNCTION TOK_ISNOTNULL (. (TOK_TABLE_OR_COL lintstring) myint))) (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL lintstring))))))

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_thrift 
          TableScan
            alias: src_thrift
            Filter Operator
              predicate:
                  expr: ((mstringstring['key_9'] is not null and lintstring.myint is not null) and lintstring is not null)
                  type: boolean
              Select Operator
                expressions:
                      expr: mstringstring['key_9']
                      type: string
                      expr: lintstring.myint
                      type: array<int>
                outputColumnNames: _col0, _col1
                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: FROM src_thrift
SELECT src_thrift.mstringstring['key_9'], lintstring.myint
WHERE src_thrift.mstringstring['key_9'] IS NOT NULL
      OR lintstring.myint IS NOT NULL
      OR lintstring IS NOT NULL
PREHOOK: type: QUERY
PREHOOK: Input: default@src_thrift
PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-01-00_810_1828416109534074477/-mr-10000
POSTHOOK: query: FROM src_thrift
SELECT src_thrift.mstringstring['key_9'], lintstring.myint
WHERE src_thrift.mstringstring['key_9'] IS NOT NULL
      OR lintstring.myint IS NOT NULL
      OR lintstring IS NOT NULL
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_thrift
POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-01-00_810_1828416109534074477/-mr-10000
NULL	[0]
NULL	[1]
NULL	[4]
NULL	[9]
NULL	[16]
NULL	[25]
NULL	[36]
NULL	[49]
NULL	[64]
value_9	[81]
PREHOOK: query: EXPLAIN
FROM src_thrift
SELECT src_thrift.mstringstring['key_9'], lintstring.myint
WHERE src_thrift.mstringstring['key_9'] IS NOT NULL
      AND lintstring.myint IS NOT NULL
      AND lintstring IS NOT NULL
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN
FROM src_thrift
SELECT src_thrift.mstringstring['key_9'], lintstring.myint
WHERE src_thrift.mstringstring['key_9'] IS NOT NULL
      AND lintstring.myint IS NOT NULL
      AND lintstring IS NOT NULL
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src_thrift))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR ([ (. (TOK_TABLE_OR_COL src_thrift) mstringstring) 'key_9')) (TOK_SELEXPR (. (TOK_TABLE_OR_COL lintstring) myint))) (TOK_WHERE (AND (AND (TOK_FUNCTION TOK_ISNOTNULL ([ (. (TOK_TABLE_OR_COL src_thrift) mstringstring) 'key_9')) (TOK_FUNCTION TOK_ISNOTNULL (. (TOK_TABLE_OR_COL lintstring) myint))) (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL lintstring))))))

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_thrift 
          TableScan
            alias: src_thrift
            Filter Operator
              predicate:
                  expr: ((mstringstring['key_9'] is not null and lintstring.myint is not null) and lintstring is not null)
                  type: boolean
              Select Operator
                expressions:
                      expr: mstringstring['key_9']
                      type: string
                      expr: lintstring.myint
                      type: array<int>
                outputColumnNames: _col0, _col1
                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: FROM src_thrift
SELECT src_thrift.mstringstring['key_9'], lintstring.myint
WHERE src_thrift.mstringstring['key_9'] IS NOT NULL
      OR lintstring.myint IS NOT NULL
      OR lintstring IS NOT NULL
PREHOOK: type: QUERY
PREHOOK: Input: default@src_thrift
PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-01-04_306_7791720421361758230/-mr-10000
POSTHOOK: query: FROM src_thrift
SELECT src_thrift.mstringstring['key_9'], lintstring.myint
WHERE src_thrift.mstringstring['key_9'] IS NOT NULL
      OR lintstring.myint IS NOT NULL
      OR lintstring IS NOT NULL
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src_thrift
POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-01-04_306_7791720421361758230/-mr-10000
NULL	[0]
NULL	[1]
NULL	[4]
NULL	[9]
NULL	[16]
NULL	[25]
NULL	[36]
NULL	[49]
NULL	[64]
value_9	[81]