JBoss Community Archive (Read Only)

Teiid 8.12

Apache HBase Translator (hbase)

Also see common JDBC Translator Information

The Apache HBase Translator, known by the type name hbase, exposes querying functionality to HBase Tables. Apache Phoenix is a JDBC SQL interface for HBase - see Phoenix Data Sources that is required for this translator as it pushes down commands into Phoenix SQL.

The DatabaseTimezone property should not be used with this translator.

The HBase Translator doesn't support Joins. Phoenix uses the HBase Table Row ID as the Primary Key, which map to . This Translator is developed with Phoenix 4.3+ for HBase 0.98.1+.

The translator implements INSERT/UPDATE through the Phoenix UPSERT operation. This means you can see different behavior than with standard INSERT/UPDATE - such as repeated inserts will not throw a duplicate key exception, but will instead update the row in question.

Due to Phoenix driver limitations the importer will not look for unique constraints and defaults to not importing foreign keys.

JBoss.org Content Archive (Read Only), exported from JBoss Community Documentation Editor at 2020-03-13 12:27:02 UTC, last content change 2015-10-14 14:41:44 UTC.