search

suhora / clickhouse_connector

It connects Clickhouse with QGIS, enabling seamless integration and visualization of spatial data. It retrieves records from ClickHouse that contain point information and displays them as layers in QGIS. This plugin allows users to easily manage and visualize large geospatial datasets stored in Clickhouse directly within the QGIS environment.
GNU General Public License v3.0
1 stars 1 forks source link

Can't display data from a specially prepared table #4

Open culebron opened 3 days ago

culebron commented 3 days ago

We created a table with Point data type and timestamp. And somehow the plugin fails to load this, complaining that it can't display data matching the criteria. What criteria? I've not set any filter.

When I tried to enter anything in the basic query field, it showed error window with no content, then QGIS froze and crashed. (QGIS v3.28.10) The "No data available" window also ends in QGIS silently vanishing.

Any advice how to debug and maybe fix this myself, is welcome. (I code in Python for > decade.)

The issue: Selection_010

The columns in DBeaver: (it's unaware of Point type) Selection_011

These columns in the table structure: Selection_012

lokeshsk commented 3 days ago

Hi @culebron , First of all, thank you for trying out our plugin. However, As mentioned in README.md By default: If timestamp field is there in clickhouse table then last 8 hours data will be displayed (without any query), to query data beyond that use query tool to write your own queries.

Could you please verify if the timestamp filed in your case its creation_date, has recent data i.e with in 8 hour window of querying (current time). If not write a custom query for it.

culebron commented 3 days ago

Hi, I had read about the selection, and it didn't occur to me this was the reason. Indeed, there were no records within last 8 hours.

When I wrote a correct SQL query, everything worked correctly.

However, there's still the problem with error window that crashes QGIS. If I can help debugging, please guide me.

lokeshsk commented 3 days ago

Hi, What's the error, is it the another issue 3 ? If yes, we can continue discussion in that thread, and I can mark this one as closed.