Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 1B1B8200C87 for ; Wed, 17 May 2017 20:50:52 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 196DD160BBA; Wed, 17 May 2017 18:50:52 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 660F4160BAC for ; Wed, 17 May 2017 20:50:50 +0200 (CEST) Received: (qmail 9463 invoked by uid 500); 17 May 2017 18:50:49 -0000 Mailing-List: contact commits-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hive.apache.org Delivered-To: mailing list commits@hive.apache.org Received: (qmail 9452 invoked by uid 99); 17 May 2017 18:50:49 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 17 May 2017 18:50:49 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 6D078DFF2D; Wed, 17 May 2017 18:50:49 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit From: spena@apache.org To: commits@hive.apache.org Message-Id: <8e42c2373ac645b8877f40e114442611@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: =?utf-8?q?hive_git_commit=3A_HIVE-16539=3A_Add_PTF_tests_for_blobs?= =?utf-8?q?tores_=28Juan_Rodr=C3=ADguez_Hortal=C3=A1=2C_reviewed_by_Sergio_P?= =?utf-8?q?ena=29?= Date: Wed, 17 May 2017 18:50:49 +0000 (UTC) archived-at: Wed, 17 May 2017 18:50:52 -0000 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á Authored: Wed May 17 13:50:22 2017 -0500 Committer: Sergio Pena 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