Re: Binary fields and compression

James That makes sense Thanks for your answer, 2018-05-13 18:17 GMT+02:00 James Taylor : > You can have a property only apply to a single column family by prefixing > it with the family name: > > CREATE TABLE DOCUMENTS (HOST VARCHAR NOT NULL PRIMARY KEY, A.CONTENT >

Re: Binary fields and compression

You can have a property only apply to a single column family by prefixing it with the family name: CREATE TABLE DOCUMENTS (HOST VARCHAR NOT NULL PRIMARY KEY, A.CONTENT VARBINARY, B.TEXT VARCHAR, B.LABEL VARCHAR, B.DATE_CREATE TIMESTAMP) B.COMPRESSION='GZ' On Sun, May 13, 2018 at 3:50 AM Nicolas

Binary fields and compression

Hi, My use case is storing pdf files from one side, and it's content as text from the other. Two kind of queries would either get the text, or the pdf from the primary key. Rarely both. Then I guess the option is to create two columns family, one containing a VARBINARY column to store the binary