Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
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
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.
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.