drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From AnilKumar B <akumarb2...@gmail.com>
Subject Re: Some questions
Date Tue, 07 Oct 2014 09:21:30 GMT
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 <adityakishore@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 <rmalko@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!
> >
>

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