phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Tse <>
Subject RE: PhoenixIOException: The system cannot find the path specified
Date Wed, 04 Feb 2015 17:33:14 GMT
The exception was thrown in `SpoolingResultIterator.SpoolingResultIterator(ResultIterator scanner,
MemoryManager mm, int thresholdBytes, long maxSpoolToDisk, String spoolDirectory)`.

The parameter spoolDirectory was '/tmp', which is the default value, and did not exist on
the environment I was working in. The default value is declared and set in 'org.apache.phoenix.query.

To override the value, I created an 'hbase-site.xml' config file (as per,
and added it to the class path. I added the following property inside <configuration>...</configuration>:

Not fully sure what's happening in the background, but I'm guessing a 'SELECT *' utilizes
the spool directory, but adding 'LIMIT' does not (possibly because it doesn't know the upper
bound of records coming back, and so uses disk to buffer).


From: Mark Tse []
Sent: February-03-15 3:09 PM
Subject: PhoenixIOException: The system cannot find the path specified

Hi there,

I am getting the following exception when trying to run a "SELECT * FROM TABLE_NAME" statement
using the build #578 on Phoenix master (
org.apache.phoenix.exception.PhoenixIOException: The system cannot find the path specified

A similar query, "SELECT * FROM TABLE_NAME LIMIT 100000", does not throw the error, and appears
to successfully display all the data in TABLE_NAME.

Would anyone happen to know what the problem might be?

[Title: Brightspace by D2L Logo - Description: Link to (Brightspace by
D2L homepage).]<>
Mark Tse
QA Developer
D2L Corporation

[Title: Twitter Icon - Description: Link to Twitter feed for Brightspace by D2L]<>[Title:
Facebook Icon - Description: Link to Brightspace by D2L Facebook page]<>
[Title: LinkedIn Icon - Description: Link to D2L LinkedIn site] <>
 [Title: YouTube Icon - Description: Link to Brightspace by D2L on YouTube] <>
 [Title: Contact Icon - Description: Link to D2L's Web site contact page] <>

D2L is hiring! Make learning more pervasive, perceptive, and personalized for the entire world:<>

View raw message