Im trying to use the plugin and make your example to use but it doesnt work the response its like this.
and my query is:
SELECT time, latitude as lat, longitude as lon
FROM doc.datasource
WHERE $__timeFilter(time)
ORDER BY time
where the datasource has the next structure
zip | city | states | latitude | longitude | time | daylight
71937 | Cove | AR | 34.398483 | -94.39398 | 1571306316 | 1
im using cratedb and my model is
create table datasource (
zip text,
city text,
states text,
latitude double precision,
longitude double precision,
time timestamp without time zone,
daylight text
);
Hi!
Im trying to use the plugin and make your example to use but it doesnt work the response its like this.
and my query is:
SELECT time, latitude as lat, longitude as lon FROM doc.datasource WHERE $__timeFilter(time) ORDER BY time
where the datasource has the next structure
zip | city | states | latitude | longitude | time | daylight 71937 | Cove | AR | 34.398483 | -94.39398 | 1571306316 | 1
im using cratedb and my model is
create table datasource ( zip text, city text, states text, latitude double precision, longitude double precision, time timestamp without time zone, daylight text );