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]])
Fixed:
14.0 - SVN r34384/14.0.2
trunk - SVN r34385/15.0.0-dev-23
Made changes and tested blob column as well as blob values embedded in collections (list, map, set) on the followings:
Export/Import dialgs,
Schema Script Generator,
Script Object to Window As... (now stub value is NULL)
Table Data Editor
Query Analyzer (Grid View)
Fluid Shell (query result)
\sqlexport, \sqlimport, and \sqldump commands
Issue #10369 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build 14.0.2/15.0.0-dev-23 |
No time estimate |
1 issue link |
relates to #9236
Issue #9236Table Data Editor displays java.nio.HeapByteBuffer for BLOB data type |
Fixed:
14.0 - SVN r34384/14.0.2
trunk - SVN r34385/15.0.0-dev-23
Made changes and tested blob column as well as blob values embedded in collections (list, map, set) on the followings:
Export/Import dialgs,
Schema Script Generator,
Script Object to Window As... (now stub value is NULL)
Table Data Editor
Query Analyzer (Grid View)
Fluid Shell (query result)
\sqlexport, \sqlimport, and \sqldump commands