You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
To Reproduce
Steps to reproduce the behavior:
run the test
Expected behavior
a success
Additional context
the file format STRIP_OUTER_ARRAY trigger the def tokens_not_columns_names(self, t: LexToken) -> LexToken: t_tag = self.parse_tags_symbols(t) if t_tag: return t_tag if "ARRAY" in t.value : t.type = "ARRAY" return t the if ARRAY statement it should not, adding a len<15 could solve the problem
The text was updated successfully, but these errors were encountered:
Describe the bug
The following test doesn't pass :
`ddl = """
create external table if not exists TABLE_DATA_SRC.EXT_PAYLOAD_MANIFEST_WEB (
"type" VARCHAR(255) AS (SPLIT_PART(SPLIT_PART(METADATA$FILENAME, '/', 1), '=', 2 )),
"year" VARCHAR(255) AS (SPLIT_PART(SPLIT_PART(METADATA$FILENAME, '/', 2), '=', 2)),
"month" VARCHAR(255) AS (SPLIT_PART(SPLIT_PART(METADATA$FILENAME, '/', 3), '=', 2)),
"day" VARCHAR(255) AS (SPLIT_PART(SPLIT_PART(METADATA$FILENAME, '/', 4), '=', 2)),
"cast_YEAR" VARCHAR(200) AS (GET(VALUE,'c1')::string),
"path" VARCHAR(255) AS (METADATA$FILENAME)
)
partition by ("type", "year", "month", "day", "path")
location=@ADL_Azure_Storage_Account_Container_Name/year=2023/month=08/
auto_refresh=false
pattern='*.csv'
file_format = (TYPE = JSON NULL_IF = () STRIP_OUTER_ARRAY = TRUE )
;
"""
result_ext_table = DDLParser(ddl, normalize_names=True, debug=True).run(
output_mode="snowflake"
)
To Reproduce
Steps to reproduce the behavior:
run the test
Expected behavior
a success
Additional context
the file format
STRIP_OUTER_ARRAY
trigger thedef tokens_not_columns_names(self, t: LexToken) -> LexToken: t_tag = self.parse_tags_symbols(t) if t_tag: return t_tag if "ARRAY" in t.value : t.type = "ARRAY" return t
the if ARRAY statement it should not, adding a len<15 could solve the problemThe text was updated successfully, but these errors were encountered: