@ is not supporting to RIak Ts

Question

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.

Answer 1

Use below query.

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

Answer 2

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.