Comment on page
UP10050 Materialized View illegal column expression
- You tried to create a MATERIALIZED VIEW and the select statement contained an illegal expression such as *.
For example:
CREATE SYNC MATERIALIZED VIEW default_glue_catalog.database_16e31b.physical_store_orders_materialized_view_t AS
SELECT orderid,*
FROM default_glue_catalog.database_16e31b.orders_raw_data
GROUP BY orderid;
- Define one or more key columns and use those in the GROUP BY. Define additional aggregated columns using one of the aggregated functions.
For example:
CREATE SYNC MATERIALIZED VIEW default_glue_catalog.database_16e31b.physical_store_orders_materialized_view_t AS
SELECT orderid,
LAST(saleinfo.store.location.country) as country,
LAST(saleinfo.store.location.name) as name,
LAST(saleinfo.store.servicedby.employeeid) as employeeid,
LAST(saleinfo.store.servicedby.firstname) as firstname,
LAST(saleinfo.store.servicedby.lastname) as lastname
FROM default_glue_catalog.database_16e31b.orders_raw_data
GROUP BY orderid;
Last modified 9mo ago