This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
actual [master] out: Starting presto | |
[master] out: Started as 733 | |
[master] out: | |
Waiting to make sure we can connect to the Presto server on master, please wait. This check will time out after 2 minutes if the server does not respond. | |
[slave3] out: Starting presto | |
[slave3] out: Started as 355 | |
[slave3] out: | |
Waiting to make sure we can connect to the Presto server on slave3, please wait. This check will time out after 2 minutes if the server does not respond. | |
[slave2] out: Starting presto | |
[slave2] out: Started as 358 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
return filter() | |
.with( | |
predicate() | |
.map(ExpressionUtils::extractConjuncts) | |
.capturedAs(CONJUNCTS)) | |
.with( | |
source() | |
.caseOf( | |
anyOf(assignUniqueId(), markDistinct(), sampleNode()) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
diff --git a/presto-product-tests/src/main/java/com/facebook/presto/tests/AlterTableTests.java b/presto-product-tests/src/main/java/com/facebook/presto/tests/AlterTableTests.java | |
index 24b122b..7a49b34 100644 | |
--- a/presto-product-tests/src/main/java/com/facebook/presto/tests/AlterTableTests.java | |
+++ b/presto-product-tests/src/main/java/com/facebook/presto/tests/AlterTableTests.java | |
@@ -14,6 +14,8 @@ | |
package com.facebook.presto.tests; | |
import com.facebook.presto.tests.ImmutableTpchTablesRequirements.ImmutableNationTable; | |
+import com.teradata.tempto.AfterTestWithContext; | |
+import com.teradata.tempto.BeforeTestWithContext; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
diff --git a/presto-product-tests/src/main/java/com/facebook/presto/tests/AlterTableTests.java b/presto-product-tests/src/main/java/com/facebook/presto/tests/AlterTableTests.java | |
index 24b122b..7a49b34 100644 | |
--- a/presto-product-tests/src/main/java/com/facebook/presto/tests/AlterTableTests.java | |
+++ b/presto-product-tests/src/main/java/com/facebook/presto/tests/AlterTableTests.java | |
@@ -14,6 +14,8 @@ | |
package com.facebook.presto.tests; | |
import com.facebook.presto.tests.ImmutableTpchTablesRequirements.ImmutableNationTable; | |
+import com.teradata.tempto.AfterTestWithContext; | |
+import com.teradata.tempto.BeforeTestWithContext; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
*** q72.sql 2016-03-25 14:10:21.000000000 +0100 | |
--- q72_modified.sql 2016-03-29 11:48:52.787292010 +0200 | |
*************** | |
*** 16,26 **** | |
LEFT OUTER JOIN "${database}"."${schema}".promotion ON (cs_promo_sk=p_promo_sk) | |
LEFT OUTER JOIN "${database}"."${schema}".catalog_returns ON (cr_item_sk = cs_item_sk | |
AND cr_order_number = cs_order_number) | |
WHERE d1.d_week_seq = d2.d_week_seq | |
AND inv_quantity_on_hand < cs_quantity | |
! AND d3.d_date > d1.d_date + 5 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
*** q72.sql 2016-03-25 14:10:21.000000000 +0100 | |
--- q72_modified.sql 2016-03-29 11:40:05.511282538 +0200 | |
*************** | |
*** 16,26 **** | |
LEFT OUTER JOIN "${database}"."${schema}".promotion ON (cs_promo_sk=p_promo_sk) | |
LEFT OUTER JOIN "${database}"."${schema}".catalog_returns ON (cr_item_sk = cs_item_sk | |
AND cr_order_number = cs_order_number) | |
WHERE d1.d_week_seq = d2.d_week_seq | |
AND inv_quantity_on_hand < cs_quantity | |
! AND d3.d_date > d1.d_date + 5 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
*** q54.sql 2016-03-29 11:24:05.000000000 +0200 | |
--- q54_modified.sql 2016-03-29 11:24:28.000000000 +0200 | |
*************** | |
*** 42,52 **** | |
FROM "${database}"."${schema}".date_dim | |
WHERE d_year = 1999 | |
AND d_moy = 2) | |
GROUP BY c_customer_sk), | |
segments AS | |
! (SELECT cast((revenue/50) AS int) AS segment |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
*** q58.sql 2016-03-29 10:31:47.000000000 +0200 | |
--- q58_modified.sql 2016-03-29 11:02:31.000000000 +0200 | |
*************** | |
*** 63,69 **** | |
AND ss_item_rev BETWEEN 0.9 * ws_item_rev AND 1.1 * ws_item_rev | |
AND cs_item_rev BETWEEN 0.9 * ss_item_rev AND 1.1 * ss_item_rev | |
AND cs_item_rev BETWEEN 0.9 * ws_item_rev AND 1.1 * ws_item_rev | |
AND ws_item_rev BETWEEN 0.9 * ss_item_rev AND 1.1 * ss_item_rev | |
AND ws_item_rev BETWEEN 0.9 * cs_item_rev AND 1.1 * cs_item_rev | |
! ORDER BY item_id, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
drop table if exists call_center; | |
create table call_center( | |
cc_call_center_sk int | |
, cc_call_center_id string | |
, cc_rec_start_date string | |
, cc_rec_end_date string | |
, cc_closed_date_sk int | |
, cc_open_date_sk int |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
*** q98.sql 2016-03-25 14:10:21.910553746 +0100 | |
--- q98_modified.sql 2016-03-25 14:10:21.910553746 +0100 | |
*************** | |
*** 10,20 **** | |
WHERE ss_item_sk = i_item_sk | |
AND i_category IN ('Music', | |
'Men', | |
'Shoes') | |
AND ss_sold_date_sk = d_date_sk | |
! AND d_date BETWEEN cast('2001-02-24' AS date) AND (cast('2001-02-24' AS date) + 30 days) |