I don't get all the rows when try to fetch single table

[agonen]

Hi Anton , I'm try to run those commands : R := LOAD 'nation' BINARY AS (nationkey{1}:int, regionkey{3}:int); RS := SELECT nationkey as n_nationkey ,regionkey as n_regionkey FROM R ; STORE RS INTO 'nation.sql.txt' USING ('|') LIMIT 10;

and I get output - Process count = 6200000 BINARY LOAD: R nation SELECT RS R cycle 0 select mem 2751848448 final select 1 select time 0.102 STORE: RS nation.sql.txt | SQL scan parse worked cycle time 0.11 0|0|

While the table has more rows (it is the nation table from TPHC).

I'm using the lastest version from github.

Anyidea ? where to look ?

thanks Amihay.

[antonmks]

Fixed, should be working now.

On Mon, Feb 25, 2013 at 5:15 PM, agonen notifications@github.com wrote:

Hi Anton , I'm try to run those commands : R := LOAD 'nation' BINARY AS (nationkey{1}:int, regionkey{3}:int); RS := SELECT nationkey as n_nationkey ,regionkey as n_regionkey FROM R ; STORE RS INTO 'nation.sql.txt' USING ('|') LIMIT 10;

and I get output - Process count = 6200000 BINARY LOAD: R nation SELECT RS R cycle 0 select mem 2751848448 final select 1 select time 0.102 STORE: RS nation.sql.txt | SQL scan parse worked cycle time 0.11 0|0|

While the table has more rows (it is the nation table from TPHC).

I'm using the lastest version from github.

Anyidea ? where to look ?

thanks Amihay.

— Reply to this email directly or view it on GitHubhttps://github.com/antonmks/Alenka/issues/4.

[antonmks]

Fixed.

[agonen]

wow . this was quick :+1 thanks very much , I'll update my repo and test it locally .