Pratyoy Das created ASTERIXDB-3524:
--------------------------------------
Summary: 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
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)
