× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
funfun reported 2013-10-09T04:09:45Z  · SachinPrakash last modified 2013-10-21T19:49:49Z

Cassandra - INSERT statement for blob data type


Dev
Fun Fun
funfun
QA
Tariq Rahiman
tariqrahiman
Priority Major
Complexity Unknown
Component DB - Cassandra
Version 14.0

Cassandra 1.2.3+ servers accepts the following form to insert a blob data:
   INSERT INTO tableName (keyColumn, blobColumn) VALUES(1, 0x01);
which does not work on 1.2.1 server.

In the current ADS implementation, the INSERT statement generated for import/export/schema script generator on a blob column is similar to the one shown below:
   INSERT INTO tableName("keyColumn", "blobColumn") VALUES(1, 01)
which won't work on 1.2.3+ servers.

And, the current implementation cannot handle blob values contained in a collection, the generated INSERT statement is similar to this:
   INSERT INTO collectionTable ("keyColumn", "listColumn") VALUES(1, [java.nio.HeapByteBuffer[pos=0 lim=1 cap=1]])

3 attachments

Issue #10369

Closed
Fixed
Resolved 2013-10-10T01:24:40Z
 
 
Completion
No due date
Fixed Build 14.0.2/15.0.0-dev-23
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017