I hereby claim:
- I am charles-tan on github.
- I am charlestan (https://keybase.io/charlestan) on keybase.
- I have a public key ASCo6erESP8eQ6GYQtOVPvqPmHl3Ivn21qWVz1-hqSPbFgo
To claim this, I am signing this object:
Charles Tan charles-tan
charles-tan
/ keybase.md
Created
December 2, 2021 19:41
charles-tan
/ ds_on-time-delivery-shipments_orders-ex.txt
Created
October 17, 2023 19:48
This file contains 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
| { | |
| "Order_timestamp": "2023.03.02 13:53:22", | |
| "orderID": "Order_17", | |
| "customerID": "customer_32", | |
| "price": "12.31", | |
| "itemID": "7740485A-836A-447F-96F9-DBBD00E92387", | |
| "destination_address": { | |
| "number": 2555, | |
| "street": "University", | |
| "city": "Palo Alto", |
charles-tan
/ ds_on-time-delivery-shipments_shipments-ex.txt
Created
October 17, 2023 20:41
This file contains 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
| { | |
| "shipment_timestamp": "2023.03.02 13:53:22", | |
| "orderID": "Order_17", | |
| "shipment_center_ID": 3 | |
| } |
charles-tan
/ ds_on-time-delivery-shipments_orders-ddl.txt
Created
October 17, 2023 20:41
This file contains 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
| CREATE STREAM "Orders" ( | |
| order_timestamp TIMESTAMP(3), | |
| "orderID" VARCHAR, | |
| "customerID" VARCHAR, | |
| price DOUBLE, | |
| "itemID" VARCHAR, | |
| destination_address STRUCT<"number" BIGINT, street VARCHAR, city VARCHAR, "state" VARCHAR, zipcode VARCHAR> | |
| ) WITH ( | |
| 'topic'='Orders', | |
| 'value.format'='json', |
charles-tan
/ ds_on-time-delivery-shipments_shipments-ddl.txt
Created
October 17, 2023 20:42
This file contains 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
| CREATE STREAM "Shipments" ( | |
| shipment_timestamp TIMESTAMP(3), | |
| "orderID" VARCHAR, | |
| "shipment_center_ID" BIGINT | |
| ) WITH ( | |
| 'topic'='Shipments', | |
| 'value.format'='json', | |
| 'timestamp'='shipment_timestamp' | |
| ); |
charles-tan
/ ds_on-time-delivery-shipments_csas-1.txt
Created
October 17, 2023 20:43
This file contains 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
| CREATE STREAM "OrdersShipmentsJoin" AS | |
| SELECT | |
| * | |
| FROM "Orders" o | |
| LEFT JOIN "Shipments" s | |
| WITHIN 30 minutes | |
| ON o."orderID" = s."orderID"; |
charles-tan
/ ds_on-time-delivery-shipments_csas-2.txt
Created
October 17, 2023 20:43
This file contains 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
| CREATE STREAM "OrdersNotShipped" AS | |
| SELECT | |
| order_timestamp, | |
| "o_orderID" AS "orderID", | |
| "customerID", | |
| "itemID", | |
| destination_address->zipcode AS "Destination_zipcode" | |
| FROM "OrdersShipmentsJoin" | |
| WHERE shipment_timestamp IS NULL; |
charles-tan
/ ds_on-time-delivery-shipments_orders-input.txt
Created
October 17, 2023 20:44
This file contains 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
| { | |
| "order_timestamp": "2023-03-02T13:53:22", | |
| "orderID": "Order_1", | |
| "customerID": "customer_32", | |
| "price": "12.31", | |
| "itemID": "7740485A-836A-447F-96F9-DBBD00E92387", | |
| "destination_address": { | |
| "number": 2555, | |
| "street": "University", | |
| "city": "Palo Alto", |
charles-tan
/ ds_on-time-delivery-shipments_shipments-input.txt
Created
October 17, 2023 20:45
This file contains 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
| { | |
| "shipment_timestamp": "2023-03-02T14:08:43", | |
| "orderID": "Order_1", | |
| "shipment_center_ID": 7 | |
| } | |
| { | |
| "shipment_timestamp": "2023-03-02T14:45:17", | |
| "orderID": "Order_2", | |
| "shipment_center_ID": 3 | |
| } |
charles-tan
/ ds_on-time-delivery-shipments_join-output.txt
Created
October 17, 2023 20:46
This file contains 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
| { | |
| "order_timestamp": "2023-03-02T13:53:22", | |
| "o_orderID": "Order_1", | |
| "customerID": "customer_32", | |
| "price": 12.31, | |
| "itemID": "7740485A-836A-447F-96F9-DBBD00E92387", | |
| "destination_address": { | |
| "number": 2555, | |
| "street": "University", | |
| "city": "Palo Alto", |
OlderNewer