Yes, and just to add to that, those files should be deleted when the scan is closed. If that's not the case, please file a JIRA. Thanks, James
On Tue, May 6, 2014 at 12:08 AM, Gabriel Reid <[email protected]>wrote: > Yes, Phoenix writes the results of scanners to an in-memory store that > spools into file storage once it gets too big (see [1]). > > 1. > https://github.com/apache/incubator-phoenix/blob/c22539d940fa0afc790cc0f25c2cdbbb255f80a3/phoenix-core/src/main/java/org/apache/phoenix/iterate/SpoolingResultIterator.java#L95 > > On Sun, May 4, 2014 at 8:19 AM, anil gupta <[email protected]> wrote: > > Hi, > > > > I would like to know why phoenix creates "ResultSpoolerxxxxxxxx.bin" > file? > > What is the content of these? > > > > I was using sqlline with phoenix3.0 and ran a "select * from table" > query. > > That table had around 10 million rows. Is phoenix really trying to read > > entire table? > > > > Eventually this exception was thrown by phoenix: > > java.lang.Runtime Exception: > > org.apache.phoenix.exception.PhoenixIOException: > > org.apache.phoenix.exception.PhoenixIOException: No space left on device > > at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2440) > > at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2074) > > at sqlline.SqlLine.print(SqlLine.java:1735) > > at sqlline.SqlLine$Commands.execute(SqlLine.java:3683) > > at sqlline.SqlLine$Commands.sql(SqlLine.java:3584) > > at sqlline.SqlLine.dispatch(SqlLine.java:821) > > at sqlline.SqlLine.begin(SqlLine.java:699) > > at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441) > > at sqlline.SqlLine.main(SqlLine.java:424) > > > > -- > > Thanks & Regards, > > Anil Gupta >
