wren-engine
wren-engine copied to clipboard
Canner
🤖 The Semantic Engine for Model Context Protocol(MCP) Clients and AI Agents 🔥
ibis server error message ``` ERROR: Exception in ASGI application Traceback (most recent call last): File "/Users/apple/.pyenv/versions/3.11.1/lib/python3.11/site-packages/uvicorn/protocols/http/httptools_impl.py", line 411, in run_asgi result = await app( # type: ignore[func-returns-value] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File...
Input SQL ```SQL SELECT COUNT(*) AS "count" FROM "tpch"."Orders" WHERE ("tpch"."Orders"."orderkey" IS NOT NULL) AND (("tpch"."Orders"."orderkey" ?) OR ("tpch"."Orders"."orderkey" IS NULL)) ``` Rewritten SQL ```SQL WITH "Orders" AS ( SELECT...
https://github.com/Canner/wren-engine/blob/88d527b241abdc5bd56e3bdf396c1d2b379d7aaf/wren-main/src/main/java/io/wren/main/wireprotocol/PostgresWireProtocol.java#L284-L286
See the discussion https://github.com/Canner/wren-engine/pull/519#issuecomment-2041939997
We need to re-definiton the scope for the MDL. `WITH` is not in the MDL scope, so `getColumnType` will be failed in the `ExpressionTypeAnalyzer`. Like this case - TestAllRulesRewrite.testAccioNoRewrite("with normalCte...
# Description The Wren engine provides the deploy API for MDL deployment after the server has started. The MDL file should not be required for the server to start. Currently,...
Metabase will use `SUBSTRING` function in PostgreSQL. ``` SUBSTRING(`Model_Deal`.`company_id`, 1, 1234) `substring1189` ``` We don't transfer this to the BigQuery corresponding function correctly.
When we analyze the prepare-statement for the function's return type, we don't have the parameter is what type when it is a `?` at the visitFunctionCall in the ExpressionTypeAnalyzer. https://github.com/Canner/accio/blob/e94fb56a61216295b57db776cafa6344b579d462/accio-tests/src/test/java/io/accio/testing/bigquery/TestFunctions.java#L109-L115
We missed the analysis of `having` at the visitQuerySpecification in the StatementAnalyzer. It should be like `analyzeWhere`. https://github.com/Canner/accio/blob/9dfc709d7d7bce8883947a035fc1badbfc9f85fe/accio-base/src/main/java/io/accio/base/sqlrewrite/analyzer/StatementAnalyzer.java#L312-L318
ERROR: com.google.cloud.bigquery.BigQueryException: OFFSET is not a function. It can only be used for array element access using array[OFFSET(position)] at [28:70] ``` { "catalog": "canner-cml", "schema": "hubspot", "models": [ { "name":...
