FAQ
Author: gangtimliu
Date: Thu Apr 11 04:33:41 2013
New Revision: 1466765

URL: http://svn.apache.org/r1466765
Log:
HIVE-4337: Update list bucketing test results (Samuel Yuan via Gang Tim Liu)

Modified:
     hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out
     hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out
     hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out
     hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out
     hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out
     hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out
     hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out
     hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out
     hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out
     hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out
     hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out
     hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out
     hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out

Modified: hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out?rev=1466765&r1=1466764&r2=1466765&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_12.q.out Thu Apr 11 04:33:41 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/trunk/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out?rev=1466765&r1=1466764&r2=1466765&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_13.q.out Thu Apr 11 04:33:41 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/trunk/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out?rev=1466765&r1=1466764&r2=1466765&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_2.q.out Thu Apr 11 04:33:41 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/trunk/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out?rev=1466765&r1=1466764&r2=1466765&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_4.q.out Thu Apr 11 04:33:41 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/trunk/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out?rev=1466765&r1=1466764&r2=1466765&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_5.q.out Thu Apr 11 04:33:41 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/trunk/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out?rev=1466765&r1=1466764&r2=1466765&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_6.q.out Thu Apr 11 04:33:41 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/trunk/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out?rev=1466765&r1=1466764&r2=1466765&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_7.q.out Thu Apr 11 04:33:41 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/trunk/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out?rev=1466765&r1=1466764&r2=1466765&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_8.q.out Thu Apr 11 04:33:41 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/trunk/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out?rev=1466765&r1=1466764&r2=1466765&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/list_bucket_dml_9.q.out Thu Apr 11 04:33:41 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/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out?rev=1466765&r1=1466764&r2=1466765&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_multiskew_2.q.out Thu Apr 11 04:33:41 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/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out?rev=1466765&r1=1466764&r2=1466765&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_1.q.out Thu Apr 11 04:33:41 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/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out?rev=1466765&r1=1466764&r2=1466765&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out Thu Apr 11 04:33:41 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/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out?rev=1466765&r1=1466764&r2=1466765&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/list_bucket_query_oneskew_3.q.out Thu Apr 11 04:33:41 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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 1 | next ›
Discussion Overview
groupcommits @
categorieshive, hadoop
postedApr 11, '13 at 4:34a
activeApr 11, '13 at 4:34a
posts1
users1
websitehive.apache.org

1 user in discussion

Gangtimliu: 1 post

People

Translate

site design / logo © 2021 Grokbase