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
