GitHub user sptrakesh created a discussion: function read_parquet(unknown) does 
not exist

I am running Superset with pgduckdb (similar set up to 
https://github.com/khofenbitzer/superset-duckdb/tree/main).  I am able to run 
queries directly against the database via `psql`, but the same query fails when 
I run it from "SQL Lab".  Running latest Superset docker image.

The log is as follows:

```
2026-05-26 
21:13:26,523:WARNING:superset.views.error_handling:SupersetErrorsException
Traceback (most recent call last):
  File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1484, in 
full_dispatch_request
    rv = self.dispatch_request()
  File "/app/.venv/lib/python3.10/site-packages/flask/app.py", line 1469, in 
dispatch_request
    return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
  File 
"/app/.venv/lib/python3.10/site-packages/flask_appbuilder/security/decorators.py",
 line 109, in wraps
    return f(self, *args, **kwargs)
  File "/app/superset/views/base_api.py", line 120, in wraps
    duration, response = time_function(f, self, *args, **kwargs)
  File "/app/superset/utils/core.py", line 1559, in time_function
    response = func(*args, **kwargs)
  File "/app/superset/views/base_api.py", line 92, in wraps
    return f(self, *args, **kwargs)
  File "/app/superset/utils/log.py", line 301, in wrapper
    value = f(*args, **kwargs)
  File "/app/superset/sqllab/api.py", line 555, in execute_sql_query
    command_result: CommandResult = command.run()
  File "/app/superset/utils/decorators.py", line 267, in wrapped
    return on_error(ex)
  File "/app/superset/utils/decorators.py", line 232, in on_error
    raise ex
  File "/app/superset/utils/decorators.py", line 260, in wrapped
    result = func(*args, **kwargs)
  File "/app/superset/commands/sql_lab/execute.py", line 105, in run
    status = self._run_sql_json_exec_from_scratch()
  File "/app/superset/commands/sql_lab/execute.py", line 158, in 
_run_sql_json_exec_from_scratch
    return self._sql_json_executor.execute(
  File "/app/superset/sqllab/sql_json_executer.py", line 110, in execute
    raise SupersetErrorsException(
superset.exceptions.SupersetErrorsException: [SupersetError(message="postgresql 
error: function read_parquet(unknown) does not exist\nLINE 4: FROM 
READ_PARQUET('/data/parquet/reelhistory/*.parquet') AS ...\n             
^\nHINT:  No function matches the given name and argument types. You might need 
to add explicit type casts.\n", 
error_type=<SupersetErrorType.GENERIC_DB_ENGINE_ERROR: 
'GENERIC_DB_ENGINE_ERROR'>, level=<ErrorLevel.ERROR: 'error'>, 
extra={'engine_name': 'PostgreSQL', 'issue_codes': [{'code': 1002, 'message': 
'Issue 1002 - The database returned an unexpected error.'}]})]
```

GitHub link: https://github.com/apache/superset/discussions/40453

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: 
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to