Questions tagged [riak-ts]

Riak TS is a distributed NoSQL key/value store optimized for time series data. For more information on Riak TS see: docs.basho.com/riak/ts/

17 questions
1
vote
1 answer

Riak TS should not be a no NoSQL database?

Why is Riak TS considered as a NoSQL database when it needs a predefined schema for tables? This schema even cannot be changed! Source: documentation I think that some people may think that when Riak TS is built on Riak KV, then it is a NoSQL…
MacakM
  • 1,804
  • 3
  • 23
  • 46
1
vote
1 answer

riak spark connector doesn't work

My Riak-Spark connector doesn't work. I can launch Spark with: /opt/spark/bin/spark-shell \ --jars com.fasterxml.jackson.module_jackson-module-scala_2.11-2.4.4.jar \ --conf spark.riak.connection.host=127.0.0.1:8087 \ --packages…
user2405703
  • 87
  • 1
  • 6
1
vote
1 answer

Count by minute in Riak TS

I'm trying to grasp the recently added group by in Riak TS. I'm unable to find a way to group my results by minute, e.g. count. I'll show an example below. CREATE TABLE Results ( result VARCHAR NOT NULL, time TIMESTAMP NOT…
Ricardo Mayerhofer
  • 2,121
  • 20
  • 22
1
vote
1 answer

DELETE a table in Riak TS

I am attempting to drop an entire table in RIAK TS, but nothing seems to work. I have tried both "drop table" in a standard query so (using Python): from riak import RiakClient client = RiakClient(host = '127.0.0.1') client.ts_query('ticks', 'DROP…
Thomas Browne
  • 23,824
  • 32
  • 78
  • 121
0
votes
1 answer

Riak unrecoverable disk failure

I have a 3 node Riak cluster with each having approx. 1 TB disk usage. All of a sudden, one node's hard disk failed unrecoverably. So, I added a new node using the following steps: 1) riak-admin cluster join 2) down the failed node 3) riak-admin…
Leo
  • 1
0
votes
3 answers

Riak Docs not working

Can anyone tell why Riak website is not working this time from a few days. http://docs.basho.com/riak/ts/1.5.2/using/core-fundamentals/ this link of riak is not working.
0
votes
1 answer

Riak container does not start when its data volume is mounted

The following command works perfectly and the riak service starts as expected: docker run --name=riak -d -p 8087:8087 -p 8098:8098 -v $(pwd)/schemas:/etc/riak/schema basho/riak-ts The local schemas directory is mounted successfully and the sql…
B Faley
  • 17,120
  • 43
  • 133
  • 223
0
votes
1 answer

ERROR com.basho.riak.client.core.RiakNode - Write failed on RiakNode

I am using Riak KV with Java client and I am unable to write on the RiakNode, although I have created a Bucket with the name of the space I want to create an object on. I basically have the TasteOfRiak.java class, which has been provided by the…
0711geek
  • 1
  • 1
0
votes
2 answers

@ is not supporting to RIak Ts

while making query to Riak TS, my email contaning @ symbol so it giving some problem like SQL Lexer error <<"Unexpected token '@'.">> then How we Resolve this problem.
0
votes
0 answers

riak-shell giving error as Not connected to riak

my riak-shell was running when my riak.conf containing as listener.protobuf.internal = 127.0.0.1:8087 when i change localhost to My IP then riak-shell is not working after changing to IP as listener.protobuf.internal = 172.16.27.252:8087 then it's…
0
votes
1 answer

Inserting now as timestamp in Riak

Usually I don't trust clients time when inserting time series data. Is it possible to tell Riak to insert a record using server side current time? Something like now() function in…
Ricardo Mayerhofer
  • 2,121
  • 20
  • 22
0
votes
1 answer

how we define auto increment id in riak ts

How we create table in Riak TS for auto_increment id such as in mysql we create:::as example--- create table Department(id int auto_increment not null,departmentName varchar(9)); is there any way to create table with AUTO_INCREMENT CAN ANYONE TELL…
0
votes
1 answer

Alter table in Riak TS and new column

I have Table having lots of data in Riak time series, but now I want to make this table alter to add some columns, How can I do that? I tried: alter table Person add column designation varchar(23); I am getting the following error: Extension…
0
votes
1 answer

getting latest inserted object from riak timeseries

Procedure to get latest record from Riak TS based on timestamp. I created following table: CREATE TABLE devicedetail (memberId SINT64 NOT NULL, type VARCHAR NOT NULL,model VARCHAR NOT NULL,imei VARCHAR NOT NULL,deviceId VARCHAR NOT NULL,manufacturer…
0
votes
1 answer

How to change the config file for Riak TS when using Docker

I want to run a local cluster using the docker-compose files from Basho on docker hub. However I need to change the quanta span configuration variable (usually in /etc/riak/riak.conf) called riak_kv.query.timeseries.max_quanta_span. This is usally…
Thomas Browne
  • 23,824
  • 32
  • 78
  • 121
1
2