[
https://issues.apache.org/jira/browse/ASTERIXDB-3452?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Suryaa Charan updated ASTERIXDB-3452:
-------------------------------------
Description:
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])
was:
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:*
# [^QueriesToReplicateIssue.txt]Queries to replicate the
issue.([^QueriesToReplicateIssue.txt])
# Log trace showcasing the error.([^LogTrace.txt])
> 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
> 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)
