Re: RiakTS Query Question

2017-03-31 Thread Andrei Zavada
__ > From: Andrei Zavada > Sent: Wednesday, March 29, 2017 3:14:58 PM > To: Alexander Sicular > Cc: Joe Olson; riak-users@lists.basho.com > Subject: Re: RiakTS Query Question > > Joe, > > TS records in a given table all have the same structure an

Re: RiakTS Query Question

2017-03-30 Thread Joe Olson
riak-users@lists.basho.com Subject: Re: RiakTS Query Question Joe, TS records in a given table all have the same structure and are stored and retrieved as single objects (in Riak KV sense); the backend cannot introspect them and only extract some fields. Full records are read from backend and these are de

Re: RiakTS Query Question

2017-03-29 Thread Andrei Zavada
Joe, TS records in a given table all have the same structure and are stored and retrieved as single objects (in Riak KV sense); the backend cannot introspect them and only extract some fields. Full records are read from backend and these are delivered, in chunks, to the coordinator node (the node

Re: RiakTS Query Question

2017-03-29 Thread Alexander Sicular
I'm not 100% certain but I do not believe that is the case. Part of the reason for structured data is efficient retrieval. I believe the data is read but only the data selected leaves the leveldb backend, unselected data never leaves leveldb so there's no overhead when passing data from level to

RiakTS Query Question

2017-03-29 Thread Joe Olson
Suppose I have the following table in RiakTS: CREATE TABLE T1 ( idVARCHAR NOT NULL, eventtime TIMESTAMP 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