Skip to content

Instantly share code, notes, and snippets.

View kokosing's full-sized avatar
💤

Grzegorz Kokosiński kokosing

💤
View GitHub Profile
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
return filter()
.with(
predicate()
.map(ExpressionUtils::extractConjuncts)
.capturedAs(CONJUNCTS))
.with(
source()
.caseOf(
anyOf(assignUniqueId(), markDistinct(), sampleNode())
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;
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;
*** 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
*** 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
*** 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
*** 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,
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
*** 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)