You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by am...@apache.org on 2013/04/17 09:29:46 UTC
svn commit: r1468783 [12/16] - in /hive/branches/HIVE-4115: ./
beeline/src/java/org/apache/hive/beeline/ beeline/src/test/org/
beeline/src/test/org/apache/ beeline/src/test/org/apache/hive/
beeline/src/test/org/apache/hive/beeline/ beeline/src/test/org...
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out Wed Apr 17 07:29:38 2013
@@ -49,56 +49,43 @@ STAGE PLANS:
GatherStats: false
Select Operator
expressions:
- expr: 1
- type: int
+ expr: UDFToString(1)
+ type: string
expr: key
type: string
- expr: 1
- type: int
+ expr: UDFToString(1)
+ type: string
expr: value
type: string
- expr: 1
- type: int
+ expr: UDFToString(1)
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Select Operator
- expressions:
- expr: UDFToString(_col0)
- type: string
- expr: _col1
- type: string
- expr: UDFToString(_col2)
- type: string
- expr: _col3
- type: string
- expr: UDFToString(_col4)
- type: string
- outputColumnNames: _col0, _col1, _col2, _col3, _col4
- File Output Operator
- compressed: false
- GlobalTableId: 1
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Static Partition Specification: ds=2008-04-08/hr=11/
-#### A masked pattern was here ####
- table:
- input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
- properties:
- bucket_count -1
- columns col1,col2,col3,col4,col5
- columns.types string:string:string:string:string
-#### A masked pattern was here ####
- name default.list_bucketing_mul_col
- partition_columns ds/hr
- serialization.ddl struct list_bucketing_mul_col { string col1, string col2, string col3, string col4, string col5}
- serialization.format 1
- serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
-#### A masked pattern was here ####
- serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- name: default.list_bucketing_mul_col
- TotalFiles: 1
- GatherStats: true
- MultiFileSpray: false
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+#### A masked pattern was here ####
+ NumFilesPerFileSink: 1
+ Static Partition Specification: ds=2008-04-08/hr=11/
+#### A masked pattern was here ####
+ table:
+ input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
+ properties:
+ bucket_count -1
+ columns col1,col2,col3,col4,col5
+ columns.types string:string:string:string:string
+#### A masked pattern was here ####
+ name default.list_bucketing_mul_col
+ partition_columns ds/hr
+ serialization.ddl struct list_bucketing_mul_col { string col1, string col2, string col3, string col4, string col5}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
+#### A masked pattern was here ####
+ serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
+ name: default.list_bucketing_mul_col
+ TotalFiles: 1
+ GatherStats: true
+ MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
#### A masked pattern was here ####
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out Wed Apr 17 07:29:38 2013
@@ -49,56 +49,43 @@ STAGE PLANS:
GatherStats: false
Select Operator
expressions:
- expr: 1
- type: int
+ expr: UDFToString(1)
+ type: string
expr: key
type: string
- expr: 1
- type: int
+ expr: UDFToString(1)
+ type: string
expr: value
type: string
- expr: 1
- type: int
+ expr: UDFToString(1)
+ type: string
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Select Operator
- expressions:
- expr: UDFToString(_col0)
- type: string
- expr: _col1
- type: string
- expr: UDFToString(_col2)
- type: string
- expr: _col3
- type: string
- expr: UDFToString(_col4)
- type: string
- outputColumnNames: _col0, _col1, _col2, _col3, _col4
- File Output Operator
- compressed: false
- GlobalTableId: 1
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
- Static Partition Specification: ds=2008-04-08/hr=2013-01-23+18%3A00%3A99/
-#### A masked pattern was here ####
- table:
- input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
- properties:
- bucket_count -1
- columns col1,col2,col3,col4,col5
- columns.types string:string:string:string:string
-#### A masked pattern was here ####
- name default.list_bucketing_mul_col
- partition_columns ds/hr
- serialization.ddl struct list_bucketing_mul_col { string col1, string col2, string col3, string col4, string col5}
- serialization.format 1
- serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
-#### A masked pattern was here ####
- serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- name: default.list_bucketing_mul_col
- TotalFiles: 1
- GatherStats: true
- MultiFileSpray: false
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+#### A masked pattern was here ####
+ NumFilesPerFileSink: 1
+ Static Partition Specification: ds=2008-04-08/hr=2013-01-23+18%3A00%3A99/
+#### A masked pattern was here ####
+ table:
+ input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
+ properties:
+ bucket_count -1
+ columns col1,col2,col3,col4,col5
+ columns.types string:string:string:string:string
+#### A masked pattern was here ####
+ name default.list_bucketing_mul_col
+ partition_columns ds/hr
+ serialization.ddl struct list_bucketing_mul_col { string col1, string col2, string col3, string col4, string col5}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
+#### A masked pattern was here ####
+ serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
+ name: default.list_bucketing_mul_col
+ TotalFiles: 1
+ GatherStats: true
+ MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
#### A masked pattern was here ####
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out Wed Apr 17 07:29:38 2013
@@ -470,8 +470,8 @@ POSTHOOK: Input: default@srcpart@ds=2008
#### A masked pattern was here ####
POSTHOOK: Lineage: list_bucketing_static_part PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: list_bucketing_static_part PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-484 val_484 2008-04-08 11
484 val_484 2008-04-08 12
+484 val_484 2008-04-08 11
PREHOOK: query: -- 51 and val_51 in the table so skewed data for 51 and val_14 should be none
-- but query should succeed for 51 or 51 and val_14
select * from srcpart where ds = '2008-04-08' and key = '51'
@@ -490,10 +490,10 @@ POSTHOOK: Input: default@srcpart@ds=2008
#### A masked pattern was here ####
POSTHOOK: Lineage: list_bucketing_static_part PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: list_bucketing_static_part PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-51 val_51 2008-04-08 11
-51 val_51 2008-04-08 11
51 val_51 2008-04-08 12
51 val_51 2008-04-08 12
+51 val_51 2008-04-08 11
+51 val_51 2008-04-08 11
PREHOOK: query: select * from list_bucketing_static_part where key = '51'
PREHOOK: type: QUERY
PREHOOK: Input: default@list_bucketing_static_part
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out Wed Apr 17 07:29:38 2013
@@ -125,7 +125,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.srcpart
numFiles 1
- numPartitions 4
numRows 0
partition_columns ds/hr
rawDataSize 0
@@ -172,7 +171,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.srcpart
numFiles 1
- numPartitions 4
numRows 0
partition_columns ds/hr
rawDataSize 0
@@ -242,12 +240,14 @@ STAGE PLANS:
PREHOOK: query: insert overwrite table list_bucketing_static_part partition (ds = '2008-04-08', hr = '11')
select key, value from srcpart where ds = '2008-04-08'
PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Output: default@list_bucketing_static_part@ds=2008-04-08/hr=11
POSTHOOK: query: insert overwrite table list_bucketing_static_part partition (ds = '2008-04-08', hr = '11')
select key, value from srcpart where ds = '2008-04-08'
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Output: default@list_bucketing_static_part@ds=2008-04-08/hr=11
@@ -397,7 +397,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.srcpart
numFiles 1
- numPartitions 4
numRows 0
partition_columns ds/hr
rawDataSize 0
@@ -444,7 +443,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.srcpart
numFiles 1
- numPartitions 4
numRows 0
partition_columns ds/hr
rawDataSize 0
@@ -633,12 +631,14 @@ STAGE PLANS:
PREHOOK: query: insert overwrite table list_bucketing_static_part partition (ds = '2008-04-08', hr = '11')
select key, value from srcpart where ds = '2008-04-08'
PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Output: default@list_bucketing_static_part@ds=2008-04-08/hr=11
POSTHOOK: query: insert overwrite table list_bucketing_static_part partition (ds = '2008-04-08', hr = '11')
select key, value from srcpart where ds = '2008-04-08'
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Output: default@list_bucketing_static_part@ds=2008-04-08/hr=11
@@ -707,11 +707,13 @@ Storage Desc Params:
serialization.format 1
PREHOOK: query: select count(1) from srcpart where ds = '2008-04-08'
PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
POSTHOOK: query: select count(1) from srcpart where ds = '2008-04-08'
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
@@ -722,10 +724,12 @@ POSTHOOK: Lineage: list_bucketing_static
1000
PREHOOK: query: select count(*) from list_bucketing_static_part
PREHOOK: type: QUERY
+PREHOOK: Input: default@list_bucketing_static_part
PREHOOK: Input: default@list_bucketing_static_part@ds=2008-04-08/hr=11
#### A masked pattern was here ####
POSTHOOK: query: select count(*) from list_bucketing_static_part
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@list_bucketing_static_part
POSTHOOK: Input: default@list_bucketing_static_part@ds=2008-04-08/hr=11
#### A masked pattern was here ####
POSTHOOK: Lineage: list_bucketing_static_part PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
@@ -810,7 +814,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.list_bucketing_static_part
numFiles 4
- numPartitions 1
numRows 1000
partition_columns ds/hr
rawDataSize 9624
@@ -852,10 +855,12 @@ STAGE PLANS:
PREHOOK: query: select * from list_bucketing_static_part where ds = '2008-04-08' and hr = '11' and key = '484' and value = 'val_484'
PREHOOK: type: QUERY
+PREHOOK: Input: default@list_bucketing_static_part
PREHOOK: Input: default@list_bucketing_static_part@ds=2008-04-08/hr=11
#### A masked pattern was here ####
POSTHOOK: query: select * from list_bucketing_static_part where ds = '2008-04-08' and hr = '11' and key = '484' and value = 'val_484'
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@list_bucketing_static_part
POSTHOOK: Input: default@list_bucketing_static_part@ds=2008-04-08/hr=11
#### A masked pattern was here ####
POSTHOOK: Lineage: list_bucketing_static_part PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
@@ -866,11 +871,13 @@ POSTHOOK: Lineage: list_bucketing_static
484 val_484 2008-04-08 11
PREHOOK: query: select * from srcpart where ds = '2008-04-08' and key = '484' and value = 'val_484'
PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
POSTHOOK: query: select * from srcpart where ds = '2008-04-08' and key = '484' and value = 'val_484'
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
@@ -878,8 +885,8 @@ POSTHOOK: Lineage: list_bucketing_static
POSTHOOK: Lineage: list_bucketing_static_part PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: list_bucketing_static_part PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: list_bucketing_static_part PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-484 val_484 2008-04-08 11
484 val_484 2008-04-08 12
+484 val_484 2008-04-08 11
PREHOOK: query: -- clean up
drop table list_bucketing_static_part
PREHOOK: type: DROPTABLE
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out Wed Apr 17 07:29:38 2013
@@ -97,7 +97,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.srcpart
numFiles 1
- numPartitions 4
numRows 0
partition_columns ds/hr
rawDataSize 0
@@ -144,7 +143,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.srcpart
numFiles 1
- numPartitions 4
numRows 0
partition_columns ds/hr
rawDataSize 0
@@ -213,11 +211,13 @@ STAGE PLANS:
PREHOOK: query: insert overwrite table list_bucketing_dynamic_part partition (ds='2008-04-08', hr) select key, value, hr from srcpart where ds='2008-04-08'
PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Output: default@list_bucketing_dynamic_part@ds=2008-04-08
POSTHOOK: query: insert overwrite table list_bucketing_dynamic_part partition (ds='2008-04-08', hr) select key, value, hr from srcpart where ds='2008-04-08'
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Output: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=11
@@ -326,11 +326,13 @@ Storage Desc Params:
serialization.format 1
PREHOOK: query: select count(1) from srcpart where ds='2008-04-08'
PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
POSTHOOK: query: select count(1) from srcpart where ds='2008-04-08'
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
@@ -341,11 +343,13 @@ POSTHOOK: Lineage: list_bucketing_dynami
1000
PREHOOK: query: select count(1) from list_bucketing_dynamic_part where ds='2008-04-08'
PREHOOK: type: QUERY
+PREHOOK: Input: default@list_bucketing_dynamic_part
PREHOOK: Input: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=11
PREHOOK: Input: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=12
#### A masked pattern was here ####
POSTHOOK: query: select count(1) from list_bucketing_dynamic_part where ds='2008-04-08'
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@list_bucketing_dynamic_part
POSTHOOK: Input: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=11
POSTHOOK: Input: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=12
#### A masked pattern was here ####
@@ -356,11 +360,13 @@ POSTHOOK: Lineage: list_bucketing_dynami
1000
PREHOOK: query: select key, value from srcpart where ds='2008-04-08' and key = "103" and value ="val_103"
PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
POSTHOOK: query: select key, value from srcpart where ds='2008-04-08' and key = "103" and value ="val_103"
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
@@ -445,7 +451,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.list_bucketing_dynamic_part
numFiles 3
- numPartitions 2
numRows 500
partition_columns ds/hr
rawDataSize 5312
@@ -492,7 +497,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.list_bucketing_dynamic_part
numFiles 3
- numPartitions 2
numRows 500
partition_columns ds/hr
rawDataSize 5312
@@ -535,11 +539,13 @@ STAGE PLANS:
PREHOOK: query: select key, value from list_bucketing_dynamic_part where ds='2008-04-08' and key = "103" and value ="val_103"
PREHOOK: type: QUERY
+PREHOOK: Input: default@list_bucketing_dynamic_part
PREHOOK: Input: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=11
PREHOOK: Input: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=12
#### A masked pattern was here ####
POSTHOOK: query: select key, value from list_bucketing_dynamic_part where ds='2008-04-08' and key = "103" and value ="val_103"
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@list_bucketing_dynamic_part
POSTHOOK: Input: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=11
POSTHOOK: Input: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=12
#### A masked pattern was here ####
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out Wed Apr 17 07:29:38 2013
@@ -173,7 +173,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.srcpart
numFiles 1
- numPartitions 4
numRows 0
partition_columns ds/hr
rawDataSize 0
@@ -220,7 +219,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.srcpart
numFiles 1
- numPartitions 4
numRows 0
partition_columns ds/hr
rawDataSize 0
@@ -290,12 +288,14 @@ STAGE PLANS:
PREHOOK: query: insert overwrite table list_bucketing_dynamic_part partition (ds = '2008-04-08', hr)
select key, value, if(key % 100 == 0, 'a1', 'b1') from srcpart where ds = '2008-04-08'
PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Output: default@list_bucketing_dynamic_part@ds=2008-04-08
POSTHOOK: query: insert overwrite table list_bucketing_dynamic_part partition (ds = '2008-04-08', hr)
select key, value, if(key % 100 == 0, 'a1', 'b1') from srcpart where ds = '2008-04-08'
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Output: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=a1
@@ -346,7 +346,7 @@ Partition Parameters:
numFiles 1
numRows 16
rawDataSize 136
- totalSize 102
+ totalSize 4096
#### A masked pattern was here ####
# Storage Information
@@ -478,7 +478,7 @@ STAGE PLANS:
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 10836
+ totalSize 14830
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
name: default.list_bucketing_dynamic_part
@@ -504,7 +504,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.srcpart
numFiles 1
- numPartitions 4
numRows 0
partition_columns ds/hr
rawDataSize 0
@@ -551,7 +550,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.srcpart
numFiles 1
- numPartitions 4
numRows 0
partition_columns ds/hr
rawDataSize 0
@@ -621,7 +619,7 @@ STAGE PLANS:
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 10836
+ totalSize 14830
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
name: default.list_bucketing_dynamic_part
@@ -655,7 +653,7 @@ STAGE PLANS:
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 10836
+ totalSize 14830
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
@@ -675,7 +673,7 @@ STAGE PLANS:
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 10836
+ totalSize 14830
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
name: default.list_bucketing_dynamic_part
@@ -707,7 +705,7 @@ STAGE PLANS:
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 10836
+ totalSize 14830
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
@@ -727,7 +725,7 @@ STAGE PLANS:
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 10836
+ totalSize 14830
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
name: default.list_bucketing_dynamic_part
@@ -745,12 +743,14 @@ STAGE PLANS:
PREHOOK: query: insert overwrite table list_bucketing_dynamic_part partition (ds = '2008-04-08', hr)
select key, value, if(key % 100 == 0, 'a1', 'b1') from srcpart where ds = '2008-04-08'
PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
PREHOOK: Output: default@list_bucketing_dynamic_part@ds=2008-04-08
POSTHOOK: query: insert overwrite table list_bucketing_dynamic_part partition (ds = '2008-04-08', hr)
select key, value, if(key % 100 == 0, 'a1', 'b1') from srcpart where ds = '2008-04-08'
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Output: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=a1
@@ -813,7 +813,7 @@ Partition Parameters:
numFiles 1
numRows 16
rawDataSize 136
- totalSize 102
+ totalSize 4096
#### A masked pattern was here ####
# Storage Information
@@ -883,11 +883,13 @@ Storage Desc Params:
serialization.format 1
PREHOOK: query: select count(1) from srcpart where ds = '2008-04-08'
PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
POSTHOOK: query: select count(1) from srcpart where ds = '2008-04-08'
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
@@ -902,11 +904,13 @@ POSTHOOK: Lineage: list_bucketing_dynami
1000
PREHOOK: query: select count(*) from list_bucketing_dynamic_part
PREHOOK: type: QUERY
+PREHOOK: Input: default@list_bucketing_dynamic_part
PREHOOK: Input: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=a1
PREHOOK: Input: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=b1
#### A masked pattern was here ####
POSTHOOK: query: select count(*) from list_bucketing_dynamic_part
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@list_bucketing_dynamic_part
POSTHOOK: Input: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=a1
POSTHOOK: Input: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=b1
#### A masked pattern was here ####
@@ -1000,14 +1004,13 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.list_bucketing_dynamic_part
numFiles 1
- numPartitions 2
numRows 16
partition_columns ds/hr
rawDataSize 136
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 102
+ totalSize 4096
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
@@ -1027,7 +1030,7 @@ STAGE PLANS:
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 10724
+ totalSize 14718
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
name: default.list_bucketing_dynamic_part
@@ -1047,7 +1050,6 @@ STAGE PLANS:
#### A masked pattern was here ####
name default.list_bucketing_dynamic_part
numFiles 4
- numPartitions 2
numRows 984
partition_columns ds/hr
rawDataSize 9488
@@ -1074,7 +1076,7 @@ STAGE PLANS:
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 10724
+ totalSize 14718
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
name: default.list_bucketing_dynamic_part
@@ -1090,11 +1092,13 @@ STAGE PLANS:
PREHOOK: query: select * from list_bucketing_dynamic_part where key = '484' and value = 'val_484'
PREHOOK: type: QUERY
+PREHOOK: Input: default@list_bucketing_dynamic_part
PREHOOK: Input: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=a1
PREHOOK: Input: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=b1
#### A masked pattern was here ####
POSTHOOK: query: select * from list_bucketing_dynamic_part where key = '484' and value = 'val_484'
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@list_bucketing_dynamic_part
POSTHOOK: Input: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=a1
POSTHOOK: Input: default@list_bucketing_dynamic_part@ds=2008-04-08/hr=b1
#### A masked pattern was here ####
@@ -1110,11 +1114,13 @@ POSTHOOK: Lineage: list_bucketing_dynami
484 val_484 2008-04-08 b1
PREHOOK: query: select * from srcpart where ds = '2008-04-08' and key = '484' and value = 'val_484'
PREHOOK: type: QUERY
+PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
POSTHOOK: query: select * from srcpart where ds = '2008-04-08' and key = '484' and value = 'val_484'
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
@@ -1126,8 +1132,8 @@ POSTHOOK: Lineage: list_bucketing_dynami
POSTHOOK: Lineage: list_bucketing_dynamic_part PARTITION(ds=2008-04-08,hr=b1).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: list_bucketing_dynamic_part PARTITION(ds=2008-04-08,hr=b1).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: list_bucketing_dynamic_part PARTITION(ds=2008-04-08,hr=b1).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-484 val_484 2008-04-08 11
484 val_484 2008-04-08 12
+484 val_484 2008-04-08 11
PREHOOK: query: -- clean up
drop table list_bucketing_dynamic_part
PREHOOK: type: DROPTABLE
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out Wed Apr 17 07:29:38 2013
@@ -294,7 +294,7 @@ Partition Parameters:
numFiles 1
numRows 16
rawDataSize 136
- totalSize 204
+ totalSize 4096
#### A masked pattern was here ####
# Storage Information
@@ -426,7 +426,7 @@ STAGE PLANS:
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 10780
+ totalSize 14672
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
name: default.list_bucketing_dynamic_part
@@ -567,7 +567,7 @@ STAGE PLANS:
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 10780
+ totalSize 14672
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
name: default.list_bucketing_dynamic_part
@@ -601,7 +601,7 @@ STAGE PLANS:
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 10780
+ totalSize 14672
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
@@ -621,7 +621,7 @@ STAGE PLANS:
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 10780
+ totalSize 14672
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
name: default.list_bucketing_dynamic_part
@@ -653,7 +653,7 @@ STAGE PLANS:
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 10780
+ totalSize 14672
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
@@ -673,7 +673,7 @@ STAGE PLANS:
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 10780
+ totalSize 14672
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
name: default.list_bucketing_dynamic_part
@@ -761,7 +761,7 @@ Partition Parameters:
numFiles 1
numRows 16
rawDataSize 136
- totalSize 136
+ totalSize 4096
#### A masked pattern was here ####
# Storage Information
@@ -958,7 +958,7 @@ STAGE PLANS:
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 136
+ totalSize 4096
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
@@ -978,7 +978,7 @@ STAGE PLANS:
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 10656
+ totalSize 14616
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
name: default.list_bucketing_dynamic_part
@@ -1024,7 +1024,7 @@ STAGE PLANS:
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 10656
+ totalSize 14616
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
name: default.list_bucketing_dynamic_part
@@ -1080,8 +1080,8 @@ POSTHOOK: Lineage: list_bucketing_dynami
POSTHOOK: Lineage: list_bucketing_dynamic_part PARTITION(ds=2008-04-08,hr=b1).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: list_bucketing_dynamic_part PARTITION(ds=2008-04-08,hr=b1).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: list_bucketing_dynamic_part PARTITION(ds=2008-04-08,hr=b1).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-484 val_484 2008-04-08 11
484 val_484 2008-04-08 12
+484 val_484 2008-04-08 11
PREHOOK: query: -- clean up
drop table list_bucketing_dynamic_part
PREHOOK: type: DROPTABLE
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out Wed Apr 17 07:29:38 2013
@@ -350,7 +350,7 @@ Partition Parameters:
numFiles 1
numRows 16
rawDataSize 136
- totalSize 102
+ totalSize 4096
#### A masked pattern was here ####
# Storage Information
@@ -593,7 +593,7 @@ STAGE PLANS:
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 102
+ totalSize 4096
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
@@ -613,7 +613,7 @@ STAGE PLANS:
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 10688
+ totalSize 14682
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
name: default.list_bucketing_dynamic_part
@@ -659,7 +659,7 @@ STAGE PLANS:
serialization.ddl struct list_bucketing_dynamic_part { string key, string value}
serialization.format 1
serialization.lib org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- totalSize 10688
+ totalSize 14682
#### A masked pattern was here ####
serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
name: default.list_bucketing_dynamic_part
@@ -707,8 +707,8 @@ POSTHOOK: Lineage: list_bucketing_dynami
POSTHOOK: Lineage: list_bucketing_dynamic_part PARTITION(ds=2008-04-08,hr=a1).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: list_bucketing_dynamic_part PARTITION(ds=2008-04-08,hr=b1).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: list_bucketing_dynamic_part PARTITION(ds=2008-04-08,hr=b1).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-484 val_484 2008-04-08 11
484 val_484 2008-04-08 12
+484 val_484 2008-04-08 11
PREHOOK: query: -- clean up
drop table list_bucketing_dynamic_part
PREHOOK: type: DROPTABLE
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out Wed Apr 17 07:29:38 2013
@@ -885,8 +885,8 @@ POSTHOOK: Lineage: list_bucketing_static
POSTHOOK: Lineage: list_bucketing_static_part PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: list_bucketing_static_part PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: list_bucketing_static_part PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-484 val_484 2008-04-08 11
484 val_484 2008-04-08 12
+484 val_484 2008-04-08 11
PREHOOK: query: -- clean up
drop table list_bucketing_static_part
PREHOOK: type: DROPTABLE
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out Wed Apr 17 07:29:38 2013
@@ -581,9 +581,9 @@ POSTHOOK: Input: default@fact_daily@ds=1
#### A masked pattern was here ####
POSTHOOK: Lineage: fact_daily PARTITION(ds=1,hr=4).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: fact_daily PARTITION(ds=1,hr=4).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+484 val_484
238 val_238
238 val_238
-484 val_484
PREHOOK: query: -- clean up
drop table fact_daily
PREHOOK: type: DROPTABLE
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out Wed Apr 17 07:29:38 2013
@@ -152,16 +152,18 @@ Storage Desc Params:
serialization.format 1
PREHOOK: query: SELECT * FROM fact_daily WHERE ds='1'
PREHOOK: type: QUERY
+PREHOOK: Input: default@fact_daily
PREHOOK: Input: default@fact_daily@ds=1
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM fact_daily WHERE ds='1'
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@fact_daily
POSTHOOK: Input: default@fact_daily@ds=1
#### A masked pattern was here ####
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=1).x EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=2).x EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-495 1
484 1
+495 1
PREHOOK: query: -- pruner only pick up skewed-value directory
-- explain plan shows which directory selected: Truncated Path -> Alias
explain extended SELECT x FROM fact_daily WHERE ds='1' and x=484
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out Wed Apr 17 07:29:38 2013
@@ -168,18 +168,20 @@ Storage Desc Params:
serialization.format 1
PREHOOK: query: SELECT * FROM fact_daily WHERE ds='1'
PREHOOK: type: QUERY
+PREHOOK: Input: default@fact_daily
PREHOOK: Input: default@fact_daily@ds=1
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM fact_daily WHERE ds='1'
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@fact_daily
POSTHOOK: Input: default@fact_daily@ds=1
#### A masked pattern was here ####
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=1).x EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=1).y SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=2).x EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=2).y SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-495 val_484 1
484 val_484 1
+495 val_484 1
PREHOOK: query: -- The first subquery
-- explain plan shows which directory selected: Truncated Path -> Alias
explain extended select x from (select x from fact_daily where ds = '1') subq where x = 484
@@ -217,28 +219,23 @@ STAGE PLANS:
expr: x
type: int
outputColumnNames: _col0
- Select Operator
- expressions:
- expr: _col0
- type: int
- outputColumnNames: _col0
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
-#### A masked pattern was here ####
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- columns _col0
- columns.types int
- escape.delim \
- serialization.format 1
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+#### A masked pattern was here ####
+ NumFilesPerFileSink: 1
+#### A masked pattern was here ####
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ columns _col0
+ columns.types int
+ escape.delim \
+ serialization.format 1
+ TotalFiles: 1
+ GatherStats: false
+ MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
#### A masked pattern was here ####
@@ -344,30 +341,23 @@ STAGE PLANS:
expr: y
type: string
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
-#### A masked pattern was here ####
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- columns _col0,_col1
- columns.types int:string
- escape.delim \
- serialization.format 1
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+#### A masked pattern was here ####
+ NumFilesPerFileSink: 1
+#### A masked pattern was here ####
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ columns _col0,_col1
+ columns.types int:string
+ escape.delim \
+ serialization.format 1
+ TotalFiles: 1
+ GatherStats: false
+ MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
#### A masked pattern was here ####
@@ -416,7 +406,6 @@ STAGE PLANS:
Fetch Operator
limit: -1
-
PREHOOK: query: -- List Bucketing Query
select x1, y1 from(select x as x1, y as y1 from fact_daily where ds ='1') subq where x1 = 484
PREHOOK: type: QUERY
@@ -708,30 +697,23 @@ STAGE PLANS:
expr: _col1
type: bigint
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: _col0
- type: int
- expr: _col1
- type: bigint
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 0
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
-#### A masked pattern was here ####
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- columns _col0,_col1
- columns.types int:bigint
- escape.delim \
- serialization.format 1
- TotalFiles: 1
- GatherStats: false
- MultiFileSpray: false
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+#### A masked pattern was here ####
+ NumFilesPerFileSink: 1
+#### A masked pattern was here ####
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ columns _col0,_col1
+ columns.types int:bigint
+ escape.delim \
+ serialization.format 1
+ TotalFiles: 1
+ GatherStats: false
+ MultiFileSpray: false
Truncated Path -> Alias:
/fact_tz/ds=1/x=484 [subq:fact_daily]
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out Wed Apr 17 07:29:38 2013
@@ -218,10 +218,12 @@ Storage Desc Params:
serialization.format 1
PREHOOK: query: SELECT * FROM fact_daily WHERE ds='1'
PREHOOK: type: QUERY
+PREHOOK: Input: default@fact_daily
PREHOOK: Input: default@fact_daily@ds=1
#### A masked pattern was here ####
POSTHOOK: query: SELECT * FROM fact_daily WHERE ds='1'
POSTHOOK: type: QUERY
+POSTHOOK: Input: default@fact_daily
POSTHOOK: Input: default@fact_daily@ds=1
#### A masked pattern was here ####
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=1).x EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
@@ -233,12 +235,12 @@ POSTHOOK: Lineage: fact_tz PARTITION(ds=
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=3).x EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=3).y SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=3).z SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
+484 val_484 val_484 1
86 val_86 val_86 1
278 val_278 val_278 1
278 val_278 val_278 1
238 val_238 val_238 1
238 val_238 val_238 1
-484 val_484 val_484 1
PREHOOK: query: -- pruner pick up right directory
-- explain plan shows which directory selected: Truncated Path -> Alias
explain extended SELECT x FROM fact_daily WHERE ds='1' and not (x = 86)
@@ -444,8 +446,8 @@ POSTHOOK: Lineage: fact_tz PARTITION(ds=
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=3).x EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=3).y SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
POSTHOOK: Lineage: fact_tz PARTITION(ds=1,hr=3).z SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-278 val_278 val_278
-278 val_278 val_278
238 val_238 val_238
238 val_238 val_238
+278 val_278 val_278
+278 val_278 val_278
484 val_484 val_484
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/literal_decimal.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/literal_decimal.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/literal_decimal.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/literal_decimal.q.out Wed Apr 17 07:29:38 2013
@@ -58,4 +58,4 @@ POSTHOOK: query: SELECT -1BD, 0BD, 1BD,
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
--1 0 1 3.14 -3.14 99999999999999999 99999999999999999.9999999999999 1E-99 1E+99
+-1 0 1 3.14 -3.14 99999999999999999 99999999999999999.9999999999999 NULL NULL
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part1.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part1.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part1.q.out Wed Apr 17 07:29:38 2013
@@ -20,8 +20,6 @@ PREHOOK: query: describe extended nzhang
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended nzhang_part1
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
ds string None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part10.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part10.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part10.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part10.q.out Wed Apr 17 07:29:38 2013
@@ -15,8 +15,6 @@ PREHOOK: query: describe extended nzhang
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended nzhang_part10
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
ds string None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part11.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part11.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part11.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part11.q.out Wed Apr 17 07:29:38 2013
@@ -15,8 +15,6 @@ PREHOOK: query: describe extended nzhang
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended nzhang_part
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
ds string None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part12.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part12.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part12.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part12.q.out Wed Apr 17 07:29:38 2013
@@ -15,8 +15,6 @@ PREHOOK: query: describe extended nzhang
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended nzhang_part12
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
ds string None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part13.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part13.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part13.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part13.q.out Wed Apr 17 07:29:38 2013
@@ -15,8 +15,6 @@ PREHOOK: query: describe extended nzhang
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended nzhang_part13
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
ds string None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part14.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part14.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part14.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part14.q.out Wed Apr 17 07:29:38 2013
@@ -15,8 +15,6 @@ PREHOOK: query: describe extended nzhang
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended nzhang_part14
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string None
value string None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part2.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part2.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part2.q.out Wed Apr 17 07:29:38 2013
@@ -11,8 +11,6 @@ PREHOOK: query: describe extended nzhang
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended nzhang_part_bucket
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string None
value string None
ds string None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part3.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part3.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part3.q.out Wed Apr 17 07:29:38 2013
@@ -15,8 +15,6 @@ PREHOOK: query: describe extended nzhang
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended nzhang_part3
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
ds string None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part4.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part4.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part4.q.out Wed Apr 17 07:29:38 2013
@@ -15,8 +15,6 @@ PREHOOK: query: describe extended nzhang
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended nzhang_part4
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
ds string None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part5.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part5.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part5.q.out Wed Apr 17 07:29:38 2013
@@ -7,8 +7,6 @@ PREHOOK: query: describe extended nzhang
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended nzhang_part5
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string None
value string None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part6.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part6.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part6.q.out Wed Apr 17 07:29:38 2013
@@ -15,8 +15,6 @@ PREHOOK: query: describe extended nzhang
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended nzhang_part6
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
ds string None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part7.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part7.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part7.q.out Wed Apr 17 07:29:38 2013
@@ -15,8 +15,6 @@ PREHOOK: query: describe extended nzhang
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended nzhang_part7
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
ds string None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part8.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part8.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part8.q.out Wed Apr 17 07:29:38 2013
@@ -15,8 +15,6 @@ PREHOOK: query: describe extended nzhang
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended nzhang_part8
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
ds string None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part9.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part9.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_dyn_part9.q.out Wed Apr 17 07:29:38 2013
@@ -15,8 +15,6 @@ PREHOOK: query: describe extended nzhang
PREHOOK: type: DESCTABLE
POSTHOOK: query: describe extended nzhang_part9
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string default
value string default
ds string None
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_fs.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_fs.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_fs.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/load_fs.q.out Wed Apr 17 07:29:38 2013
@@ -47,8 +47,6 @@ PREHOOK: query: desc extended load_overw
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended load_overwrite
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string None
value string None
@@ -89,8 +87,6 @@ PREHOOK: query: desc extended load_overw
PREHOOK: type: DESCTABLE
POSTHOOK: query: desc extended load_overwrite2
POSTHOOK: type: DESCTABLE
-# col_name data_type comment
-
key string None
value string None