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

[ https://issues.jboss.org/browse/TEIID-2816?page=com.atlassian.jira.plugin... ] Kylin Soong edited comment on TEIID-2816 at 1/14/15 4:41 AM: ------------------------------------------------------------- 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, we 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... was (Author: kylin): 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... -- This message was sent by Atlassian JIRA (v6.3.11#6341)