[jira] [Updated] (DRILL-3750) Not able to connect to HDFS and/or Hive

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-3750?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Nadeau updated DRILL-3750:
----------------------------------
    Labels:   (was: newbie)

> 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
>             Fix For: Future
>
>   Original Estimate: 504h
>  Remaining Estimate: 504h
>
> 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)