Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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?
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB