drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ravi ranjan kumar (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3750) Not able to connect to HDFS and/or Hive
Date Tue, 08 Sep 2015 18:32:46 GMT
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)

Mime
View raw message