Hey Alok, I'm not sure if that's possible with Object stores like S3. I'll let others comment. But you could file a JIRA requesting ability to query buckets directly.
-Abhishek On Mon, Apr 17, 2017 at 7:10 AM Alon Principal <[email protected]> wrote: > Hi Abhishek, > > Do you think it is going to be solved in the next versions? > > > -----Original Message----- > From: Abhishek Girish [mailto:[email protected]] > Sent: Sunday, April 16, 2017 02:21 > To: [email protected] > Subject: Re: querying S3 bucket root dir > > 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! > > > > >
