-
Notifications
You must be signed in to change notification settings - Fork 2k
Closed
Labels
Description
Describe the bug
Consider the following data model:
cubes:
- name: gaue14kij3hmvnbnma3bu86g3e
sql: >
SELECT * FROM read_csv('s3://bbb/aaa.csv',delim = ',',header = true,columns={'time':'DATE','count':'NUMERIC'})The SQL expression in sql is a legitimate one in DuckDB (https://duckdb.org/docs/data/csv/overview.html). However, Cube would not compile the data model, emitting the following error:
Can't parse python expression. Most likely this type of syntax isn't supported yet:
Unsupported Python multiple children node: Expr_stmtContext:
f"SELECT * FROM read_csv('s3://bbb/aaa.csv',delim = ',',header = true,columns={'time'<missing DOUBLE_QUOTE_SHORT_TEMPLATE_STRING_END>:'DATE'
Looks like this error has something to do with :.
Expected behavior
Cube compiles provided data model.
Version:
0.35.29
Reactions are currently unavailable