Hi Rob & Aditya, We are looking into auth issue ( https://issues.apache.org/jira/browse/DRILL-1502). We will also look into this CTAS issue.
Thanks & Regards, B Anil Kumar. On Tue, Oct 7, 2014 at 1:55 PM, Aditya <[email protected]> wrote: > Welcome Rob! > > Both of the issues that you are hitting seems to be bugs in the MongoDB > storage plugin. > I see that you have already created JIRA for the first one. Would you mind > creating a > second one for the CTAS issue with the example query you're trying? > > And for your second question, Drill currently does not support querying > data from an RDBMS, > however we do plan to build that support through a JDBC storage plugin [1]. > > [1] https://issues.apache.org/jira/browse/DRILL-105 > > On Mon, Oct 6, 2014 at 5:02 PM, Rob Malko <[email protected]> wrote: > > > First time Drill User and absolutely loving it. > > > > First off, I've been playing around with the latest 0.6 build, to try out > > the mongo integration, and can't quite figure out how to get connected > to a > > mongo instance that requires auth. I tried the usual > > mongodb://user:pass@host:port/ but that didn't seem to work. > > > > Second: Is there a way to also use Drill to query a normal sql database > > like postgres? Let's say I have some json files, mongo db records, some > > stuff in hdfs, and would like to do some joins against something that we > > may have in postgres. Doable? > > > > Lastly, I was trying to use the Create Table As (CTAS) command with a > > mongodb query but it didn't seem to like it "Error: Current schema is > not a > > Drill schema. Can't create new relations (tables or views) in non-Drill > > schemas." Is that something that's supported? > > > > Thanks! > > >
