drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abhishek Girish <abhishek.gir...@gmail.com>
Subject Re: Unable to query data from hdfs
Date Tue, 07 Apr 2015 22:15:08 GMT
Hello,

Can you please try the query as follows:

> select * from dfs.root.`/test.csv`;

Or
> use dfs.root;
> select * from `test.csv`;

Regards,
Abhishek

On Tue, Apr 7, 2015 at 3:02 PM, Sivasubramaniam, Latha <
Latha.Sivasubramaniam@aspect.com> wrote:

> Hi,
>
> I have the hdfs storage system registered, below is the storage plugin
> details, it got registered successfully.
>
>
> {
>   "type": "file",
>   "enabled": true,
>  "connection": "hdfs://<actualIP addr>:8020/",
>   "workspaces": {
>     "root": {
>       "location": "/user/root/",
>       "writable": true,
>       "defaultInputFormat": null
>     }
>   },
>   "formats": {
>     "parquet": {
>       "type": "parquet"
>     },
>     "csv": {
>       "type": "text",
>       "extensions": [
>         "csv"
>       ],
>       "delimiter": ","
>     }
>   }
> }
>
> I am able to list the files from the hdfs location, but when I query one
> of the file it gives an error. I tried different ways everything says "not
> found". Appreciate any help.
>
>
> 0: jdbc:drill:zk=rtr-poc-imp1:2181> show files;
>
> +------------+-------------+------------+------------+------------+------------+-------------+------------+------------------+
> |    name    | isDirectory |   isFile   |   length   |   owner    |
>  group    | permissions | accessTime | modificationTime |
>
> +------------+-------------+------------+------------+------------+------------+-------------+------------+------------------+
> | .Trash     | true        | false      | 0          | root       | root
>      | rwx------   | 1969-12-31 18:00:00.0 | 2015-04-01 19:00:00.253 |
> | .staging   | true        | false      | 0          | root       | root
>      | rwx------   | 1969-12-31 18:00:00.0 | 2015-03-31 15:18:52.599 |
> | DIM_Agent_Status | true        | false      | 0          | root       |
> root       | rwxr-xr-x   | 1969-12-31 18:00:00.0 | 2015-03-31 15:17:12.022 |
> | DIM_Agent_Status_Reasons | true        | false      | 0          | root
>      | root       | rwxr-xr-x   | 1969-12-31 18:00:00.0 | 2015-03-31
> 15:18:51.35 |
> | DIM_Agents | true        | false      | 0          | root       | root
>      | rwxr-xr-x   | 1969-12-31 18:00:00.0 | 2015-03-26 17:16:54.108 |
> | DIM_Call_Action_Reasons | true        | false      | 0          | root
>      | root       | rwxr-xr-x   | 1969-12-31 18:00:00.0 | 2015-03-31
> 15:16:04.684 |
> | DIM_Call_Actions | true        | false      | 0          | root       |
> root       | rwxr-xr-x   | 1969-12-31 18:00:00.0 | 2015-03-30 17:18:27.834 |
> | DIM_Call_Types | true        | false      | 0          | root       |
> root       | rwxr-xr-x   | 1969-12-31 18:00:00.0 | 2015-03-30 17:08:48.452 |
> | DIM_Dispositions | true        | false      | 0          | root       |
> root       | rwxr-xr-x   | 1969-12-31 18:00:00.0 | 2015-03-31 15:15:11.433 |
> | DIM_Resource_Groups | true        | false      | 0          | root
>  | root       | rwxr-xr-x   | 1969-12-31 18:00:00.0 | 2015-03-31
> 15:09:12.781 |
> | DIM_Services | true        | false      | 0          | root       |
> root       | rwxr-xr-x   | 1969-12-31 18:00:00.0 | 2015-03-30 17:15:47.463 |
> | DIM_Sites  | true        | false      | 0          | root       | root
>      | rwxr-xr-x   | 1969-12-31 18:00:00.0 | 2015-03-30 17:10:15.353 |
> | DIM_Workgroups | true        | false      | 0          | root       |
> root       | rwxr-xr-x   | 1969-12-31 18:00:00.0 | 2015-03-31 15:14:24.826 |
> | FACT_Agent_Activity_Detail_12M | true        | false      | 0          |
> root       | root       | rwxr-xr-x   | 1969-12-31 18:00:00.0 | 2015-03-31
> 00:42:54.38 |
> | FACT_Contact_Detail | true        | false      | 0          | root
>  | root       | rwxr-xr-x   | 1969-12-31 18:00:00.0 | 2015-03-27
> 00:22:36.465 |
> | FACT_Contact_Detail_12M | true        | false      | 0          | root
>      | root       | rwxr-xr-x   | 1969-12-31 18:00:00.0 | 2015-03-27
> 15:34:40.518 |
> | test.csv   | false       | true       | 17         | root       | root
>      | rw-r--r--   | 2015-04-07 15:37:13.469 | 2015-04-07 15:37:13.792 |
>
> +------------+-------------+------------+------------+------------+------------+-------------+------------+------------------+
> 17 rows selected (0.089 seconds)
> 0: jdbc:drill:zk=rtr-poc-imp1:2181> select * from root.`/test.csv`;
> Query failed: SqlValidatorException: Table 'root./test.csv' not found
>
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
> 0: jdbc:drill:zk=rtr-poc-imp1:2181>
>
> Thanks,
> Latha
> This email (including any attachments) is proprietary to Aspect Software,
> Inc. and may contain information that is confidential. If you have received
> this message in error, please do not read, copy or forward this message.
> Please notify the sender immediately, delete it from your system and
> destroy any copies. You may not further disclose or distribute this email
> or its attachments.
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message