Ted,
thanks for the update.
One of the sample queries:
SELECT n.name, r.name FROM (
SELECT _MAP['N_REGIONKEY'] as regionKey, _MAP['N_NAME'] as name
FROM "sample-data/nation.parquet") nations
join (
SELECT _MAP['R_REGIONKEY'] as regionKey, _MAP['R_NAME'] as name
FROM "sample-data/region.parquet") regions
on nations.regionKey = regions.regionKey
order by nations.name;
==> the 'n' and 'r' are not defined.
Should be:
SELECT nation.name, region.name FROM (
SELECT _MAP['N_REGIONKEY'] as regionKey, _MAP['N_NAME'] as name
FROM "sample-data/nation.parquet") nation
join (
SELECT _MAP['R_REGIONKEY'] as regionKey, _MAP['R_NAME'] as name
FROM "sample-data/region.parquet") region
on nation.regionKey = region.regionKey
order by nation.name;
Cheers,
-Harri
On 2.9.2013, at 18.32, Ted Dunning <ted.dunning@gmail.com<mailto:ted.dunning@gmail.com>>
wrote:
Ahh... but I had not pushed.
Update now and you should see the files in a new sample-data directory. I
will also add instructions to run the commands in the prototype directory
(subject to change after the grand code motion).
On Mon, Sep 2, 2013 at 8:28 AM, Ted Dunning <ted.dunning@gmail.com<mailto:ted.dunning@gmail.com>>
wrote:
On Mon, Sep 2, 2013 at 7:25 AM, Adam Szulinski <A.Szulinski@kainos.com<mailto:A.Szulinski@kainos.com>>wrote:
It seams to be lack of parquet file. Should I get it from somewhere?
I checked the files in last night. Have you updated recently?
|