GeoMesa导出查询错误

Question

问题:当我试图在查询下面运行时，会产生错误。CQL查询中缺少了什么，还是缺少了jar文件？另外，无论是GeoMesa错误还是accumulo错误。还有其他方法来查询GeoMesa并在CSV文件中获取结果吗？

命名空间: myNamespace

收藏: d1temp

查询：

geomesa export -u user -p password -c myNamespace.d1temp -f d1-json -q "WITHIN(geom, POLYGON((-6.4101 55.597244,-6.4101 50.947156,0.656067 50.947156,0.656067 55.597244,-6.4101 55.597244)))"

错误：

id,*geom:Point:srid=4326,short_text_field:String,long_text_field_1:String,long_text_field_2:String,security_tag:String,numerical_tag_1:Integer,numerical_tag_2:Double,timestamp:Date
Exception in thread "main" java.lang.NoSuchMethodError: java.util.ArrayList.sort(Ljava/util/Comparator;)V
    at org.locationtech.sfcurve.zorder.ZN.zranges(ZN.scala:212)
    at org.locationtech.geomesa.curve.Z2SFC$.ranges(Z2SFC.scala:33)
    at org.locationtech.geomesa.accumulo.index.z2.Z2QueryableIndex$class.getQueryPlan(Z2QueryableIndex.scala:119)
    at org.locationtech.geomesa.accumulo.index.z2.Z2Index$.getQueryPlan(Z2Index.scala:20)
    at org.locationtech.geomesa.accumulo.index.z2.Z2Index$.getQueryPlan(Z2Index.scala:20)
    at org.locationtech.geomesa.accumulo.index.QueryPlanner$$anonfun$getQueryPlans$7$$anonfun$4.apply(QueryPlanner.scala:150)
    at org.locationtech.geomesa.accumulo.index.QueryPlanner$$anonfun$getQueryPlans$7$$anonfun$4.apply(QueryPlanner.scala:150)
    at org.locationtech.geomesa.utils.stats.MethodProfiling$class.profile(MethodProfiling.scala:20)
    at org.locationtech.geomesa.accumulo.index.QueryPlanner.profile(QueryPlanner.scala:56)
    at org.locationtech.geomesa.accumulo.index.QueryPlanner$$anonfun$getQueryPlans$7.apply(QueryPlanner.scala:150)
    at org.locationtech.geomesa.accumulo.index.QueryPlanner$$anonfun$getQueryPlans$7.apply(QueryPlanner.scala:144)
    at scala.collection.Iterator$$anon$12.hasNext(Iterator.scala:396)
    at org.locationtech.geomesa.accumulo.util.CloseableIterator$$anon$5.hasNext(CloseableIterator.scala:34)
    at org.locationtech.geomesa.accumulo.util.SelfClosingIterator$$anon$1.hasNext(CloseableIterator.scala:100)
    at org.locationtech.geomesa.accumulo.util.CloseableIterator$$anon$2.<init>(CloseableIterator.scala:66)
    at org.locationtech.geomesa.accumulo.util.CloseableIterator$class.ciFlatMap(CloseableIterator.scala:65)
    at org.locationtech.geomesa.accumulo.util.SelfClosingIterator$$anon$1.ciFlatMap(CloseableIterator.scala:98)
    at org.locationtech.geomesa.accumulo.index.QueryPlanner.scan$1(QueryPlanner.scala:87)
    at org.locationtech.geomesa.accumulo.index.QueryPlanner.executePlans(QueryPlanner.scala:108)
    at org.locationtech.geomesa.accumulo.index.QueryPlanner.runQuery(QueryPlanner.scala:78)
    at org.locationtech.geomesa.accumulo.data.AccumuloFeatureReaderWithStats$$anonfun$2.apply(AccumuloFeatureReader.scala:86)
    at org.locationtech.geomesa.accumulo.data.AccumuloFeatureReaderWithStats$$anonfun$2.apply(AccumuloFeatureReader.scala:86)
    at org.locationtech.geomesa.utils.stats.MethodProfiling$class.profile(MethodProfiling.scala:26)
    at org.locationtech.geomesa.accumulo.data.AccumuloFeatureReaderWithStats.profile(AccumuloFeatureReader.scala:77)
    at org.locationtech.geomesa.accumulo.data.AccumuloFeatureReaderWithStats.<init>(AccumuloFeatureReader.scala:86)
    at org.locationtech.geomesa.accumulo.data.AccumuloFeatureReader$$anon$3.<init>(AccumuloFeatureReader.scala:55)
    at org.locationtech.geomesa.accumulo.data.AccumuloFeatureReader$.apply(AccumuloFeatureReader.scala:55)
    at org.locationtech.geomesa.accumulo.data.AccumuloDataStore.getFeatureReader(AccumuloDataStore.scala:439)
    at org.locationtech.geomesa.accumulo.data.AccumuloFeatureCollection.reader(AccumuloFeatureSource.scala:171)
    at org.geotools.data.store.DataFeatureCollection.openIterator(DataFeatureCollection.java:230)
    at org.locationtech.geomesa.accumulo.data.AccumuloFeatureCollection.openIterator(AccumuloFeatureSource.scala:134)
    at org.geotools.data.store.DataFeatureCollection.iterator(DataFeatureCollection.java:198)
    at org.geotools.data.store.DataFeatureCollection.features(DataFeatureCollection.java:187)
    at org.locationtech.geomesa.tools.accumulo.DelimitedExport.write(FeatureExporter.scala:156)
    at org.locationtech.geomesa.tools.accumulo.commands.ExportCommand.execute(ExportCommand.scala:52)
    at org.locationtech.geomesa.tools.common.Runner$class.main(Runner.scala:26)
    at org.locationtech.geomesa.tools.accumulo.AccumuloRunner$.main(AccumuloRunner.scala:20)
    at org.locationtech.geomesa.tools.accumulo.AccumuloRunner.main(AccumuloRunner.scala)

Answer 1

这个错误发生在Java7中。GeoMesa需要Java 8。命令'java -- version‘将显示您正在使用的Java版本的详细信息。

您需要检查操作系统如何处理多个版本的Java，并更新JAVA_HOME以指向Java8安装。在那之后，你就会回到正轨！

您的CQL过滤器和其他命令看起来很棒。就我个人而言，我更喜欢'bbox‘或’交叉‘，因为我不需要考虑论证顺序。(如果A与B相交，则B与A相交。当A在B内时，并不意味着B在A之内。)