garystafford

package com.article.examples;

import java.util.List;

/**
 * Main class that calls all example methods
 *
 * @author Gary A. Stafford
 */
public class RunExamples {

garystafford

AWSTemplateFormatVersion: "2010-09-09"
Description: "This template deploys a RDS PostgreSQL database and an Amazon S3 bucket"
Parameters:
  DBInstanceIdentifier:
    Type: String
    Default: "ahana-prestodb-demo"
  DBEngine:
    Type: String
    Default: "postgres"
  DBEngineVersion:

garystafford

WITH credit_demographics AS (
    SELECT
        (year (now()) - c_birth_year) AS age,
        cd_credit_rating AS credit_rating,
        cd_gender AS gender,
        count(cd_gender) AS gender_count
    FROM
        postgresql.public.customer
        LEFT JOIN hive.default.customer_demographics ON c_current_cdemo_sk = cd_demo_sk
    WHERE

garystafford

-- Modified version of
-- Figure 7: Reporting Query (Query 40)
-- http://www.tpc.org/tpcds/presentations/tpcds_workload_analysis.pdf

WITH customer_total_return AS (
    SELECT
        cr_returning_customer_sk AS ctr_cust_sk,
        ca_state AS ctr_state,
        sum(cr_return_amt_inc_tax) AS ctr_return
    FROM

garystafford

-- Modified version of
-- Figure 7: Reporting Query (Query 40)
-- http://www.tpc.org/tpcds/presentations/tpcds_workload_analysis.pdf

WITH customer_total_return AS (
    SELECT
        cr_returning_customer_sk AS ctr_cust_sk,
        ca_state AS ctr_state,
        sum(cr_return_amt_inc_tax) AS ctr_return
    FROM

garystafford

-- Modified version of
-- Figure 7: Reporting Query (Query 40)
-- http://www.tpc.org/tpcds/presentations/tpcds_workload_analysis.pdf

WITH customer_total_return AS (
    SELECT
        cr_returning_customer_sk AS ctr_cust_sk,
        ca_state AS ctr_state,
        sum(cr_return_amt_inc_tax) AS ctr_return
    FROM

garystafford

SELECT
    data.device_id,
    data.gateway_id,
    data.temperature,
    data.humidity,
    data.pressure,
    data.color.red,
    data.color.green,
    data.color.blue,
    data.color.ambient,

garystafford

aws cloudformation create-stack \
  --stack-name lora-iot-demo \
  --template-body file://cloudformation/iot-analytics.yaml \
  --parameters ParameterKey=ProjectName,ParameterValue=lora-iot-demo \
               ParameterKey=IoTTopicName,ParameterValue=lora-iot-demo \
  --capabilities CAPABILITY_NAMED_IAM

garystafford

def lambda_handler(event, context):
    for e in event:
        e['temperature'] = round((e['temperature'] * 1.8) + 32, 2)
        e['humidity'] = round(e['humidity'], 2)
        e['pressure'] = round((e['pressure'] / 3.3864), 2)
        e['red'] = int(round(e['red'] / (4097 / 255), 0))
        e['green'] = int(round(e['green'] / (4097 / 255), 0))
        e['blue'] = int(round(e['blue'] / (4097 / 255), 0))
        e['ambient'] = int(round(e['ambient'] / (4097 / 255), 0))
    return event

garystafford

{
    "data": {
        "color": {
            "ambient": 1057,
            "blue": 650,
            "green": 667,
            "red": 281
        },
        "device_id": "0447383033363932003C0034",
        "gateway_id": "00000000f62051ce",