Version: 17.0.6-2
Build #: 50254
Build Date: 2016-Jun-27 12:43:27 PM
Operating Environment: Mac OS X (10.8.5, x86_64) / UTF-8 / en / US / Oracle Corporation 1.8.0_40-b27
Memory: Max=704,643,072; Total=668,991,488; Free=528,706,728; CPUs=8
Cassandra 3.x -> Grid results on tuple values
1. Navigate to Cassandra Keyspaces test in AWS where the tables are already created and execute the SELECT queries given here
or
2. You can create the tables, insert and select SQL which is given below
3. Executing the select you can see that Cassandra returns, where as ADS returns a Null Pointer Exception under the Console Tab in View log and values are as shown in below tables
Cassandra
k | v
---+-----------------
0 | (3, 'bar', 2.1)
Aqua Data Studio v17 returns below values
k v
---- -----------------------
0 bar@ff
k t
---- -----------------------------------------------
0 java.nio.HeapByteBuffer[pos=98 lim=129 cap=489]
SQL for the tables
// Table 1
CREATE TABLE collect_things (
k int PRIMARY KEY,
v tuple<int, text, float>
)
go
INSERT INTO collect_things (k, v) VALUES(0, (3, 'bar', 2.1))
go
// Table 2
CREATE TABLE nested (k int PRIMARY KEY, t tuple <int, tuple<text, double>>)
go
INSERT INTO nested (k, t) VALUES (0, (3, ('foo', 3.4)))
go
// select
SELECT * FROM collect_things
go
SELECT * FROM nested
go
Go to View Log and Console Tab and you get below exception
java.lang.NullPointerException
at org.apache.cassandra.cql.jdbc.CassandraResultSet$CResultSetMetaData.getColumnType(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.K⡗ꇁꀀᛞ5.a(Unknown Source)
at \\.\\.\\हिñçêČάй語简�?한\\.K⡗ꇁꀀᛞ5.a(Unknown Source)
at com.aquafold.datastudio.queryanalyzer.Qꅧꁂꑗꇨcase.run(Unknown Source)
tuples was introduced in cassandra 2.1... We currently do not support this datatype and should not add to on the fly to 17. Will move issue to 19 and to Sachin to determine when support for this should happen.
Tuples documentation: https://docs.datastax.com/en/latest-java-driver/java-driver/reference/tupleTypes.html