SELECT * FROM WIDGETS WHERE WEIGHT_G > 120
{
SELECT COUNT(*) FROM WIDGETS GROUP BY PRODUCTION_LINE
}
“reading_ts”: “2020-02-14T12:19:27Z”, “sensor_id”: “aa-101”, “production_line”: “w01”, “widget_type”: “acme94”, “temp_celcius”: 23, “widget_weight_g”: 100
Photo by Franck V. on Unsplash
SELECT AVG(TEMP_CELCIUS) AS TEMP FROM WIDGETS GROUP BY SENSOR_ID HAVING TEMP>20
CREATE SINK CONNECTOR dw WITH ( Object store, ‘connector.class’ = ‘S3Connector’, data warehouse, ‘topics’ = ‘widgets’ RDBMS …); @rmoff
|
#NDCOslo
|
@confluentinc