UP10010 Missing ON condition

While SQL allows executing a JOIN statement without the ON condition, it is mandatory to provide one in SQLake.

Possible Causes

• You tried to create a job with LEFT JOIN but no ON condition was provided as part of the SELECT statement.

Possible Solutions

• Use the ON clause to specify the join conditions and how the rows should be matched:

CREATE SYNC JOB join_orders_with_last_employee
    AS INSERT INTO default_glue_catalog.upsolver_samples.joined_orders_transformed_data MAP_COLUMNS_BY_NAM
    SELECT 
       s.orderid, 
       mv.employeeid AS employeeid, 
       mv.firstname AS firstname, 
       mv.lastname AS lastname
    FROM default_glue_catalog.upsolver_samples.orders_raw_data as s
    LEFT JOIN default_glue_catalog.upsolver_samples.physical_store_orders_materialized_view AS mv
    ON mv.orderid = s.orderid
    WHERE mv.source = 'Store'
    AND time_filter();