Hi
I have a problem with executing a UNION ALL statment with added hints. I need
the hints to be able to use the index. For example:
explain SELECT /*+ INDEX(table1 INDEX_TABLE1_COL) */ col1, col2 FROM table1
WHERE col1='123' UNION ALL SELECT /*+ INDEX(table2 INDEX_TABLE2_COL) */ col1,
col2 FR
plan with the index is better. Please file a Jira for the NPE.
Thanks,
Alicia
From: Gašper Metelko
mailto:gasper.mete...@salviol.com>>
Reply-To: "user@phoenix.apache.org<mailto:user@phoenix.apache.org>"
mailto:user@phoenix.apache.org>>
Date: Friday, September 25,
Hi
With using phoenix-4.8.1-HBase-1.1-bin I have problems doing a join with hints.
Doing a select with a join on two tables when trying to use multiple hints
phoenix does include them in the execution plan:
Should be: CLIENT 1-CHUNK 0 ROWS 0 BYTES PARALLEL 1-WAY ROUND ROBIN RANGE SCAN
OVER C12