Querying a spatiotemporal Big Data Store service from ArcGIS REST API

kavi88 — Wed, 19 Apr 2023 08:19:49 GMT

Hello everyone,

I would like to use the ArcGIS REST API interface to query a spatiotempral Big Data Store service that has been created from ArcGIS GeoEvent. I am trying to perfomr a query that will list duplicates.

I am doing something like this :

SELECT nom, COUNT(*) FROM mon_service WHERE nom IS NOT NULL GROUP BY nom HAVING COUNT(*) > 1

However, the query throws the error below :

Query option 'having' is allowed only if layer.table's 'supportHavingClause' is equal to true.

I did some researche, and I am afraid that this parameter is only availaibal for relational data ; is that correct?

How can i perfom such query ? do you have any alternative ideas on how can i list duplicates?

Thank you

EricIronside , RJSunderman

topic Querying a spatiotemporal Big Data Store service from ArcGIS REST API in ArcGIS GeoEvent Server Questions

Querying a spatiotemporal Big Data Store service from ArcGIS REST API