4.0

Querying topic data

Create a Topic via SQL 


query = (
    "CREATE TABLE greetings(_key string, _value string) 
    FORMAT (string, string)"
)

result = lenses_lib.ExecSQL(query)

Insert records into a topic 

query = (
    "INSERT INTO greetings(_key, _value)
     VALUES('Hello', 'World')"
)
result = lenses_lib.ExecSQL(query)

Query a topic 

query = (
    "SELECT * FROM greetings limit 1"
)

result = lenses_lib.ExecSQL(query)