Some questions

[Rob Malko <rm...@homefinder.com>]

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!

Re: Some questions

[AnilKumar B <ak...@gmail.com>]

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 <ad...@gmail.com> 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 <rm...@homefinder.com> 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!
> >
>

Re: Some questions

[Aditya <ad...@gmail.com>]

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 <rm...@homefinder.com> 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!
>