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//issues/4.

[antonmks]

Fixed.

[agonen]

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