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:
- Open the ODBC Data Source Administrator where you created the DSN, then select the DSN, then click Configure, and then click Schema Definition.
- In the Schema Definition dialog box, in the Table Name list, select the table for which you want to edit the schema definition.
- 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.
- 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.
- Repeat the steps above as needed to modify the schema definition.
- 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.