I just used the syntax straight from the docs site:
https://cwiki.apache.org/confluence/display/DRILL/CREATE+TABLE+AS+%28CTAS%29+Command
 I tried all the different use cases.

On Tue, Oct 7, 2014 at 2:07 PM, Neeraja Rentachintala <
[email protected]> wrote:

> can you send the CTAS syntax you used here.
>
> On Tue, Oct 7, 2014 at 5:25 AM, Robert Malko (JIRA) <[email protected]>
> wrote:
>
> > Robert Malko created DRILL-1503:
> > -----------------------------------
> >
> >              Summary: CTAS does not work against mongo plugin
> >                  Key: DRILL-1503
> >                  URL: https://issues.apache.org/jira/browse/DRILL-1503
> >              Project: Apache Drill
> >           Issue Type: Bug
> >     Affects Versions: 0.6.0
> >             Reporter: Robert Malko
> >             Priority: Minor
> >
> >
> > Just putting in another ticket here as per the drill-user mailing list
> > question.  When using CTAS on a mongo query, I receive "Error: Current
> > schema is not a Drill schema. Can't create new relations (tables or
> views)
> > in non-Drill schemas.".
> >
> > Thanks!
> >
> >
> >
> > --
> > This message was sent by Atlassian JIRA
> > (v6.3.4#6332)
> >
>

Reply via email to