Enabling Multiple Schemas

By default, the CData ODBC Driver for Apache Phoenix will not use multiple schemas. The driver can be configured to work with other schemas if EnableSchemas is set to true.

The necessary changes must be made on the server-side of HBase and ApachePhoenix. Please consult the docs for more information.

Fine Tune Driver Performance

The connection property Pagesize can be used to control the size of a page (frame) returned from the API.

Setting a lower number will result in more requests made for data retrieval, while setting a bigger number will result in fewer requests. Setting a really big number can also result in OutOfMemory errors.

Batch Operations

The driver does extra operations in the background to convert INSERT and update operations to upserts. For performance reasons, it is advised to use upserts in batch operations.