Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Required keyword: 'expression' missing for <class 'sqlglot.expressions.GT'>. #1370

Open
carroll1118 opened this issue Mar 6, 2025 · 1 comment
Open

Required keyword: 'expression' missing for <class 'sqlglot.expressions.GT'>. #1370

carroll1118 opened this issue Mar 6, 2025 · 1 comment
Labels
bug Something isn't working

Comments

@carroll1118
Copy link

I0306 06:26:46.436 8 wren-ai-service:165] Follow-Up SQL Generation pipeline is running...
2025-03-06T06:26:46.581424200Z I0306 06:26:46.581 8 wren-ai-service:130] SQL Generation Reasoning pipeline is running...
2025-03-06T06:26:46.821231000Z INFO: 172.18.0.6:43076 - "GET /v1/asks/ed4964c7-4018-41d7-9fde-e253a4afcfc0/result HTTP/1.1" 200 OK
2025-03-06T06:26:47.873990300Z INFO: 172.18.0.6:43080 - "GET /v1/asks/ed4964c7-4018-41d7-9fde-e253a4afcfc0/result HTTP/1.1" 200 OK
2025-03-06T06:26:49.148220500Z E0306 06:26:49.138 8 wren-ai-service:57] Error in sqlglot.transpile to SELECT wmswarehouse_sku.sku_code AS sku_code, wmswarehouse_sku.product_name AS product_name FROM wmswarehouse_sku WHERE wmswarehouse_sku.expiration_warning_value > <设定的阈值>: Required keyword: 'expression' missing for <class 'sqlglot.expressions.GT'>. Line 1, Col: 165.
2025-03-06T06:26:49.148448100Z roduct_name AS product_name FROM wmswarehouse_sku WHERE wmswarehouse_sku.expiration_warning_value > <设定的阈值>
2025-03-06T06:26:49.148473700Z Traceback (most recent call last):
2025-03-06T06:26:49.148485400Z File "/src/core/engine.py", line 55, in add_quotes
2025-03-06T06:26:49.148496300Z quoted_sql = sqlglot.transpile(sql, read="trino", identify=True)[0]
2025-03-06T06:26:49.148507600Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-03-06T06:26:49.148538600Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/init.py", line 177, in transpile
2025-03-06T06:26:49.148719400Z for expression in parse(sql, read, error_level=error_level)
2025-03-06T06:26:49.149189700Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-03-06T06:26:49.149340700Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/init.py", line 102, in parse
2025-03-06T06:26:49.149360400Z return Dialect.get_or_raise(read or dialect).parse(sql, **opts)
2025-03-06T06:26:49.149370900Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-03-06T06:26:49.149381400Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/dialects/dialect.py", line 931, in parse
2025-03-06T06:26:49.149393200Z return self.parser(**opts).parse(self.tokenize(sql), sql)
2025-03-06T06:26:49.149403400Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-03-06T06:26:49.149413400Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/parser.py", line 1432, in parse
2025-03-06T06:26:49.149478300Z return self._parse(
2025-03-06T06:26:49.149491300Z ^^^^^^^^^^^^
2025-03-06T06:26:49.149513900Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/parser.py", line 1501, in _parse
2025-03-06T06:26:49.149525500Z expressions.append(parse_method(self))
2025-03-06T06:26:49.149535600Z ^^^^^^^^^^^^^^^^^^
2025-03-06T06:26:49.149546000Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/parser.py", line 1742, in _parse_statement
2025-03-06T06:26:49.149556900Z expression = self._parse_set_operations(expression) if expression else self._parse_select()
2025-03-06T06:26:49.149661600Z ^^^^^^^^^^^^^^^^^^^^
2025-03-06T06:26:49.149677800Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/parser.py", line 3050, in _parse_select
2025-03-06T06:26:49.149689100Z this = self._parse_query_modifiers(this)
2025-03-06T06:26:49.149698900Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-03-06T06:26:49.149708700Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/parser.py", line 3227, in _parse_query_modifiers
2025-03-06T06:26:49.149719300Z key, expression = parser(self)
2025-03-06T06:26:49.149729200Z ^^^^^^^^^^^^
2025-03-06T06:26:49.149738900Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/parser.py", line 1149, in
2025-03-06T06:26:49.149750000Z TokenType.WHERE: lambda self: ("where", self._parse_where()),
2025-03-06T06:26:49.149759500Z ^^^^^^^^^^^^^^^^^^^
2025-03-06T06:26:49.149769600Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/parser.py", line 4125, in _parse_where
2025-03-06T06:26:49.149780200Z exp.Where, comments=self._prev_comments, this=self._parse_assignment()
2025-03-06T06:26:49.149789700Z ^^^^^^^^^^^^^^^^^^^^^^^^
2025-03-06T06:26:49.149799200Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/parser.py", line 4455, in _parse_assignment
2025-03-06T06:26:49.149812800Z this = self._parse_disjunction()
2025-03-06T06:26:49.149911700Z ^^^^^^^^^^^^^^^^^^^^^^^^^
2025-03-06T06:26:49.149937600Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/parser.py", line 4476, in _parse_disjunction
2025-03-06T06:26:49.149950100Z return self._parse_tokens(self._parse_conjunction, self.DISJUNCTION)
2025-03-06T06:26:49.149960300Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-03-06T06:26:49.149970600Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/parser.py", line 6695, in _parse_tokens
2025-03-06T06:26:49.149981400Z this = parse_method()
2025-03-06T06:26:49.150032500Z ^^^^^^^^^^^^^^
2025-03-06T06:26:49.150279900Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/parser.py", line 4479, in _parse_conjunction
2025-03-06T06:26:49.150325900Z return self._parse_tokens(self._parse_equality, self.CONJUNCTION)
2025-03-06T06:26:49.150352000Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-03-06T06:26:49.150363900Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/parser.py", line 6695, in _parse_tokens
2025-03-06T06:26:49.150375200Z this = parse_method()
2025-03-06T06:26:49.150385400Z ^^^^^^^^^^^^^^
2025-03-06T06:26:49.150395000Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/parser.py", line 4482, in _parse_equality
2025-03-06T06:26:49.150406200Z return self._parse_tokens(self._parse_comparison, self.EQUALITY)
2025-03-06T06:26:49.150417300Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-03-06T06:26:49.150428000Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/parser.py", line 6695, in _parse_tokens
2025-03-06T06:26:49.150448100Z this = parse_method()
2025-03-06T06:26:49.150459100Z ^^^^^^^^^^^^^^
2025-03-06T06:26:49.150467900Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/parser.py", line 4485, in _parse_comparison
2025-03-06T06:26:49.150478900Z return self._parse_tokens(self._parse_range, self.COMPARISON)
2025-03-06T06:26:49.150489500Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-03-06T06:26:49.150508500Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/parser.py", line 6698, in _parse_tokens
2025-03-06T06:26:49.150520500Z this = self.expression(
2025-03-06T06:26:49.150531600Z ^^^^^^^^^^^^^^^^
2025-03-06T06:26:49.150541800Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/parser.py", line 1565, in expression
2025-03-06T06:26:49.150553400Z return self.validate_expression(instance)
2025-03-06T06:26:49.150564100Z ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2025-03-06T06:26:49.150575600Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/parser.py", line 1585, in validate_expression
2025-03-06T06:26:49.150587500Z self.raise_error(error_message)
2025-03-06T06:26:49.150598100Z File "/app/.venv/lib/python3.12/site-packages/sqlglot/parser.py", line 1545, in raise_error
2025-03-06T06:26:49.150609800Z raise error
2025-03-06T06:26:49.150619400Z sqlglot.errors.ParseError: Required keyword: 'expression' missing for <class 'sqlglot.expressions.GT'>. Line 1, Col: 165.
2025-03-06T06:26:49.150630400Z roduct_name AS product_name FROM wmswarehouse_sku WHERE wmswarehouse_sku.expiration_warning_value > <设定的阈值>
@carroll1118 carroll1118 added the bug Something isn't working label Mar 6, 2025
@wwwy3y3
Copy link
Member

wwwy3y3 commented Mar 6, 2025 •
edited
Loading

Hi, thanks for reaching out.

  1. Could you describe your issue, telling us what happened on your screen?
  2. What OS / Browser are you using ?
  3. What version of Wren AI are you using ?
  4. Could you provide detailed logs with following command ?
  docker logs wrenai-wren-ui-1 >& wrenai-wren-ui.log && \
  docker logs wrenai-wren-ai-service-1 >& wrenai-wren-ai-service.log && \
  docker logs wrenai-wren-engine-1 >& wrenai-wren-engine.log && \
  docker logs wrenai-ibis-server-1 >& wrenai-ibis-server.log

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@wwwy3y3 @carroll1118