Record
목차
개념
설지
프로젝트
Using influx
cli
influx
> use driver_locations
> show MEASUREMENT
> SHOW RETENTION POLICIES
> precision rfc3339 ; 날짜 출력
influx -execute 'SELECT \* FROM location LIMIT 3' -database=driver_locations -precision=rfc3339
select time, lat, lng from location where user_driver_id = '{$userDriverId}' and time <= {$arrivedAt} and time >= {$departedAt} order by time limit 2000;
use driver_car_conditions
select (time::integer) as time, temperature1, temperature2 from condition where user_driver_id = ‘179449’ and time <= 1684217689000000000 and time >= 1684197128000000000 order by time;
select (time::integer) as time, temperature1, temperature2 from condition where user_driver_id = ‘138881’ and time >= ‘2021-08-25 00:00:00’ and time < ‘2022-08-26 00:00:00’ order by time;
