PREHOOK: query: DESCRIBE FUNCTION isnull PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION isnull POSTHOOK: type: DESCFUNCTION isnull a - Returns true if a is NULL and false otherwise PREHOOK: query: DESCRIBE FUNCTION EXTENDED isnull PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION EXTENDED isnull POSTHOOK: type: DESCFUNCTION isnull a - Returns true if a is NULL and false otherwise PREHOOK: query: DESCRIBE FUNCTION isnotnull PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION isnotnull POSTHOOK: type: DESCFUNCTION isnotnull a - Returns true if a is not NULL and false otherwise PREHOOK: query: DESCRIBE FUNCTION EXTENDED isnotnull PREHOOK: type: DESCFUNCTION POSTHOOK: query: DESCRIBE FUNCTION EXTENDED isnotnull POSTHOOK: type: DESCFUNCTION isnotnull a - Returns true if a is not NULL and false otherwise PREHOOK: query: EXPLAIN SELECT NULL IS NULL, 1 IS NOT NULL, 'my string' IS NOT NULL FROM src WHERE true IS NOT NULL LIMIT 1 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT NULL IS NULL, 1 IS NOT NULL, 'my string' IS NOT NULL FROM src WHERE true IS NOT NULL LIMIT 1 POSTHOOK: type: QUERY ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION TOK_ISNULL TOK_NULL)) (TOK_SELEXPR (TOK_FUNCTION TOK_ISNOTNULL 1)) (TOK_SELEXPR (TOK_FUNCTION TOK_ISNOTNULL 'my string'))) (TOK_WHERE (TOK_FUNCTION TOK_ISNOTNULL true)) (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 Filter Operator predicate: expr: true is not null type: boolean Filter Operator predicate: expr: true is not null type: boolean Select Operator expressions: expr: null is null type: boolean expr: 1 is not null type: boolean expr: 'my string' is not null 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 NULL IS NULL, 1 IS NOT NULL, 'my string' IS NOT NULL FROM src WHERE true IS NOT NULL LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1963364824/10000 POSTHOOK: query: SELECT NULL IS NULL, 1 IS NOT NULL, 'my string' IS NOT NULL FROM src WHERE true IS NOT NULL LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/1963364824/10000 true true true PREHOOK: query: EXPLAIN FROM src_thrift SELECT src_thrift.lint IS NOT NULL, src_thrift.lintstring IS NOT NULL, src_thrift.mstringstring IS NOT NULL WHERE src_thrift.lint IS NOT NULL AND NOT (src_thrift.mstringstring IS NULL) LIMIT 1 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN FROM src_thrift SELECT src_thrift.lint IS NOT NULL, src_thrift.lintstring IS NOT NULL, src_thrift.mstringstring IS NOT NULL WHERE src_thrift.lint IS NOT NULL AND NOT (src_thrift.mstringstring IS NULL) LIMIT 1 POSTHOOK: type: QUERY ABSTRACT SYNTAX TREE: (TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION TOK_ISNOTNULL (. (TOK_TABLE_OR_COL src_thrift) lint))) (TOK_SELEXPR (TOK_FUNCTION TOK_ISNOTNULL (. (TOK_TABLE_OR_COL src_thrift) lintstring))) (TOK_SELEXPR (TOK_FUNCTION TOK_ISNOTNULL (. (TOK_TABLE_OR_COL src_thrift) mstringstring)))) (TOK_WHERE (AND (TOK_FUNCTION TOK_ISNOTNULL (. (TOK_TABLE_OR_COL src_thrift) lint)) (NOT (TOK_FUNCTION TOK_ISNULL (. (TOK_TABLE_OR_COL src_thrift) mstringstring))))) (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_thrift TableScan alias: src_thrift Filter Operator predicate: expr: (lint is not null and (not mstringstring is null)) type: boolean Filter Operator predicate: expr: (lint is not null and (not mstringstring is null)) type: boolean Select Operator expressions: expr: lint is not null type: boolean expr: lintstring is not null type: boolean expr: mstringstring is not null 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: FROM src_thrift SELECT src_thrift.lint IS NOT NULL, src_thrift.lintstring IS NOT NULL, src_thrift.mstringstring IS NOT NULL WHERE src_thrift.lint IS NOT NULL AND NOT (src_thrift.mstringstring IS NULL) LIMIT 1 PREHOOK: type: QUERY PREHOOK: Input: default@src_thrift PREHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/609638755/10000 POSTHOOK: query: FROM src_thrift SELECT src_thrift.lint IS NOT NULL, src_thrift.lintstring IS NOT NULL, src_thrift.mstringstring IS NOT NULL WHERE src_thrift.lint IS NOT NULL AND NOT (src_thrift.mstringstring IS NULL) LIMIT 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src_thrift POSTHOOK: Output: file:/Users/carl/Projects/hd9/hive-trunk/build/ql/tmp/609638755/10000 true true true