Return-Path: X-Original-To: apmail-drill-dev-archive@www.apache.org Delivered-To: apmail-drill-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 56105172EE for ; Wed, 15 Apr 2015 18:21:52 +0000 (UTC) Received: (qmail 38644 invoked by uid 500); 15 Apr 2015 18:21:52 -0000 Delivered-To: apmail-drill-dev-archive@drill.apache.org Received: (qmail 38602 invoked by uid 500); 15 Apr 2015 18:21:52 -0000 Mailing-List: contact dev-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list dev@drill.apache.org Received: (qmail 38590 invoked by uid 99); 15 Apr 2015 18:21:51 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Apr 2015 18:21:51 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,NORMAL_HTTP_TO_IP,RCVD_IN_DNSWL_LOW,SPF_PASS,WEIRD_PORT X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of venki.korukanti@gmail.com designates 209.85.220.174 as permitted sender) Received: from [209.85.220.174] (HELO mail-qk0-f174.google.com) (209.85.220.174) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 15 Apr 2015 18:21:26 +0000 Received: by qkhg7 with SMTP id g7so96814256qkh.2 for ; Wed, 15 Apr 2015 11:20:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; bh=nUg7p1EVndiA0+2bmQ8djbMjfkKYgikAUHOkAjsNWso=; b=izRN2s4tEiAjMUzsS4+hIXEoHVLbYoOwSIFpESy4JOFTRKuXvXv39+bpjyBWAtKeKl NAvL+SYLbAx0xzk/mfeR2pz3iXxPAkYXQjgNi6YkZnnGasNCfWt4XX9s4qBhiIs8CuI3 BaYJVvcJZiKXMizf/v3bWUTS3zO+ui54L+S3qEvKxWhR3Y38bxmAQ8eKPtL/AiJZrzpR PmqRyD7oWY/YSR/4d3VVEfKzn+6K8Kk5t6faffLhmg5yMs0N0V46TceYSFEhnqE3d2PH p6eoRb8umbnBs/1sdJih4gqVgzN1VZKE6nKYkZoKORTGMe6ge7VE4DHST2rd01W9CphB 2cYQ== X-Received: by 10.140.40.74 with SMTP id w68mr32230832qgw.58.1429122006849; Wed, 15 Apr 2015 11:20:06 -0700 (PDT) MIME-Version: 1.0 Received: by 10.96.78.199 with HTTP; Wed, 15 Apr 2015 11:19:46 -0700 (PDT) In-Reply-To: References: From: Venki Korukanti Date: Wed, 15 Apr 2015 11:19:46 -0700 Message-ID: Subject: Re: Error using Hive storage Plugin: IOException: No FileSystem for scheme: maprfs To: dev@drill.apache.org Cc: "drill-dev@incubator.apache.org" , Parth Chandra Content-Type: multipart/alternative; boundary=001a11c137928f1d470513c76507 X-Virus-Checked: Checked by ClamAV on apache.org --001a11c137928f1d470513c76507 Content-Type: text/plain; charset=UTF-8 Is the tar.gz file generated compiled with -Pmapr profle? On Wed, Apr 15, 2015 at 11:11 AM, Alexander Zarei < alexanderz.simba@gmail.com> wrote: > Thanks Ramana for the help. I tried what you said but it did not work. > Basically the storage plugin addition fails. I set the log level to debug > and it didn't tell much about the problem. I will try it with TRACE log > level to see what happened. > > As I was not able to get the MapR Hadoop on EMR running I switched to > Amazon Hadoop and it worked as per documentation. > > Thanks again for your reply. > > Thanks, > Alex > > On Fri, Apr 3, 2015 at 1:58 PM, Ramana Inukonda > wrote: > > > Also is drill running on the same node as a MapR cluster? In that case > you > > just can specify maprfs:/// for the connection value. > > > > Regards > > Ramana > > > > > > On Fri, Apr 3, 2015 at 1:40 PM, Ramana Inukonda > > wrote: > > > > > Please check if your drill-env.sh contains the following: > > > > > > export DRILL_JAVA_OPTS="$DRILL_JAVA_OPTS > > > -Djava.security.auth.login.config=/opt/mapr/conf/mapr.login.conf > > > -Dzookeeper.sasl.client=false " > > > > > > > > > Regards > > > Ramana > > > > > > > > > > > > On Thu, Apr 2, 2015 at 8:51 PM, Alexander Zarei < > > > alexanderz.simba@gmail.com> wrote: > > > > > >> Hi, > > >> > > >> > > >> I am suing Drill on an AWS EMR cluster and trying to connect Hive and > > >> MapR-FS storage plugins. > > >> > > >> The hive plugin is connected successfully as inlined below; I created > a > > >> dummy table by hive shell and then I observed the following Drill > Error > > >> when browsing the dummy table with Drill Exporer: > > >> > > >> > > >> *[30024]Query execution error. Details:[ IOException: No FileSystem > for > > >> scheme: maprfs* > > >> > > >> I tried to connect the MapR-FS storage plugin but I am not sure if the > > >> port > > >> number I am using is correct. > > >> > > >> According to Drill documentation any distributed file system included > in > > >> core-site.xml can be used by Drill but I do not see any information > > >> related > > >> to MapR-FS in this file. However, when I use the Amazon Hadoop the > > >> information (hdfs nodename ip and port number ) is there and I can > > connect > > >> to hive storage by Drill. > > >> > > >> I wonder if you could let me know what I am missing in crafting the > > >> storage > > >> plugins below: > > >> > > >> Hive storage plugin: > > >> > > >> { > > >> "type": "hive", > > >> "enabled": true, > > >> "configProps": { > > >> "hive.metastore.uris": "thrift://localhost:9083", > > >> "hive.metastore.local": "false", > > >> "hive.metastore.warehouse.dir": "/user/hive/warehouse" > > >> } > > >> } > > >> > > >> and maprfs: > > >> > > >> { > > >> "type": "file", > > >> "enabled": "false", > > >> "connection": "maprfs://54.224.109.121:8041/", > > >> "workspaces": { > > >> "root": { > > >> "location": "/", > > >> "writable": false, > > >> "defaultInputFormat": null > > >> }, > > >> "tmp": { > > >> "location": "/tmp", > > >> "writable": true, > > >> "defaultInputFormat": null > > >> } > > >> }, > > >> "formats": { > > >> "psv": { > > >> "type": "text", > > >> "extensions": [ > > >> "tbl" > > >> ], > > >> "delimiter": "|" > > >> }, > > >> "csv": { > > >> "type": "text", > > >> "extensions": [ > > >> "csv" > > >> ], > > >> "delimiter": "," > > >> }, > > >> "tsv": { > > >> "type": "text", > > >> "extensions": [ > > >> "tsv" > > >> ], > > >> "delimiter": "\t" > > >> }, > > >> "parquet": { > > >> "type": "parquet" > > >> }, > > >> "json": { > > >> "type": "json" > > >> } > > >> } > > >> } > > >> > > >> > > >> Thanks, > > >> Alex > > >> > > > > > > > > > --001a11c137928f1d470513c76507--