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
