(Replying to PARENT post)

I'm in the process of moving from InfluxDB to TimescaleDB myself and can't wait to get rid of the hoops I have to jump through to get InfluxDB to answer some basic questions, mostly stemming from the fact that InfluxQL doesn't support boolean expressions. Something like 'SELECT MAX(temperature) > 10 FROM...' doesn't work.

👤RedShift1🕑5y🔼0🗨️0

(Replying to PARENT post)

Welcome to the TimescaleDB community! In case it is helpful, we wrote a tool to easily migrate from InfluxDB to TimescaleDB:

https://docs.timescale.com/latest/tutorials/outflux

👤akulkarni🕑5y🔼0🗨️0

(Replying to PARENT post)

Agreed -- every time I tried to query data from the command line I could not get anything to work. I would usually find a piece of working python code and adapt that to run the query instead.

100% opposite of what a CLI interface should be.

👤mayhemchaos🕑5y🔼0🗨️0

(Replying to PARENT post)

Speaking from my own experience, you may save yourself some future effort by moving directly to clickhouse.

Timescale brings its own issues. If your goal is performance, you will be better served by clickhouse.

👤1996🕑5y🔼0🗨️0

(Replying to PARENT post)

(InfluxData solution architect here) Boolean is supported. You query it in the WHERE clause. Try `SELECT MAX(temperature) FROM ... WHERE temperature > 10`. That said, I'm not sure why you'd run a query like that in InfluxQL as it's the same as `SELECT max(temperature)`. :).

👤samhld🕑5y🔼0🗨️0

(Replying to PARENT post)

it's not that hard: `select max from (select max(temperature) from measurement_name group by time(1h)) where max > 10`

👤jstrong🕑5y🔼0🗨️0