You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Karthik Palanisamy (Jira)" <ji...@apache.org> on 2022/01/25 06:37:00 UTC

[jira] [Created] (PHOENIX-6629) Phoenix.spool.directory is ineffective

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)