You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2024/02/08 22:43:00 UTC
[jira] [Commented] (ASTERIXDB-3352) Join hints not honored
[ https://issues.apache.org/jira/browse/ASTERIXDB-3352?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17815851#comment-17815851 ]
ASF subversion and git services commented on ASTERIXDB-3352:
------------------------------------------------------------
Commit c3941fcd6948a7dcb27304fd4a00e124ca32be29 in asterixdb's branch refs/heads/master from Vijay Sarathy
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=c3941fcd69 ]
[ASTERIXDB-3352][COMP] Join hints not honored
Change-Id: I81420996900bd4e8538946c3db08c4805f6e2f4c
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/18156
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: <mu...@couchbase.com>
Reviewed-by: Vijay Sarathy <vi...@couchbase.com>
> Join hints not honored
> ----------------------
>
> Key: ASTERIXDB-3352
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3352
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Reporter: Vijay Sarathy
> Assignee: Vijay Sarathy
> Priority: Major
>
> For the following query, the join hints are not honored.
> select 061, count(1) from R join S
> on int64_default_null (R.u64) /+ indexnl */ /+ productivity R 65536.0 */ = int64_default_null (S.u64)
> join T on int64_default_null (S.u256) /+ hashjoin build (S) */ /+ productivity S 16384.0 */ = int64_default_null (T.u256)
> where R.rand /*+ selectivity 0.000015258789063 */ <= 64
> and S.rand /*+ selectivity 0.000003814697266 */ <= 16
> and T.rand /*+ selectivity 0.000003814697266 */ <= 16;
> Upon debugging, I see that the hints are being used during plan enumeration, but another plan which uses one of the hints (but not both hints), is costed cheaper and is picked. The fix would be to favor plans that use more hints when comparing two plans irrespective of cost.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)