[teiid-issues] [JBoss JIRA] (TEIID-2816) HBase Connector/Translator

[Kylin Soong (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2816?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13032332#comment-13032332 ] 

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_table

> 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)