Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Tue, 8 Sep 2015 18:32:46 +0000 (UTC)
From: "ravi ranjan kumar (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.12862509.1441737116000.281934.1441737166231@Atlassian.JIRA>
In-Reply-To: <JIRA.12862509.1441737116000@Atlassian.JIRA>
References: <JIRA.12862509.1441737116000@Atlassian.JIRA>
 <JIRA.12862509.1441737116122@arcas>
Subject: [jira] [Created] (DRILL-3750) Not able to connect to HDFS and/or
 Hive
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

ravi ranjan kumar created DRILL-3750:
----------------------------------------

             Summary: Not able to connect to HDFS and/or Hive
                 Key: DRILL-3750
                 URL: https://issues.apache.org/jira/browse/DRILL-3750
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill, Metadata, Storage - Hive, Storage - Text & CSV
    Affects Versions: 1.1.0
         Environment: apache hadoop and apache drill
            Reporter: ravi ranjan kumar
            Assignee: Mehant Baid


I am not able to connect/fetch data using select queries form hive storage and hdfs storage.

hive storage config - 
{
  "type": "hive",
  "enabled": true,
  "configProps": {
    "hive.metastore.uris": "thrift://192.168.146.138:9083",
    "javax.jdo.option.ConnectionURL": "jdbc:derby:;databaseName=/home/ravi/bigdata/hive-1.0.1/metastore_db;create=true",
    "hive.metastore.warehouse.dir": "/tmp/hive",
    "fs.default.name": "hdfs://192.168.146.136:9000/",
    "hive.metastore.sasl.enabled": "false"
  }
}

Query -  select * from hive.`customers`
ERROR - org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: EOFException [Error Id: 29746c1e-90fc-41f6-8263-ce943354b07e on ubuntu:31010]


HDFS storage config -

{
  "type": "file",
  "enabled": true,
  "connection": "hdfs://192.168.146.136:9000/",
  "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"
    },
    "avro": {
      "type": "avro"
    }
  }
}

Query  - select * from hdfs.`/customers.csv`
ERROR - org.apache.drill.common.exceptions.UserRemoteException: PARSE ERROR: From line 1, column 15 to line 1, column 18: Table 'hdfs./customers.csv' not found [Error Id: 13df2ccb-01bd-480f-966c-ceda7e1503a8 on ubuntu:31010]


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)