Export of blob data as insert does not work correctly. Re-insertion produces "Invalid STRING constant".

Answered

When I export data as "insert" from credential_store column family using datagrip, the blob column seems to be invalid. (See below)

Attempting to re-insert the row, produces an exception: "Invalid STRING constant".

The secret column is defined as blob.

secret      blob,

INSERT INTO test_services.credential_store (user_id, provider_id, secret) VALUES ('BL', 'HI', '5316B8169459AEA716094C3424EE0458B39BC0E577806739FBB9A158ABFA82861B619A8F69F2DF059F22EE28FE3C057EC1AB1F8C058DA7A01C217C6CE5B383A5BFF3F1C28E068670E65675D9EAA5FF5B665F44C9A8F28EB62B741D1AA86E9B6085C2647D95923F6498F4BD1574265144DC31DE76C18CE77FF1A277927F5449A1F85BF69E9DF19BF859C7112C61KB0B6CAC9952EB77B7DF9B4844736AD90E676B33F8ACAB7C8911F1D647ABF99C10F26526B7L74DD337DB1A061760EFB82427E460AC630534D0539262FC6BA7C41B36D310BFA246F563DCAF68DCE618ADC26B5B6EF83CB26CEFFE472F86BDD07E05AA4D766F2C655446D73E1CAFB83046799DEF7DBDF5B7051B9ABD6FE47B3837EB2FFB17219502AC562A5EFC306ACA923BE1A66798D821978CDE1A470D91F3264880B60632F44D0EC2F070B23A806242A6DD272775B0BA01673F1373C6FE203CCFFEA5D1178C983C832181C9369A3060B13B3A14E5546C31CD9320EA3CCCEFDE935C3A866D0797E96D20ECBF5F740D5027DA41392D8B4EACD435DC5B2AC7C3D35EF5D2686A8C743937133E5A34C1F89E6B8C51E4463FC90AAEAD24220F7B72CE49D275EF41869A5FA9E19AA5DCAD8BBE72C70F73E51FE1DC6FDAA2A1835FDF015D2022ACF3ABD7C4184A90742EB30A852FE369464AC7E64ACAC4A9E16AF6CE8B3E0945C266EA92B366105402DB7EA9571373907FF734446AFD5CE35186BFB68BACEC1F3580B086860BB21EC29EDEEEF2EB7A1B411602A2557B1B4E14D1B9E21A09395A553E2B47F0EBE2B7956');

5 comments

@ Bknyvlad 

Could you specify database verndor and version you use?

 

0

Sorry I did not specify. I am using DataGrip to connect to Cassandra v3.4.4.

 

0

@Bknyvlad

I created an issue based on your description https://youtrack.jetbrains.com/issue/DBE-8323

As a temporary workaround you can use multicursor feature and replace 'your blob data' with textAsBlob('your blob data')

0

Vasily,

 

Also, noticed a similar issue with any rows that have a cassandra column of type 'SET'

https://docs.datastax.com/en/cql/3.3/cql/cql_using/useSet.html

DataGrip does not export the row as CQL INSERT correctly.

1

@Bknyvlad
Thank you for your feedback

0

Please sign in to leave a comment.