Skip to main content Skip to complementary content

Retrieving a Hcatalog table schema

Procedure

  1. When you click Retrieve Schema, a new wizard opens up where you can filter and display different tables in the HCatalog.
    New Schema on "HCatalog_connection" dialog box showing schema to be selected.
  2. In the Name filter field, you can enter the name of the tables you are looking for to filter it/them.
    Otherwise, you can directly find and select the tables of which you need to retrieve the schemas.
    Each time when the schema retrieval is done for a table selected, the Creation status of this table becomes Success.
  3. Click Next to open a new view on the wizard that lists the selected table schema(s). You can select any of them to display its details in the Schema area.
    New Schema on "HCatalog_connection" dialog box showing schema added on repository.
  4. Modify the selected schema if needed. You can change the name of the schema and according to your needs, you can also customize the schema structure in the Schema area.
    Indeed, the tool bar allows you to add, remove or move columns in your schema.
    To overwrite the modifications you made on this selected schema with its default one, click Retrieve schema. Note that this overwriting does not retain any custom edits.
  5. Click Finish to complete the HCatalog table schema creation. All the retrieved schemas are displayed under the relevant HCatalog connection node in the Repository view.
    If then you still need to edit a schema, right-click this schema under the related HCatalog connection node in the Repository view and from the contextual menu, select Edit Schema to open this wizard again and then make the modifications.
    Information noteNote:

    If you modify the schemas, ensure that the data type in the Type column is correctly defined.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here