Skip to content

Instantly share code, notes, and snippets.

View zeroflag's full-sized avatar

Attila Magyar zeroflag

53 followers · 27 following
View GitHub Profile
@zeroflag
zeroflag / exp.forth
Last active June 19, 2021 11:12
-> amount => type
#[
1 'food delivery'
2 'groceries'
3 'snacks'
4 'sport'
5 'public transport'
6 'maintenance'
7 'medical'
8 'travel'
@zeroflag
zeroflag / mandelbrot.hplsql
Created March 29, 2021 12:14
declare size int = 100;
declare fac double = 2.0 / 100.0;
create procedure computeRow(y int)
begin
declare Ci double = (y*fac - 1.0);
for x in 0..size-1 loop
declare Zr double = 0.0;
declare Zi double = 0.0;
@zeroflag
zeroflag / query94
Created June 12, 2020 09:54
SELECT count(distinct ws_order_number) as order_count,
sum(ws_ext_ship_cost) as total_shipping_cost,
sum(ws_net_profit) as total_net_profit
FROM web_sales ws1
JOIN customer_address ca ON (ws1.ws_ship_addr_sk = ca.ca_address_sk)
JOIN web_site s ON (ws1.ws_web_site_sk = s.web_site_sk)
JOIN date_dim d ON (ws1.ws_ship_date_sk = d.d_date_sk)
LEFT SEMI JOIN (SELECT ws2.ws_order_number as ws_order_number
FROM web_sales ws2 JOIN web_sales ws3
ON (ws2.ws_order_number = ws3.ws_order_number)
@zeroflag
zeroflag / gist:ca0c02a0a822ffe055c344e929c8a2ef
Created June 11, 2020 14:38
+----------------------------------------------------+
| Explain |
+----------------------------------------------------+
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
@zeroflag
zeroflag / gist:013b55cea341159389c94c0c2e64a736
Created June 11, 2020 14:32
+----------------------------------------------------+
| Explain |
+----------------------------------------------------+
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
@zeroflag
zeroflag / gist:1d70f1ed7d91041e217a094cc97bd3dd
Created June 11, 2020 12:37
+----------------------------------------------------+
| Explain |
+----------------------------------------------------+
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
@zeroflag
zeroflag / gist:3fe8c82c67bd594b09ea3ae2e2bd7322
Created June 11, 2020 08:41
+----------------------------------------------------+
| Explain |
+----------------------------------------------------+
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
@zeroflag
zeroflag / gist:eb0f591e300581091b920ebe29621092
Created June 11, 2020 08:32
+----------------------------------------------------+
| Explain |
+----------------------------------------------------+
| STAGE DEPENDENCIES: |
| Stage-1 is a root stage |
| Stage-0 depends on stages: Stage-1 |
| |
| STAGE PLANS: |
| Stage: Stage-1 |
| Tez |
@zeroflag
zeroflag / topnkey2.q
Created December 14, 2019 15:38
--! qt:dataset:src
SET hive.mapred.mode=nonstrict;
SET hive.vectorized.execution.enabled=false;
-- SET hive.optimize.ppd=true;
-- SET hive.ppd.remove.duplicatefilters=true;
-- SET hive.optimize.metadataonly=false;
-- SET hive.optimize.index.filter=true;
-- SET hive.tez.min.bloom.filter.entries=1;
@zeroflag
zeroflag / topnkey.q
Created December 14, 2019 10:46
--! qt:dataset:src
SET hive.mapred.mode=nonstrict;
SET hive.vectorized.execution.enabled=false;
SET hive.optimize.ppd=true;
SET hive.ppd.remove.duplicatefilters=true;
SET hive.tez.dynamic.partition.pruning=true;
SET hive.optimize.metadataonly=false;
SET hive.optimize.index.filter=true;
SET hive.tez.min.bloom.filter.entries=1;