how to list from query executer all tables name

Solved888 views
2
0 Comments

hi , we are trying to extract information from query executer , we want to know all tables names

Roger Bijos [SLC] [DevOps Advocate] Answered question 26th March 2021

3 Answers

0
30 2 Comments

Hello Miguel,

Just a last question, if we use SELECT * FROM timetrace we get a lot of information from different time, We can extract/generate only the information from one specific day?

Regards

Javier Gordon Posted new comment 24th March 2021
Tom Waterbley [SLC] [DevOps Enabler] commented

retrieving only the information between two specific dates can be done using the following query: SELECT * FROM timetrace WHERE t > ‘2021-03-22’ AND t < '2021-03-24' LIMIT 1000 ALLOW FILTERING
Javier Gordon commented

Hello Tom,

We tried the command but it generates an error:
CassandraConnection ExecuteQuery – exception executing query:
SELECT * FROM timetrace WHERE t> ‘2021-03-22’ AND t <'2021-03-24' LIMIT 1000 ALLOWS FILTERING – line 1:34 alternative not viable in character '"

We tried changing the quotes, however generating the error.
You are viewing 1 out of 3 answers, click here to view all answers.