Easily find issues by searching: #<Issue ID>
Example: #1832
For Cassandra, if i create the below table and try to import the table with the contents of attached csv file, for the column c4 i find entries like java.nio.HeapByteBuffer[pos=183 lim=21675 cap=173760]
"C1" int,
"C2" text,
"C3" text,
"C4" blob,
"C5" text,
"C6" text,
PRIMARY KEY("C1")
)
GO
<< From Fung >>
While developing Cassandra support, 'blob' is the only data type that I don't know how to insert a row to the table from the CLI. You might want to create an issue to track this problem. For the time bing, the only thing I know it will be accepted by Cassandra server is to create a null value using '' in the INSERT/UPDATE statements.
|
336 KB
|
|
227 KB
| Field | Old Value | New Value |
|---|---|---|
| Fixed Build | 14.0.0-beta-33 | |
| Resolution | Fixed | |
| Resolved Date | Jun 20, 2013 11:26 PM | |
| Status | New | Resolved |
Fixed: SVN r32974/14.0.0-beta-33
(1) Cassandra JDBC does not support java.sql.Blob interface, Cassandra's ResultSet.getBlob(...) will throw 'not supported' exception.
(2) Cassandra JDBC return a BLOB as an instance of java.nio.ByteBuffer (an abstract class). HeapByteBuffer is Cassandra's implementation to support java.nio.ByteBuffer.
(3) "java.nio.HeapByteBuffer[pos=183 lim=21675 cap=173760]" is the String representation of a java.nio.ByteBuffer object.
(4) Made changes in Cassandra JDBC so that a HeapByteBuffer is converted to a byte[] which is then returned to ADS.
(5) Similar to other supported databases, e.g. DB2, MySQL, etc., the 'BLOB' column in Edit Table Data tool is not editable.
| Field | Old Value | New Value |
|---|---|---|
| Status | Resolved | Closed |
Works the same as other RDBMS. Fixed in 14.0.0-beta-33
Works the same as other RDBMS. Fixed in 14.0.0-beta-33
Issue #9236 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build 14.0.0-beta-33 |
| No time estimate |
1 issue link |
relates to #10369
Issue #10369Cassandra - INSERT statement for blob data type |
Fixed: SVN r32974/14.0.0-beta-33
(1) Cassandra JDBC does not support java.sql.Blob interface, Cassandra's ResultSet.getBlob(...) will throw 'not supported' exception.
(2) Cassandra JDBC return a BLOB as an instance of java.nio.ByteBuffer (an abstract class). HeapByteBuffer is Cassandra's implementation to support java.nio.ByteBuffer.
(3) "java.nio.HeapByteBuffer[pos=183 lim=21675 cap=173760]" is the String representation of a java.nio.ByteBuffer object.
(4) Made changes in Cassandra JDBC so that a HeapByteBuffer is converted to a byte[] which is then returned to ADS.
(5) Similar to other supported databases, e.g. DB2, MySQL, etc., the 'BLOB' column in Edit Table Data tool is not editable.