3 Replies Latest reply on Apr 19, 2018 12:52 PM by Steven Hawkins

    Cannot import cassandra datasource using Teiid Importer

    Ruud Fleskens Newbie

      Hi, i try to import a cassandra datasource using Teiid Connection Importer, but get the following error below.

       

      We are using the following configuration:

      Jboss DV 6.3.0 &

      Cassandra 3.9

       

      Is this possible, or do we have to upgrade drivers/versions?

      We also tried using the driver from the latest teiid release, which has the following config:

       

      ./system/layers/dv/com/datastax/cassandra

      ./system/layers/dv/com/datastax/cassandra/driver

      ./system/layers/dv/com/datastax/cassandra/driver/core

      ./system/layers/dv/com/datastax/cassandra/driver/core/main

      ./system/layers/dv/com/datastax/cassandra/driver/core/main/module.xml

      ./system/layers/dv/com/datastax/cassandra/driver/core/main/metrics-core-3.1.2.jar

      ./system/layers/dv/com/datastax/cassandra/driver/core/main/cassandra-driver-core-3.1.3.jar

      ./system/layers/dv/org/jboss/teiid/resource-adapter/cassandra

      ./system/layers/dv/org/jboss/teiid/resource-adapter/cassandra/main

      ./system/layers/dv/org/jboss/teiid/resource-adapter/cassandra/main/META-INF

      ./system/layers/dv/org/jboss/teiid/resource-adapter/cassandra/main/META-INF/ra.xml

      ./system/layers/dv/org/jboss/teiid/resource-adapter/cassandra/main/META-INF/MANIFEST.MF

      ./system/layers/dv/org/jboss/teiid/resource-adapter/cassandra/main/module.xml

      ./system/layers/dv/org/jboss/teiid/resource-adapter/cassandra/main/connector-cassandra-10.2.0.jar

      ./system/layers/dv/org/jboss/teiid/translator/cassandra

      ./system/layers/dv/org/jboss/teiid/translator/cassandra/main

      ./system/layers/dv/org/jboss/teiid/translator/cassandra/main/translator-cassandra-10.2.0.jar

      ./system/layers/dv/org/jboss/teiid/translator/cassandra/main/module.xml

       

      But this resulted in:

       

      16:04:54,595 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-6) MSC000001: Failed to start service jboss.teiid.vdb.importVDB.1: org.jboss.msc.service.StartException in service jboss.teiid.vdb.importVDB.1: Failed to start service
              at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1936) [jboss-msc-1.1.6.Final-redhat-1.jar:1.1.6.Final-redhat-1]
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_131]
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_131]
              at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_131]
      Caused by: java.lang.NoSuchMethodError: org.teiid.translator.cassandra.CassandraExecutionFactory.setTransactionSupport(Lorg/teiid/translator/ExecutionFactory$TransactionSupport;)V
              at org.teiid.translator.cassandra.CassandraExecutionFactory.start(CassandraExecutionFactory.java:62)
              at org.teiid.deployers.TranslatorUtil.buildExecutionFactory(TranslatorUtil.java:127)
              at org.teiid.jboss.VDBService.getExecutionFactory(VDBService.java:320)
              at org.teiid.jboss.VDBService$5.getExecutionFactory(VDBService.java:292)
              at org.teiid.dqp.internal.datamgr.ConnectorManagerRepository.createConnectorManager(ConnectorManagerRepository.java:134)
              at org.teiid.dqp.internal.datamgr.ConnectorManagerRepository.createConnectorManagers(ConnectorManagerRepository.java:108)
              at org.teiid.jboss.VDBService.createConnectorManagers(VDBService.java:296)
              at org.teiid.jboss.VDBService.start(VDBService.java:129)
              at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1980) [jboss-msc-1.1.6.Final-redhat-1.jar:1.1.6.Final-redhat-1]
              at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1913) [jboss-msc-1.1.6.Final-redhat-1.jar:1.1.6.Final-redhat-1]
              ... 3 more

       

      Original error (original drivers):

       

      16:30:36,551 DEBUG [com.datastax.driver.core.ControlConnection] (teiid-async-threads - 3) [Control connection] error on /[ip]:9042 connection, no more host to try: com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured table schema_keyspaces
       at com.datastax.driver.core.Responses$Error.asException(Responses.java:103) [cassandra-driver-core-2.1.3.jar:]
       at com.datastax.driver.core.DefaultResultSetFuture.onSet(DefaultResultSetFuture.java:110) [cassandra-driver-core-2.1.3.jar:]
       at com.datastax.driver.core.DefaultResultSetFuture.onSet(DefaultResultSetFuture.java:128) [cassandra-driver-core-2.1.3.jar:]
       at com.datastax.driver.core.Connection$Dispatcher.messageReceived(Connection.java:668) [cassandra-driver-core-2.1.3.jar:]
       at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70)
       at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
       at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)
       at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296)
       at org.jboss.netty.handler.codec.oneone.OneToOneDecoder.handleUpstream(OneToOneDecoder.java:70)
       at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
       at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)
       at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296)
       at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462)
       at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443)
       at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303)
       at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70)
       at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
       at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559)
       at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268)
       at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255)
       at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88)
       at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:109)
       at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:328)
       at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:90)
       at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178)
       at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108)
       at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42)
       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_131]
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_131]
       at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_131]
       
      16:30:36,554 DEBUG [com.datastax.driver.core.Cluster] (teiid-async-threads - 3) Shutting down
      16:30:36,555 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (teiid-async-threads - 3) IJ000604: Throwable while attempting to get a new connection: null: com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /13.95.30.69:9042 (com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured table schema_keyspaces))
       at com.datastax.driver.core.ControlConnection.reconnectInternal(ControlConnection.java:220) [cassandra-driver-core-2.1.3.jar:]
       at com.datastax.driver.core.ControlConnection.connect(ControlConnection.java:78) [cassandra-driver-core-2.1.3.jar:]
       at com.datastax.driver.core.Cluster$Manager.init(Cluster.java:1231) [cassandra-driver-core-2.1.3.jar:]
       at com.datastax.driver.core.Cluster.getMetadata(Cluster.java:334) [cassandra-driver-core-2.1.3.jar:]
       at org.teiid.resource.adapter.cassandra.CassandraConnectionImpl.(CassandraConnectionImpl.java:67)
       at org.teiid.resource.adapter.cassandra.CassandraManagedConnectionFactory$1.getConnection(CassandraManagedConnectionFactory.java:48)
       at org.teiid.resource.adapter.cassandra.CassandraManagedConnectionFactory$1.getConnection(CassandraManagedConnectionFactory.java:45)
       at org.teiid.resource.spi.BasicManagedConnectionFactory.createManagedConnection(BasicManagedConnectionFactory.java:71) [teiid-api-8.12.5.redhat-8.jar:8.12.5.redhat-8]
       at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:858)
       at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:413)
       at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:457)
       at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:429)
       at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:344)
       at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:367)
       at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:499)
       at org.teiid.resource.spi.WrappedConnectionFactory.getConnection(WrappedConnectionFactory.java:58) [teiid-api-8.12.5.redhat-8.jar:8.12.5.redhat-8]
       at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:181) [teiid-api-8.12.5.redhat-8.jar:8.12.5.redhat-8]
       at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:202) [teiid-api-8.12.5.redhat-8.jar:8.12.5.redhat-8]
       at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:72)
       at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62)
       at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
       at org.teiid.jboss.VDBService$6.run(VDBService.java:395)
       at org.teiid.jboss.VDBService$7.run(VDBService.java:446)
       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_131]
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_131]
       at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_131]
       at org.jboss.threads.JBossThread.run(JBossThread.java:122)
       
      16:30:36,556 DEBUG [com.datastax.driver.core.Connection] (New I/O worker #73) Defuncting connection to /[ip]:9042: com.datastax.driver.core.TransportException: [/13.95.30.69:9042] Channel has been closed
       at com.datastax.driver.core.Connection$Dispatcher.channelClosed(Connection.java:721) [cassandra-driver-core-2.1.3.jar:]
       at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:88)
       at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
       at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)
       at org.jboss.netty.handler.codec.oneone.OneToOneDecoder.handleUpstream(OneToOneDecoder.java:60)
       at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
       at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)
       at org.jboss.netty.handler.codec.frame.FrameDecoder.cleanup(FrameDecoder.java:493)
       at org.jboss.netty.handler.codec.frame.FrameDecoder.channelClosed(FrameDecoder.java:371)
       at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:88)
       at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
       at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559)
       at org.jboss.netty.channel.Channels.fireChannelClosed(Channels.java:468)
       at org.jboss.netty.channel.Channels$6.run(Channels.java:457)
       at org.jboss.netty.channel.socket.ChannelRunnableWrapper.run(ChannelRunnableWrapper.java:40)
       at org.jboss.netty.channel.socket.nio.AbstractNioSelector.processTaskQueue(AbstractNioSelector.java:382)
       at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:306)
       at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:90)
       at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178)
       at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108)
       at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42)
       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_131]
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_131]
       at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_131]
       
      16:30:36,558 DEBUG [com.datastax.driver.core.Connection] (New I/O worker #73) Connection[/[ip]:9042-1, inFlight=0, closed=true] closing connection
      16:30:36,560 WARN  [org.teiid.RUNTIME] (teiid-async-threads - 3) TEIID50036 VDB importVDB.1 model "importVDBSrcModel" metadata failed to load. Reason:TEIID31178 Could not obtain connection for schema importVDBSrcModel, but one is required for metadata load. : org.teiid.translator.TranslatorException: TEIID31178 Could not obtain connection for schema importVDBSrcModel, but one is required for metadata load. 
       at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:76) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
       at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:62) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
       at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
       at org.teiid.jboss.VDBService$6.run(VDBService.java:395) [teiid-jboss-integration-8.12.5.redhat-8.jar:8.12.5.redhat-8]
       at org.teiid.jboss.VDBService$7.run(VDBService.java:446) [teiid-jboss-integration-8.12.5.redhat-8.jar:8.12.5.redhat-8]
       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_131]
       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_131]
       at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_131]
       at org.jboss.threads.JBossThread.run(JBossThread.java:122)
      Caused by: org.teiid.translator.TranslatorException: TEIID60000 javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/cassandraDS
       at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:183) [teiid-api-8.12.5.redhat-8.jar:8.12.5.redhat-8]
       at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:202) [teiid-api-8.12.5.redhat-8.jar:8.12.5.redhat-8]
       at org.teiid.query.metadata.NativeMetadataRepository.getMetadata(NativeMetadataRepository.java:72) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
       ... 8 more
      Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/cassandraDS
       at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:410) [ironjacamar-core-impl-1.0.37.Final-redhat-1.jar:1.0.37.Final-redhat-1]
       at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:367) [ironjacamar-core-impl-1.0.37.Final-redhat-1.jar:1.0.37.Final-redhat-1]
       at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:499) [ironjacamar-core-impl-1.0.37.Final-redhat-1.jar:1.0.37.Final-redhat-1]
       at org.teiid.resource.spi.WrappedConnectionFactory.getConnection(WrappedConnectionFactory.java:58) [teiid-api-8.12.5.redhat-8.jar:8.12.5.redhat-8]
       at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:181) [teiid-api-8.12.5.redhat-8.jar:8.12.5.redhat-8]
       ... 10 more
      Caused by: javax.resource.ResourceException: IJ000658: Unexpected throwable while trying to create a connection: null
       at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:454) [ironjacamar-core-impl-1.0.37.Final-redhat-1.jar:1.0.37.Final-redhat-1]
       at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:457) [ironjacamar-core-impl-1.0.37.Final-redhat-1.jar:1.0.37.Final-redhat-1]
       at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:429) [ironjacamar-core-impl-1.0.37.Final-redhat-1.jar:1.0.37.Final-redhat-1]
       at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:344) [ironjacamar-core-impl-1.0.37.Final-redhat-1.jar:1.0.37.Final-redhat-1]
       ... 14 more
      Caused by: com.datastax.driver.core.exceptions.NoHostAvailableException: All host(s) tried for query failed (tried: /[ip]:9042 (com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured table schema_keyspaces))
       at com.datastax.driver.core.ControlConnection.reconnectInternal(ControlConnection.java:220)
       at com.datastax.driver.core.ControlConnection.connect(ControlConnection.java:78)
       at com.datastax.driver.core.Cluster$Manager.init(Cluster.java:1231)
       at com.datastax.driver.core.Cluster.getMetadata(Cluster.java:334)
       at org.teiid.resource.adapter.cassandra.CassandraConnectionImpl.(CassandraConnectionImpl.java:67)
       at org.teiid.resource.adapter.cassandra.CassandraManagedConnectionFactory$1.getConnection(CassandraManagedConnectionFactory.java:48)
       at org.teiid.resource.adapter.cassandra.CassandraManagedConnectionFactory$1.getConnection(CassandraManagedConnectionFactory.java:45)
       at org.teiid.resource.spi.BasicManagedConnectionFactory.createManagedConnection(BasicManagedConnectionFactory.java:71) [teiid-api-8.12.5.redhat-8.jar:8.12.5.redhat-8]
       at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:858) [ironjacamar-core-impl-1.0.37.Final-redhat-1.jar:1.0.37.Final-redhat-1]
       at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:413) [ironjacamar-core-impl-1.0.37.Final-redhat-1.jar:1.0.37.Final-redhat-1]
      ... 17 more
        • 1. Re: Cannot import cassandra datasource using Teiid Importer
          Ramesh Reddy Master

          The root issue is

           

          All host(s) tried for query failed (tried: /13.95.30.69:9042 (com.datastax.driver.core.exceptions.InvalidQueryException: unconfigured table schema_keyspaces)) 

           

          so it looks like you did not configure your resource-adapter configuration correctly. What does it look like, and is the Keyspace property configured correctly and exists in the target Cassandra data source?

          • 2. Re: Cannot import cassandra datasource using Teiid Importer
            Ruud Fleskens Newbie

            Hello Ramesh,

             

            I use the following configuration:

             

            <resource-adapter id="cassandra">

                                <module slot="main" id="org.jboss.teiid.resource-adapter.cassandra"/>

                                <transaction-support>LocalTransaction</transaction-support>

                                <connection-definitions>

                                    <connection-definition class-name="org.teiid.resource.adapter.cassandra.CassandraManagedConnectionFactory" jndi-name="java:/cassandraDS" enabled="true" use-java-context="true" pool-name="cassandraDS">

                                        <config-property name="Address">

                                            13.95.30.69

                                        </config-property>

                                        <config-property name="Keyspace">

                                            enexis_sensor

                                        </config-property>

                                        <config-property name="Port">

                                            9042

                                        </config-property>

                                    </connection-definition>

                                </connection-definitions>

                            </resource-adapter>

             

            Cassandra version is 3.9

            and there is connectivity on port 9042:

             

            [fb-jboss@enx-vm-p088401 configuration]$ telnet 13.95.30.69 9042

            Trying 13.95.30.69...

            Connected to 13.95.30.69.

            Escape character is '^]'.

            • 3. Re: Cannot import cassandra datasource using Teiid Importer
              Steven Hawkins Master

              > We also tried using the driver from the latest teiid release, which has the following config:

               

              The teiid jars can be release specific, so you generally cannot cross major versions.

               

              It could be that the older cassandra library is not compatible with 3.9.  You can test with Teiid 9.2+ to confirm as [TEIID-4476] Upgrade Cassandra Client library - JBoss Issue Tracker is included in those versions.

               

              If you need support in JDV you can open a support ticket or look at creating a custom translator through applying the TEIID-4476 patch.