Maybe I am missing something, though I followed your suggestion and decreased the "phoenix.query.spoolThresholdBytes" value to 10MB, though after some time I am still running out of disk space (350+GB). Any suggestions?
--Wildfly 10 Datasource Declaration-- <datasource jndi-name="java:jboss/datasources/PhoenixDS" pool-name="PhoenixDS" enabled="true" use-java-context="true"> <connection-url>jdbc:phoenix:server01:/hbase-unsecure</connection-url> <connection-property name="phoenix.connection.autoCommit">true</connection-property> <connection-property name="phoenix.query.spoolThresholdBytes">10485760</connection-property> <driver>phoenix</driver> <validation> <check-valid-connection-sql>SELECT 1 FROM SYSTEM.CATALOG LIMIT 1</check-valid-connection-sql> </validation></datasource> -- Sent: Friday, 15 April 2016, 16:51 Subject: Re: Getting swamped with Phoenix *.tmp files on SELECT. We ran into something similar, here is the ticket https://issues.apache.org/jira/browse/PHOENIX-2685The work around that mitigated this issue for us was to lower the value of phoenix.query.spoolThresholdBytes to 10 MB. It is counter intuitive, but, due to the way the spooling iterator interacts with global memory manager, it works. Alok Alok a...@cloudability.com On Fri, Apr 15, 2016 at 1:42 PM, wrote: I am using an Ambari HDP distribution of the Phoenix client (/usr/hdp/2.3.4.0-3485/phoenix/phoenix-4.4.0.2.3.4.0-3485-client.jar), and to close database connections I am using the standard Java JDBC try-with-resources process (http://www.mastertheboss.com/jboss-server/jboss-datasource/using-try-with-resources-to-close-database-connections , https://docs.oracle.com/javase/tutorial/essential/exceptions/tryResourceClose.html). From: Samarth Jain Sent: Friday, 15 April 2016, 16:03 Subject: Re: Getting swamped with Phoenix *.tmp files on SELECT. What version of phoenix are you using? Is the application properly closing statements and result sets? On Friday, April 15, 2016, wrote: I am running into an issue where a huge number temporary files are being created in my C:\Users\myuser\AppData\Local\Temp folder, they are around 20MB big and never get cleaned up. These *.tmp files grew to around 200GB before I stopped the server. Example file names: 7a0967de-9dff-432b-bcfe-de30bc630add5176202498513378657.tmp 813e40e1-afa9-4847-919c-7c55f95f8a475501154042645376476.tmp 1329da43-561d-4e68-9120-56bd650a6ac98781585316402092121.tmp Currently, I have my Phoenix Client jar deployed to Wildfly 10 as described here: https://docs.jboss.org/author/display/TEIID/Phoenix+Data+Sources These *.tmp files only appear when I run SELECT queries. Any help would be appreciated.