PREHOOK: query: create table temp_null(a int) stored as textfile PREHOOK: type: CREATETABLE POSTHOOK: query: create table temp_null(a int) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@temp_null PREHOOK: query: load data local inpath '../data/files/test.dat' overwrite into table temp_null PREHOOK: type: LOAD PREHOOK: Output: default@temp_null POSTHOOK: query: load data local inpath '../data/files/test.dat' overwrite into table temp_null POSTHOOK: type: LOAD POSTHOOK: Output: default@temp_null PREHOOK: query: select null, null from temp_null PREHOOK: type: QUERY PREHOOK: Input: default@temp_null #### A masked pattern was here #### POSTHOOK: query: select null, null from temp_null POSTHOOK: type: QUERY POSTHOOK: Input: default@temp_null #### A masked pattern was here #### NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL PREHOOK: query: create table tt(a int, b string) PREHOOK: type: CREATETABLE POSTHOOK: query: create table tt(a int, b string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@tt PREHOOK: query: insert overwrite table tt select null, null from temp_null PREHOOK: type: QUERY PREHOOK: Input: default@temp_null PREHOOK: Output: default@tt POSTHOOK: query: insert overwrite table tt select null, null from temp_null POSTHOOK: type: QUERY POSTHOOK: Input: default@temp_null POSTHOOK: Output: default@tt POSTHOOK: Lineage: tt.a EXPRESSION [] POSTHOOK: Lineage: tt.b SIMPLE [] PREHOOK: query: select * from tt PREHOOK: type: QUERY PREHOOK: Input: default@tt #### A masked pattern was here #### POSTHOOK: query: select * from tt POSTHOOK: type: QUERY POSTHOOK: Input: default@tt #### A masked pattern was here #### POSTHOOK: Lineage: tt.a EXPRESSION [] POSTHOOK: Lineage: tt.b SIMPLE [] NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL PREHOOK: query: create table tt_b(a int, b string) row format serde "org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe" PREHOOK: type: CREATETABLE POSTHOOK: query: create table tt_b(a int, b string) row format serde "org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe" POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@tt_b POSTHOOK: Lineage: tt.a EXPRESSION [] POSTHOOK: Lineage: tt.b SIMPLE [] PREHOOK: query: insert overwrite table tt_b select null, null from temp_null PREHOOK: type: QUERY PREHOOK: Input: default@temp_null PREHOOK: Output: default@tt_b POSTHOOK: query: insert overwrite table tt_b select null, null from temp_null POSTHOOK: type: QUERY POSTHOOK: Input: default@temp_null POSTHOOK: Output: default@tt_b POSTHOOK: Lineage: tt.a EXPRESSION [] POSTHOOK: Lineage: tt.b SIMPLE [] POSTHOOK: Lineage: tt_b.a EXPRESSION [] POSTHOOK: Lineage: tt_b.b EXPRESSION [] PREHOOK: query: select * from tt_b PREHOOK: type: QUERY PREHOOK: Input: default@tt_b #### A masked pattern was here #### POSTHOOK: query: select * from tt_b POSTHOOK: type: QUERY POSTHOOK: Input: default@tt_b #### A masked pattern was here #### POSTHOOK: Lineage: tt.a EXPRESSION [] POSTHOOK: Lineage: tt.b SIMPLE [] POSTHOOK: Lineage: tt_b.a EXPRESSION [] POSTHOOK: Lineage: tt_b.b EXPRESSION [] NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL PREHOOK: query: insert overwrite directory "../build/ql/test/data/warehouse/null_columns.out" select null, null from temp_null PREHOOK: type: QUERY PREHOOK: Input: default@temp_null PREHOOK: Output: ../build/ql/test/data/warehouse/null_columns.out POSTHOOK: query: insert overwrite directory "../build/ql/test/data/warehouse/null_columns.out" select null, null from temp_null POSTHOOK: type: QUERY POSTHOOK: Input: default@temp_null POSTHOOK: Output: ../build/ql/test/data/warehouse/null_columns.out POSTHOOK: Lineage: tt.a EXPRESSION [] POSTHOOK: Lineage: tt.b SIMPLE [] POSTHOOK: Lineage: tt_b.a EXPRESSION [] POSTHOOK: Lineage: tt_b.b EXPRESSION [] \N\N \N\N \N\N \N\N \N\N \N\N PREHOOK: query: create table temp_null2 (key string, value string) partitioned by (ds string) PREHOOK: type: CREATETABLE POSTHOOK: query: create table temp_null2 (key string, value string) partitioned by (ds string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: default@temp_null2 POSTHOOK: Lineage: tt.a EXPRESSION [] POSTHOOK: Lineage: tt.b SIMPLE [] POSTHOOK: Lineage: tt_b.a EXPRESSION [] POSTHOOK: Lineage: tt_b.b EXPRESSION [] PREHOOK: query: insert overwrite table temp_null2 partition(ds='2010-04-01') select '1',NULL from src limit 1 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@temp_null2@ds=2010-04-01 POSTHOOK: query: insert overwrite table temp_null2 partition(ds='2010-04-01') select '1',NULL from src limit 1 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@temp_null2@ds=2010-04-01 POSTHOOK: Lineage: temp_null2 PARTITION(ds=2010-04-01).key SIMPLE [] POSTHOOK: Lineage: temp_null2 PARTITION(ds=2010-04-01).value SIMPLE [] POSTHOOK: Lineage: tt.a EXPRESSION [] POSTHOOK: Lineage: tt.b SIMPLE [] POSTHOOK: Lineage: tt_b.a EXPRESSION [] POSTHOOK: Lineage: tt_b.b EXPRESSION [] PREHOOK: query: select * from temp_null2 where ds is not null PREHOOK: type: QUERY PREHOOK: Input: default@temp_null2@ds=2010-04-01 #### A masked pattern was here #### POSTHOOK: query: select * from temp_null2 where ds is not null POSTHOOK: type: QUERY POSTHOOK: Input: default@temp_null2@ds=2010-04-01 #### A masked pattern was here #### POSTHOOK: Lineage: temp_null2 PARTITION(ds=2010-04-01).key SIMPLE [] POSTHOOK: Lineage: temp_null2 PARTITION(ds=2010-04-01).value SIMPLE [] POSTHOOK: Lineage: tt.a EXPRESSION [] POSTHOOK: Lineage: tt.b SIMPLE [] POSTHOOK: Lineage: tt_b.a EXPRESSION [] POSTHOOK: Lineage: tt_b.b EXPRESSION [] 1 NULL 2010-04-01