PREHOOK: query: drop table temp_null
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table temp_null
POSTHOOK: type: DROPTABLE
PREHOOK: query: drop table tt
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table tt
POSTHOOK: type: DROPTABLE
PREHOOK: query: drop table tt_b
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table tt_b
POSTHOOK: type: DROPTABLE
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
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
PREHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-11-46_460_130526701412066561/10000
POSTHOOK: query: select null, null from temp_null
POSTHOOK: type: QUERY
POSTHOOK: Input: default@temp_null
POSTHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-11-46_460_130526701412066561/10000
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
PREHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-11-54_210_4646908468388375810/10000
POSTHOOK: query: select * from tt
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tt
POSTHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-11-54_210_4646908468388375810/10000
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
PREHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-11-58_088_4831793622839318296/10000
POSTHOOK: query: select * from tt_b
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tt_b
POSTHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-11-58_088_4831793622839318296/10000
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: drop table temp_null2
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table temp_null2
POSTHOOK: type: DROPTABLE
POSTHOOK: Lineage: tt.a EXPRESSION []
POSTHOOK: Lineage: tt.b SIMPLE []
POSTHOOK: Lineage: tt_b.a EXPRESSION []
POSTHOOK: Lineage: tt_b.b EXPRESSION []
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
PREHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-12-05_597_2273874996761576508/10000
POSTHOOK: query: select * from temp_null2 where ds is not null
POSTHOOK: type: QUERY
POSTHOOK: Input: default@temp_null2@ds=2010-04-01
POSTHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-12-05_597_2273874996761576508/10000
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
PREHOOK: query: drop table tt
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table tt
POSTHOOK: type: DROPTABLE
POSTHOOK: Output: default@tt
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: drop table tt_b
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table tt_b
POSTHOOK: type: DROPTABLE
POSTHOOK: Output: default@tt_b
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: drop table temp_null
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table temp_null
POSTHOOK: type: DROPTABLE
POSTHOOK: Output: default@temp_null
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: drop table temp_null2
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table temp_null2
POSTHOOK: type: DROPTABLE
POSTHOOK: Output: default@temp_null2
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 []