[teiid-issues] [JBoss JIRA] (TEIID-2837) Cassandra: doesn't work with Case Sensitvie KEYSPACE and TABLE name

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-2837:
---------------------------------------

So they expect the value to be quoted when created the session and unquoted when getting the metadata.  It seems like an issue should be logged against their driver so that Cluster.connect will quote if needed.

For now I'll add a null check and a workaround to strip quotes when getting the metadata.
                
> Cassandra:  doesn't work with Case Sensitvie KEYSPACE and TABLE name
> --------------------------------------------------------------------
>
>                 Key: TEIID-2837
>                 URL: https://issues.jboss.org/browse/TEIID-2837
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.6
>         Environment: Cassandra with Teiid 8.6
>            Reporter: Ivan Chan
>            Assignee: Steven Hawkins
>              Labels: teiid
>
> Teiid doesn't work with KeySpace or Table which contains UpperCase.
> Reference From Cassandra -  Using double quote for Case Sensitive KeySpace and Table:
> http://www.datastax.com/docs/1.1/references/cql/CREATE_KEYSPACE
> Exception when try to deploy:
> java.lang.NullPointerException
>         at org.teiid.translator.cassandra.metadata.CassandraMetadataProcessor.processMetadata(CassandraMetadataProcessor.java:52)
>         at org.teiid.translator.cassandra.CassandraExecutionFactory.getMetadata(CassandraExecutionFactory.java:100)
>         at org.teiid.translator.cassandra.CassandraExecutionFactory.getMetadata(CassandraExecutionFactory.java:53)
>         at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:61)
>         at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
>         at org.teiid.runtime.EmbeddedServer.loadMetadata(EmbeddedServer.java:644)
>         at org.teiid.runtime.AbstractVDBDeployer.loadMetadata(AbstractVDBDeployer.java:161)
>         at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:605)
>         at org.teiid.runtime.EmbeddedServer.deployVDB(EmbeddedServer.java:536)

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira