Materialized Views in Athena
This series of commands will show the usage the following matview CLI commands:
matview-create
matview-stats
matview-describe
matview-list
matview-pause
matview-resume
matview-delete
Note:
- Only timeseriesio materialized views are supported in athena.
- Currently we only support CSV and JSON storage formats.
We will create a table in Glue data catalog (GDC) and construct athena materialized view on top of it.
Create a table in Glue data catalog using athena query
Create a timeseriesio MV using DPL file
Save as page_loads_mv.dpl
.
Run the following CLI command:
Returns
datacoral organize matview-stats
Check Returns
datacoral organize matview-describe
Check Returns JSON
by default
Returns DPL
file
datacoral organize matview-list
Check Returns
datacoral organize matview-pause
Check Returns
datacoral organize matview-resume
Check Returns
datacoral organize matview-delete
Check Returns