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
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.
DESChave been added to the CREATE TABLE statement. Adding the ASC/DESC keywords to your local key during
CREATE TABLEmeans 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
DESCin the local key here.
- 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
LIMITallows 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.
- You can now use
DELETEfrom riak shell to remove a record from your TS table. Learn all about
- You can now use
INSERT NULLto 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.
- You can now run
SHOW CREATE TABLEto review SQL definition and replication properties of existing Riak TS tables. You can read more about the SHOW CREATE TABLE statement here.
- 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.
- 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.
- 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]
- 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]
- Object size limitations, as set in riak.conf, have been decreased.
object.size.warning_thresholdhas been decreased from a default of 5MB to 50kB.
object.size.maximumhas been decreased from 50MB to 500kB. [PR 1505 & PR 1218]
- If a bucket type property contains a
ddlproperty 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_spanis capped at 1000. [PR 1505]
- The default value for
[ ]. [PR 1546]
- [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 Riak.
- [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/1due 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.
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
- AAE must remain turned off.
- You cannot use Bitcask with Riak TS tables.
riak_kv.query.timeseries.max_quanta_spanis capped at 1000 due to a bug.
You can see a table of KV and TS features here.