UP10050 Materialized View Illegal Column Expression

Possible Causes

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 AS 
    SELECT orderid,*
    FROM default_glue_catalog.upsolver_samples.orders_raw_data
    GROUP BY orderid;

Possible Solutions

Define one or more key columns and use those in the GROUP BY. Define additional aggregated columns using one of the aggregate functions.

For example:

CREATE SYNC MATERIALIZED VIEW default_glue_catalog.upsolver_samples.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.upsolver_samples.orders_raw_data
    GROUP BY orderid;