phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gabriel Reid <gabriel.r...@gmail.com>
Subject Re: Phoenix creates ResultSpoolerxxxxxx.bin files in /tmp
Date Tue, 06 May 2014 07:08:17 GMT
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 <anilgupta84@gmail.com> 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

Mime
View raw message