Subject: 1022 error in RiakTS

Andy Till atill at basho.com
Mon Jan 30 11:29:26 EST 2017


Hi

> Hi All, I have a 3 node cluster hosting a Riak TS database. During a query
> I run into a 1022 error. The characteristics of my data and other setup is
> below. I am trying to understand
>
> 1) the error and remedy
> 2) what are good conf setting for my case.
>
> Data:
> 1 minute interval with 30 columns per minute. Indexed on time (quantum of
> 1d) and two other columns.
>
> Query:
>       avg(<some column>) where time > t1 and time < t2 and key1=<some val>
> and key2 =<someval>
>
> Strangely enough, the query works when t2-t1 <= 5 days; however, for any
> duration longer than that I get a 1022 error (projected result of query is
> too big). I am using RiakTS v1.5 and it seems in this version this setting
> is controlled by riak_kv.query.timeseries.max_quanta_span (set to 5K/(1K
> actual?) ); so, is the result purely a coincidence?
>
> It is hard to determine whether this is a coincidence without having the
actual dataset. The bug is fixed in
Riak TS 1.5.1, download here: http://docs.basho.com/riak/ts/1.5.1/downloads/

> w.r.t 1022 error: Docs say that max_returned_data_size is the parameter I
> can tune to fix this issue.
> However, it seems this parameter controls the size of the result; so, Is
> there any reason I get this error code on a avg calculation?
>
> I have not changed the max_returned_data_size setting to see if it will fix
> the issue; just trying to understand whether this is the size of the data
> scanned or size of the data returned
>
> Aggregate functions like AVG use the max_returned_data_size setting like a
non-aggregate query, though
the result is one row. Setting it high enough to hold the query results
should allow the query to complete.

> Finally, I have 1m interval data for a year and in a production setting I
> would like to go to 10s data for 3 years; Are there any recommended value
> for quanta I should be using?
>
> I would really appreciate any insight/input into the issue and any
> recommendation on how to configure the table.
>
> There is some advice in the docs on quantum size here.

http://docs.basho.com/riak/ts/1.5.0/learn-about/bestpractices/#quantum


> Best,
> C.S.N
>
> Cheers
Andy
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.basho.com/pipermail/riak-users_lists.basho.com/attachments/20170130/496525eb/attachment-0002.html>


More information about the riak-users mailing list