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)

Reply via email to