Karthik Palanisamy created PHOENIX-6629:
-------------------------------------------
Summary: Phoenix.spool.directory is ineffective
Key: PHOENIX-6629
URL: https://issues.apache.org/jira/browse/PHOENIX-6629
Project: Phoenix
Issue Type: Bug
Components: core
Affects Versions: 5.0.0
Reporter: Karthik Palanisamy
Phoenix.spool.directory is ineffective when using joins query along with HINTS.
It always refers to "java.io.tmpdir".
Example Query:
SELECT /*+ USE_SORT_MERGE_JOIN*/ A.AGE as AGE_A, B.AGE as AGE_B, A.CITY FROM
PEOPLE A, PEOPLE B WHERE A.ID <> B.ID AND A.CITY = B.CITY ORDER BY A.CITY;
--
This message was sent by Atlassian Jira
(v8.20.1#820001)