You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by nz...@apache.org on 2010/07/23 01:57:42 UTC
svn commit: r966909 [14/27] - in /hadoop/hive/trunk: ./ contrib/
data/warehouse/src/ hbase-handler/ hwi/ jdbc/ odbc/ ql/
ql/src/test/org/apache/hadoop/hive/ql/ ql/src/test/queries/clientnegative/
ql/src/test/queries/clientpositive/ ql/src/test/results/...
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/ddltime.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/ddltime.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/ddltime.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/ddltime.q.out Thu Jul 22 23:57:29 2010
@@ -10,7 +10,7 @@ POSTHOOK: type: DESCTABLE
key string default
value string default
-Detailed Table Information Table(tableName:t1, dbName:default, owner:null, createTime:1277236615, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/t1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{EXTERNAL=FALSE,transient_lastDdlTime=1277236615}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:t1, dbName:default, owner:null, createTime:1279736455, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/t1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{EXTERNAL=FALSE, transient_lastDdlTime=1279736455}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: insert overwrite table T1 select * from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -30,7 +30,7 @@ POSTHOOK: Lineage: t1.value SIMPLE [(src
key string default
value string default
-Detailed Table Information Table(tableName:t1, dbName:default, owner:null, createTime:1277236615, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/t1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{EXTERNAL=FALSE,transient_lastDdlTime=1277236620}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:t1, dbName:default, owner:null, createTime:1279736455, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/t1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{EXTERNAL=FALSE, transient_lastDdlTime=1279736459}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: insert overwrite table T1 select /*+ HOLD_DDLTIME*/ * from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -54,7 +54,7 @@ POSTHOOK: Lineage: t1.value SIMPLE [(src
key string default
value string default
-Detailed Table Information Table(tableName:t1, dbName:default, owner:null, createTime:1277236615, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/t1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{EXTERNAL=FALSE,transient_lastDdlTime=1277236620}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:t1, dbName:default, owner:null, createTime:1279736455, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/t1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{EXTERNAL=FALSE, transient_lastDdlTime=1279736459}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: insert overwrite table T1 select * from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -82,18 +82,7 @@ POSTHOOK: Lineage: t1.value SIMPLE [(src
key string default
value string default
-Detailed Table Information Table(tableName:t1, dbName:default, owner:null, createTime:1277236615, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/t1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{EXTERNAL=FALSE,transient_lastDdlTime=1277236629}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
-PREHOOK: query: drop table T1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table T1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@t1
-POSTHOOK: Lineage: t1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: t1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: t1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+Detailed Table Information Table(tableName:t1, dbName:default, owner:null, createTime:1279736455, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/t1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{EXTERNAL=FALSE, transient_lastDdlTime=1279736467}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: create table if not exists T2 like srcpart
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table if not exists T2 like srcpart
@@ -120,7 +109,7 @@ value string default
ds string
hr string
-Detailed Table Information Table(tableName:t2, dbName:default, owner:null, createTime:1277236629, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/t2, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:hr, type:string, comment:null)], parameters:{EXTERNAL=FALSE,transient_lastDdlTime=1277236629}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:t2, dbName:default, owner:null, createTime:1279736467, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/t2, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:hr, type:string, comment:null)], parameters:{EXTERNAL=FALSE, transient_lastDdlTime=1279736467}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: insert overwrite table T2 partition (ds = '2010-06-21', hr = '1') select key, value from src where key > 10
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -154,7 +143,7 @@ value string default
ds string
hr string
-Detailed Partition Information Partition(values:[2010-06-21, 1], dbName:default, tableName:t2, createTime:1277236634, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/t2/ds=2010-06-21/hr=1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{transient_lastDdlTime=1277236634})
+Detailed Partition Information Partition(values:[2010-06-21, 1], dbName:default, tableName:t2, createTime:1279736471, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/t2/ds=2010-06-21/hr=1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{transient_lastDdlTime=1279736471})
PREHOOK: query: insert overwrite table T2 partition (ds = '2010-06-21', hr='1') select /*+ HOLD_DDLTIME */ key, value from src where key > 10
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -192,7 +181,7 @@ value string default
ds string
hr string
-Detailed Partition Information Partition(values:[2010-06-21, 1], dbName:default, tableName:t2, createTime:1277236634, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/t2/ds=2010-06-21/hr=1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{transient_lastDdlTime=1277236634})
+Detailed Partition Information Partition(values:[2010-06-21, 1], dbName:default, tableName:t2, createTime:1279736471, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/t2/ds=2010-06-21/hr=1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{transient_lastDdlTime=1279736471})
PREHOOK: query: insert overwrite table T2 partition (ds='2010-06-01', hr='1') select key, value from src where key > 10
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -234,21 +223,4 @@ value string default
ds string
hr string
-Detailed Partition Information Partition(values:[2010-06-01, 1], dbName:default, tableName:t2, createTime:1277236643, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/data/users/nzhang/work/876/apache-hive/build/ql/test/data/warehouse/t2/ds=2010-06-01/hr=1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{transient_lastDdlTime=1277236643})
-PREHOOK: query: drop table T2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table T2
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@t2
-POSTHOOK: Lineage: t1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: t1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: t1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: t1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-01,hr=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-01,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-06-21,hr=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+Detailed Partition Information Partition(values:[2010-06-01, 1], dbName:default, tableName:t2, createTime:1279736478, lastAccessTime:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:default), FieldSchema(name:value, type:string, comment:default)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/t2/ds=2010-06-01/hr=1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), parameters:{transient_lastDdlTime=1279736478})
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/diff_part_input_formats.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/diff_part_input_formats.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/diff_part_input_formats.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/diff_part_input_formats.q.out Thu Jul 22 23:57:29 2010
@@ -27,13 +27,8 @@ POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Output: default@part_test@ds=2
PREHOOK: query: SELECT count(1) FROM part_test WHERE ds='3'
PREHOOK: type: QUERY
-PREHOOK: Output: file:/data/users/pyang/task/trunk/VENDOR.hive/trunk/build/ql/scratchdir/hive_2010-06-15_10-14-51_112_6812982446306518733/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-21-20_502_7998672376160685808/10000
POSTHOOK: query: SELECT count(1) FROM part_test WHERE ds='3'
POSTHOOK: type: QUERY
-POSTHOOK: Output: file:/data/users/pyang/task/trunk/VENDOR.hive/trunk/build/ql/scratchdir/hive_2010-06-15_10-14-51_112_6812982446306518733/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-21-20_502_7998672376160685808/10000
0
-PREHOOK: query: DROP TABLE part_test
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE part_test
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@part_test
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/disable_file_format_check.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/disable_file_format_check.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/disable_file_format_check.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/disable_file_format_check.q.out Thu Jul 22 23:57:29 2010
@@ -18,13 +18,3 @@ PREHOOK: type: LOAD
POSTHOOK: query: load data local inpath '../data/files/kv1.txt' overwrite into table kv_fileformat_check_seq
POSTHOOK: type: LOAD
POSTHOOK: Output: default@kv_fileformat_check_seq
-PREHOOK: query: drop table kv_fileformat_check_seq
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table kv_fileformat_check_seq
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@kv_fileformat_check_seq
-PREHOOK: query: drop table kv_fileformat_check_txt
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table kv_fileformat_check_txt
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@kv_fileformat_check_txt
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out Thu Jul 22 23:57:29 2010
@@ -1,7 +1,3 @@
-PREHOOK: query: drop table bucket2_1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table bucket2_1
-POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE bucket2_1(key int, value string) CLUSTERED BY (key) INTO 2 BUCKETS
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE bucket2_1(key int, value string) CLUSTERED BY (key) INTO 2 BUCKETS
@@ -49,9 +45,9 @@ STAGE PLANS:
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/test/data/warehouse/src [src]
+ file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/src [src]
Path -> Partition:
- file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/test/data/warehouse/src
+ file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/src
Partition
base file name: src
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -62,12 +58,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/test/data/warehouse/src
+ location file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/src
name src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1270516041
+ transient_lastDdlTime 1279735685
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -78,12 +74,12 @@ STAGE PLANS:
columns.types string:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/test/data/warehouse/src
+ location file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/src
name src
serialization.ddl struct src { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1270516041
+ transient_lastDdlTime 1279735685
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
name: src
@@ -99,7 +95,7 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-07-21_813_2816895778195265258/10000
+ directory: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-21-24_032_5058530528484682613/10000
NumFilesPerFileSink: 2
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -111,12 +107,12 @@ STAGE PLANS:
columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/test/data/warehouse/bucket2_1
+ location file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/bucket2_1
name bucket2_1
serialization.ddl struct bucket2_1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1270516041
+ transient_lastDdlTime 1279736484
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: bucket2_1
TotalFiles: 2
@@ -126,7 +122,7 @@ STAGE PLANS:
Move Operator
tables:
replace: true
- source: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-07-21_813_2816895778195265258/10000
+ source: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-21-24_032_5058530528484682613/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -137,15 +133,15 @@ STAGE PLANS:
columns.types int:string
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/test/data/warehouse/bucket2_1
+ location file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/bucket2_1
name bucket2_1
serialization.ddl struct bucket2_1 { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1270516041
+ transient_lastDdlTime 1279736484
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: bucket2_1
- tmp directory: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-07-21_813_2816895778195265258/10001
+ tmp directory: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-21-24_032_5058530528484682613/10001
PREHOOK: query: insert overwrite table bucket2_1
@@ -225,11 +221,11 @@ STAGE PLANS:
PREHOOK: query: select * from bucket2_1 tablesample (bucket 1 out of 2) s order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@bucket2_1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-07-28_295_4764288900823189670/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-21-26_856_8066476091371346194/10000
POSTHOOK: query: select * from bucket2_1 tablesample (bucket 1 out of 2) s order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@bucket2_1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_0/build/ql/scratchdir/hive_2010-04-05_18-07-28_295_4764288900823189670/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-21-26_856_8066476091371346194/10000
POSTHOOK: Lineage: bucket2_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: bucket2_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
0 val_0
@@ -479,10 +475,3 @@ POSTHOOK: Lineage: bucket2_1.value SIMPL
498 val_498
498 val_498
498 val_498
-PREHOOK: query: drop table bucket2_1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table bucket2_1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@bucket2_1
-POSTHOOK: Lineage: bucket2_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: bucket2_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/drop_multi_partitions.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/drop_multi_partitions.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/drop_multi_partitions.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/drop_multi_partitions.q.out Thu Jul 22 23:57:29 2010
@@ -53,8 +53,3 @@ PREHOOK: type: SHOWPARTITIONS
POSTHOOK: query: show partitions mp
POSTHOOK: type: SHOWPARTITIONS
b=2/c=2
-PREHOOK: query: drop table mp
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table mp
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@mp
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_mix.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_mix.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_mix.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_mix.q.out Thu Jul 22 23:57:29 2010
@@ -1,7 +1,3 @@
-PREHOOK: query: drop table fileformat_mix_test
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table fileformat_mix_test
-POSTHOOK: type: DROPTABLE
PREHOOK: query: create table fileformat_mix_test (src int, value string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table fileformat_mix_test (src int, value string) partitioned by (ds string)
@@ -44,12 +40,12 @@ PREHOOK: query: select count(1) from fil
PREHOOK: type: QUERY
PREHOOK: Input: default@fileformat_mix_test@ds=1
PREHOOK: Input: default@fileformat_mix_test@ds=2
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-06-20_21-21-12_115_4377005987442515283/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-21-45_393_3654336984212621494/10000
POSTHOOK: query: select count(1) from fileformat_mix_test
POSTHOOK: type: QUERY
POSTHOOK: Input: default@fileformat_mix_test@ds=1
POSTHOOK: Input: default@fileformat_mix_test@ds=2
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-06-20_21-21-12_115_4377005987442515283/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-21-45_393_3654336984212621494/10000
POSTHOOK: Lineage: fileformat_mix_test PARTITION(ds=1).src EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: fileformat_mix_test PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
500
@@ -57,12 +53,12 @@ PREHOOK: query: select src from fileform
PREHOOK: type: QUERY
PREHOOK: Input: default@fileformat_mix_test@ds=1
PREHOOK: Input: default@fileformat_mix_test@ds=2
-PREHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-06-20_21-21-17_269_3478340175683868925/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-21-48_001_5704820361095123784/10000
POSTHOOK: query: select src from fileformat_mix_test
POSTHOOK: type: QUERY
POSTHOOK: Input: default@fileformat_mix_test@ds=1
POSTHOOK: Input: default@fileformat_mix_test@ds=2
-POSTHOOK: Output: file:/var/folders/6g/6grtCwPMEf4sqHUPpy6xQG9ByHg/-Tmp-/heyongqiang/hive_2010-06-20_21-21-17_269_3478340175683868925/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-21-48_001_5704820361095123784/10000
POSTHOOK: Lineage: fileformat_mix_test PARTITION(ds=1).src EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: fileformat_mix_test PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
238
@@ -565,10 +561,3 @@ POSTHOOK: Lineage: fileformat_mix_test P
400
200
97
-PREHOOK: query: drop table fileformat_mix_test
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table fileformat_mix_test
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@fileformat_mix_test
-POSTHOOK: Lineage: fileformat_mix_test PARTITION(ds=1).src EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: fileformat_mix_test PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out Thu Jul 22 23:57:29 2010
@@ -43,7 +43,7 @@ POSTHOOK: type: DESCTABLE
key int
value string
-Detailed Table Information Table(tableName:dest1, dbName:default, owner:athusoo, createTime:1270516226, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/test/data/warehouse/dest1, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1270516226}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:dest1, dbName:default, owner:jssarma, createTime:1279736511, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/dest1, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1279736511}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 10
PREHOOK: type: QUERY
@@ -59,11 +59,11 @@ POSTHOOK: Lineage: dest1.value SIMPLE [(
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-10-30_861_6151697846173493077/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-21-53_917_3907368248535068834/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-10-30_861_6151697846173493077/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-21-53_917_3907368248535068834/10000
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
0 val_0
@@ -76,10 +76,3 @@ POSTHOOK: Lineage: dest1.value SIMPLE [(
2 val_2
5 val_5
9 val_9
-PREHOOK: query: DROP TABLE dest1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE dest1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@dest1
-POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out Thu Jul 22 23:57:29 2010
@@ -43,7 +43,7 @@ POSTHOOK: type: DESCTABLE
key int
value string
-Detailed Table Information Table(tableName:dest1, dbName:default, owner:athusoo, createTime:1270516127, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/test/data/warehouse/dest1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1270516127}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
+Detailed Table Information Table(tableName:dest1, dbName:default, owner:jssarma, createTime:1279736514, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/dest1, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1279736514}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 10
PREHOOK: type: QUERY
@@ -59,11 +59,11 @@ POSTHOOK: Lineage: dest1.value SIMPLE [(
PREHOOK: query: SELECT dest1.* FROM dest1
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
-PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-08-51_909_8811972959551956946/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-21-57_089_3981013039375138901/10000
POSTHOOK: query: SELECT dest1.* FROM dest1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest1
-POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_2/build/ql/scratchdir/hive_2010-04-05_18-08-51_909_8811972959551956946/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-21-57_089_3981013039375138901/10000
POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
0 val_0
@@ -76,10 +76,3 @@ POSTHOOK: Lineage: dest1.value SIMPLE [(
2 val_2
5 val_5
9 val_9
-PREHOOK: query: DROP TABLE dest1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE dest1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@dest1
-POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/filter_join_breaktask.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/filter_join_breaktask.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/filter_join_breaktask.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/filter_join_breaktask.q.out Thu Jul 22 23:57:29 2010
@@ -1,7 +1,3 @@
-PREHOOK: query: DROP TABLE filter_join_breaktask
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE filter_join_breaktask
-POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE filter_join_breaktask(key int, value string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE filter_join_breaktask(key int, value string) partitioned by (ds string)
@@ -123,7 +119,7 @@ STAGE PLANS:
serialization.ddl struct filter_join_breaktask { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1276212172
+ transient_lastDdlTime 1279736517
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -140,7 +136,7 @@ STAGE PLANS:
serialization.ddl struct filter_join_breaktask { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1276212172
+ transient_lastDdlTime 1279736517
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: filter_join_breaktask
name: filter_join_breaktask
@@ -171,7 +167,7 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/tmp/jssarma/hive_2010-06-10_16-22-55_084_1486227885854106344/10002
+ directory: file:/tmp/jssarma/hive_2010-07-21_11-22-00_300_3159170495555394870/10002
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -227,7 +223,7 @@ STAGE PLANS:
Needs Tagging: true
Path -> Alias:
file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/filter_join_breaktask/ds=2008-04-08 [g]
- file:/tmp/jssarma/hive_2010-06-10_16-22-55_084_1486227885854106344/10002 [$INTNAME]
+ file:/tmp/jssarma/hive_2010-07-21_11-22-00_300_3159170495555394870/10002 [$INTNAME]
Path -> Partition:
file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/test/data/warehouse/filter_join_breaktask/ds=2008-04-08
Partition
@@ -248,7 +244,7 @@ STAGE PLANS:
serialization.ddl struct filter_join_breaktask { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1276212172
+ transient_lastDdlTime 1279736517
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -265,11 +261,11 @@ STAGE PLANS:
serialization.ddl struct filter_join_breaktask { i32 key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- transient_lastDdlTime 1276212172
+ transient_lastDdlTime 1279736517
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: filter_join_breaktask
name: filter_join_breaktask
- file:/tmp/jssarma/hive_2010-06-10_16-22-55_084_1486227885854106344/10002
+ file:/tmp/jssarma/hive_2010-07-21_11-22-00_300_3159170495555394870/10002
Partition
base file name: 10002
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
@@ -304,7 +300,7 @@ STAGE PLANS:
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-06-10_16-22-55_084_1486227885854106344/10001
+ directory: file:/mnt/vol/devrs004.snc1/jssarma/projects/hive_trunk/build/ql/scratchdir/hive_2010-07-21_11-22-00_300_3159170495555394870/10001
NumFilesPerFileSink: 1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -326,13 +322,13 @@ FROM filter_join_breaktask f JOIN filter
JOIN filter_join_breaktask g ON(g.value = m.value AND g.ds='2008-04-08' AND m.ds='2008-04-08' AND m.value is not null AND m.value !='')
PREHOOK: type: QUERY
PREHOOK: Input: default@filter_join_breaktask@ds=2008-04-08
-PREHOOK: Output: file:/tmp/jssarma/hive_2010-06-10_16-22-55_434_9085757094579036575/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-22-00_469_3112953081846350734/10000
POSTHOOK: query: SELECT f.key, g.value
FROM filter_join_breaktask f JOIN filter_join_breaktask m ON( f.key = m.key AND f.ds='2008-04-08' AND m.ds='2008-04-08' AND f.key is not null)
JOIN filter_join_breaktask g ON(g.value = m.value AND g.ds='2008-04-08' AND m.ds='2008-04-08' AND m.value is not null AND m.value !='')
POSTHOOK: type: QUERY
POSTHOOK: Input: default@filter_join_breaktask@ds=2008-04-08
-POSTHOOK: Output: file:/tmp/jssarma/hive_2010-06-10_16-22-55_434_9085757094579036575/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-22-00_469_3112953081846350734/10000
POSTHOOK: Lineage: filter_join_breaktask PARTITION(ds=2008-04-08).key EXPRESSION [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: filter_join_breaktask PARTITION(ds=2008-04-08).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
146 val_146
@@ -347,10 +343,3 @@ POSTHOOK: Lineage: filter_join_breaktask
406 val_406
66 val_66
98 val_98
-PREHOOK: query: DROP TABLE filter_join_breaktask
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE filter_join_breaktask
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@filter_join_breaktask
-POSTHOOK: Lineage: filter_join_breaktask PARTITION(ds=2008-04-08).key EXPRESSION [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
-POSTHOOK: Lineage: filter_join_breaktask PARTITION(ds=2008-04-08).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/filter_join_breaktask2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/filter_join_breaktask2.q.out?rev=966909&r1=966908&r2=966909&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/filter_join_breaktask2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/filter_join_breaktask2.q.out Thu Jul 22 23:57:29 2010
@@ -1,19 +1,3 @@
-PREHOOK: query: drop table T1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table T1
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table T2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table T2
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table T3
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table T3
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table T4
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table T4
-POSTHOOK: type: DROPTABLE
PREHOOK: query: create table T1(c1 string, c2 string, c3 string, c4 string, c5 string, c6 string, c7 string)
partitioned by (ds string)
PREHOOK: type: CREATETABLE
@@ -269,11 +253,11 @@ POSTHOOK: Lineage: t4 PARTITION(ds=2010-
PREHOOK: query: select * from T2
PREHOOK: type: QUERY
PREHOOK: Input: default@t2@ds=2010-04-17
-PREHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-55-08_819_6769669287322680370/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-22-18_463_1385997241277658790/10000
POSTHOOK: query: select * from T2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t2@ds=2010-04-17
-POSTHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-55-08_819_6769669287322680370/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-22-18_463_1385997241277658790/10000
POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c1 SIMPLE []
POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c2 SIMPLE []
POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c3 SIMPLE []
@@ -398,11 +382,11 @@ POSTHOOK: Lineage: t4 PARTITION(ds=2010-
PREHOOK: query: select * from T1
PREHOOK: type: QUERY
PREHOOK: Input: default@t1@ds=2010-04-17
-PREHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-55-09_308_2908418676652974905/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-22-18_668_3928437893588448271/10000
POSTHOOK: query: select * from T1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1@ds=2010-04-17
-POSTHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-55-09_308_2908418676652974905/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-22-18_668_3928437893588448271/10000
POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c1 SIMPLE []
POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c2 SIMPLE []
POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c3 SIMPLE []
@@ -527,11 +511,11 @@ POSTHOOK: Lineage: t4 PARTITION(ds=2010-
PREHOOK: query: select * from T3
PREHOOK: type: QUERY
PREHOOK: Input: default@t3@ds=2010-04-17
-PREHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-55-09_632_4357906996789662185/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-22-18_801_6024512080264702124/10000
POSTHOOK: query: select * from T3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t3@ds=2010-04-17
-POSTHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-55-09_632_4357906996789662185/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-22-18_801_6024512080264702124/10000
POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c1 SIMPLE []
POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c2 SIMPLE []
POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c3 SIMPLE []
@@ -656,11 +640,11 @@ POSTHOOK: Lineage: t4 PARTITION(ds=2010-
PREHOOK: query: select * from T4
PREHOOK: type: QUERY
PREHOOK: Input: default@t4@ds=2010-04-17
-PREHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-55-09_923_4310274942964197494/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-22-18_931_7314109222032805369/10000
POSTHOOK: query: select * from T4
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t4@ds=2010-04-17
-POSTHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-55-09_923_4310274942964197494/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-22-18_931_7314109222032805369/10000
POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c1 SIMPLE []
POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c2 SIMPLE []
POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c3 SIMPLE []
@@ -794,7 +778,7 @@ PREHOOK: Input: default@t4@ds=2010-04-17
PREHOOK: Input: default@t2@ds=2010-04-17
PREHOOK: Input: default@t3@ds=2010-04-17
PREHOOK: Input: default@t1@ds=2010-04-17
-PREHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-55-10_432_8791433634827654875/10000
+PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-22-19_056_2171086064566020577/10000
POSTHOOK: query: SELECT a.c1 as a_c1, b.c1 b_c1, d.c0 as d_c0
FROM T1 a JOIN T2 b
ON (a.c1 = b.c1 AND a.ds='2010-04-17' AND b.ds='2010-04-17')
@@ -807,7 +791,7 @@ POSTHOOK: Input: default@t4@ds=2010-04-1
POSTHOOK: Input: default@t2@ds=2010-04-17
POSTHOOK: Input: default@t3@ds=2010-04-17
POSTHOOK: Input: default@t1@ds=2010-04-17
-POSTHOOK: Output: file:/data/users/nzhang/work/784/apache-hive/build/ql/scratchdir/hive_2010-05-11_12-55-10_432_8791433634827654875/10000
+POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-22-19_056_2171086064566020577/10000
POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c1 SIMPLE []
POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c2 SIMPLE []
POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c3 SIMPLE []
@@ -929,503 +913,3 @@ POSTHOOK: Lineage: t4 PARTITION(ds=2010-
POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c83 EXPRESSION []
POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c9 SIMPLE []
5 5 4
-PREHOOK: query: drop table T1
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table T1
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@t1
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c1 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c2 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c3 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c4 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c5 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c6 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c7 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c0 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c1 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c10 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c11 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c12 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c13 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c14 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c15 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c16 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c17 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c18 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c19 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c2 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c20 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c21 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c22 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c23 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c24 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c25 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c3 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c4 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c5 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c6 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c7 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c8 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c9 SIMPLE []
-POSTHOOK: Lineage: t3 PARTITION(ds=2010-04-17).c0 EXPRESSION []
-POSTHOOK: Lineage: t3 PARTITION(ds=2010-04-17).c1 EXPRESSION []
-POSTHOOK: Lineage: t3 PARTITION(ds=2010-04-17).c2 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c0 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c1 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c10 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c11 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c12 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c13 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c14 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c15 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c16 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c17 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c18 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c19 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c2 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c20 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c21 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c22 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c23 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c24 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c25 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c26 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c27 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c28 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c29 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c3 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c30 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c31 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c32 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c33 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c34 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c35 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c36 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c37 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c38 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c39 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c4 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c40 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c41 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c42 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c43 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c44 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c45 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c46 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c47 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c48 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c49 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c5 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c50 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c51 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c52 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c53 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c54 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c55 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c56 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c57 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c58 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c59 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c6 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c60 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c61 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c62 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c63 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c64 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c65 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c66 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c67 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c68 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c69 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c7 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c70 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c71 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c72 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c73 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c74 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c75 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c76 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c77 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c78 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c79 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c8 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c80 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c81 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c82 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c83 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c9 SIMPLE []
-PREHOOK: query: drop table T2
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table T2
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@t2
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c1 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c2 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c3 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c4 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c5 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c6 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c7 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c0 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c1 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c10 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c11 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c12 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c13 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c14 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c15 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c16 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c17 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c18 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c19 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c2 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c20 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c21 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c22 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c23 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c24 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c25 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c3 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c4 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c5 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c6 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c7 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c8 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c9 SIMPLE []
-POSTHOOK: Lineage: t3 PARTITION(ds=2010-04-17).c0 EXPRESSION []
-POSTHOOK: Lineage: t3 PARTITION(ds=2010-04-17).c1 EXPRESSION []
-POSTHOOK: Lineage: t3 PARTITION(ds=2010-04-17).c2 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c0 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c1 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c10 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c11 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c12 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c13 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c14 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c15 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c16 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c17 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c18 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c19 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c2 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c20 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c21 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c22 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c23 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c24 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c25 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c26 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c27 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c28 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c29 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c3 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c30 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c31 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c32 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c33 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c34 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c35 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c36 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c37 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c38 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c39 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c4 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c40 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c41 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c42 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c43 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c44 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c45 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c46 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c47 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c48 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c49 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c5 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c50 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c51 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c52 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c53 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c54 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c55 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c56 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c57 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c58 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c59 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c6 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c60 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c61 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c62 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c63 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c64 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c65 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c66 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c67 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c68 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c69 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c7 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c70 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c71 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c72 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c73 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c74 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c75 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c76 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c77 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c78 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c79 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c8 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c80 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c81 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c82 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c83 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c9 SIMPLE []
-PREHOOK: query: drop table T3
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table T3
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@t3
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c1 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c2 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c3 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c4 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c5 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c6 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c7 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c0 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c1 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c10 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c11 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c12 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c13 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c14 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c15 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c16 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c17 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c18 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c19 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c2 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c20 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c21 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c22 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c23 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c24 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c25 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c3 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c4 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c5 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c6 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c7 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c8 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c9 SIMPLE []
-POSTHOOK: Lineage: t3 PARTITION(ds=2010-04-17).c0 EXPRESSION []
-POSTHOOK: Lineage: t3 PARTITION(ds=2010-04-17).c1 EXPRESSION []
-POSTHOOK: Lineage: t3 PARTITION(ds=2010-04-17).c2 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c0 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c1 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c10 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c11 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c12 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c13 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c14 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c15 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c16 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c17 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c18 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c19 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c2 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c20 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c21 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c22 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c23 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c24 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c25 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c26 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c27 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c28 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c29 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c3 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c30 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c31 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c32 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c33 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c34 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c35 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c36 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c37 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c38 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c39 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c4 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c40 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c41 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c42 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c43 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c44 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c45 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c46 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c47 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c48 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c49 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c5 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c50 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c51 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c52 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c53 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c54 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c55 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c56 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c57 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c58 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c59 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c6 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c60 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c61 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c62 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c63 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c64 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c65 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c66 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c67 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c68 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c69 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c7 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c70 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c71 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c72 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c73 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c74 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c75 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c76 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c77 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c78 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c79 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c8 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c80 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c81 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c82 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c83 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c9 SIMPLE []
-PREHOOK: query: drop table T4
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table T4
-POSTHOOK: type: DROPTABLE
-POSTHOOK: Output: default@t4
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c1 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c2 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c3 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c4 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c5 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c6 SIMPLE []
-POSTHOOK: Lineage: t1 PARTITION(ds=2010-04-17).c7 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c0 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c1 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c10 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c11 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c12 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c13 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c14 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c15 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c16 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c17 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c18 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c19 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c2 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c20 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c21 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c22 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c23 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c24 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c25 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c3 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c4 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c5 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c6 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c7 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c8 SIMPLE []
-POSTHOOK: Lineage: t2 PARTITION(ds=2010-04-17).c9 SIMPLE []
-POSTHOOK: Lineage: t3 PARTITION(ds=2010-04-17).c0 EXPRESSION []
-POSTHOOK: Lineage: t3 PARTITION(ds=2010-04-17).c1 EXPRESSION []
-POSTHOOK: Lineage: t3 PARTITION(ds=2010-04-17).c2 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c0 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c1 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c10 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c11 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c12 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c13 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c14 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c15 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c16 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c17 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c18 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c19 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c2 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c20 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c21 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c22 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c23 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c24 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c25 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c26 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c27 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c28 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c29 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c3 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c30 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c31 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c32 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c33 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c34 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c35 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c36 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c37 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c38 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c39 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c4 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c40 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c41 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c42 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c43 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c44 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c45 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c46 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c47 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c48 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c49 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c5 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c50 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c51 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c52 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c53 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c54 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c55 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c56 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c57 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c58 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c59 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c6 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c60 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c61 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c62 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c63 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c64 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c65 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c66 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c67 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c68 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c69 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c7 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c70 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c71 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c72 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c73 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c74 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c75 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c76 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c77 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c78 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c79 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c8 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c80 SIMPLE []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c81 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c82 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c83 EXPRESSION []
-POSTHOOK: Lineage: t4 PARTITION(ds=2010-04-17).c9 SIMPLE []