[
https://issues.jboss.org/browse/TEIID-2816?page=com.atlassian.jira.plugin...
]
Kylin Soong commented on TEIID-2816:
------------------------------------
We need add double quotes for all table name, qualifiers from nameinsource and
columnFamilies from properties in Hbase Table Mapping DDL, cause as [1], Phoenix will
upper casing all of them. For example, use 'CREATE TABLE IF NOT EXISTS
Customer(...' to map 'Customer' table in HBase, it will be cast to 'CREATE
TABLE IF NOT EXISTS CUSTOMER(...', since CUSTOMER not exist in HBase, Phoenix will
create a new one, rather than map to 'Customer', the same way in qualifiers and
columnFamilies. This also affect the SQLConversionVisitor in runtime, me may need rewrite
visit() method for adding the double quotes.
[1]
http://phoenix.apache.org/faq.html#How_I_map_Phoenix_table_to_an_existing...
HBase Connector/Translator
--------------------------
Key: TEIID-2816
URL:
https://issues.jboss.org/browse/TEIID-2816
Project: Teiid
Issue Type: Feature Request
Components: Connector API, JDBC Connector, JDBC Driver
Affects Versions: Open To Community
Reporter: devin pinkston
Assignee: Kylin Soong
Labels: HBase, Translator
Fix For: 8.10
Develop a HBase translator/connector. Potentially using the Phoenix JDBC driver,
supports most SQL and handles connections:
https://github.com/forcedotcom/phoenix
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)