Cloudera Docs

Vertica

Learn how to set up Vertica metadata sources with Cloudera Octopai.

Tool Permissions Prerequisites

Ensure the following prerequisites are met:

  • Open Server Port for each Vertica Database Connection
  • Admin Vertica user for each connection with grant permission for the following dictionary tables:
    • PROJECTIONS
    • TEXT_INDICES
    • USER_FUNCTIONS
    • USER_PROCEDURES
    • USER_TRANSFORMS
    • VIEW_COLUMNS
    • VIEWS
    • VIEW_TABLES
    • ALL_TABLES
    • DATABASES
    • COLUMNS
    • COMMENTS
    • HCATALOG_TABLES
    • CONSTRAINT_COLUMNS
    • HCATALOG_COLUMNS
    • HCATALOG_SCHEMATA
    • HCATALOG_TABLE_LIST
    • PROJECTION_COLUMNS

Setting up Vertica Metadata Source

Metadata Sources are set on the Cloudera Octopai Client.

How to verify the extracted Metadata File

Troubleshoot

Error during the extraction:

  • Check the permissions
  • Send the log with the connector number and name to Cloudera Support - C:\Program Files (x86)\Octopai\Service\log

Access the Cloudera Octopai Target Folder (TGT)

  1. Go to the TGT Folder located on the Server where the Cloudera Octopai Client is installed. By default: C:\Program Files (x86)\Octopai\Service\TGT
  2. Open the zip file having the Connector Name. Example:
  3. Verify its content: Quantity & Quality of inner files