[2022-06-06 15:24:07,976] WARNING {datahub.ingest...
# ingestions
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?
breezy-controller-54597
06/07/2022, 12:27 AMI 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.
breezy-controller-54597
06/07/2022, 12:32 AMIf 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 AMI am using v0.8.35. I will upgrade to v0.8.36 and test again
👍 1
2 Views