drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Dunning <ted.dunn...@gmail.com>
Subject Re: Running demo Drill 1.0
Date Mon, 02 Sep 2013 17:41:26 GMT
Thanks Harri!

I will fix the wiki page


On Mon, Sep 2, 2013 at 8:55 AM, Harri Kinnunen
<Harri.Kinnunen@hitsaamo.fi>wrote:

> 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?
>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message