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)
