Modifying a Schema Definition

When connecting to an HBase database, the Simba HBase ODBC Driver dynamically detects the database schema that is needed to map the data to an ODBC-compatible format. You can modify the schema definition that the connector uses to connect to the database.

To modify a schema definition:

  1. Open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then click Schema Definition.
  2. In the Schema Definition dialog box, in the Table Name list, select the table for which you want to edit the schema definition.
  3. To change the number of rows in the table that the connector samples to detect columns and corresponding data types, type a number in the Rows field, and then click Sample. In the confirmation dialog, click OK.
  4. To change the data type of a column, in the Columns area, click the Type list for the column, and then select the appropriate data type. The Data Preview pane updates to reflect your change.
  5. Repeat the steps above as needed to modify the schema definition.
  6. When you are finished modifying the schema definition, click OK, and then click Yes when prompted to write metadata to the database.

Schema definitions are stored in a collection called SIMBA_METATABLE. You can copy the collection to other HBase instances to duplicate the schema definition.

Note:

Deleting the SIMBA_METATABLE collection deletes the schema definition.