You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by br...@apache.org on 2014/11/07 21:41:45 UTC
svn commit: r1637444 [17/20] - in /hive/branches/spark: ./
cli/src/test/org/apache/hadoop/hive/cli/ common/
common/src/java/org/apache/hadoop/hive/common/type/
common/src/java/org/apache/hadoop/hive/conf/
common/src/test/org/apache/hadoop/hive/conf/ co...
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge4.q.out?rev=1637444&r1=1637443&r2=1637444&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge4.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge4.q.out Fri Nov 7 20:41:34 2014
@@ -36,47 +36,8 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@orcfile_merge3a@ds=1
POSTHOOK: Lineage: orcfile_merge3a PARTITION(ds=1).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge3a PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: DESC FORMATTED orcfile_merge3a PARTITION (ds='1')
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orcfile_merge3a
-POSTHOOK: query: DESC FORMATTED orcfile_merge3a PARTITION (ds='1')
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orcfile_merge3a
-# col_name data_type comment
-
-key int
-value string
-
-# Partition Information
-# col_name data_type comment
-
-ds string
-
-# Detailed Partition Information
-Partition Value: [1]
-Database: default
-Table: orcfile_merge3a
-#### A masked pattern was here ####
-Protect Mode: None
+Found 1 items
#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 1
- numRows 500
- rawDataSize 47000
- totalSize 2496
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
PREHOOK: query: INSERT OVERWRITE TABLE orcfile_merge3a PARTITION (ds='1')
SELECT * FROM src
PREHOOK: type: QUERY
@@ -101,88 +62,10 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@orcfile_merge3a@ds=2
POSTHOOK: Lineage: orcfile_merge3a PARTITION(ds=2).key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: orcfile_merge3a PARTITION(ds=2).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: DESC FORMATTED orcfile_merge3a PARTITION (ds='1')
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orcfile_merge3a
-POSTHOOK: query: DESC FORMATTED orcfile_merge3a PARTITION (ds='1')
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orcfile_merge3a
-# col_name data_type comment
-
-key int
-value string
-
-# Partition Information
-# col_name data_type comment
-
-ds string
-
-# Detailed Partition Information
-Partition Value: [1]
-Database: default
-Table: orcfile_merge3a
-#### A masked pattern was here ####
-Protect Mode: None
-#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 1
- numRows 500
- rawDataSize 47000
- totalSize 2496
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-PREHOOK: query: DESC FORMATTED orcfile_merge3a PARTITION (ds='2')
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orcfile_merge3a
-POSTHOOK: query: DESC FORMATTED orcfile_merge3a PARTITION (ds='2')
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orcfile_merge3a
-# col_name data_type comment
-
-key int
-value string
-
-# Partition Information
-# col_name data_type comment
-
-ds string
-
-# Detailed Partition Information
-Partition Value: [2]
-Database: default
-Table: orcfile_merge3a
-#### A masked pattern was here ####
-Protect Mode: None
+Found 1 items
#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 1
- numRows 500
- rawDataSize 47000
- totalSize 2496
+Found 1 items
#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE orcfile_merge3b
SELECT key, value FROM orcfile_merge3a
PREHOOK: type: QUERY
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge5.q.out?rev=1637444&r1=1637443&r2=1637444&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge5.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge5.q.out Fri Nov 7 20:41:34 2014
@@ -104,45 +104,8 @@ analyze table orc_merge5b compute statis
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_merge5b
POSTHOOK: Output: default@orc_merge5b
-PREHOOK: query: desc formatted orc_merge5b
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5b
-POSTHOOK: query: desc formatted orc_merge5b
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5b
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Detailed Table Information
-Database: default
-#### A masked pattern was here ####
-Protect Mode: None
-Retention: 0
-#### A masked pattern was here ####
-Table Type: MANAGED_TABLE
-Table Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 3
- numRows 3
- rawDataSize 765
- totalSize 1133
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+Found 3 items
+#### A masked pattern was here ####
PREHOOK: query: select * from orc_merge5b
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_merge5b
@@ -274,45 +237,8 @@ analyze table orc_merge5b compute statis
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_merge5b
POSTHOOK: Output: default@orc_merge5b
-PREHOOK: query: desc formatted orc_merge5b
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5b
-POSTHOOK: query: desc formatted orc_merge5b
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5b
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Detailed Table Information
-Database: default
-#### A masked pattern was here ####
-Protect Mode: None
-Retention: 0
-#### A masked pattern was here ####
-Table Type: MANAGED_TABLE
-Table Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 1
- numRows 3
- rawDataSize 765
- totalSize 899
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+Found 1 items
+#### A masked pattern was here ####
PREHOOK: query: select * from orc_merge5b
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_merge5b
@@ -345,45 +271,8 @@ POSTHOOK: query: analyze table orc_merge
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_merge5b
POSTHOOK: Output: default@orc_merge5b
-PREHOOK: query: desc formatted orc_merge5b
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5b
-POSTHOOK: query: desc formatted orc_merge5b
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5b
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Detailed Table Information
-Database: default
-#### A masked pattern was here ####
-Protect Mode: None
-Retention: 0
-#### A masked pattern was here ####
-Table Type: MANAGED_TABLE
-Table Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 3
- numRows 3
- rawDataSize 765
- totalSize 1133
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+Found 3 items
+#### A masked pattern was here ####
PREHOOK: query: select * from orc_merge5b
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_merge5b
@@ -438,45 +327,8 @@ analyze table orc_merge5b compute statis
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_merge5b
POSTHOOK: Output: default@orc_merge5b
-PREHOOK: query: desc formatted orc_merge5b
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5b
-POSTHOOK: query: desc formatted orc_merge5b
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5b
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Detailed Table Information
-Database: default
-#### A masked pattern was here ####
-Protect Mode: None
-Retention: 0
-#### A masked pattern was here ####
-Table Type: MANAGED_TABLE
-Table Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 1
- numRows 3
- rawDataSize 765
- totalSize 899
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+Found 1 items
+#### A masked pattern was here ####
PREHOOK: query: select * from orc_merge5b
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_merge5b
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge6.q.out?rev=1637444&r1=1637443&r2=1637444&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge6.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge6.q.out Fri Nov 7 20:41:34 2014
@@ -134,96 +134,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@year=2001/hour=24
-PREHOOK: query: desc formatted orc_merge5a partition(year="2000",hour=24)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5a
-POSTHOOK: query: desc formatted orc_merge5a partition(year="2000",hour=24)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5a
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Partition Information
-# col_name data_type comment
-
-year string
-hour int
-
-# Detailed Partition Information
-Partition Value: [2000, 24]
-Database: default
-Table: orc_merge5a
-#### A masked pattern was here ####
-Protect Mode: None
-#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 3
- numRows 3
- rawDataSize 765
- totalSize 1133
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-PREHOOK: query: desc formatted orc_merge5a partition(year="2001",hour=24)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5a
-POSTHOOK: query: desc formatted orc_merge5a partition(year="2001",hour=24)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5a
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Partition Information
-# col_name data_type comment
-
-year string
-hour int
-
-# Detailed Partition Information
-Partition Value: [2001, 24]
-Database: default
-Table: orc_merge5a
-#### A masked pattern was here ####
-Protect Mode: None
-#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 3
- numRows 3
- rawDataSize 765
- totalSize 1133
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+Found 3 items
+#### A masked pattern was here ####
+Found 3 items
+#### A masked pattern was here ####
PREHOOK: query: show partitions orc_merge5a
PREHOOK: type: SHOWPARTITIONS
PREHOOK: Input: default@orc_merge5a
@@ -398,96 +312,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@year=2001/hour=24
-PREHOOK: query: desc formatted orc_merge5a partition(year="2000",hour=24)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5a
-POSTHOOK: query: desc formatted orc_merge5a partition(year="2000",hour=24)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5a
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Partition Information
-# col_name data_type comment
-
-year string
-hour int
-
-# Detailed Partition Information
-Partition Value: [2000, 24]
-Database: default
-Table: orc_merge5a
-#### A masked pattern was here ####
-Protect Mode: None
-#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 1
- numRows 3
- rawDataSize 765
- totalSize 899
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-PREHOOK: query: desc formatted orc_merge5a partition(year="2001",hour=24)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5a
-POSTHOOK: query: desc formatted orc_merge5a partition(year="2001",hour=24)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5a
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Partition Information
-# col_name data_type comment
-
-year string
-hour int
-
-# Detailed Partition Information
-Partition Value: [2001, 24]
-Database: default
-Table: orc_merge5a
-#### A masked pattern was here ####
-Protect Mode: None
-#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 1
- numRows 3
- rawDataSize 765
- totalSize 899
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+Found 1 items
+#### A masked pattern was here ####
+Found 1 items
+#### A masked pattern was here ####
PREHOOK: query: show partitions orc_merge5a
PREHOOK: type: SHOWPARTITIONS
PREHOOK: Input: default@orc_merge5a
@@ -560,96 +388,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@year=2001/hour=24
-PREHOOK: query: desc formatted orc_merge5a partition(year="2000",hour=24)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5a
-POSTHOOK: query: desc formatted orc_merge5a partition(year="2000",hour=24)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5a
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Partition Information
-# col_name data_type comment
-
-year string
-hour int
-
-# Detailed Partition Information
-Partition Value: [2000, 24]
-Database: default
-Table: orc_merge5a
-#### A masked pattern was here ####
-Protect Mode: None
-#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 3
- numRows 3
- rawDataSize 765
- totalSize 1133
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-PREHOOK: query: desc formatted orc_merge5a partition(year="2001",hour=24)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5a
-POSTHOOK: query: desc formatted orc_merge5a partition(year="2001",hour=24)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5a
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Partition Information
-# col_name data_type comment
-
-year string
-hour int
-
-# Detailed Partition Information
-Partition Value: [2001, 24]
-Database: default
-Table: orc_merge5a
-#### A masked pattern was here ####
-Protect Mode: None
-#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 3
- numRows 3
- rawDataSize 765
- totalSize 1133
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+Found 3 items
+#### A masked pattern was here ####
+Found 3 items
+#### A masked pattern was here ####
PREHOOK: query: show partitions orc_merge5a
PREHOOK: type: SHOWPARTITIONS
PREHOOK: Input: default@orc_merge5a
@@ -742,96 +484,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@year=2001/hour=24
-PREHOOK: query: desc formatted orc_merge5a partition(year="2000",hour=24)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5a
-POSTHOOK: query: desc formatted orc_merge5a partition(year="2000",hour=24)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5a
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Partition Information
-# col_name data_type comment
-
-year string
-hour int
-
-# Detailed Partition Information
-Partition Value: [2000, 24]
-Database: default
-Table: orc_merge5a
-#### A masked pattern was here ####
-Protect Mode: None
-#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 1
- numRows 3
- rawDataSize 765
- totalSize 899
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-PREHOOK: query: desc formatted orc_merge5a partition(year="2001",hour=24)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5a
-POSTHOOK: query: desc formatted orc_merge5a partition(year="2001",hour=24)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5a
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Partition Information
-# col_name data_type comment
-
-year string
-hour int
-
-# Detailed Partition Information
-Partition Value: [2001, 24]
-Database: default
-Table: orc_merge5a
-#### A masked pattern was here ####
-Protect Mode: None
-#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 1
- numRows 3
- rawDataSize 765
- totalSize 899
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+Found 1 items
+#### A masked pattern was here ####
+Found 1 items
+#### A masked pattern was here ####
PREHOOK: query: show partitions orc_merge5a
PREHOOK: type: SHOWPARTITIONS
PREHOOK: Input: default@orc_merge5a
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge7.q.out?rev=1637444&r1=1637443&r2=1637444&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge7.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge7.q.out Fri Nov 7 20:41:34 2014
@@ -167,94 +167,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@st=0.8
-PREHOOK: query: desc formatted orc_merge5a partition(st=80.0)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5a
-POSTHOOK: query: desc formatted orc_merge5a partition(st=80.0)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5a
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Partition Information
-# col_name data_type comment
-
-st double
-
-# Detailed Partition Information
-Partition Value: [80.0]
-Database: default
-Table: orc_merge5a
-#### A masked pattern was here ####
-Protect Mode: None
-#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 1
- numRows 1
- rawDataSize 255
- totalSize 513
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-PREHOOK: query: desc formatted orc_merge5a partition(st=0.8)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5a
-POSTHOOK: query: desc formatted orc_merge5a partition(st=0.8)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5a
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Partition Information
-# col_name data_type comment
-
-st double
-
-# Detailed Partition Information
-Partition Value: [0.8]
-Database: default
-Table: orc_merge5a
-#### A masked pattern was here ####
-Protect Mode: None
-#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 2
- numRows 2
- rawDataSize 510
- totalSize 1044
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+Found 1 items
+#### A masked pattern was here ####
+Found 2 items
+#### A masked pattern was here ####
PREHOOK: query: show partitions orc_merge5a
PREHOOK: type: SHOWPARTITIONS
PREHOOK: Input: default@orc_merge5a
@@ -463,94 +379,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@st=0.8
-PREHOOK: query: desc formatted orc_merge5a partition(st=80.0)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5a
-POSTHOOK: query: desc formatted orc_merge5a partition(st=80.0)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5a
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Partition Information
-# col_name data_type comment
-
-st double
-
-# Detailed Partition Information
-Partition Value: [80.0]
-Database: default
-Table: orc_merge5a
-#### A masked pattern was here ####
-Protect Mode: None
-#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 1
- numRows 1
- rawDataSize 255
- totalSize 513
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-PREHOOK: query: desc formatted orc_merge5a partition(st=0.8)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5a
-POSTHOOK: query: desc formatted orc_merge5a partition(st=0.8)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5a
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Partition Information
-# col_name data_type comment
-
-st double
-
-# Detailed Partition Information
-Partition Value: [0.8]
-Database: default
-Table: orc_merge5a
-#### A masked pattern was here ####
-Protect Mode: None
-#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 1
- numRows 2
- rawDataSize 510
- totalSize 838
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+Found 1 items
+#### A masked pattern was here ####
+Found 1 items
+#### A masked pattern was here ####
PREHOOK: query: show partitions orc_merge5a
PREHOOK: type: SHOWPARTITIONS
PREHOOK: Input: default@orc_merge5a
@@ -662,94 +494,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@st=0.8
-PREHOOK: query: desc formatted orc_merge5a partition(st=80.0)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5a
-POSTHOOK: query: desc formatted orc_merge5a partition(st=80.0)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5a
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Partition Information
-# col_name data_type comment
-
-st double
-
-# Detailed Partition Information
-Partition Value: [80.0]
-Database: default
-Table: orc_merge5a
-#### A masked pattern was here ####
-Protect Mode: None
-#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 1
- numRows 1
- rawDataSize 255
- totalSize 513
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-PREHOOK: query: desc formatted orc_merge5a partition(st=0.8)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5a
-POSTHOOK: query: desc formatted orc_merge5a partition(st=0.8)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5a
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Partition Information
-# col_name data_type comment
-
-st double
-
-# Detailed Partition Information
-Partition Value: [0.8]
-Database: default
-Table: orc_merge5a
-#### A masked pattern was here ####
-Protect Mode: None
-#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 2
- numRows 2
- rawDataSize 510
- totalSize 1044
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+Found 1 items
+#### A masked pattern was here ####
+Found 2 items
+#### A masked pattern was here ####
PREHOOK: query: show partitions orc_merge5a
PREHOOK: type: SHOWPARTITIONS
PREHOOK: Input: default@orc_merge5a
@@ -844,94 +592,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@st=0.8
-PREHOOK: query: desc formatted orc_merge5a partition(st=80.0)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5a
-POSTHOOK: query: desc formatted orc_merge5a partition(st=80.0)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5a
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Partition Information
-# col_name data_type comment
-
-st double
-
-# Detailed Partition Information
-Partition Value: [80.0]
-Database: default
-Table: orc_merge5a
-#### A masked pattern was here ####
-Protect Mode: None
-#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 1
- numRows 1
- rawDataSize 255
- totalSize 513
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-PREHOOK: query: desc formatted orc_merge5a partition(st=0.8)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5a
-POSTHOOK: query: desc formatted orc_merge5a partition(st=0.8)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5a
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Partition Information
-# col_name data_type comment
-
-st double
-
-# Detailed Partition Information
-Partition Value: [0.8]
-Database: default
-Table: orc_merge5a
-#### A masked pattern was here ####
-Protect Mode: None
-#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 1
- numRows 2
- rawDataSize 510
- totalSize 838
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+Found 1 items
+#### A masked pattern was here ####
+Found 1 items
+#### A masked pattern was here ####
PREHOOK: query: show partitions orc_merge5a
PREHOOK: type: SHOWPARTITIONS
PREHOOK: Input: default@orc_merge5a
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge_incompat1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge_incompat1.q.out?rev=1637444&r1=1637443&r2=1637444&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge_incompat1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge_incompat1.q.out Fri Nov 7 20:41:34 2014
@@ -155,45 +155,8 @@ analyze table orc_merge5b compute statis
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_merge5b
POSTHOOK: Output: default@orc_merge5b
-PREHOOK: query: desc formatted orc_merge5b
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5b
-POSTHOOK: query: desc formatted orc_merge5b
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5b
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Detailed Table Information
-Database: default
-#### A masked pattern was here ####
-Protect Mode: None
-Retention: 0
-#### A masked pattern was here ####
-Table Type: MANAGED_TABLE
-Table Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 5
- numRows 15
- rawDataSize 3825
- totalSize 2877
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+Found 5 items
+#### A masked pattern was here ####
PREHOOK: query: select * from orc_merge5b
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_merge5b
@@ -235,45 +198,8 @@ analyze table orc_merge5b compute statis
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_merge5b
POSTHOOK: Output: default@orc_merge5b
-PREHOOK: query: desc formatted orc_merge5b
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5b
-POSTHOOK: query: desc formatted orc_merge5b
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5b
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Detailed Table Information
-Database: default
-#### A masked pattern was here ####
-Protect Mode: None
-Retention: 0
-#### A masked pattern was here ####
-Table Type: MANAGED_TABLE
-Table Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 3
- numRows 15
- rawDataSize 3825
- totalSize 2340
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
+Found 3 items
+#### A masked pattern was here ####
PREHOOK: query: select * from orc_merge5b
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_merge5b
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge_incompat2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge_incompat2.q.out?rev=1637444&r1=1637443&r2=1637444&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge_incompat2.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/orc_merge_incompat2.q.out Fri Nov 7 20:41:34 2014
@@ -225,94 +225,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@st=0.8
-PREHOOK: query: desc formatted orc_merge5a partition(st=80.0)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5a
-POSTHOOK: query: desc formatted orc_merge5a partition(st=80.0)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5a
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Partition Information
-# col_name data_type comment
-
-st double
-
-# Detailed Partition Information
-Partition Value: [80.0]
-Database: default
-Table: orc_merge5a
-#### A masked pattern was here ####
-Protect Mode: None
-#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 4
- numRows 4
- rawDataSize 1020
- totalSize 2060
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-PREHOOK: query: desc formatted orc_merge5a partition(st=0.8)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5a
-POSTHOOK: query: desc formatted orc_merge5a partition(st=0.8)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5a
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Partition Information
-# col_name data_type comment
-
-st double
-
-# Detailed Partition Information
-Partition Value: [0.8]
-Database: default
-Table: orc_merge5a
-#### A masked pattern was here ####
-Protect Mode: None
+Found 4 items
#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 4
- numRows 8
- rawDataSize 2040
- totalSize 2188
+Found 4 items
#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
PREHOOK: query: show partitions orc_merge5a
PREHOOK: type: SHOWPARTITIONS
PREHOOK: Input: default@orc_merge5a
@@ -414,94 +330,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a
POSTHOOK: Output: default@orc_merge5a@st=0.8
-PREHOOK: query: desc formatted orc_merge5a partition(st=80.0)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5a
-POSTHOOK: query: desc formatted orc_merge5a partition(st=80.0)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5a
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Partition Information
-# col_name data_type comment
-
-st double
-
-# Detailed Partition Information
-Partition Value: [80.0]
-Database: default
-Table: orc_merge5a
-#### A masked pattern was here ####
-Protect Mode: None
-#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 3
- numRows 4
- rawDataSize 1020
- totalSize 1819
-#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
-PREHOOK: query: desc formatted orc_merge5a partition(st=0.8)
-PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@orc_merge5a
-POSTHOOK: query: desc formatted orc_merge5a partition(st=0.8)
-POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@orc_merge5a
-# col_name data_type comment
-
-userid bigint
-string1 string
-subtype double
-decimal1 decimal(10,0)
-ts timestamp
-
-# Partition Information
-# col_name data_type comment
-
-st double
-
-# Detailed Partition Information
-Partition Value: [0.8]
-Database: default
-Table: orc_merge5a
-#### A masked pattern was here ####
-Protect Mode: None
+Found 3 items
#### A masked pattern was here ####
-Partition Parameters:
- COLUMN_STATS_ACCURATE true
- numFiles 3
- numRows 8
- rawDataSize 2040
- totalSize 1928
+Found 3 items
#### A masked pattern was here ####
-
-# Storage Information
-SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde
-InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
-OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
-Compressed: No
-Num Buckets: -1
-Bucket Columns: []
-Sort Columns: []
-Storage Desc Params:
- serialization.format 1
PREHOOK: query: show partitions orc_merge5a
PREHOOK: type: SHOWPARTITIONS
PREHOOK: Input: default@orc_merge5a
Modified: hive/branches/spark/ql/src/test/results/clientpositive/tez/ptf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/tez/ptf.q.out?rev=1637444&r1=1637443&r2=1637444&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/tez/ptf.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/tez/ptf.q.out Fri Nov 7 20:41:34 2014
@@ -1,45 +1,3 @@
-PREHOOK: query: DROP TABLE part
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE part
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: -- data setup
-CREATE TABLE part(
- p_partkey INT,
- p_name STRING,
- p_mfgr STRING,
- p_brand STRING,
- p_type STRING,
- p_size INT,
- p_container STRING,
- p_retailprice DOUBLE,
- p_comment STRING
-)
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@part
-POSTHOOK: query: -- data setup
-CREATE TABLE part(
- p_partkey INT,
- p_name STRING,
- p_mfgr STRING,
- p_brand STRING,
- p_type STRING,
- p_size INT,
- p_container STRING,
- p_retailprice DOUBLE,
- p_comment STRING
-)
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@part
-PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
-PREHOOK: type: LOAD
-#### A masked pattern was here ####
-PREHOOK: Output: default@part
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
-POSTHOOK: type: LOAD
-#### A masked pattern was here ####
-POSTHOOK: Output: default@part
PREHOOK: query: -- SORT_QUERY_RESULTS
--1. test1