[
https://issues.apache.org/jira/browse/ASTERIXDB-3524?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ian Maxon updated ASTERIXDB-3524:
---------------------------------
Labels: triaged (was: )
> Index hints ignored while not producing a warning
> -------------------------------------------------
>
> Key: ASTERIXDB-3524
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3524
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: IDX - Indexes
> Reporter: Pratyoy Das
> Assignee: Vijay Sarathy
> Priority: Major
> Labels: triaged
> Attachments: asterixdb-query-results (1).json
>
>
> When I run a query with a particular index hint, Asterix DB ignores the index
> on the hint and uses the default primary key index.
> Below is an example query:
> USE tpch;SELECT Orders.o_custkey, Lineitem.l_extendedprice
> FROM Orders, Lineitem
> WHERE Orders.o_orderkey /*+ indexnl(lineitem_fk_orders) */ =
> Lineitem.l_orderkey
> I am attaching the json query plan where you will see the"Lineitem" index is
> used to join with Lineitem and not "lineitem_fk_orders".
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
