troubleshooting
How can sub nested columns be accessed to create materialized views?
Jim is trying to create a materialized view in a data source with nested columns. He provided examples of queries that resulted in errors. Yufan Song suggested a corrected query.
Ji
Jim
Asked on Oct 11, 2023
- To access sub nested columns in a materialized view, use the correct syntax for nested fields.
CREATE MATERIALIZED VIEW test AS SELECT (data).crm.Operation AS operation FROM crm;Oct 12, 2023Edited by