Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Drill >> mail # user >> Running demo Drill 1.0


Copy link to this message
-
Re: Running demo Drill 1.0
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 <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> 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 <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
On Mon, Sep 2, 2013 at 7:25 AM, Adam Szulinski <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>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?