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.upsolver_samples.physical_store_orders_materialized_view_t ASSELECT orderid,*FROM default_glue_catalog.upsolver_samples.orders_raw_dataGROUP BY orderid;
Possible Solutions
For example:
CREATE SYNC MATERIALIZED VIEW default_glue_catalog.upsolver_samples.physical_store_orders_materialized_view_t ASSELECT orderid, LAST(saleinfo.store.location.country) as country,LAST(saleinfo.store.location.name) asname,LAST(saleinfo.store.servicedby.employeeid) as employeeid,LAST(saleinfo.store.servicedby.firstname) as firstname,LAST(saleinfo.store.servicedby.lastname) as lastnameFROM default_glue_catalog.upsolver_samples.orders_raw_dataGROUP BY orderid;
Last updated
Define one or more key columns and use those in the GROUP BY. Define additional aggregated columns using one of the .