[
https://issues.apache.org/jira/browse/ASTERIXDB-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ian Maxon updated ASTERIXDB-3452:
---------------------------------
Labels: triaged (was: )
> Spatial Join Fails with Indexed Datasets Unless Index-Only Plan is Disabled
> ---------------------------------------------------------------------------
>
> Key: ASTERIXDB-3452
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3452
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: OTH - Other
> Reporter: Suryaa Charan
> Priority: Major
> Labels: triaged
> Attachments: LogTrace.txt, QueriesToReplicateIssue.txt
>
>
> The spatial join operation fails when +*both*+ datasets involved in the join
> have indices. The operation succeeds if one of the datasets does not have an
> index or if the index-only plan is disabled using the command: SET
> compiler.indexonly "false";
> *Expected Behavior:* The spatial join should work seamlessly with indexed
> datasets without the need to disable the index-only plan.
> *Actual Behavior:* The spatial join fails when both datasets have indices,
> indicating an issue with the index-only plan mechanism.
> *Workaround:* Disabling the index-only plan with the command {{SET
> }}compiler.indexonly{{ "false";}} allows the spatial join to succeed.
> *Attachments:*
> # Queries to replicate the issue.([^QueriesToReplicateIssue.txt])
> # Log trace showcasing the error.([^LogTrace.txt])
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
