https://datahubproject.io logo
#ingestion
Title
# ingestion
s

stocky-midnight-78204

06/06/2022, 7:29 AM
[2022-06-06 152407,976] WARNING {datahub.ingestion.source.sql.sql_common:1141} - Unable to ingest view xxxxxx due to an exception. Traceback (most recent call last): File "/usr/local/python3/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/local/python3/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) File "/usr/local/python3/lib/python3.8/site-packages/vertica_python/vertica/cursor.py", line 235, in execute self._execute_simple_query(operation) File "/usr/local/python3/lib/python3.8/site-packages/vertica_python/vertica/cursor.py", line 632, in _execute_simple_query raise errors.QueryError.from_error_response(self._message, query) vertica_python.errors.MissingRelation: Severity: ERROR, Message: Relation "pg_class" does not exist
m

mammoth-bear-12532

06/06/2022, 5:40 PM
@breezy-controller-54597: do you have any advice here since this is Vertica related
👍 1
b

breezy-controller-54597

06/06/2022, 10:27 PM
@stocky-midnight-78204 What version and recipe are you using?
I think you are using an earlier version of DataHub because the logs show that vertica.py, which was added in v0.8.36, is not being called.
If you set sqlalchemy as source type and vertica_python as driver in recipe, you cannot ingest the view. Please use v0.8.36 or later version and set vertica as source type in recipe.
s

stocky-midnight-78204

06/07/2022, 1:17 AM
I am using v0.8.35. I will upgrade to v0.8.36 and test again
👍 1
2 Views