I'm continuing exploration of accessing files on S3, and running into this
issue:
0: jdbc:drill:> *SELECT COUNT(1) FROM
s3n.root.`/dev/dan/cleaned_1210/clean.txt`;*
*Query failed: Query failed: Failure validating SQL.
org.eigenbase.util.EigenbaseContextException: From line 1, column 22 to
line 1, column 24: Table 's3n.root./dev/dan/cleaned_1210/clean.txt' not
found*

*Error: exception while executing query: Failure while executing query.
(state=,code=0)*

At the same time:
0: jdbc:drill:> *show files from s3n.`dev/dan/cleaned_1210/clean.txt`;*
*+------------+-------------+------------+------------+------------+------------+-------------+------------+------------------+*
*|    name    | isDirectory |   isFile   |   length   |   owner    |
group    | permissions | accessTime | modificationTime |*
*+------------+-------------+------------+------------+------------+------------+-------------+------------+------------------+*
*| clean.txt  | false       | true       | 1313500    |            |
     | rw-rw-rw-   | 1970-01-01 00:00:00.0 | 2014-12-10 23:51:59.0 |*
*+------------+-------------+------------+------------+------------+------------+-------------+------------+------------------+*
*1 row selected (0.53 seconds)*

My storage config is below. Any suggestions on what could be wrong, or how
to debug this error?

{
  "type": "file",
  "enabled": true,
  "connection": "s3n://bucket-name",
  "workspaces": {
    "root": {
      "location": "/",
      "writable": false,
      "defaultInputFormat": null
    },
    "tmp": {
      "location": "file:///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"
    }
  }
}

Reply via email to