Skip to content

Instantly share code, notes, and snippets.

View aditiharini's full-sized avatar

Aditi Srinivasan aditiharini

13 followers · 3 following
View GitHub Profile
@aditiharini
aditiharini / orders_by_country_response.sql
Created July 31, 2019 23:44
+----------------+---------------+
| Country | TotalOrders |
|----------------+---------------|
| United States | 4762 |
| India | 3304 |
| China | 3242 |
| United Kingdom | 1610 |
| Canada | 1524 |
+----------------+---------------+
Time: 0.395s
@aditiharini
aditiharini / orders_by_country_query.sql
Created July 31, 2019 23:43
SELECT Country, COUNT(DISTINCT InvoiceNo) as TotalOrders
FROM "orders"
GROUP BY Country
ORDER By TotalOrders DESC;
@aditiharini
aditiharini / highest_selling_products_output.sql
Created July 31, 2019 23:42
+------------------------------------+------------------+
| Description | QuantitiesSold |
|------------------------------------+------------------|
| ASSORTED COLOUR BIRD ORNAMENT | 87786 |
| WHITE METAL LANTERN | 65821 |
| WHITE HANGING HEART T-LIGHT HOLDER | 65319 |
| CREAM CUPID HEARTS COAT HANGER | 43978 |
| RED WOOLLY HOTTIE WHITE HEART. | 43260 |
+------------------------------------+------------------+
Time: 0.423s
@aditiharini
aditiharini / simple.sql
Created July 31, 2019 23:41
SELECT *
FROM orders
LIMIT 10;
@aditiharini
aditiharini / highest_selling_products_query.sql
Created July 31, 2019 23:40
SELECT Description, SUM(Quantity) as QuantitiesSold
FROM "orders"
GROUP BY Description
ORDER By QuantitiesSold DESC
LIMIT 5;
@aditiharini
aditiharini / order.json
Created July 31, 2019 23:35
{
"InvoiceNo": 14,
"InvoiceDate": 1547523082,
"CustomerID": 10140,
"Country": "India",
"StockCode": 3009,
"Description": "HAND WARMER RED POLKA DOT",
"Quantity": 6,
"UnitPrice": 1.85
}
@aditiharini
aditiharini / rock_configure.sh
Created July 31, 2019 23:18
rock configure --api_key <YOUR-API-KEY>
@aditiharini
aditiharini / config.py
Last active July 31, 2019 23:15
# Kafka Configuration
KAFKA_TOPIC = 'orders'
KAFKA_BOOTSTRAP_SERVER = ['localhost:9092']
# Rockset Configuration
ROCKSET_API_KEY = '' # Create API Key - https://console.rockset.com/manage/apikeys
ROCKSET_API_SERVER = 'https://api.rs2.usw2.rockset.com'
@aditiharini
aditiharini / deps.sh
Last active July 31, 2019 23:15
python3 -m virtualenv rockset-kafka-demo
source rockset-kafka-demo/bin/activate
pip install -r requirements.txt
@aditiharini
aditiharini / init.sh
Last active July 31, 2019 23:14
git clone git@github.com:rockset/recipes.git
cd recipes/kafka-rockset-integration/