RiakTS Query Question

Joe Olson jo4243 at outlook.com
Wed Mar 29 15:08:39 EDT 2017

Suppose I have the following table in RiakTS:


id                VARCHAR NOT NULL,


field2         SINT64,

data           BLOB NOT NULL,

primary key (id, QUANTUM(eventtime, 365, 'd')),id)


Assume the BLOB field is close to the max size for a RiakTS BLOB value (~1MB)

Suppose I want to execute the following query:

Select id, eventtime, field2 from T1 where ((id = ID1) and (eventtime >= T1 and eventtime < T2))

I only want the SINT64 field, not the 1MB BLOB.

Am I paying for the bandwidth for the RiakTS cluster to pass around (internally) the 1MB BLOB field just to get the SINT64 field?

If so, is there a way to avoid this, besides creating a second table without the BLOB field?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.basho.com/pipermail/riak-users_lists.basho.com/attachments/20170329/82fa172e/attachment-0002.html>

More information about the riak-users mailing list