hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sp...@apache.org
Subject hive git commit: HIVE-16539: Add PTF tests for blobstores (Juan Rodríguez Hortalá, reviewed by Sergio Pena)
Date Wed, 17 May 2017 18:50:49 GMT
Repository: hive
Updated Branches:
  refs/heads/master eead46c4c -> 029763517


HIVE-16539: Add PTF tests for blobstores (Juan Rodríguez Hortalá, reviewed by Sergio Pena)


Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/02976351
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/02976351
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/02976351

Branch: refs/heads/master
Commit: 029763517b45f1bd8c96bcfad9c892f6d4c67ea5
Parents: eead46c
Author: Juan Rodríguez Hortalá <hortala@amazon.com>
Authored: Wed May 17 13:50:22 2017 -0500
Committer: Sergio Pena <sergio.pena@cloudera.com>
Committed: Wed May 17 13:50:22 2017 -0500

----------------------------------------------------------------------
 data/files/part.orc                             | Bin 0 -> 2689 bytes
 .../clientpositive/ptf_general_queries.q        |  34 ++
 .../test/queries/clientpositive/ptf_matchpath.q |  35 ++
 .../test/queries/clientpositive/ptf_orcfile.q   |  32 ++
 .../queries/clientpositive/ptf_persistence.q    |  15 +
 .../test/queries/clientpositive/ptf_rcfile.q    |  32 ++
 .../test/queries/clientpositive/ptf_seqfile.q   |  32 ++
 .../clientpositive/ptf_general_queries.q.out    | 139 +++++
 .../results/clientpositive/ptf_matchpath.q.out  | 105 ++++
 .../results/clientpositive/ptf_orcfile.q.out    | 104 ++++
 .../clientpositive/ptf_persistence.q.out        | 549 +++++++++++++++++++
 .../results/clientpositive/ptf_rcfile.q.out     | 104 ++++
 .../results/clientpositive/ptf_seqfile.q.out    | 104 ++++
 13 files changed, 1285 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/hive/blob/02976351/data/files/part.orc
----------------------------------------------------------------------
diff --git a/data/files/part.orc b/data/files/part.orc
new file mode 100644
index 0000000..361326c
Binary files /dev/null and b/data/files/part.orc differ

http://git-wip-us.apache.org/repos/asf/hive/blob/02976351/itests/hive-blobstore/src/test/queries/clientpositive/ptf_general_queries.q
----------------------------------------------------------------------
diff --git a/itests/hive-blobstore/src/test/queries/clientpositive/ptf_general_queries.q b/itests/hive-blobstore/src/test/queries/clientpositive/ptf_general_queries.q
new file mode 100644
index 0000000..5ad65b1
--- /dev/null
+++ b/itests/hive-blobstore/src/test/queries/clientpositive/ptf_general_queries.q
@@ -0,0 +1,34 @@
+-- Check some basic PTF operations
+DROP TABLE part_tiny;
+CREATE TABLE part_tiny(
+  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
+)
+LOCATION '${hiveconf:test.blobstore.path.unique}/ptf_general_queries/part_tiny';
+
+LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' INTO TABLE part_tiny;
+
+-- Test DISTRIBUTE BY without any aggregate function 
+SELECT p_mfgr, p_name, p_size
+FROM part_tiny
+DISTRIBUTE BY p_mfgr
+SORT BY p_name;
+        
+-- Test using UDAF without windowing nor group by 
+SELECT 
+  p_mfgr,p_name,p_retailprice,
+  SUM(p_retailprice) OVER(PARTITION BY p_mfgr ORDER BY p_name) AS sum,
+  MIN(p_retailprice) OVER(PARTITION BY p_mfgr ORDER BY p_name) AS min,
+  MAX(p_retailprice) OVER(PARTITION BY p_mfgr ORDER BY p_name) AS max,
+  AVG(p_retailprice) OVER(PARTITION BY p_mfgr ORDER BY p_name) AS avg
+FROM part_tiny;
+        
+-- Test using a constant expression in SELECT 
+SELECT 'tst1' AS key, COUNT(1) AS value FROM part_tiny;

http://git-wip-us.apache.org/repos/asf/hive/blob/02976351/itests/hive-blobstore/src/test/queries/clientpositive/ptf_matchpath.q
----------------------------------------------------------------------
diff --git a/itests/hive-blobstore/src/test/queries/clientpositive/ptf_matchpath.q b/itests/hive-blobstore/src/test/queries/clientpositive/ptf_matchpath.q
new file mode 100644
index 0000000..72d0c6a
--- /dev/null
+++ b/itests/hive-blobstore/src/test/queries/clientpositive/ptf_matchpath.q
@@ -0,0 +1,35 @@
+-- Check behavior of MATCHPATH with a partitioned table with several partitions, 
+-- and with a partitioned table with a single partition
+DROP TABLE flights_tiny;
+CREATE TABLE flights_tiny (
+  origin_city_name string,
+  dest_city_name string,
+  year int,
+  month int,
+  day_of_month int,
+  arr_delay float,
+  fl_num string
+)
+LOCATION '${hiveconf:test.blobstore.path.unique}/ptf_matchpath/flights_tiny';
+
+LOAD DATA LOCAL INPATH '../../data/files/flights_tiny.txt' INTO TABLE flights_tiny;
+
+-- basic MATCHPATH test
+SELECT origin_city_name, fl_num, year, month, day_of_month, sz, tpath
+FROM MATCHPATH(
+  ON flights_tiny 
+  DISTRIBUTE BY fl_num
+  SORT BY year, month, day_of_month
+  ARG1('LATE.LATE+'), ARG2('LATE'), ARG3(arr_delay > 15),
+  ARG4('origin_city_name, fl_num, year, month, day_of_month, SIZE(tpath) AS sz, tpath[0].day_of_month
AS tpath')
+);
+
+-- MATCHPATH on 1 partition
+SELECT origin_city_name, fl_num, year, month, day_of_month, sz, tpath
+FROM MATCHPATH(
+  ON flights_tiny 
+  SORT BY year, month, day_of_month, fl_num, origin_city_name
+  ARG1('LATE.LATE+'), ARG2('LATE'), ARG3(arr_delay > 15),
+  ARG4('origin_city_name, fl_num, year, month, day_of_month, SIZE(tpath) AS sz, tpath[0].day_of_month
AS tpath')
+)
+WHERE fl_num = 1142;

http://git-wip-us.apache.org/repos/asf/hive/blob/02976351/itests/hive-blobstore/src/test/queries/clientpositive/ptf_orcfile.q
----------------------------------------------------------------------
diff --git a/itests/hive-blobstore/src/test/queries/clientpositive/ptf_orcfile.q b/itests/hive-blobstore/src/test/queries/clientpositive/ptf_orcfile.q
new file mode 100644
index 0000000..7a25275
--- /dev/null
+++ b/itests/hive-blobstore/src/test/queries/clientpositive/ptf_orcfile.q
@@ -0,0 +1,32 @@
+-- Test several window functions on a table stored using ORC
+DROP TABLE part_orc;
+CREATE TABLE part_orc(
+  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
+)
+STORED AS ORC
+LOCATION '${hiveconf:test.blobstore.path.unique}/ptf_orcfile/part_orc';
+
+LOAD DATA LOCAL INPATH '../../data/files/part.orc' OVERWRITE INTO TABLE part_orc;
+
+-- Test windowing PTFs with several partitions, using ORC storage 
+SELECT 
+  p_mfgr, p_name, p_size,
+  RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS r,
+  DENSE_RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS dr, 
+  SUM(p_retailprice) OVER (
+    PARTITION BY p_mfgr 
+    ORDER BY p_name ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
+  ) AS s1
+FROM NOOP(
+  ON part_orc 
+  PARTITION BY p_mfgr 
+  ORDER BY p_name
+);

http://git-wip-us.apache.org/repos/asf/hive/blob/02976351/itests/hive-blobstore/src/test/queries/clientpositive/ptf_persistence.q
----------------------------------------------------------------------
diff --git a/itests/hive-blobstore/src/test/queries/clientpositive/ptf_persistence.q b/itests/hive-blobstore/src/test/queries/clientpositive/ptf_persistence.q
new file mode 100644
index 0000000..edc736a
--- /dev/null
+++ b/itests/hive-blobstore/src/test/queries/clientpositive/ptf_persistence.q
@@ -0,0 +1,15 @@
+-- Check PTFOperator is able to reset PTFPersistence (https://issues.apache.org/jira/browse/HIVE-4932)
+DROP TABLE ptf_persistence_table;
+CREATE TABLE ptf_persistence_table(
+  key int,
+  value string) 
+STORED AS TEXTFILE
+LOCATION '${hiveconf:test.blobstore.path.unique}/ptf_persistence/ptf_persistence_table';
+
+LOAD DATA LOCAL INPATH '../../data/files/srcbucket1.txt' INTO TABLE ptf_persistence_table;
+
+SET hive.conf.validation=false;
+SET hive.ptf.partition.persistence.memsize=32;
+SELECT key, value, NTILE(10)
+OVER (PARTITION BY value ORDER BY key DESC)
+FROM ptf_persistence_table;

http://git-wip-us.apache.org/repos/asf/hive/blob/02976351/itests/hive-blobstore/src/test/queries/clientpositive/ptf_rcfile.q
----------------------------------------------------------------------
diff --git a/itests/hive-blobstore/src/test/queries/clientpositive/ptf_rcfile.q b/itests/hive-blobstore/src/test/queries/clientpositive/ptf_rcfile.q
new file mode 100644
index 0000000..13edae3
--- /dev/null
+++ b/itests/hive-blobstore/src/test/queries/clientpositive/ptf_rcfile.q
@@ -0,0 +1,32 @@
+-- Test several window functions on a table stored using RC
+DROP TABLE part_rc;
+CREATE TABLE part_rc(
+  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
+)
+STORED AS RCFILE 
+LOCATION '${hiveconf:test.blobstore.path.unique}/ptf_rcfile/part_rc';
+
+LOAD DATA LOCAL INPATH '../../data/files/part.rc' OVERWRITE INTO TABLE part_rc;
+
+-- Test windowing PTFs with several partitions, using RC storage 
+SELECT 
+  p_mfgr, p_name, p_size,
+  RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS r,
+  DENSE_RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS dr, 
+  SUM(p_retailprice) OVER (
+    PARTITION BY p_mfgr 
+    ORDER BY p_name ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
+  ) AS s1
+FROM NOOP(
+  ON part_rc 
+  PARTITION BY p_mfgr 
+  ORDER BY p_name
+);

http://git-wip-us.apache.org/repos/asf/hive/blob/02976351/itests/hive-blobstore/src/test/queries/clientpositive/ptf_seqfile.q
----------------------------------------------------------------------
diff --git a/itests/hive-blobstore/src/test/queries/clientpositive/ptf_seqfile.q b/itests/hive-blobstore/src/test/queries/clientpositive/ptf_seqfile.q
new file mode 100644
index 0000000..6307d44
--- /dev/null
+++ b/itests/hive-blobstore/src/test/queries/clientpositive/ptf_seqfile.q
@@ -0,0 +1,32 @@
+-- Test several window functions on a table stored using sequence files
+DROP TABLE part_seq;
+CREATE TABLE part_seq( 
+  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
+)
+STORED AS SEQUENCEFILE 
+LOCATION '${hiveconf:test.blobstore.path.unique}/ptf_seqfile/part_seq';
+
+LOAD DATA LOCAL INPATH '../../data/files/part.seq' OVERWRITE INTO TABLE part_seq;
+
+-- Test windowing PTFs with several partitions, using sequence files storage 
+SELECT 
+  p_mfgr, p_name, p_size,
+  RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS r,
+  DENSE_RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS dr, 
+  SUM(p_retailprice) OVER (
+    PARTITION BY p_mfgr 
+    ORDER BY p_name ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
+  ) AS s1
+FROM NOOP(
+  ON part_seq 
+  PARTITION BY p_mfgr 
+  ORDER BY p_name
+);

http://git-wip-us.apache.org/repos/asf/hive/blob/02976351/itests/hive-blobstore/src/test/results/clientpositive/ptf_general_queries.q.out
----------------------------------------------------------------------
diff --git a/itests/hive-blobstore/src/test/results/clientpositive/ptf_general_queries.q.out
b/itests/hive-blobstore/src/test/results/clientpositive/ptf_general_queries.q.out
new file mode 100644
index 0000000..5e10716
--- /dev/null
+++ b/itests/hive-blobstore/src/test/results/clientpositive/ptf_general_queries.q.out
@@ -0,0 +1,139 @@
+PREHOOK: query: DROP TABLE part_tiny
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE part_tiny
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE TABLE part_tiny(
+  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
+)
+#### A masked pattern was here ####
+PREHOOK: type: CREATETABLE
+PREHOOK: Input: ### test.blobstore.path ###/ptf_general_queries/part_tiny
+PREHOOK: Output: database:default
+PREHOOK: Output: default@part_tiny
+POSTHOOK: query: CREATE TABLE part_tiny(
+  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
+)
+#### A masked pattern was here ####
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Input: ### test.blobstore.path ###/ptf_general_queries/part_tiny
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@part_tiny
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' INTO TABLE part_tiny
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@part_tiny
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' INTO TABLE part_tiny
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@part_tiny
+PREHOOK: query: SELECT p_mfgr, p_name, p_size
+FROM part_tiny
+DISTRIBUTE BY p_mfgr
+SORT BY p_name
+PREHOOK: type: QUERY
+PREHOOK: Input: default@part_tiny
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT p_mfgr, p_name, p_size
+FROM part_tiny
+DISTRIBUTE BY p_mfgr
+SORT BY p_name
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@part_tiny
+#### A masked pattern was here ####
+Manufacturer#5	almond antique blue firebrick mint	31
+Manufacturer#1	almond antique burnished rose metallic	2
+Manufacturer#1	almond antique burnished rose metallic	2
+Manufacturer#3	almond antique chartreuse khaki white	17
+Manufacturer#1	almond antique chartreuse lavender yellow	34
+Manufacturer#3	almond antique forest lavender goldenrod	14
+Manufacturer#4	almond antique gainsboro frosted violet	10
+Manufacturer#5	almond antique medium spring khaki	6
+Manufacturer#3	almond antique metallic orange dim	19
+Manufacturer#3	almond antique misty red olive	1
+Manufacturer#3	almond antique olive coral navajo	45
+Manufacturer#1	almond antique salmon chartreuse burlywood	6
+Manufacturer#5	almond antique sky peru orange	2
+Manufacturer#2	almond antique violet chocolate turquoise	14
+Manufacturer#4	almond antique violet mint lemon	39
+Manufacturer#2	almond antique violet turquoise frosted	40
+Manufacturer#1	almond aquamarine burnished black steel	28
+Manufacturer#5	almond aquamarine dodger light gainsboro	46
+Manufacturer#4	almond aquamarine floral ivory bisque	27
+Manufacturer#2	almond aquamarine midnight light salmon	2
+Manufacturer#1	almond aquamarine pink moccasin thistle	42
+Manufacturer#2	almond aquamarine rose maroon antique	25
+Manufacturer#2	almond aquamarine sandy cyan gainsboro	18
+Manufacturer#4	almond aquamarine yellow dodger mint	7
+Manufacturer#4	almond azure aquamarine papaya violet	12
+Manufacturer#5	almond azure blanched chiffon midnight	23
+PREHOOK: query: SELECT 
+  p_mfgr,p_name,p_retailprice,
+  SUM(p_retailprice) OVER(PARTITION BY p_mfgr ORDER BY p_name) AS sum,
+  MIN(p_retailprice) OVER(PARTITION BY p_mfgr ORDER BY p_name) AS min,
+  MAX(p_retailprice) OVER(PARTITION BY p_mfgr ORDER BY p_name) AS max,
+  AVG(p_retailprice) OVER(PARTITION BY p_mfgr ORDER BY p_name) AS avg
+FROM part_tiny
+PREHOOK: type: QUERY
+PREHOOK: Input: default@part_tiny
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT 
+  p_mfgr,p_name,p_retailprice,
+  SUM(p_retailprice) OVER(PARTITION BY p_mfgr ORDER BY p_name) AS sum,
+  MIN(p_retailprice) OVER(PARTITION BY p_mfgr ORDER BY p_name) AS min,
+  MAX(p_retailprice) OVER(PARTITION BY p_mfgr ORDER BY p_name) AS max,
+  AVG(p_retailprice) OVER(PARTITION BY p_mfgr ORDER BY p_name) AS avg
+FROM part_tiny
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@part_tiny
+#### A masked pattern was here ####
+Manufacturer#1	almond antique burnished rose metallic	1173.15	2346.3	1173.15	1173.15	1173.15
+Manufacturer#1	almond antique burnished rose metallic	1173.15	2346.3	1173.15	1173.15	1173.15
+Manufacturer#1	almond antique chartreuse lavender yellow	1753.76	4100.06	1173.15	1753.76
1366.6866666666667
+Manufacturer#1	almond antique salmon chartreuse burlywood	1602.59	5702.650000000001	1173.15
1753.76	1425.6625000000001
+Manufacturer#1	almond aquamarine burnished black steel	1414.42	7117.070000000001	1173.15
1753.76	1423.4140000000002
+Manufacturer#1	almond aquamarine pink moccasin thistle	1632.66	8749.730000000001	1173.15
1753.76	1458.2883333333336
+Manufacturer#2	almond antique violet chocolate turquoise	1690.68	1690.68	1690.68	1690.68
1690.68
+Manufacturer#2	almond antique violet turquoise frosted	1800.7	3491.38	1690.68	1800.7	1745.69
+Manufacturer#2	almond aquamarine midnight light salmon	2031.98	5523.360000000001	1690.68
2031.98	1841.1200000000001
+Manufacturer#2	almond aquamarine rose maroon antique	1698.66	7222.02	1690.68	2031.98	1805.505
+Manufacturer#2	almond aquamarine sandy cyan gainsboro	1701.6	8923.62	1690.68	2031.98	1784.7240000000002
+Manufacturer#3	almond antique chartreuse khaki white	1671.68	1671.68	1671.68	1671.68	1671.68
+Manufacturer#3	almond antique forest lavender goldenrod	1190.27	2861.95	1190.27	1671.68	1430.975
+Manufacturer#3	almond antique metallic orange dim	1410.39	4272.34	1190.27	1671.68	1424.1133333333335
+Manufacturer#3	almond antique misty red olive	1922.98	6195.32	1190.27	1922.98	1548.83
+Manufacturer#3	almond antique olive coral navajo	1337.29	7532.61	1190.27	1922.98	1506.522
+Manufacturer#4	almond antique gainsboro frosted violet	1620.67	1620.67	1620.67	1620.67	1620.67
+Manufacturer#4	almond antique violet mint lemon	1375.42	2996.09	1375.42	1620.67	1498.045
+Manufacturer#4	almond aquamarine floral ivory bisque	1206.26	4202.35	1206.26	1620.67	1400.7833333333335
+Manufacturer#4	almond aquamarine yellow dodger mint	1844.92	6047.27	1206.26	1844.92	1511.8175
+Manufacturer#4	almond azure aquamarine papaya violet	1290.35	7337.620000000001	1206.26	1844.92
1467.5240000000001
+Manufacturer#5	almond antique blue firebrick mint	1789.69	1789.69	1789.69	1789.69	1789.69
+Manufacturer#5	almond antique medium spring khaki	1611.66	3401.3500000000004	1611.66	1789.69
1700.6750000000002
+Manufacturer#5	almond antique sky peru orange	1788.73	5190.08	1611.66	1789.69	1730.0266666666666
+Manufacturer#5	almond aquamarine dodger light gainsboro	1018.1	6208.18	1018.1	1789.69	1552.045
+Manufacturer#5	almond azure blanched chiffon midnight	1464.48	7672.66	1018.1	1789.69	1534.532
+PREHOOK: query: SELECT 'tst1' AS key, COUNT(1) AS value FROM part_tiny
+PREHOOK: type: QUERY
+PREHOOK: Input: default@part_tiny
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT 'tst1' AS key, COUNT(1) AS value FROM part_tiny
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@part_tiny
+#### A masked pattern was here ####
+tst1	26

http://git-wip-us.apache.org/repos/asf/hive/blob/02976351/itests/hive-blobstore/src/test/results/clientpositive/ptf_matchpath.q.out
----------------------------------------------------------------------
diff --git a/itests/hive-blobstore/src/test/results/clientpositive/ptf_matchpath.q.out b/itests/hive-blobstore/src/test/results/clientpositive/ptf_matchpath.q.out
new file mode 100644
index 0000000..ac0eaad
--- /dev/null
+++ b/itests/hive-blobstore/src/test/results/clientpositive/ptf_matchpath.q.out
@@ -0,0 +1,105 @@
+PREHOOK: query: DROP TABLE flights_tiny
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE flights_tiny
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE TABLE flights_tiny (
+  origin_city_name string,
+  dest_city_name string,
+  year int,
+  month int,
+  day_of_month int,
+  arr_delay float,
+  fl_num string
+)
+#### A masked pattern was here ####
+PREHOOK: type: CREATETABLE
+PREHOOK: Input: ### test.blobstore.path ###/ptf_matchpath/flights_tiny
+PREHOOK: Output: database:default
+PREHOOK: Output: default@flights_tiny
+POSTHOOK: query: CREATE TABLE flights_tiny (
+  origin_city_name string,
+  dest_city_name string,
+  year int,
+  month int,
+  day_of_month int,
+  arr_delay float,
+  fl_num string
+)
+#### A masked pattern was here ####
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Input: ### test.blobstore.path ###/ptf_matchpath/flights_tiny
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@flights_tiny
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_tiny.txt' INTO TABLE flights_tiny
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@flights_tiny
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_tiny.txt' INTO TABLE flights_tiny
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@flights_tiny
+PREHOOK: query: SELECT origin_city_name, fl_num, year, month, day_of_month, sz, tpath
+FROM MATCHPATH(
+  ON flights_tiny 
+  DISTRIBUTE BY fl_num
+  SORT BY year, month, day_of_month
+  ARG1('LATE.LATE+'), ARG2('LATE'), ARG3(arr_delay > 15),
+  ARG4('origin_city_name, fl_num, year, month, day_of_month, SIZE(tpath) AS sz, tpath[0].day_of_month
AS tpath')
+)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@flights_tiny
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT origin_city_name, fl_num, year, month, day_of_month, sz, tpath
+FROM MATCHPATH(
+  ON flights_tiny 
+  DISTRIBUTE BY fl_num
+  SORT BY year, month, day_of_month
+  ARG1('LATE.LATE+'), ARG2('LATE'), ARG3(arr_delay > 15),
+  ARG4('origin_city_name, fl_num, year, month, day_of_month, SIZE(tpath) AS sz, tpath[0].day_of_month
AS tpath')
+)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@flights_tiny
+#### A masked pattern was here ####
+Baltimore	1142	2010	10	20	6	20
+Baltimore	1142	2010	10	21	5	21
+Baltimore	1142	2010	10	22	4	22
+Baltimore	1142	2010	10	25	3	25
+Baltimore	1142	2010	10	26	2	26
+Chicago	1531	2010	10	21	2	21
+Chicago	1531	2010	10	25	3	25
+Chicago	1531	2010	10	26	2	26
+Baltimore	1599	2010	10	21	2	21
+Baltimore	1599	2010	10	25	3	25
+Baltimore	1599	2010	10	26	2	26
+Chicago	361	2010	10	20	2	20
+Washington	7291	2010	10	27	2	27
+Chicago	897	2010	10	20	4	20
+Chicago	897	2010	10	21	3	21
+Chicago	897	2010	10	22	2	22
+PREHOOK: query: SELECT origin_city_name, fl_num, year, month, day_of_month, sz, tpath
+FROM MATCHPATH(
+  ON flights_tiny 
+  SORT BY year, month, day_of_month, fl_num, origin_city_name
+  ARG1('LATE.LATE+'), ARG2('LATE'), ARG3(arr_delay > 15),
+  ARG4('origin_city_name, fl_num, year, month, day_of_month, SIZE(tpath) AS sz, tpath[0].day_of_month
AS tpath')
+)
+WHERE fl_num = 1142
+PREHOOK: type: QUERY
+PREHOOK: Input: default@flights_tiny
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT origin_city_name, fl_num, year, month, day_of_month, sz, tpath
+FROM MATCHPATH(
+  ON flights_tiny 
+  SORT BY year, month, day_of_month, fl_num, origin_city_name
+  ARG1('LATE.LATE+'), ARG2('LATE'), ARG3(arr_delay > 15),
+  ARG4('origin_city_name, fl_num, year, month, day_of_month, SIZE(tpath) AS sz, tpath[0].day_of_month
AS tpath')
+)
+WHERE fl_num = 1142
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@flights_tiny
+#### A masked pattern was here ####
+Baltimore	1142	2010	10	21	3	21
+Baltimore	1142	2010	10	22	3	22
+Baltimore	1142	2010	10	25	3	25
+Baltimore	1142	2010	10	26	3	26
+Baltimore	1142	2010	10	27	3	27

http://git-wip-us.apache.org/repos/asf/hive/blob/02976351/itests/hive-blobstore/src/test/results/clientpositive/ptf_orcfile.q.out
----------------------------------------------------------------------
diff --git a/itests/hive-blobstore/src/test/results/clientpositive/ptf_orcfile.q.out b/itests/hive-blobstore/src/test/results/clientpositive/ptf_orcfile.q.out
new file mode 100644
index 0000000..5cfe773
--- /dev/null
+++ b/itests/hive-blobstore/src/test/results/clientpositive/ptf_orcfile.q.out
@@ -0,0 +1,104 @@
+PREHOOK: query: DROP TABLE part_orc
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE part_orc
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE TABLE part_orc(
+  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
+)
+STORED AS ORC
+#### A masked pattern was here ####
+PREHOOK: type: CREATETABLE
+PREHOOK: Input: ### test.blobstore.path ###/ptf_orcfile/part_orc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@part_orc
+POSTHOOK: query: CREATE TABLE part_orc(
+  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
+)
+STORED AS ORC
+#### A masked pattern was here ####
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Input: ### test.blobstore.path ###/ptf_orcfile/part_orc
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@part_orc
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part.orc' OVERWRITE INTO TABLE part_orc
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@part_orc
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part.orc' OVERWRITE INTO TABLE
part_orc
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@part_orc
+PREHOOK: query: SELECT 
+  p_mfgr, p_name, p_size,
+  RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS r,
+  DENSE_RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS dr, 
+  SUM(p_retailprice) OVER (
+    PARTITION BY p_mfgr 
+    ORDER BY p_name ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
+  ) AS s1
+FROM NOOP(
+  ON part_orc 
+  PARTITION BY p_mfgr 
+  ORDER BY p_name
+)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@part_orc
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT 
+  p_mfgr, p_name, p_size,
+  RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS r,
+  DENSE_RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS dr, 
+  SUM(p_retailprice) OVER (
+    PARTITION BY p_mfgr 
+    ORDER BY p_name ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
+  ) AS s1
+FROM NOOP(
+  ON part_orc 
+  PARTITION BY p_mfgr 
+  ORDER BY p_name
+)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@part_orc
+#### A masked pattern was here ####
+Manufacturer#1	almond antique burnished rose metallic	2	1	1	1173.15
+Manufacturer#1	almond antique burnished rose metallic	2	1	1	2346.3
+Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2	4100.06
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	5702.650000000001
+Manufacturer#1	almond aquamarine burnished black steel	28	5	4	7117.070000000001
+Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	8749.730000000001
+Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	1690.68
+Manufacturer#2	almond antique violet turquoise frosted	40	2	2	3491.38
+Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	5523.360000000001
+Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	7222.02
+Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	8923.62
+Manufacturer#3	almond antique chartreuse khaki white	17	1	1	1671.68
+Manufacturer#3	almond antique forest lavender goldenrod	14	2	2	2861.95
+Manufacturer#3	almond antique metallic orange dim	19	3	3	4272.34
+Manufacturer#3	almond antique misty red olive	1	4	4	6195.32
+Manufacturer#3	almond antique olive coral navajo	45	5	5	7532.61
+Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	1620.67
+Manufacturer#4	almond antique violet mint lemon	39	2	2	2996.09
+Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	4202.35
+Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	6047.27
+Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	7337.620000000001
+Manufacturer#5	almond antique blue firebrick mint	31	1	1	1789.69
+Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.3500000000004
+Manufacturer#5	almond antique sky peru orange	2	3	3	5190.08
+Manufacturer#5	almond aquamarine dodger light gainsboro	46	4	4	6208.18
+Manufacturer#5	almond azure blanched chiffon midnight	23	5	5	7672.66

http://git-wip-us.apache.org/repos/asf/hive/blob/02976351/itests/hive-blobstore/src/test/results/clientpositive/ptf_persistence.q.out
----------------------------------------------------------------------
diff --git a/itests/hive-blobstore/src/test/results/clientpositive/ptf_persistence.q.out b/itests/hive-blobstore/src/test/results/clientpositive/ptf_persistence.q.out
new file mode 100644
index 0000000..d685cf1
--- /dev/null
+++ b/itests/hive-blobstore/src/test/results/clientpositive/ptf_persistence.q.out
@@ -0,0 +1,549 @@
+PREHOOK: query: DROP TABLE ptf_persistence_table
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE ptf_persistence_table
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE TABLE ptf_persistence_table(
+  key int,
+  value string) 
+STORED AS TEXTFILE
+#### A masked pattern was here ####
+PREHOOK: type: CREATETABLE
+PREHOOK: Input: ### test.blobstore.path ###/ptf_persistence/ptf_persistence_table
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ptf_persistence_table
+POSTHOOK: query: CREATE TABLE ptf_persistence_table(
+  key int,
+  value string) 
+STORED AS TEXTFILE
+#### A masked pattern was here ####
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Input: ### test.blobstore.path ###/ptf_persistence/ptf_persistence_table
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@ptf_persistence_table
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/srcbucket1.txt' INTO TABLE ptf_persistence_table
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@ptf_persistence_table
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/srcbucket1.txt' INTO TABLE ptf_persistence_table
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@ptf_persistence_table
+PREHOOK: query: SELECT key, value, NTILE(10)
+OVER (PARTITION BY value ORDER BY key DESC)
+FROM ptf_persistence_table
+PREHOOK: type: QUERY
+PREHOOK: Input: default@ptf_persistence_table
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT key, value, NTILE(10)
+OVER (PARTITION BY value ORDER BY key DESC)
+FROM ptf_persistence_table
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@ptf_persistence_table
+#### A masked pattern was here ####
+99	val_100	1
+101	val_102	1
+103	val_103	1
+103	val_103	2
+105	val_105	1
+105	val_106	1
+105	val_106	2
+11	val_11	1
+111	val_111	1
+113	val_113	1
+113	val_113	2
+117	val_118	1
+117	val_118	2
+119	val_119	1
+119	val_119	2
+119	val_119	3
+11	val_12	1
+11	val_12	2
+11	val_12	3
+119	val_120	1
+119	val_120	2
+119	val_120	3
+121	val_122	1
+121	val_122	2
+123	val_124	1
+123	val_124	2
+125	val_125	1
+125	val_125	2
+125	val_126	1
+129	val_129	1
+129	val_129	2
+129	val_130	1
+129	val_130	2
+131	val_131	1
+133	val_133	1
+133	val_134	1
+135	val_136	1
+135	val_136	2
+135	val_136	3
+137	val_137	1
+137	val_137	2
+137	val_138	1
+143	val_143	1
+143	val_144	1
+145	val_145	1
+147	val_148	1
+147	val_148	2
+149	val_149	1
+149	val_149	2
+15	val_15	1
+15	val_15	2
+149	val_150	1
+151	val_152	1
+151	val_152	2
+153	val_153	1
+153	val_154	1
+153	val_154	2
+155	val_155	1
+157	val_157	1
+157	val_158	1
+157	val_158	2
+15	val_16	1
+15	val_16	2
+161	val_162	1
+161	val_162	2
+161	val_162	3
+161	val_162	4
+163	val_163	1
+165	val_165	1
+165	val_165	2
+165	val_166	1
+167	val_167	1
+167	val_167	2
+167	val_167	3
+167	val_168	1
+169	val_169	1
+169	val_169	2
+169	val_169	3
+169	val_169	4
+17	val_17	1
+175	val_175	1
+175	val_175	2
+175	val_176	1
+175	val_176	2
+177	val_177	1
+177	val_178	1
+177	val_178	2
+179	val_179	1
+179	val_179	2
+179	val_180	1
+181	val_181	1
+183	val_183	1
+183	val_184	1
+185	val_186	1
+187	val_187	1
+187	val_187	2
+187	val_187	3
+189	val_189	1
+19	val_19	1
+189	val_190	1
+191	val_191	1
+191	val_191	2
+191	val_192	1
+193	val_193	1
+193	val_193	2
+193	val_193	3
+195	val_195	1
+195	val_195	2
+197	val_197	1
+197	val_197	2
+197	val_198	1
+199	val_199	1
+199	val_199	2
+199	val_199	3
+1	val_2	1
+19	val_20	1
+199	val_200	1
+201	val_201	1
+203	val_203	1
+203	val_203	2
+205	val_205	1
+205	val_205	2
+205	val_206	1
+207	val_207	1
+207	val_207	2
+209	val_209	1
+209	val_209	2
+209	val_210	1
+209	val_210	2
+213	val_213	1
+213	val_213	2
+213	val_214	1
+215	val_216	1
+217	val_217	1
+217	val_217	2
+217	val_218	1
+217	val_218	2
+219	val_219	1
+219	val_219	2
+21	val_22	1
+21	val_22	2
+21	val_22	3
+21	val_22	4
+221	val_221	1
+221	val_221	2
+223	val_223	1
+223	val_223	2
+227	val_228	1
+229	val_229	1
+229	val_229	2
+231	val_232	1
+233	val_233	1
+233	val_233	2
+235	val_235	1
+235	val_236	1
+237	val_237	1
+237	val_237	2
+239	val_239	1
+239	val_239	2
+23	val_24	1
+239	val_240	1
+239	val_240	2
+241	val_241	1
+241	val_242	1
+241	val_242	2
+241	val_242	3
+241	val_242	4
+243	val_244	1
+243	val_244	2
+245	val_246	1
+245	val_246	2
+247	val_247	1
+249	val_249	1
+249	val_250	1
+249	val_250	2
+255	val_255	1
+255	val_255	2
+257	val_257	1
+257	val_258	1
+257	val_258	2
+259	val_260	1
+259	val_260	2
+261	val_262	1
+263	val_263	1
+265	val_265	1
+265	val_265	2
+265	val_266	1
+267	val_268	1
+27	val_27	1
+271	val_272	1
+273	val_273	1
+273	val_273	2
+273	val_273	3
+273	val_274	1
+275	val_275	1
+275	val_276	1
+275	val_276	2
+277	val_277	1
+277	val_277	2
+277	val_277	3
+277	val_277	4
+277	val_278	1
+277	val_278	2
+281	val_281	1
+281	val_281	2
+281	val_282	1
+281	val_282	2
+281	val_282	3
+283	val_283	1
+285	val_285	1
+285	val_286	1
+287	val_287	1
+287	val_288	1
+287	val_288	2
+289	val_289	1
+289	val_290	1
+291	val_291	1
+291	val_292	1
+291	val_292	2
+293	val_294	1
+293	val_294	2
+295	val_296	1
+295	val_296	2
+29	val_30	1
+29	val_30	2
+303	val_304	1
+303	val_304	2
+305	val_305	1
+305	val_306	1
+307	val_307	1
+307	val_307	2
+309	val_309	1
+309	val_309	2
+309	val_310	1
+311	val_311	1
+311	val_311	2
+311	val_311	3
+313	val_314	1
+315	val_315	1
+317	val_317	1
+317	val_317	2
+317	val_318	1
+31	val_32	1
+321	val_321	1
+321	val_321	2
+323	val_323	1
+323	val_324	1
+325	val_325	1
+325	val_325	2
+327	val_327	1
+327	val_327	2
+327	val_327	3
+33	val_33	1
+331	val_331	1
+331	val_331	2
+331	val_332	1
+331	val_332	2
+333	val_333	1
+333	val_333	2
+333	val_334	1
+335	val_335	1
+335	val_336	1
+335	val_336	2
+337	val_338	1
+339	val_339	1
+33	val_34	1
+341	val_341	1
+341	val_342	1
+341	val_342	2
+341	val_342	3
+343	val_344	1
+345	val_345	1
+347	val_348	1
+347	val_348	2
+35	val_35	1
+35	val_35	2
+35	val_35	3
+349	val_350	1
+349	val_350	2
+349	val_350	3
+349	val_350	4
+351	val_351	1
+351	val_352	1
+351	val_352	2
+353	val_353	1
+353	val_353	2
+353	val_354	1
+355	val_356	1
+355	val_356	2
+35	val_36	1
+35	val_36	2
+35	val_36	3
+363	val_364	1
+363	val_364	2
+363	val_364	3
+365	val_365	1
+367	val_367	1
+367	val_367	2
+367	val_368	1
+367	val_368	2
+369	val_369	1
+369	val_369	2
+369	val_369	3
+37	val_37	1
+37	val_37	2
+369	val_370	1
+371	val_372	1
+371	val_372	2
+371	val_372	3
+371	val_372	4
+373	val_373	1
+373	val_374	1
+375	val_375	1
+375	val_376	1
+375	val_376	2
+375	val_376	3
+375	val_376	4
+375	val_376	5
+377	val_377	1
+379	val_379	1
+379	val_380	1
+381	val_382	1
+385	val_386	1
+385	val_386	2
+389	val_389	1
+389	val_390	1
+389	val_390	2
+391	val_392	1
+391	val_392	2
+393	val_393	1
+393	val_394	1
+393	val_394	2
+395	val_395	1
+395	val_395	2
+395	val_396	1
+395	val_396	2
+397	val_397	1
+397	val_397	2
+399	val_399	1
+399	val_399	2
+3	val_4	1
+399	val_400	1
+399	val_400	2
+401	val_401	1
+401	val_401	2
+401	val_401	3
+401	val_401	4
+401	val_401	5
+401	val_402	1
+403	val_403	1
+403	val_403	2
+403	val_403	3
+405	val_406	1
+407	val_407	1
+407	val_408	1
+407	val_408	2
+407	val_408	3
+409	val_409	1
+409	val_409	2
+409	val_409	3
+41	val_41	1
+409	val_410	1
+409	val_410	2
+411	val_411	1
+411	val_412	1
+413	val_413	1
+413	val_413	2
+413	val_414	1
+415	val_416	1
+417	val_417	1
+417	val_417	2
+417	val_417	3
+419	val_419	1
+421	val_421	1
+421	val_422	1
+421	val_422	2
+423	val_424	1
+425	val_426	1
+427	val_427	1
+427	val_428	1
+427	val_428	2
+429	val_429	1
+429	val_429	2
+43	val_43	1
+429	val_430	1
+429	val_430	2
+431	val_431	1
+431	val_431	2
+431	val_431	3
+431	val_432	1
+435	val_435	1
+435	val_436	1
+437	val_437	1
+437	val_438	1
+439	val_439	1
+439	val_439	2
+439	val_440	1
+439	val_440	2
+441	val_442	1
+443	val_443	1
+443	val_444	1
+443	val_444	2
+443	val_444	3
+447	val_448	1
+449	val_449	1
+451	val_452	1
+453	val_453	1
+453	val_454	1
+455	val_455	1
+455	val_456	1
+455	val_456	2
+457	val_457	1
+457	val_458	1
+457	val_458	2
+459	val_459	1
+459	val_459	2
+459	val_460	1
+461	val_462	1
+463	val_463	1
+463	val_463	2
+463	val_464	1
+467	val_467	1
+467	val_468	1
+469	val_469	1
+469	val_469	2
+469	val_469	3
+469	val_469	4
+469	val_469	5
+47	val_47	1
+469	val_470	1
+473	val_474	1
+475	val_475	1
+475	val_476	1
+477	val_477	1
+477	val_478	1
+479	val_479	1
+47	val_48	1
+481	val_481	1
+481	val_482	1
+483	val_483	1
+485	val_485	1
+485	val_486	1
+485	val_486	2
+487	val_487	1
+487	val_488	1
+489	val_489	1
+489	val_489	2
+489	val_489	3
+489	val_489	4
+489	val_490	1
+491	val_491	1
+491	val_492	1
+491	val_492	2
+493	val_493	1
+495	val_495	1
+495	val_496	1
+497	val_497	1
+497	val_498	1
+497	val_498	2
+5	val_5	1
+5	val_5	2
+5	val_5	3
+49	val_50	1
+49	val_50	2
+51	val_51	1
+51	val_51	2
+51	val_52	1
+53	val_53	1
+53	val_54	1
+57	val_57	1
+5	val_6	1
+59	val_60	1
+61	val_62	1
+63	val_64	1
+65	val_65	1
+65	val_66	1
+65	val_66	2
+67	val_67	1
+67	val_67	2
+69	val_69	1
+69	val_70	1
+71	val_72	1
+75	val_76	1
+77	val_77	1
+77	val_78	1
+77	val_78	2
+83	val_83	1
+83	val_83	2
+85	val_85	1
+85	val_86	1
+87	val_87	1
+87	val_88	1
+87	val_88	2
+9	val_9	1
+89	val_90	1
+89	val_90	2
+89	val_90	3
+91	val_92	1
+93	val_94	1
+93	val_94	2
+93	val_94	3
+95	val_95	1
+95	val_95	2
+97	val_97	1
+97	val_97	2
+97	val_98	1
+97	val_98	2

http://git-wip-us.apache.org/repos/asf/hive/blob/02976351/itests/hive-blobstore/src/test/results/clientpositive/ptf_rcfile.q.out
----------------------------------------------------------------------
diff --git a/itests/hive-blobstore/src/test/results/clientpositive/ptf_rcfile.q.out b/itests/hive-blobstore/src/test/results/clientpositive/ptf_rcfile.q.out
new file mode 100644
index 0000000..4eb82a6
--- /dev/null
+++ b/itests/hive-blobstore/src/test/results/clientpositive/ptf_rcfile.q.out
@@ -0,0 +1,104 @@
+PREHOOK: query: DROP TABLE part_rc
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE part_rc
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE TABLE part_rc(
+  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
+)
+STORED AS RCFILE 
+#### A masked pattern was here ####
+PREHOOK: type: CREATETABLE
+PREHOOK: Input: ### test.blobstore.path ###/ptf_rcfile/part_rc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@part_rc
+POSTHOOK: query: CREATE TABLE part_rc(
+  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
+)
+STORED AS RCFILE 
+#### A masked pattern was here ####
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Input: ### test.blobstore.path ###/ptf_rcfile/part_rc
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@part_rc
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part.rc' OVERWRITE INTO TABLE part_rc
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@part_rc
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part.rc' OVERWRITE INTO TABLE part_rc
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@part_rc
+PREHOOK: query: SELECT 
+  p_mfgr, p_name, p_size,
+  RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS r,
+  DENSE_RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS dr, 
+  SUM(p_retailprice) OVER (
+    PARTITION BY p_mfgr 
+    ORDER BY p_name ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
+  ) AS s1
+FROM NOOP(
+  ON part_rc 
+  PARTITION BY p_mfgr 
+  ORDER BY p_name
+)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@part_rc
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT 
+  p_mfgr, p_name, p_size,
+  RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS r,
+  DENSE_RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS dr, 
+  SUM(p_retailprice) OVER (
+    PARTITION BY p_mfgr 
+    ORDER BY p_name ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
+  ) AS s1
+FROM NOOP(
+  ON part_rc 
+  PARTITION BY p_mfgr 
+  ORDER BY p_name
+)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@part_rc
+#### A masked pattern was here ####
+Manufacturer#1	almond antique burnished rose metallic	2	1	1	1173.15
+Manufacturer#1	almond antique burnished rose metallic	2	1	1	2346.3
+Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2	4100.06
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	5702.650000000001
+Manufacturer#1	almond aquamarine burnished black steel	28	5	4	7117.070000000001
+Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	8749.730000000001
+Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	1690.68
+Manufacturer#2	almond antique violet turquoise frosted	40	2	2	3491.38
+Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	5523.360000000001
+Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	7222.02
+Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	8923.62
+Manufacturer#3	almond antique chartreuse khaki white	17	1	1	1671.68
+Manufacturer#3	almond antique forest lavender goldenrod	14	2	2	2861.95
+Manufacturer#3	almond antique metallic orange dim	19	3	3	4272.34
+Manufacturer#3	almond antique misty red olive	1	4	4	6195.32
+Manufacturer#3	almond antique olive coral navajo	45	5	5	7532.61
+Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	1620.67
+Manufacturer#4	almond antique violet mint lemon	39	2	2	2996.09
+Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	4202.35
+Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	6047.27
+Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	7337.620000000001
+Manufacturer#5	almond antique blue firebrick mint	31	1	1	1789.69
+Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.3500000000004
+Manufacturer#5	almond antique sky peru orange	2	3	3	5190.08
+Manufacturer#5	almond aquamarine dodger light gainsboro	46	4	4	6208.18
+Manufacturer#5	almond azure blanched chiffon midnight	23	5	5	7672.66

http://git-wip-us.apache.org/repos/asf/hive/blob/02976351/itests/hive-blobstore/src/test/results/clientpositive/ptf_seqfile.q.out
----------------------------------------------------------------------
diff --git a/itests/hive-blobstore/src/test/results/clientpositive/ptf_seqfile.q.out b/itests/hive-blobstore/src/test/results/clientpositive/ptf_seqfile.q.out
new file mode 100644
index 0000000..957b8b8
--- /dev/null
+++ b/itests/hive-blobstore/src/test/results/clientpositive/ptf_seqfile.q.out
@@ -0,0 +1,104 @@
+PREHOOK: query: DROP TABLE part_seq
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: DROP TABLE part_seq
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE TABLE part_seq( 
+  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
+)
+STORED AS SEQUENCEFILE 
+#### A masked pattern was here ####
+PREHOOK: type: CREATETABLE
+PREHOOK: Input: ### test.blobstore.path ###/ptf_seqfile/part_seq
+PREHOOK: Output: database:default
+PREHOOK: Output: default@part_seq
+POSTHOOK: query: CREATE TABLE part_seq( 
+  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
+)
+STORED AS SEQUENCEFILE 
+#### A masked pattern was here ####
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Input: ### test.blobstore.path ###/ptf_seqfile/part_seq
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@part_seq
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part.seq' OVERWRITE INTO TABLE part_seq
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@part_seq
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part.seq' OVERWRITE INTO TABLE
part_seq
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@part_seq
+PREHOOK: query: SELECT 
+  p_mfgr, p_name, p_size,
+  RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS r,
+  DENSE_RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS dr, 
+  SUM(p_retailprice) OVER (
+    PARTITION BY p_mfgr 
+    ORDER BY p_name ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
+  ) AS s1
+FROM NOOP(
+  ON part_seq 
+  PARTITION BY p_mfgr 
+  ORDER BY p_name
+)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@part_seq
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT 
+  p_mfgr, p_name, p_size,
+  RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS r,
+  DENSE_RANK() OVER (PARTITION BY p_mfgr ORDER BY p_name) AS dr, 
+  SUM(p_retailprice) OVER (
+    PARTITION BY p_mfgr 
+    ORDER BY p_name ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
+  ) AS s1
+FROM NOOP(
+  ON part_seq 
+  PARTITION BY p_mfgr 
+  ORDER BY p_name
+)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@part_seq
+#### A masked pattern was here ####
+Manufacturer#1	almond antique burnished rose metallic	2	1	1	1173.15
+Manufacturer#1	almond antique burnished rose metallic	2	1	1	2346.3
+Manufacturer#1	almond antique chartreuse lavender yellow	34	3	2	4100.06
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	4	3	5702.650000000001
+Manufacturer#1	almond aquamarine burnished black steel	28	5	4	7117.070000000001
+Manufacturer#1	almond aquamarine pink moccasin thistle	42	6	5	8749.730000000001
+Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	1690.68
+Manufacturer#2	almond antique violet turquoise frosted	40	2	2	3491.38
+Manufacturer#2	almond aquamarine midnight light salmon	2	3	3	5523.360000000001
+Manufacturer#2	almond aquamarine rose maroon antique	25	4	4	7222.02
+Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	5	5	8923.62
+Manufacturer#3	almond antique chartreuse khaki white	17	1	1	1671.68
+Manufacturer#3	almond antique forest lavender goldenrod	14	2	2	2861.95
+Manufacturer#3	almond antique metallic orange dim	19	3	3	4272.34
+Manufacturer#3	almond antique misty red olive	1	4	4	6195.32
+Manufacturer#3	almond antique olive coral navajo	45	5	5	7532.61
+Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	1620.67
+Manufacturer#4	almond antique violet mint lemon	39	2	2	2996.09
+Manufacturer#4	almond aquamarine floral ivory bisque	27	3	3	4202.35
+Manufacturer#4	almond aquamarine yellow dodger mint	7	4	4	6047.27
+Manufacturer#4	almond azure aquamarine papaya violet	12	5	5	7337.620000000001
+Manufacturer#5	almond antique blue firebrick mint	31	1	1	1789.69
+Manufacturer#5	almond antique medium spring khaki	6	2	2	3401.3500000000004
+Manufacturer#5	almond antique sky peru orange	2	3	3	5190.08
+Manufacturer#5	almond aquamarine dodger light gainsboro	46	4	4	6208.18
+Manufacturer#5	almond azure blanched chiffon midnight	23	5	5	7672.66


Mime
View raw message