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 [14/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/orc_merge5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/orc_merge5.q.out?rev=1637444&r1=1637443&r2=1637444&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/orc_merge5.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/orc_merge5.q.out Fri Nov 7 20:41:34 2014
@@ -97,45 +97,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
@@ -252,45 +215,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
@@ -323,45 +249,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
@@ -416,45 +305,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/orc_merge6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/orc_merge6.q.out?rev=1637444&r1=1637443&r2=1637444&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/orc_merge6.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/orc_merge6.q.out Fri Nov 7 20:41:34 2014
@@ -127,96 +127,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
@@ -376,96 +290,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
@@ -538,96 +366,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
@@ -720,96 +462,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/orc_merge7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/orc_merge7.q.out?rev=1637444&r1=1637443&r2=1637444&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/orc_merge7.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/orc_merge7.q.out Fri Nov 7 20:41:34 2014
@@ -160,94 +160,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
@@ -441,94 +357,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
@@ -640,94 +472,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
@@ -822,94 +570,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/orc_merge_incompat1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out?rev=1637444&r1=1637443&r2=1637444&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out Fri Nov 7 20:41:34 2014
@@ -148,45 +148,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
@@ -228,45 +191,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/orc_merge_incompat2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out?rev=1637444&r1=1637443&r2=1637444&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out Fri Nov 7 20:41:34 2014
@@ -218,94 +218,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
@@ -407,94 +323,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/order_within_subquery.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/order_within_subquery.q.out?rev=1637444&r1=1637443&r2=1637444&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/order_within_subquery.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/order_within_subquery.q.out Fri Nov 7 20:41:34 2014
@@ -1,39 +1,3 @@
-PREHOOK: query: 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: 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: select t1.p_name, t2.p_name
from (select * from part order by p_size limit 10) t1 join part t2 on t1.p_partkey = t2.p_partkey and t1.p_size = t2.p_size
where t1.p_partkey < 100000
Modified: hive/branches/spark/ql/src/test/results/clientpositive/ptf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/ptf.q.out?rev=1637444&r1=1637443&r2=1637444&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/ptf.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/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
Modified: hive/branches/spark/ql/src/test/results/clientpositive/ptf_decimal.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/ptf_decimal.q.out?rev=1637444&r1=1637443&r2=1637444&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/ptf_decimal.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/ptf_decimal.q.out Fri Nov 7 20:41:34 2014
@@ -1,45 +1,3 @@
-PREHOOK: query: DROP TABLE IF EXISTS part
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE IF EXISTS 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 DECIMAL(6,2),
- 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 DECIMAL(6,2),
- 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: -- 1. aggregate functions with decimal type
select p_mfgr, p_retailprice,
Modified: hive/branches/spark/ql/src/test/results/clientpositive/ptf_general_queries.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/ptf_general_queries.q.out?rev=1637444&r1=1637443&r2=1637444&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/ptf_general_queries.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/ptf_general_queries.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: -- 1. testNoPTFNoWindowing
select p_mfgr, p_name, p_size
from part
Modified: hive/branches/spark/ql/src/test/results/clientpositive/ptf_streaming.q.out
URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/ptf_streaming.q.out?rev=1637444&r1=1637443&r2=1637444&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/ptf_streaming.q.out (original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/ptf_streaming.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: create temporary function noopstreaming as 'org.apache.hadoop.hive.ql.udf.ptf.NoopStreaming$NoopStreamingResolver'
PREHOOK: type: CREATEFUNCTION
PREHOOK: Output: noopstreaming