Riak TS Release Notes

Released December 20, 2016.

Riak TS 1.5.0 expands its SQL implementation. It includes additional SELECT query clauses: ORDER BY and LIMIT. It also includes DELETE for a single record. TS 1.5 also includes ASC and DESC keywords in table schema definition, and better usage of the NULL keyword in WHERE clause conditions and INSERT statements.

TS 1.5.0 adds SHOW CREATE TABLE to review the SQL statement used to create the table. This statement is useful for re-creating your table from a testing to a deployment cluster, or to another data-center.

Data storage of unstructured (binary) or opaque (JSON) data has also gotten a little easier in TS 1.5 with the introduction of a BLOB data type.

Updates in TS 1.5 include multi-line paste functionality, built-in help for SQL commands, and enhanced error handling in riak shell.

Riak TS has significantly improved performance, thanks to streamlining of the on-disk encoding format and increased parallelization of record decoding. These updates have focused on improvement of SQL query latency, and result in typical speedups of 2-4x for large queries, particularly for data sets that are distributed around the cluster.

New Features

• ASC and DESC have been added to the CREATE TABLE statement. Adding the ASC/DESC keywords to your local key during CREATE TABLE means you can have your data pre-sorted in ascending or descending order as it’s input into your TS table. You can read more about ASC/DESC in the local key here.
  • [PR 1427]
  • [PR 1500]
  • [PR 1558]
  • [PR 1560]
  • [riak_ql PR 117]
  • [riak_ql PR 162]
  • [riak_test PR 1200]
  • [riak_test PR 1081]
  • [riak_test PR 1201]
• The ORDER BY statement has been added to SELECT, allowing you to sort the results of your query in various ways, including: ascending or descending order, or nulls first or last. You can learn about ORDER BY here.
  • [PR 1479]
  • [riak erlang client PR 321]
  • [riak_pb PR 208]
  • [riak_test PR 1152]
• LIMIT allows you to specify that you only want a specific number of records from your query, and it can be expanded by OFFSET. You can read about how to use the LIMIT statement here.
  • [PR 1479]
  • [riak erlang client PR 321]
  • [riak_pb PR 208]
  • [riak_test PR 1152]
• You can now use DELETE from riak shell to remove a record from your TS table. Learn all about DELETE here.
  • [PR 1552]
  • [riak_ql PR 145]
  • [riak_shell PR 23]
  • [riak_test 1216]
• You can now use INSERT NULL to add null values. You can do so explicitly, by specifying NULL in the VALUES column, or implicitly, by omitting the column. This change also allows for column re-ordering within the INSERT statement. You can select records based on whether or not they contain NULL values in specific fields using WHERE »field« IS [NOT] NULL.
  • [PR 1507]
  • [PR 1496]
  • [riak_ql PR 142]
  • [riak_ql PR 144]
  • [riak_shell PR 56]
  • [riak_test PR 1169]
• You can now run SHOW CREATE TABLE to review SQL definition and replication properties of existing Riak TS tables. You can read more about the SHOW CREATE TABLE statement here.
  • [PR 1536
  • [riak_ql 155]
  • [riak_ql 159]
  • [riak_shell PR 62]
  • [riak_test PR 1193]
  • [riak_test PR 1211]
• A BLOB data type is now available. BLOB allows the storage of unstructured data, binary or opaque (JSON), in a Riak TS column. Learn about BLOB data type here.
  • [PR 1540]
  • [riak_pb PR 211]
  • [riak_ql PR 156]
  • [riak_ql PR 143]
  • [riak_shell PR 61]
  • [riak_test PR 1212]
• Multi-line paste and in-line SQL help is now available in riak shell. SQL comments are supported in the following types: /* blah multiline */ and -- single line. Riak shell has also been updated to better handle errors. And it now pretty print floats, as well.
  • [riak_shell PR 60]
  • [riak_shell PR 58]
  • [riak_shell PR 57]
  • [riak_ql 154]
  • TTB has replaced msgpack as the on-disk encoding format. This replacement has demonstrated an improvement in latency reduction and efficiency.
  • [PR 1510]
  • [eleveldb PR 223]
• Query results are now decoded in a way that leverages parallelization across your TS cluster. This update speeds up large queries particularly for data residing on multiple nodes.
  • [PR 1538]

Additions

• The timestamp type is now able to be used as an argument in aggregate functions. [riak_ql PR 146 & riak_ql PR 147]
• You can now see the Status field of your TS table when you use SHOW TABLES. [PR 1514 and PR 1176]
• Introduced the following new parameters in riak.conf. See the TS configuration docs for details. [PR 1505]
  • riak_kv.query.timeseries.max_returned_data_size
  • riak_kv.query.timeseries.max_running_fsms
  • riak_kv.query.timeseries.qbuf_root_path
  • riak_kv.query.timeseries.maximum_query_queue_length

Changes

• Object size limitations, as set in riak.conf, have been decreased. object.size.warning_threshold has been decreased from a default of 5MB to 50kB. object.size.maximum has been decreased from 50MB to 500kB. [PR 1505 & PR 1218]
• If a bucket type property contains a ddl property we infer that it’s a time series table. New defaults have been also been added in the event they are not specified. [riak_core PR 870]
• The maximum number of index FSMs used to serve TS queries is now configurable. [PR 1550]
• Write-once conflict resolution has been changed to be more predictable. It is now based on timestamp rather than SHA-1 hash on value part. [PR 1512]
• LevelDB has been updated to version 2.0.33 [eleveldb PR 231]
• LZ4 is now the default compression for LevelDB. [leveldb PR 164 & eleveldb PR 208]
• Updated the default value for riak_kv.query.timeseries.max_quanta_span. See the TS configuration docs for details. Note: due to a bug in the code, the max_quanta_span is capped at 1000. [PR 1505]
• The default value for OFFSET is [ ]. [PR 1546]

Bugfixes

• [Issue 1418/PR 1544 & PR 1204] A bad error atom type was causing the protobuf and TTB services to crash. Error reporting for overload and other types of error conditions have been added.
• [riak_shell Issue 33/riak_shell PR 59] When unknown crashes occurred server-side, riak shell would get the report and crash itsef. Now, riak shell does not crash upon receiving unknown server-side crashes, and instead prompts you to report the bug to Basho.
• [riak_shell PR 68, riak_shell PR 70, & PR 1239] Unicode in SQL could crash riak shell.
• [riak_ql PR 148] It was possible to create a Riak TS table without a local key. Doing so would result in the local key becoming an exact copy of the partition key, meaning the quantum would be listed in-full rather than in a plain field name. This caused many breaks and bugs. The local key is now required, and a table creation will be unsuccessful without it.
• [PR 1479] The length of the queue was supposed to be configurable, but was being overridden by supervisor. The queue is now actually configurable.
• [PR 1478] A rare error in the EXPLAIN statement was caused by a function_clause error in riak_pb_ts_codec:encode_field_type/1 due to a typo in the code. The typo has been fixed.
• [Issue 1472/PR 1474] The error message has been improved when selecting an empty time range.
• [PR 1516] The equality operator was not working correctly with timestamp. The timestamp can now be queried using equality operators.
• [PR 1545 & riak_test PR 1208] Attempting to insert data into a non-existant table would cause crash.
• [PR 1130] It was possible to create a table without specifying a local key - the primary key would be copied over. This led to strange tables with no valid use. This now correctly returns an error.
• [PR 1286] Aggregation functions like MAX, MIN etc would cast timestamps to sint64 by default. They now correctly return values of type timestamp which appear correctly as times in riak-shell.
• [PR 157 & PR 1206] SQL insert statements of the form INSERT INTO mytable (field1, field2, field3) VALUES(val1, val2, val3) were buggy.

Compatibility

Riak TS is compatible with the following:

• RHEL/CentOS 6
• RHEL/CentOS 7
• Ubuntu 14.04 (Trusty) LTS
• Ubuntu 16.04 (Xenial) LTS*
• Debian 7 “Wheezy”(development only)
• Debian 8 “Jessie”
• OS X 10.11+ (development only)
• Amazon Linux 2016.09

Known Issues

• AAE must remain turned off.
• You cannot use Bitcask with Riak TS tables.
• riak_kv.query.timeseries.max_quanta_span is capped at 1000 due to a bug.

You can see a table of KV and TS features here.