All tasks

Sensor Data Analysis (Greenplum)

Intermediate

Analyze sensor readings using a table with DISTRIBUTED BY. Calculate the average readings by sensor and location. This task demonstrates Greenplum's hash distribution for optimal query performance.

Category
Greenplum MPP
Estimated time
~15 min
Databases
PostgreSQLGreenplum
Tags
DISTRIBUTED BYGreenplumагрегация

Sign in to solve

Start Solving