• b

    breezy-controller-54597

    5 months ago
    I added
    get_columns
    and
    _get_column_info
    , but VerticaDialect object has been recognized as str...
    datahub/ingestion/source/sql/vertica.py, line 149, in _get_column_info  
        self.ischema_names["UUID"] = UUID  
    AttributeError: 'str' object has no attribute 'ischema_names'
    b
    c
    2 replies
    Copy to Clipboard
  • b

    breezy-controller-54597

    5 months ago
    I have looked at the code from other sources and it seems that the column type needs to be converted so that sqlalchemy can handle it, but I don't know how. I am getting the following error.
    [2022-04-07 04:57:15,056] WARNING {datahub.ingestion.source.sql.sql_common:1066] - Unable to ingest view SCHEMA.VIEWNAME
    Traceback (most recent call last):
      File "/usr/local/lib/python3.8/site-packages/datahub/ingestion/source/sql/sql_common.py", line 1058, in loop_views
        yield from  self._process_view(
      File "/usr/local/lib/python3.8/site-packages/datahub/ingestion/source/sql/sql_common.py", line 1084, in_process_view
        columns = inspector.get_columns(view, schema)
      File: "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/reflection.py", line 390, in get_columns
        col_defs = self.dialect.get_columns(
      File "<string>", line 2, in get_columns
      File "/usr/local/lib/python3.8/site-packages/sqlalchemy/engine/reflection.py", line 52, in cache
        ret = fn(self, can, *args, **kw)
      File "/usr/local/lib/python3.8/site-packages/datahub/ingestion/source/sql/vertica.py", line 97, in get_columns
        column_info = self._get_column_info(name, type, default, nullable, schema)
      File "/usr/local/lib/python3.8/site-packages/datahub/ingestion/source/sql/vertica.py", line 155, in _get_column_info
        coltype = coltype(*args, **kwargs)
    TypeError: 'DATE' object is not callable
    b
    m
    +1
    12 replies
    Copy to Clipboard
  • r

    refined-ability-35859

    2 months ago
    Hello, I have created a recipe file based on Vertica as a source (https://datahubproject.io/docs/generated/ingestion/sources/vertica/) and when i execute the receipe file, i get the below error for views: vertica_python.errors.MissingRelation: Severity: ERROR, Message: Relation "pg_class" does not exist, Sqlstate: 42V01, Routine: throwRelationDoesNotExist, File: /data/jenkins/workspace/RE-ReleaseBuilds/RE-Jackhammer/server/vertica/Catalog/CatalogLookup.cpp, Line: 4108, Error Code: 4566, SQL: "SELECT pg_get_viewdef(c.oid) view_def FROM pg_class c JOIN pg_namespace n ON n.oid = c.relnamespace WHERE n.nspname = 'cognos_schema' AND c.relname = 'VNUM' AND c.relkind IN ('v', 'm')" .