CODEWITHSUNDEEP
riak-ts
Shahzad Hussain
Shahzad Hussain

Reputation: 57

@ 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.

Upvotes: 0

Views: 50

Answers (2)

Shahzad Hussain
Shahzad Hussain

Reputation: 57

specially @Saranjith

Query will be now as given below

select start,end,steps from steps_record where start >= 1472495400000 and start <= 1490121000000  and userName = '<<"[email protected]">>';

anyways Thanks @Saranjith, i tried with your given syntax in 2-3 ways after that i got this solved.

Upvotes: 0

Saranjith
Saranjith

Reputation: 11577

Use below query.

SELECT SUM(steps),
       registrationDate
FROM steps
WHERE
  START >= 1482085800000
  AND
  START <= 1489775400000
  AND userName = <<"[email protected]">>;

Upvotes: 0

Related Questions