You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2013/02/05 02:01:26 UTC
svn commit: r1442447 - in /hive/branches/ptf-windowing: data/files/
ql/src/test/queries/clientpositive/ ql/src/test/results/clientpositive/
Author: hashutosh
Date: Tue Feb 5 01:01:26 2013
New Revision: 1442447
URL: http://svn.apache.org/viewvc?rev=1442447&view=rev
Log:
HIVE-3981 : Split up tests in ptf_general_queries.q (Ashutosh Chauhan. Reviewed by Harish Bhutani)
Added:
hive/branches/ptf-windowing/data/files/part.rc (with props)
hive/branches/ptf-windowing/data/files/part.seq (with props)
hive/branches/ptf-windowing/ql/src/test/queries/clientpositive/ptf_rcfile.q
hive/branches/ptf-windowing/ql/src/test/queries/clientpositive/ptf_seqfile.q
hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_rcfile.q.out
hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_seqfile.q.out
Modified:
hive/branches/ptf-windowing/ql/src/test/queries/clientpositive/ptf_general_queries.q
hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_general_queries.q.out
Added: hive/branches/ptf-windowing/data/files/part.rc
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/data/files/part.rc?rev=1442447&view=auto
==============================================================================
Binary file - no diff available.
Propchange: hive/branches/ptf-windowing/data/files/part.rc
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: hive/branches/ptf-windowing/data/files/part.seq
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/data/files/part.seq?rev=1442447&view=auto
==============================================================================
Binary file - no diff available.
Propchange: hive/branches/ptf-windowing/data/files/part.seq
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Modified: hive/branches/ptf-windowing/ql/src/test/queries/clientpositive/ptf_general_queries.q
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/queries/clientpositive/ptf_general_queries.q?rev=1442447&r1=1442446&r2=1442447&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/queries/clientpositive/ptf_general_queries.q (original)
+++ hive/branches/ptf-windowing/ql/src/test/queries/clientpositive/ptf_general_queries.q Tue Feb 5 01:01:26 2013
@@ -1,6 +1,4 @@
DROP TABLE part;
-DROP TABLE part_rc;
-DROP TABLE part_seq;
DROP TABLE flights_tiny;
-- data setup
@@ -18,34 +16,6 @@ CREATE TABLE part(
LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part;
-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 ;
-
-LOAD DATA LOCAL INPATH '../data/files/part.rc' overwrite into table part_rc;
-
-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 ;
-
-LOAD DATA LOCAL INPATH '../data/files/part.seq' overwrite into table part_seq;
-
create table flights_tiny (
ORIGIN_CITY_NAME string,
DEST_CITY_NAME string,
@@ -531,28 +501,10 @@ distribute by p_mfgr
sort by p_name
window w1 as rows between 2 preceding and current row;
--- 48. testWindowingPTFWithPartRC
-select p_mfgr, p_name, p_size,
-rank() as r,
-denserank() as dr,
-sum(p_retailprice) as s1 over (rows between unbounded preceding and current row)
-from noop(part_rc
-distribute by p_mfgr
-sort by p_name);
-
--- 49. testWindowingPTFWithPartSeqFile
-select p_mfgr, p_name, p_size,
-rank() as r,
-denserank() as dr,
-sum(p_retailprice) as s1 over (rows between unbounded preceding and current row)
-from noop(part_seq
-distribute by p_mfgr
-sort by p_name);
-
--- 50. testConstExprInSelect
+-- 48. testConstExprInSelect
select 'tst1' as key, count(1) as value from part;
--- 51. testMultipleInserts3SWQs
+-- 49. testMultipleInserts3SWQs
CREATE TABLE part_1(
p_mfgr STRING,
p_name STRING,
@@ -615,7 +567,7 @@ select * from part_2;
select * from part_3;
--- 52. testGroupByHavingWithSWQAndAlias
+-- 50. testGroupByHavingWithSWQAndAlias
select p_mfgr, p_name, p_size, min(p_retailprice) as mi,
rank() as r,
denserank() as dr,
@@ -626,7 +578,7 @@ having p_size > 0
distribute by p_mfgr
sort by p_name;
--- 53. testMultipleRangeWindows
+-- 51. testMultipleRangeWindows
select p_mfgr,p_name, p_size,
sum(p_size) as s2 over (range between p_size 10 less and current row),
sum(p_size) as s1 over (range between current row and p_size 10 more )
@@ -635,7 +587,7 @@ distribute by p_mfgr
sort by p_mfgr, p_size
window w1 as rows between 2 preceding and 2 following;
--- 54. testMultipleInserts2SWQsWithPTF
+-- 52. testMultipleInserts2SWQsWithPTF
CREATE TABLE part_4(
p_mfgr STRING,
p_name STRING,
@@ -680,18 +632,18 @@ select * from part_4;
select * from part_5;
--- 55. testPartOrderInUDAFInvoke
+-- 53. testPartOrderInUDAFInvoke
select p_mfgr, p_name, p_size,
sum(p_size) as s over (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following)
from part;
--- 56. testPartOrderInWdwDef
+-- 54. testPartOrderInWdwDef
select p_mfgr, p_name, p_size,
sum(p_size) as s over (w1)
from part
window w1 as distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following;
--- 57. testDefaultPartitioningSpecRules
+-- 55. testDefaultPartitioningSpecRules
select p_mfgr, p_name, p_size,
sum(p_size) as s over (w1),
sum(p_size) as s2 over(w2)
@@ -700,7 +652,7 @@ sort by p_name
window w1 as distribute by p_mfgr rows between 2 preceding and 2 following,
w2 as distribute by p_mfgr sort by p_name;
--- 58. testWindowCrossReference
+-- 56. testWindowCrossReference
select p_mfgr, p_name, p_size,
sum(p_size) as s1 over (w1),
sum(p_size) as s2 over (w2)
@@ -709,7 +661,7 @@ window w1 as distribute by p_mfgr sort b
w2 as w1;
--- 59. testWindowInheritance
+-- 57. testWindowInheritance
select p_mfgr, p_name, p_size,
sum(p_size) as s1 over (w1),
sum(p_size) as s2 over (w2)
@@ -718,7 +670,7 @@ window w1 as distribute by p_mfgr sort b
w2 as w1 rows between unbounded preceding and current row;
--- 60. testWindowForwardReference
+-- 58. testWindowForwardReference
select p_mfgr, p_name, p_size,
sum(p_size) as s1 over (w1),
sum(p_size) as s2 over (w2),
@@ -731,7 +683,7 @@ window w1 as rows between 2 preceding an
w3 as rows between unbounded preceding and current row;
--- 61. testWindowDefinitionPropagation
+-- 59. testWindowDefinitionPropagation
select p_mfgr, p_name, p_size,
sum(p_size) as s1 over (w1),
sum(p_size) as s2 over (w2),
@@ -743,7 +695,7 @@ window w1 as rows between 2 preceding an
w2 as w3,
w3 as rows between unbounded preceding and current row;
--- 62. testDistinctWithWindowing
+-- 60. testDistinctWithWindowing
select DISTINCT p_mfgr, p_name, p_size,
sum(p_size) as s over (w1)
from part
@@ -751,7 +703,7 @@ distribute by p_mfgr
sort by p_name
window w1 as rows between 2 preceding and 2 following;
--- 63. testMulti2OperatorsFunctionChainWithMap
+-- 61. testMulti2OperatorsFunctionChainWithMap
select p_mfgr, p_name,
rank() as r,
denserank() as dr,
@@ -768,7 +720,7 @@ from noop(
distribute by p_mfgr,p_name
sort by p_mfgr,p_name) ;
--- 64. testMulti3OperatorsFunctionChain
+-- 62. testMulti3OperatorsFunctionChain
select p_mfgr, p_name,
rank() as r,
denserank() as dr,
@@ -785,7 +737,7 @@ from noop(
distribute by p_mfgr
sort by p_mfgr ) ;
--- 65. testMultiOperatorChainWithNoWindowing
+-- 63. testMultiOperatorChainWithNoWindowing
select p_mfgr, p_name,
rank() as r,
denserank() as dr,
@@ -801,7 +753,7 @@ from noop(
sort by p_mfgr));
--- 66. testMultiOperatorChainEndsWithNoopMap
+-- 64. testMultiOperatorChainEndsWithNoopMap
select p_mfgr, p_name,
rank() as r,
denserank() as dr,
@@ -818,7 +770,7 @@ from noopwithmap(
distribute by p_mfgr,p_name
sort by p_mfgr,p_name);
---67. testMultiOperatorChainWithDiffPartitionForWindow1
+--65. testMultiOperatorChainWithDiffPartitionForWindow1
select p_mfgr, p_name,
rank() as r,
denserank() as dr,
@@ -834,7 +786,7 @@ from noop(
sort by p_mfgr
));
---68. testMultiOperatorChainWithDiffPartitionForWindow2
+--66. testMultiOperatorChainWithDiffPartitionForWindow2
select p_mfgr, p_name,
rank() as r,
denserank() as dr,
@@ -848,7 +800,7 @@ from noopwithmap(
sort by p_mfgr, p_name)
));
--- 69. basic Npath test
+-- 67. basic Npath test
select origin_city_name, fl_num, year, month, day_of_month, sz, tpath
from npath(
'LATE.LATE+',
@@ -860,7 +812,7 @@ from npath(
sort by year, month, day_of_month
);
--- 70. testRankWithPartitioning
+-- 68. testRankWithPartitioning
select p_mfgr, p_name, p_size,
rank() as r over (distribute by p_mfgr sort by p_name )
from part;
Added: hive/branches/ptf-windowing/ql/src/test/queries/clientpositive/ptf_rcfile.q
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/queries/clientpositive/ptf_rcfile.q?rev=1442447&view=auto
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/queries/clientpositive/ptf_rcfile.q (added)
+++ hive/branches/ptf-windowing/ql/src/test/queries/clientpositive/ptf_rcfile.q Tue Feb 5 01:01:26 2013
@@ -0,0 +1,24 @@
+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 ;
+
+LOAD DATA LOCAL INPATH '../data/files/part.rc' overwrite into table part_rc;
+
+-- testWindowingPTFWithPartRC
+select p_mfgr, p_name, p_size,
+rank() as r,
+denserank() as dr,
+sum(p_retailprice) as s1 over (rows between unbounded preceding and current row)
+from noop(part_rc
+distribute by p_mfgr
+sort by p_name);
Added: hive/branches/ptf-windowing/ql/src/test/queries/clientpositive/ptf_seqfile.q
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/queries/clientpositive/ptf_seqfile.q?rev=1442447&view=auto
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/queries/clientpositive/ptf_seqfile.q (added)
+++ hive/branches/ptf-windowing/ql/src/test/queries/clientpositive/ptf_seqfile.q Tue Feb 5 01:01:26 2013
@@ -0,0 +1,24 @@
+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 ;
+
+LOAD DATA LOCAL INPATH '../data/files/part.seq' overwrite into table part_seq;
+
+-- testWindowingPTFWithPartSeqFile
+select p_mfgr, p_name, p_size,
+rank() as r,
+denserank() as dr,
+sum(p_retailprice) as s1 over (rows between unbounded preceding and current row)
+from noop(part_seq
+distribute by p_mfgr
+sort by p_name);
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_general_queries.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_general_queries.q.out?rev=1442447&r1=1442446&r2=1442447&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_general_queries.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_general_queries.q.out Tue Feb 5 01:01:26 2013
@@ -2,14 +2,6 @@ PREHOOK: query: DROP TABLE part
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE part
POSTHOOK: type: DROPTABLE
-PREHOOK: query: DROP TABLE part_rc
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE part_rc
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: DROP TABLE part_seq
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: DROP TABLE part_seq
-POSTHOOK: type: DROPTABLE
PREHOOK: query: DROP TABLE flights_tiny
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE flights_tiny
@@ -47,68 +39,6 @@ PREHOOK: Output: default@part
POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part
POSTHOOK: type: LOAD
POSTHOOK: Output: default@part
-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
-PREHOOK: type: CREATETABLE
-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
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: default@part_rc
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part.rc' overwrite into table part_rc
-PREHOOK: type: LOAD
-PREHOOK: Output: default@part_rc
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part.rc' overwrite into table part_rc
-POSTHOOK: type: LOAD
-POSTHOOK: Output: default@part_rc
-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
-PREHOOK: type: CREATETABLE
-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
-POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: default@part_seq
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part.seq' overwrite into table part_seq
-PREHOOK: type: LOAD
-PREHOOK: Output: default@part_seq
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part.seq' overwrite into table part_seq
-POSTHOOK: type: LOAD
-POSTHOOK: Output: default@part_seq
PREHOOK: query: create table flights_tiny (
ORIGIN_CITY_NAME string,
DEST_CITY_NAME string,
@@ -2478,114 +2408,18 @@ Manufacturer#5 almond aquamarine dodger
Manufacturer#5 almond azure blanched chiffon midnight 1 23 115
Manufacturer#5 almond azure blanched chiffon midnight 2 23 92
Manufacturer#5 almond azure blanched chiffon midnight 3 23 69
-PREHOOK: query: -- 48. testWindowingPTFWithPartRC
-select p_mfgr, p_name, p_size,
-rank() as r,
-denserank() as dr,
-sum(p_retailprice) as s1 over (rows between unbounded preceding and current row)
-from noop(part_rc
-distribute by p_mfgr
-sort by p_name)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part_rc
-#### A masked pattern was here ####
-POSTHOOK: query: -- 48. testWindowingPTFWithPartRC
-select p_mfgr, p_name, p_size,
-rank() as r,
-denserank() as dr,
-sum(p_retailprice) as s1 over (rows between unbounded preceding and current row)
-from noop(part_rc
-distribute by p_mfgr
-sort 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
-PREHOOK: query: -- 49. testWindowingPTFWithPartSeqFile
-select p_mfgr, p_name, p_size,
-rank() as r,
-denserank() as dr,
-sum(p_retailprice) as s1 over (rows between unbounded preceding and current row)
-from noop(part_seq
-distribute by p_mfgr
-sort by p_name)
-PREHOOK: type: QUERY
-PREHOOK: Input: default@part_seq
-#### A masked pattern was here ####
-POSTHOOK: query: -- 49. testWindowingPTFWithPartSeqFile
-select p_mfgr, p_name, p_size,
-rank() as r,
-denserank() as dr,
-sum(p_retailprice) as s1 over (rows between unbounded preceding and current row)
-from noop(part_seq
-distribute by p_mfgr
-sort 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
-PREHOOK: query: -- 50. testConstExprInSelect
+PREHOOK: query: -- 48. testConstExprInSelect
select 'tst1' as key, count(1) as value from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 50. testConstExprInSelect
+POSTHOOK: query: -- 48. testConstExprInSelect
select 'tst1' as key, count(1) as value from part
POSTHOOK: type: QUERY
POSTHOOK: Input: default@part
#### A masked pattern was here ####
tst1 26
-PREHOOK: query: -- 51. testMultipleInserts3SWQs
+PREHOOK: query: -- 49. testMultipleInserts3SWQs
CREATE TABLE part_1(
p_mfgr STRING,
p_name STRING,
@@ -2594,7 +2428,7 @@ r INT,
dr INT,
s DOUBLE)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- 51. testMultipleInserts3SWQs
+POSTHOOK: query: -- 49. testMultipleInserts3SWQs
CREATE TABLE part_1(
p_mfgr STRING,
p_name STRING,
@@ -2886,7 +2720,7 @@ Manufacturer#5 almond antique blue fireb
Manufacturer#5 almond antique medium spring khaki 6 5 5 31
Manufacturer#5 almond aquamarine dodger light gainsboro 46 5 5 6
Manufacturer#5 almond azure blanched chiffon midnight 23 5 5 2
-PREHOOK: query: -- 52. testGroupByHavingWithSWQAndAlias
+PREHOOK: query: -- 50. testGroupByHavingWithSWQAndAlias
select p_mfgr, p_name, p_size, min(p_retailprice) as mi,
rank() as r,
denserank() as dr,
@@ -2899,7 +2733,7 @@ sort by p_name
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 52. testGroupByHavingWithSWQAndAlias
+POSTHOOK: query: -- 50. testGroupByHavingWithSWQAndAlias
select p_mfgr, p_name, p_size, min(p_retailprice) as mi,
rank() as r,
denserank() as dr,
@@ -2958,7 +2792,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 1788.73 3 3 2 -4
Manufacturer#5 almond aquamarine dodger light gainsboro 46 1018.1 4 4 46 44
Manufacturer#5 almond azure blanched chiffon midnight 23 1464.48 5 5 23 -23
-PREHOOK: query: -- 53. testMultipleRangeWindows
+PREHOOK: query: -- 51. testMultipleRangeWindows
select p_mfgr,p_name, p_size,
sum(p_size) as s2 over (range between p_size 10 less and current row),
sum(p_size) as s1 over (range between current row and p_size 10 more )
@@ -2969,7 +2803,7 @@ window w1 as rows between 2 preceding an
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 53. testMultipleRangeWindows
+POSTHOOK: query: -- 51. testMultipleRangeWindows
select p_mfgr,p_name, p_size,
sum(p_size) as s2 over (range between p_size 10 less and current row),
sum(p_size) as s1 over (range between current row and p_size 10 more )
@@ -3027,7 +2861,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond azure blanched chiffon midnight 23 23 54
Manufacturer#5 almond antique blue firebrick mint 31 54 31
Manufacturer#5 almond aquamarine dodger light gainsboro 46 46 46
-PREHOOK: query: -- 54. testMultipleInserts2SWQsWithPTF
+PREHOOK: query: -- 52. testMultipleInserts2SWQsWithPTF
CREATE TABLE part_4(
p_mfgr STRING,
p_name STRING,
@@ -3036,7 +2870,7 @@ r INT,
dr INT,
s DOUBLE)
PREHOOK: type: CREATETABLE
-POSTHOOK: query: -- 54. testMultipleInserts2SWQsWithPTF
+POSTHOOK: query: -- 52. testMultipleInserts2SWQsWithPTF
CREATE TABLE part_4(
p_mfgr STRING,
p_name STRING,
@@ -3330,14 +3164,14 @@ Manufacturer#5 almond antique blue fireb
Manufacturer#5 almond antique medium spring khaki 6 37 37 2 2 0.4 31
Manufacturer#5 almond aquamarine dodger light gainsboro 46 85 46 4 4 0.8 6
Manufacturer#5 almond azure blanched chiffon midnight 23 108 69 5 5 1.0 2
-PREHOOK: query: -- 55. testPartOrderInUDAFInvoke
+PREHOOK: query: -- 53. testPartOrderInUDAFInvoke
select p_mfgr, p_name, p_size,
sum(p_size) as s over (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following)
from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 55. testPartOrderInUDAFInvoke
+POSTHOOK: query: -- 53. testPartOrderInUDAFInvoke
select p_mfgr, p_name, p_size,
sum(p_size) as s over (distribute by p_mfgr sort by p_name rows between 2 preceding and 2 following)
from part
@@ -3406,7 +3240,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 108
Manufacturer#5 almond aquamarine dodger light gainsboro 46 77
Manufacturer#5 almond azure blanched chiffon midnight 23 71
-PREHOOK: query: -- 56. testPartOrderInWdwDef
+PREHOOK: query: -- 54. testPartOrderInWdwDef
select p_mfgr, p_name, p_size,
sum(p_size) as s over (w1)
from part
@@ -3414,7 +3248,7 @@ window w1 as distribute by p_mfgr sort
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 56. testPartOrderInWdwDef
+POSTHOOK: query: -- 54. testPartOrderInWdwDef
select p_mfgr, p_name, p_size,
sum(p_size) as s over (w1)
from part
@@ -3484,7 +3318,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 108
Manufacturer#5 almond aquamarine dodger light gainsboro 46 77
Manufacturer#5 almond azure blanched chiffon midnight 23 71
-PREHOOK: query: -- 57. testDefaultPartitioningSpecRules
+PREHOOK: query: -- 55. testDefaultPartitioningSpecRules
select p_mfgr, p_name, p_size,
sum(p_size) as s over (w1),
sum(p_size) as s2 over(w2)
@@ -3495,7 +3329,7 @@ window w1 as distribute by p_mfgr rows b
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 57. testDefaultPartitioningSpecRules
+POSTHOOK: query: -- 55. testDefaultPartitioningSpecRules
select p_mfgr, p_name, p_size,
sum(p_size) as s over (w1),
sum(p_size) as s2 over(w2)
@@ -3568,7 +3402,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 108 108
Manufacturer#5 almond aquamarine dodger light gainsboro 46 77 108
Manufacturer#5 almond azure blanched chiffon midnight 23 71 108
-PREHOOK: query: -- 58. testWindowCrossReference
+PREHOOK: query: -- 56. testWindowCrossReference
select p_mfgr, p_name, p_size,
sum(p_size) as s1 over (w1),
sum(p_size) as s2 over (w2)
@@ -3578,7 +3412,7 @@ window w1 as distribute by p_mfgr sort b
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 58. testWindowCrossReference
+POSTHOOK: query: -- 56. testWindowCrossReference
select p_mfgr, p_name, p_size,
sum(p_size) as s1 over (w1),
sum(p_size) as s2 over (w2)
@@ -3650,7 +3484,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 108 108
Manufacturer#5 almond aquamarine dodger light gainsboro 46 77 77
Manufacturer#5 almond azure blanched chiffon midnight 23 71 71
-PREHOOK: query: -- 59. testWindowInheritance
+PREHOOK: query: -- 57. testWindowInheritance
select p_mfgr, p_name, p_size,
sum(p_size) as s1 over (w1),
sum(p_size) as s2 over (w2)
@@ -3660,7 +3494,7 @@ window w1 as distribute by p_mfgr sort b
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 59. testWindowInheritance
+POSTHOOK: query: -- 57. testWindowInheritance
select p_mfgr, p_name, p_size,
sum(p_size) as s1 over (w1),
sum(p_size) as s2 over (w2)
@@ -3732,7 +3566,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 108 39
Manufacturer#5 almond aquamarine dodger light gainsboro 46 77 85
Manufacturer#5 almond azure blanched chiffon midnight 23 71 108
-PREHOOK: query: -- 60. testWindowForwardReference
+PREHOOK: query: -- 58. testWindowForwardReference
select p_mfgr, p_name, p_size,
sum(p_size) as s1 over (w1),
sum(p_size) as s2 over (w2),
@@ -3746,7 +3580,7 @@ window w1 as rows between 2 preceding an
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 60. testWindowForwardReference
+POSTHOOK: query: -- 58. testWindowForwardReference
select p_mfgr, p_name, p_size,
sum(p_size) as s1 over (w1),
sum(p_size) as s2 over (w2),
@@ -3822,7 +3656,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 108 39 39
Manufacturer#5 almond aquamarine dodger light gainsboro 46 77 85 85
Manufacturer#5 almond azure blanched chiffon midnight 23 71 108 108
-PREHOOK: query: -- 61. testWindowDefinitionPropagation
+PREHOOK: query: -- 59. testWindowDefinitionPropagation
select p_mfgr, p_name, p_size,
sum(p_size) as s1 over (w1),
sum(p_size) as s2 over (w2),
@@ -3836,7 +3670,7 @@ window w1 as rows between 2 preceding an
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 61. testWindowDefinitionPropagation
+POSTHOOK: query: -- 59. testWindowDefinitionPropagation
select p_mfgr, p_name, p_size,
sum(p_size) as s1 over (w1),
sum(p_size) as s2 over (w2),
@@ -3912,7 +3746,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 108 39 108
Manufacturer#5 almond aquamarine dodger light gainsboro 46 77 85 77
Manufacturer#5 almond azure blanched chiffon midnight 23 71 108 71
-PREHOOK: query: -- 62. testDistinctWithWindowing
+PREHOOK: query: -- 60. testDistinctWithWindowing
select DISTINCT p_mfgr, p_name, p_size,
sum(p_size) as s over (w1)
from part
@@ -3922,7 +3756,7 @@ window w1 as rows between 2 preceding an
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 62. testDistinctWithWindowing
+POSTHOOK: query: -- 60. testDistinctWithWindowing
select DISTINCT p_mfgr, p_name, p_size,
sum(p_size) as s over (w1)
from part
@@ -3993,7 +3827,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 2 108
Manufacturer#5 almond aquamarine dodger light gainsboro 46 77
Manufacturer#5 almond azure blanched chiffon midnight 23 71
-PREHOOK: query: -- 63. testMulti2OperatorsFunctionChainWithMap
+PREHOOK: query: -- 61. testMulti2OperatorsFunctionChainWithMap
select p_mfgr, p_name,
rank() as r,
denserank() as dr,
@@ -4012,7 +3846,7 @@ from noop(
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 63. testMulti2OperatorsFunctionChainWithMap
+POSTHOOK: query: -- 61. testMulti2OperatorsFunctionChainWithMap
select p_mfgr, p_name,
rank() as r,
denserank() as dr,
@@ -4093,7 +3927,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 1 1 2 2
Manufacturer#5 almond aquamarine dodger light gainsboro 1 1 46 46
Manufacturer#5 almond azure blanched chiffon midnight 1 1 23 23
-PREHOOK: query: -- 64. testMulti3OperatorsFunctionChain
+PREHOOK: query: -- 62. testMulti3OperatorsFunctionChain
select p_mfgr, p_name,
rank() as r,
denserank() as dr,
@@ -4112,7 +3946,7 @@ from noop(
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 64. testMulti3OperatorsFunctionChain
+POSTHOOK: query: -- 62. testMulti3OperatorsFunctionChain
select p_mfgr, p_name,
rank() as r,
denserank() as dr,
@@ -4193,7 +4027,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 1 1 2 39
Manufacturer#5 almond aquamarine dodger light gainsboro 1 1 46 85
Manufacturer#5 almond azure blanched chiffon midnight 1 1 23 108
-PREHOOK: query: -- 65. testMultiOperatorChainWithNoWindowing
+PREHOOK: query: -- 63. testMultiOperatorChainWithNoWindowing
select p_mfgr, p_name,
rank() as r,
denserank() as dr,
@@ -4210,7 +4044,7 @@ from noop(
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 65. testMultiOperatorChainWithNoWindowing
+POSTHOOK: query: -- 63. testMultiOperatorChainWithNoWindowing
select p_mfgr, p_name,
rank() as r,
denserank() as dr,
@@ -4289,7 +4123,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 1 1 2 108
Manufacturer#5 almond aquamarine dodger light gainsboro 1 1 46 108
Manufacturer#5 almond azure blanched chiffon midnight 1 1 23 108
-PREHOOK: query: -- 66. testMultiOperatorChainEndsWithNoopMap
+PREHOOK: query: -- 64. testMultiOperatorChainEndsWithNoopMap
select p_mfgr, p_name,
rank() as r,
denserank() as dr,
@@ -4308,7 +4142,7 @@ from noopwithmap(
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 66. testMultiOperatorChainEndsWithNoopMap
+POSTHOOK: query: -- 64. testMultiOperatorChainEndsWithNoopMap
select p_mfgr, p_name,
rank() as r,
denserank() as dr,
@@ -4389,7 +4223,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 1 1 2 2
Manufacturer#5 almond aquamarine dodger light gainsboro 1 1 46 46
Manufacturer#5 almond azure blanched chiffon midnight 1 1 23 23
-PREHOOK: query: --67. testMultiOperatorChainWithDiffPartitionForWindow1
+PREHOOK: query: --65. testMultiOperatorChainWithDiffPartitionForWindow1
select p_mfgr, p_name,
rank() as r,
denserank() as dr,
@@ -4407,7 +4241,7 @@ from noop(
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: --67. testMultiOperatorChainWithDiffPartitionForWindow1
+POSTHOOK: query: --65. testMultiOperatorChainWithDiffPartitionForWindow1
select p_mfgr, p_name,
rank() as r,
denserank() as dr,
@@ -4487,7 +4321,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 1 1 2 2 2
Manufacturer#5 almond aquamarine dodger light gainsboro 1 1 46 46 46
Manufacturer#5 almond azure blanched chiffon midnight 1 1 23 23 23
-PREHOOK: query: --68. testMultiOperatorChainWithDiffPartitionForWindow2
+PREHOOK: query: --66. testMultiOperatorChainWithDiffPartitionForWindow2
select p_mfgr, p_name,
rank() as r,
denserank() as dr,
@@ -4503,7 +4337,7 @@ from noopwithmap(
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: --68. testMultiOperatorChainWithDiffPartitionForWindow2
+POSTHOOK: query: --66. testMultiOperatorChainWithDiffPartitionForWindow2
select p_mfgr, p_name,
rank() as r,
denserank() as dr,
@@ -4581,7 +4415,7 @@ Manufacturer#5 almond antique medium spr
Manufacturer#5 almond antique sky peru orange 1 1 2 39 39
Manufacturer#5 almond aquamarine dodger light gainsboro 1 1 46 85 85
Manufacturer#5 almond azure blanched chiffon midnight 1 1 23 108 108
-PREHOOK: query: -- 69. basic Npath test
+PREHOOK: query: -- 67. basic Npath test
select origin_city_name, fl_num, year, month, day_of_month, sz, tpath
from npath(
'LATE.LATE+',
@@ -4595,7 +4429,7 @@ from npath(
PREHOOK: type: QUERY
PREHOOK: Input: default@flights_tiny
#### A masked pattern was here ####
-POSTHOOK: query: -- 69. basic Npath test
+POSTHOOK: query: -- 67. basic Npath test
select origin_city_name, fl_num, year, month, day_of_month, sz, tpath
from npath(
'LATE.LATE+',
@@ -4661,14 +4495,14 @@ Washington 7291 2010 10 27 2 [{"origin_c
Chicago 897 2010 10 20 4 [{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":20,"arr_delay":24.0,"fl_num":"897"},{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":21,"arr_delay":77.0,"fl_num":"897"},{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":22,"arr_delay":24.0,"fl_num":"897"},{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":24,"arr_delay":113.0,"fl_num":"897"}]
Chicago 897 2010 10 21 3 [{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":21,"arr_delay":77.0,"fl_num":"897"},{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":22,"arr_delay":24.0,"fl_num":"897"},{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":24,"arr_delay":113.0,"fl_num":"897"}]
Chicago 897 2010 10 22 2 [{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":22,"arr_delay":24.0,"fl_num":"897"},{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":24,"arr_delay":113.0,"fl_num":"897"}]
-PREHOOK: query: -- 70. testRankWithPartitioning
+PREHOOK: query: -- 68. testRankWithPartitioning
select p_mfgr, p_name, p_size,
rank() as r over (distribute by p_mfgr sort by p_name )
from part
PREHOOK: type: QUERY
PREHOOK: Input: default@part
#### A masked pattern was here ####
-POSTHOOK: query: -- 70. testRankWithPartitioning
+POSTHOOK: query: -- 68. testRankWithPartitioning
select p_mfgr, p_name, p_size,
rank() as r over (distribute by p_mfgr sort by p_name )
from part
Added: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_rcfile.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_rcfile.q.out?rev=1442447&view=auto
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_rcfile.q.out (added)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_rcfile.q.out Tue Feb 5 01:01:26 2013
@@ -0,0 +1,83 @@
+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
+PREHOOK: type: CREATETABLE
+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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@part_rc
+PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part.rc' overwrite into table part_rc
+PREHOOK: type: LOAD
+PREHOOK: Output: default@part_rc
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part.rc' overwrite into table part_rc
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@part_rc
+PREHOOK: query: -- testWindowingPTFWithPartRC
+select p_mfgr, p_name, p_size,
+rank() as r,
+denserank() as dr,
+sum(p_retailprice) as s1 over (rows between unbounded preceding and current row)
+from noop(part_rc
+distribute by p_mfgr
+sort by p_name)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@part_rc
+#### A masked pattern was here ####
+POSTHOOK: query: -- testWindowingPTFWithPartRC
+select p_mfgr, p_name, p_size,
+rank() as r,
+denserank() as dr,
+sum(p_retailprice) as s1 over (rows between unbounded preceding and current row)
+from noop(part_rc
+distribute by p_mfgr
+sort 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
Added: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_seqfile.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_seqfile.q.out?rev=1442447&view=auto
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_seqfile.q.out (added)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/ptf_seqfile.q.out Tue Feb 5 01:01:26 2013
@@ -0,0 +1,83 @@
+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
+PREHOOK: type: CREATETABLE
+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
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@part_seq
+PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part.seq' overwrite into table part_seq
+PREHOOK: type: LOAD
+PREHOOK: Output: default@part_seq
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part.seq' overwrite into table part_seq
+POSTHOOK: type: LOAD
+POSTHOOK: Output: default@part_seq
+PREHOOK: query: -- testWindowingPTFWithPartSeqFile
+select p_mfgr, p_name, p_size,
+rank() as r,
+denserank() as dr,
+sum(p_retailprice) as s1 over (rows between unbounded preceding and current row)
+from noop(part_seq
+distribute by p_mfgr
+sort by p_name)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@part_seq
+#### A masked pattern was here ####
+POSTHOOK: query: -- testWindowingPTFWithPartSeqFile
+select p_mfgr, p_name, p_size,
+rank() as r,
+denserank() as dr,
+sum(p_retailprice) as s1 over (rows between unbounded preceding and current row)
+from noop(part_seq
+distribute by p_mfgr
+sort 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