Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-2837

Cassandra: doesn't work with Case Sensitvie KEYSPACE and TABLE name

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.7
    • 8.6
    • Query Engine
    • Hide

      Create KEYSPACE and TABLE using the following script:

      CREATE KEYSPACE "MySpace2" with REPLICATION =

      { 'class' : 'SimpleStrategy', 'replication_factor' : 1}

      ;
      use "MySpace2";
      CREATE TABLE "Users" (user_id int PRIMARY KEY, fname text, lname text);
      INSERT INTO "Users" (user_id, fname, lname) VALUES (1745, 'john', 'smith');

      Use Teiid to connect to keyspace, "\"MySpace2\"".

      Exception from deployment:

      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)

      Show
      Create KEYSPACE and TABLE using the following script: CREATE KEYSPACE "MySpace2" with REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1} ; use "MySpace2"; CREATE TABLE "Users" (user_id int PRIMARY KEY, fname text, lname text); INSERT INTO "Users" (user_id, fname, lname) VALUES (1745, 'john', 'smith'); Use Teiid to connect to keyspace, "\"MySpace2\"". Exception from deployment: 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)

    Description

      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)

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            mchantibco Ivan Chan (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: