AltimateAI / AltimateAI/vscode-dbt-power-user

An error occured while trying to compile your query: Runtime Error got an update_sql operation call with an unrecognized sql operation: sql <REDACTED>

Đang mở
#453 2 bình luận 0 reaction 0 người được giao Xem trên GitHub
bug
Ngôn ngữ chính
JavaScript
Star
585
Fork
121
Merge trung bình
5 ngày 39 phút
Pull request đã merge (30 ngày)
4

Mô tả

### Expected behavior

Should be able to view compiled SQL and be able to run and get query results either entire model or of selection

### Actual behavior

Not able to either view compiled sql nor able to get query results

### Steps To Reproduce

Initialise a dbt-glue repo and setup a very basic model

### Log output/Screenshots

{
"code": -1,
"message": "Database Error\n Glue cursor returned `error` for statement None for code SqlWrapper2.execute('''/* {\"app\": \"dbt\", \"dbt_version\": \"1.3.2\", \"profile_name\": \"\", \"target_name\": \"dev\", \"connection_name\": \"master\"} */\n '''), ParseException: \n mismatched input '' expecting {'(', 'ADD', 'ALTER', 'ANALYZE', 'CACHE', 'CLEAR', 'COMMENT', 'COMMIT', 'CREATE', 'DELETE', 'DESC', 'DESCRIBE', 'DFS', 'DROP', 'EXPLAIN', 'EXPORT', 'FROM', 'GRANT', 'IMPORT', 'INSERT', 'LIST', 'LOAD', 'LOCK', 'MAP', 'MERGE', 'MSCK', 'REDUCE', 'REFRESH', 'REPLACE', 'RESET', 'REVOKE', 'ROLLBACK', 'SELECT', 'SET', 'SHOW', 'START', 'TABLE', 'TRUNCATE', 'UNCACHE', 'UNLOCK', 'UPDATE', 'USE', 'VALUES', 'WITH'}(line 2, pos 0)\n \n == SQL ==\n /* {\"app\": \"dbt\", \"dbt_version\": \"1.3.2\", \"profile_name\": \"\", \"target_name\": \"dev\", \"connection_name\": \"master\"} */\n ^^^\n ",
"data": "\"Error: Traceback (most recent call last):\\n File \\\"/home/vscode/.vscode-server/extensions/innoverio.vscode-dbt-power-user-0.13.0/dist/node_python_bridge.py\\\", line 104, in \\n value = eval(_compile(data['code'], '', 'eval'), _locals)\\n File \\\"\\\", line 1, in \\n File \\\"/home/vscode/.vscode-server/extensions/innoverio.vscode-dbt-power-user-0.13.0/dist/dbt_integration.py\\\", line 412, in execute_sql\\n *self.adapter_execute(compiled_sql, fetch=True),\\n File \\\"/home/vscode/.vscode-server/extensions/innoverio.vscode-dbt-power-user-0.13.0/dist/dbt_integration.py\\\", line 391, in adapter_execute\\n return self.adapter.execute(sql, auto_begin, fetch)\\n File \\\"/home/vscode/.local/lib/python3.8/site-packages/dbt/adapters/base/impl.py\\\", line 278, in execute\\n return self.connections.execute(sql=sql, auto_begin=auto_begin, fetch=fetch)\\n File \\\"/home/vscode/.local/lib/python3.8/site-packages/dbt/adapters/sql/connections.py\\\", line 123, in execute\\n _, cursor = self.add_query(sql, auto_begin)\\n File \\\"/home/vscode/.local/lib/python3.8/site-packages/dbt/adapters/sql/connections.py\\\", line 70, in add_query\\n cursor.execute(sql, bindings)\\n File \\\"/home/vscode/.local/lib/python3.8/site-packages/dbt/adapters/glue/gluedbapi/cursor.py\\\", line 134, in execute\\n raise dbterrors.DatabaseException(msg=error_message)\\ndbt.exceptions.DatabaseException: Database Error\\n Glue cursor returned `error` for statement None for code SqlWrapper2.execute('''/* {\\\"app\\\": \\\"dbt\\\", \\\"dbt_version\\\": \\\"1.3.2\\\", \\\"profile_name\\\": \\\"\\\", \\\"target_name\\\": \\\"dev\\\", \\\"connection_name\\\": \\\"master\\\"} */\\n '''), ParseException: \\n mismatched input '' expecting {'(', 'ADD', 'ALTER', 'ANALYZE', 'CACHE', 'CLEAR', 'COMMENT', 'COMMIT', 'CREATE', 'DELETE', 'DESC', 'DESCRIBE', 'DFS', 'DROP', 'EXPLAIN', 'EXPORT', 'FROM', 'GRANT', 'IMPORT', 'INSERT', 'LIST', 'LOAD', 'LOCK', 'MAP', 'MERGE', 'MSCK', 'REDUCE', 'REFRESH', 'REPLACE', 'RESET', 'REVOKE', 'ROLLBACK', 'SELECT', 'SET', 'SHOW', 'START', 'TABLE', 'TRUNCATE', 'UNCACHE', 'UNLOCK', 'UPDATE', 'USE', 'VALUES', 'WITH'}(line 2, pos 0)\\n \\n == SQL ==\\n /* {\\\"app\\\": \\\"dbt\\\", \\\"dbt_version\\\": \\\"1.3.2\\\", \\\"profile_name\\\": \\\"\\\", \\\"target_name\\\": \\\"dev\\\", \\\"connection_name\\\": \\\"master\\\"} */\\n ^^^\\n \\n\\n\\tat ChildProcess.onMessage (/home/vscode/.vscode-server/extensions/innoverio.vscode-dbt-power-user-0.13.0/dist/extension.js:5563:184)\\n\\tat Object.onceWrapper (node:events:628:26)\\n\\tat ChildProcess.emit (node:events:513:28)\\n\\tat ChildProcess.emit (node:domain:489:12)\\n\\tat emit (node:internal/child_process:939:14)\\n\\tat processTicksAndRejections (node:internal/process/task_queues:84:21)\""
}

### Operating System

Debian GNU/Linux 11 (bullseye)

### dbt version

1.3.2

### dbt Adapter

dbt-glue

### dbt Power User version

v0.13.0

### Are you willing to submit PR?

- [ ] Yes I am willing to submit a PR!

Hướng dẫn đóng góp

Mở hướng dẫn đóng góp

Đánh giá

Issue này chưa được đánh giá.

Nhận issue mới trong hộp thư của bạn

Bản tóm tắt ngắn những issue GitHub phù hợp với người mới.