Hi Yiannis, You may need to set phoenix.spool.directory to correct windows folder as by default it is set to /tmp. It is fixed in 4.7. https://issues.apache.org/jira/browse/PHOENIX-2348
Regards, Ankit Singhal On Wed, Feb 24, 2016 at 10:05 PM, Yiannis Gkoufas <johngou...@gmail.com> wrote: > Hi there, > > we have been using phoenix client without a problem in linux systems but > we have encountered some problems on windows. > We run the queries through SquirellSQL using the 4.5.2 client jar > The query which looks like this SELECT * FROM TABLE WHERE ID='TEST' works > without a problem. But when we issue SELECT * FROM TABLE WHERE ID='TEST' > ORDER BY DT we get the error: > org.apache.phoenix.exception.PhoenixIOException: > org.apache.phoenix.exception.PhoenixIOException: The system cannot find the > path specified > at > org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108) > at > org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:553) > at > org.apache.phoenix.iterate.MergeSortResultIterator.getIterators(MergeSortResultIterator.java:48) > at > org.apache.phoenix.iterate.MergeSortResultIterator.minIterator(MergeSortResultIterator.java:84) > at > org.apache.phoenix.iterate.MergeSortResultIterator.next(MergeSortResultIterator.java:111) > at > org.apache.phoenix.iterate.DelegateResultIterator.next(DelegateResultIterator.java:44) > at > org.apache.phoenix.iterate.LimitingResultIterator.next(LimitingResultIterator.java:47) > at > org.apache.phoenix.jdbc.PhoenixResultSet.next(PhoenixResultSet.java:771) > at > net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetWrapper._nextOnResultSet(ResultSetWrapper.java:95) > at > net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetWrapper.next(ResultSetWrapper.java:56) > at > net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.readRow(ResultSetReader.java:182) > at > net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet.createRow(ResultSetDataSet.java:238) > at > net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet._setResultSet(ResultSetDataSet.java:204) > at > net.sourceforge.squirrel_sql.fw.datasetviewer.ResultSetDataSet.setSqlExecutionTabResultSet(ResultSetDataSet.java:127) > at > net.sourceforge.squirrel_sql.client.session.mainpanel.SQLExecutionHandler.sqlResultSetAvailable(SQLExecutionHandler.java:423) > at > net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processResultSet(SQLExecuterTask.java:549) > at > net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.processQuery(SQLExecuterTask.java:414) > at > net.sourceforge.squirrel_sql.client.session.SQLExecuterTask.run(SQLExecuterTask.java:212) > at > net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) > at java.lang.Thread.run(Unknown Source) > Caused by: java.util.concurrent.ExecutionException: > org.apache.phoenix.exception.PhoenixIOException: The system cannot find the > path specified > at java.util.concurrent.FutureTask.report(Unknown Source) > at java.util.concurrent.FutureTask.get(Unknown Source) > at > org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:549) > ... 18 more > Caused by: org.apache.phoenix.exception.PhoenixIOException: The system > cannot find the path specified > at > org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108) > at > org.apache.phoenix.iterate.SpoolingResultIterator.<init>(SpoolingResultIterator.java:151) > at > org.apache.phoenix.iterate.SpoolingResultIterator.<init>(SpoolingResultIterator.java:86) > at > org.apache.phoenix.iterate.SpoolingResultIterator.<init>(SpoolingResultIterator.java:64) > at > org.apache.phoenix.iterate.SpoolingResultIterator$SpoolingResultIteratorFactory.newIterator(SpoolingResultIterator.java:81) > at > org.apache.phoenix.iterate.ChunkedResultIterator.<init>(ChunkedResultIterator.java:92) > at > org.apache.phoenix.iterate.ChunkedResultIterator.<init>(ChunkedResultIterator.java:47) > at > org.apache.phoenix.iterate.ChunkedResultIterator$ChunkedResultIteratorFactory.newIterator(ChunkedResultIterator.java:72) > at > org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:109) > at > org.apache.phoenix.iterate.ParallelIterators$1.call(ParallelIterators.java:100) > at java.util.concurrent.FutureTask.run(Unknown Source) > at > org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask.run(JobManager.java:183) > at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) > ... 1 more > Caused by: java.io.IOException: The system cannot find the path specified > at java.io.WinNTFileSystem.createFileExclusively(Native Method) > at java.io.File.createTempFile(Unknown Source) > at > org.apache.commons.io.output.DeferredFileOutputStream.thresholdReached(DeferredFileOutputStream.java:176) > at > org.apache.phoenix.iterate.SpoolingResultIterator$1.thresholdReached(SpoolingResultIterator.java:118) > at > org.apache.commons.io.output.ThresholdingOutputStream.checkThreshold(ThresholdingOutputStream.java:224) > at > org.apache.commons.io.output.ThresholdingOutputStream.write(ThresholdingOutputStream.java:92) > at java.io.DataOutputStream.writeByte(Unknown Source) > at > org.apache.hadoop.io.WritableUtils.writeVLong(WritableUtils.java:273) > at org.apache.hadoop.io.WritableUtils.writeVInt(WritableUtils.java:253) > at org.apache.phoenix.util.TupleUtil.write(TupleUtil.java:149) > at > org.apache.phoenix.iterate.SpoolingResultIterator.<init>(SpoolingResultIterator.java:129) > ... 13 more > > Do you have any idea as to why this is happening? We are not getting the > error on linux clients. > > Thanks! >