drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Magesh Waran <mageshwa...@gmail.com>
Subject Issue Drill querying S3 recursive
Date Thu, 12 Jan 2017 14:31:22 GMT
Hi Team,

I am trying to query a file under folder 't/atms-csv.csv' which I can
successfully do it.

[image: Inline image 1]


There is another file in that location which as additional data from
another day (both file columnmodel). when I try query recursively using
folder name 't' which shows below error
[image: Inline image 2]
*Tried queries (All doesnt worked out):*
1. select * from `t/`;
2. select * from `/t/`;
3. select * from dfs.`t/`;
4. select * from dfs`/t/`;
5. select * from fs.`t/`;
6. select * from fs`/t/`;


I am using below versions,
*Drill - 1.6.0*
*S3 protool: S3n (also tried S3, S3a)*
*Sample Query String:*
 {
 "connection": "s3a://xxxxx-bucket",
  "config": {
    "fs.s3a.access.key": "xxxxxxxxxxxxxxxxxxxxxxxxxxxx",
    "fs.s3a.secret.key": "xxxxxxxxxxxxxxxxxxxxxxxxxxxx"
  },
  "workspaces": {
    "root": {
      "location": "/",
      "writable": true,
      "defaultInputFormat": null
    }
}


Thanks & Regards
Mageshwaran M
Contact: +91-9944667832

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