关于FLATTEN文档,您必须首先创建一个包含分割的视图,然后才能使用FLATTEN。https://community.denodo.com/docs/html/browse/7.0/vdp/vql/queries_select_statement/from_clause/flatten_view_flattening_data_structures
在我的例子中,我必须在同一语句中使用这两个步骤进行查询。
文档:
viewA = SELECT test1, split(test2, '; ') AS test2 FROM sourceviewB = SELECT * FROM FLATTEN viewA AS V (V .test2)
我需要这样做:
SELECT * FROM FLATTEN (SELECT test1, split(test2, '; ') AS test2 FROM source) AS V (V .test2)
这可能吗?
尝试使用公共表表达式:
WITH common_table_expression_1
AS (
SELECT test1, split(test2, ';') AS test2
FROM source
)
SELECT *
FROM FLATTEN cte1 AS v(v.test2);