[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
|
Re: [geomesa-users] CQLException on 'id' with Geomesa Geoserver plugin
|
Jo,
Just a quick update that we released GeoMesa 1.2.2 yesterday, and it
includes the fix for GEOMESA-1028 (so that warnings get logged whenever
reserved words are used as attribute names during ingest).
Sincerely,
-- Chris
On Tue, 2016-05-17 at 15:17 -0400, Chris Eichelberger wrote:
> Jo,
>
> We now have a fix being reviewed:
> https://github.com/locationtech/geomesa/pull/891
>
> Thanks again for your note.
>
> Sincerely,
> -- Chris
>
>
> On Tue, 2016-05-17 at 10:50 -0400, Chris Eichelberger wrote:
> >
> > Jo,
> >
> > Ah! This is an issue that's bitten us before, so 1) you're in good
> > company; 2) this is exactly the right forum for your question.
> >
> > It turns out that "id" is a reserved word in GeoTools: https://git
> > hu
> > b.
> > com/geotools/geotools/blob/master/modules/library/cql/src/main/jjtr
> > ee
> > /E
> > CQLGrammar.jjt#L428
> >
> > We do have an outstanding ticket for GeoMesa to warn users when
> > ingesting using reserved words: https://geomesa.atlassian.net/brow
> > se
> > /G
> > EOMESA-1028 We hope to make some headway on this as part of
> > the upcoming 1.2.2 release of GeoMesa.
> >
> > In the interim, there are good tools that can help you rename
> > attributes in a Shapefile. For example, see this question about
> > ogr2ogr: http://gis.stackexchange.com/questions/58541/how-to-renam
> > e-
> > fi
> > eld-names-in-a-shapefile-from-the-commandline
> >
> > Thanks!
> >
> > Sincerely,
> > -- Chris
> >
> >
> >
> > On Tue, 2016-05-17 at 14:24 +0100, Jo Walsh wrote:
> > >
> > >
> > > dear all,
> > >
> > > I'm evaluating Geomesa/Accumulo as a backend for Geoserver and so
> > > far, so reasonable, however I have come across an issue after
> > > ingesting a shapefile with a column named 'id' and then trying to
> > > access that data source as a WFS layer in Geoserver - Geomesa
> > > causes
> > > Geotools raises a CQLException on the "id" field. I thought it
> > > worth
> > > raising here to see if others have come across the problem, what
> > > insight others might have into the root causes, and whether this
> > > is
> > > in fact the right forum for the issue.
> > >
> > > I found a couple of what seem to be related tickets in
> > > Geotools/Geoserver but they are both resolved:
> > > https://osgeo-org.atlassian.net/browse/GEOT-2574
> > > https://osgeo-org.atlassian.net/browse/GEOS-6634
> > >
> > > And there's an older, also fixed geomesa issue referencing the ID
> > > filter in ECQL: https://locationtech.org/mhonarc/lists/geomesa-us
> > > er
> > > s/
> > > msg00195.html
> > >
> > > Here's the contents of geoserver.log where geomesa is triggering
> > > the
> > > error:
> > >
> > > org.geoserver.wfs.WFSException: Error occurred getting features
> > > ...
> > > Caused by: java.lang.IllegalArgumentException: Unable to parse
> > > expression id=id org.geotools.filter.text.cql2.CQLException:
> > > Encountered "id" at line 1, column 1.
> > > Was expecting one of:
> > > <STRING_LITERAL> ...
> > > "true" ...
> > > "false" ...
> > > "point" ...
> > > "linestring" ...
> > > "polygon" ...
> > > "multipoint" ...
> > > "multilinestring" ...
> > > "multipolygon" ...
> > > "geometrycollection" ...
> > > "envelope" ...
> > > "(" ...
> > > "[" ...
> > > "-" ...
> > > <INTEGER_LITERAL> ...
> > > <FLOATING_LITERAL> ...
> > > <DATE> ...
> > > <DATE_TIME> ...
> > > <IDENTIFIER> ...
> > > Parsing : id.
> > > at
> > > org.geotools.process.vector.TransformProcess.toDefinition(Transfo
> > > rm
> > > Pr
> > > ocess.java:185)
> > > at
> > > org.locationtech.geomesa.accumulo.index.QueryPlanner$.setQueryTra
> > > ns
> > > fo
> > > rms(QueryPlanner.scala:324)
> > > at
> > > org.locationtech.geomesa.accumulo.index.QueryPlanner$.configureQu
> > > er
> > > y(
> > > QueryPlanner.scala:228)
> > > at
> > > org.locationtech.geomesa.accumulo.data.AccumuloFeatureCollection.
> > > ge
> > > tS
> > > chema(AccumuloFeatureSource.scala:115)
> > > at
> > > org.locationtech.geomesa.accumulo.data.AccumuloFeatureCollection.
> > > ge
> > > tS
> > > chema(AccumuloFeatureSource.scala:105)
> > >
> > > So it's happening here:
> > > https://github.com/locationtech/geomesa/blob/master/geomesa-accum
> > > ul
> > > o/
> > > geomesa-accumulo-
> > > datastore/src/main/scala/org/locationtech/geomesa/accumulo/index/
> > > Qu
> > > er
> > > yPlanner.scala#L325
> > >
> > > https://github.com/geotools/geotools/blob/master/modules/library/
> > > cq
> > > l/
> > > ECQL.md
> > > states that ID is a predicate / reserved word in ECQL.
> > >
> > > This is only happening if I ingest a shapefile with a column
> > > named
> > > 'id' - i can replace the column name, re-ingest and the same data
> > > appears fine via WFS.
> > >
> > > cheers,
> > >
> > >
> > > Jo
> > > --
> > >
> > >
> > > _______________________________________________
> > > geomesa-users mailing list
> > > geomesa-users@xxxxxxxxxxxxxxxx
> > > To change your delivery options, retrieve your password, or
> > > unsubscribe from this list, visit
> > > https://www.locationtech.org/mailman/listinfo/geomesa-users
> > _______________________________________________
> > geomesa-users mailing list
> > geomesa-users@xxxxxxxxxxxxxxxx
> > To change your delivery options, retrieve your password, or
> > unsubscribe from this list, visit
> > https://www.locationtech.org/mailman/listinfo/geomesa-users
> _______________________________________________
> geomesa-users mailing list
> geomesa-users@xxxxxxxxxxxxxxxx
> To change your delivery options, retrieve your password, or
> unsubscribe from this list, visit
> https://www.locationtech.org/mailman/listinfo/geomesa-users
