Multiple hints in phoenix join

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

RE: Error with union all and a hint

ile a Jira for the NPE. Thanks, Alicia From: Gašper Metelko <gasper.mete...@salviol.com<mailto:gasper.mete...@salviol.com>> Reply-To: "user@phoenix.apache.org<mailto:user@phoenix.apache.org>" <user@phoenix.apache.org<mailto:user@phoenix.apache.org

Error with union all and a hint

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