Able to ingest data but not able to query it back

InfluxDB 2
1

image
image1080×342 11.3 KB

I am having hard time understanding the problem
I am able to ingest the data properly but unable to query it back initially i assumed maybe the version issue but for a different measurement withing the same bucket it is working

Any help is appreciated! Thanks [Will attach another image in the msg]

2

image
image1280×902 75.5 KB

3

Hello @shanmukh-d,
What client library are you using?
And what version of InfluxDB are you using? If you go to the homepage you can see the version on the bottom right.

If you’re using InfluxDB Severless or Dedicated and the InfluxDB v3 Python Client

First thing to note: If you’re using Severless then you can query with Flux, but its not recommended.

If you’re using Dedicated you can’t query with Flux only SQL.

Based on the fact that you’re returning a Fluxtable, that tells me that you’re using Severless.

That being said I recommend first and foremost using SQL jus like you did in the screenshot you shared.

Second I recommend using the Pandas mode and printing Pandas DataFrames.

from influxdb_client_3 import InfluxDBClient3

client = InfluxDBClient3(host=f"cluster-id.a.influxdb.io",
                         database=f"DATABASE_NAME",
                         token=f"DATABASE_TOKEN")
query = "SELECT * from "msgs" WHERE time >= now() - INTERVAL '1 hour'"
pd = client.query(query=query, mode="pandas")
print(pd.head())

Hope that helps!