Looks like this might not be possible. I gave it a try and could only query files/folders within the bucket, but not the bucket itself directly.
Also, I couldn't get workspaces to work (like with DFS). I had to provide the path to the object (relative to the bucket). We should document this. On Sat, Apr 15, 2017 at 3:42 PM Alon Principal <[email protected]> wrote: > Hi, > > What's the right syntax to query an S3 bucket root directory with Drill? > > For example, my bucket: > /a/file1.json > /b/file2.json > /c/file3.json > > and I'd like to do something like that: Select * from s3.`root`; and that > it'll return the contents of file1.json+file2.json+file3.json. > > Thanks! > >
