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.
