Geospatial presto - IndexOutOfBoundsException: end index (1353) must not be greater than size (1352)

[임태준]

java.lang.IndexOutOfBoundsException: end index (1353) must not be greater than size (1352)
	at io.airlift.slice.Preconditions.checkPositionIndexes(Preconditions.java:81)
	at io.airlift.slice.Slice.checkIndexLength(Slice.java:1266)
	at io.airlift.slice.Slice.getLong(Slice.java:479)
	at com.facebook.presto.spi.block.AbstractVariableWidthBlock.getLong(AbstractVariableWidthBlock.java:63)
	at com.facebook.presto.spi.block.DictionaryBlock.getLong(DictionaryBlock.java:125)
	at com.facebook.presto.spi.type.DoubleType.getDouble(DoubleType.java:103)
	at com.facebook.presto.$gen.PageProjectionWork_20180503_024650_67.evaluate(Unknown Source)
	at com.facebook.presto.$gen.PageProjectionWork_20180503_024650_67.process(Unknown Source)
	at com.facebook.presto.operator.project.PageProcessor$PositionsPageProcessorIterator.processBatch(PageProcessor.java:275)
	at com.facebook.presto.operator.project.PageProcessor$PositionsPageProcessorIterator.computeNext(PageProcessor.java:180)
	at com.facebook.presto.operator.project.PageProcessor$PositionsPageProcessorIterator.computeNext(PageProcessor.java:127)
	at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:145)
	at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:140)
	at com.facebook.presto.operator.project.PageProcessorOutput.hasNext(PageProcessorOutput.java:49)
	at com.facebook.presto.operator.project.MergingPageOutput.getOutput(MergingPageOutput.java:110)
	at com.facebook.presto.operator.FilterAndProjectOperator.getOutput(FilterAndProjectOperator.java:104)
	at com.facebook.presto.operator.Driver.processInternal(Driver.java:379)
	at com.facebook.presto.operator.Driver.lambda$processFor$8(Driver.java:278)
	at com.facebook.presto.operator.Driver.tryWithLock(Driver.java:645)
	at com.facebook.presto.operator.Driver.processFor(Driver.java:272)
	at com.facebook.presto.execution.SqlTaskExecution$DriverSplitRunner.processFor(SqlTaskExecution.java:975)
	at com.facebook.presto.execution.executor.PrioritizedSplitRunner.process(PrioritizedSplitRunner.java:162)
	at com.facebook.presto.execution.executor.TaskExecutor$TaskRunner.run(TaskExecutor.java:492)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)

this is my query

select t.sale_price as price

from hms.jeju j

join hms.trnstn_situtn t

on ST_Contains( ST_GeometryFromText(j.geometry), ST_Point(t.longitude, t.latitude)) limit 1;

jeju schema

... , geometry varchar ( wkt)

trnstn_situtn schema

... longitude double, latitude double

anybody can help me ?

[taejun]

the data located in hdfs by hive orc file

[Dain Sundstrom]

Can you open a GitHub issue?

Also what version are you running?

And can you try executing these two queries and add the results to the issue also:

select checksum(sale_price), checksum(longitude), checksum(latitude)
from hms.trnstn_situtn

select checksum(j.geometry)
from hms.jeju

-dain

> On May 2, 2018, at 8:16 PM, taejun <dlaxo...@gmail.com> wrote:
>
> the data located in hdfs by hive orc file
>

> --
> You received this message because you are subscribed to the Google Groups "Presto" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to presto-users...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.