drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sean Hsuan-Yi Chu <hsuanyi...@gmail.com>
Subject Re: [Create view] Unable to create view. Schema [csvtest.default] is immutable.
Date Thu, 30 Oct 2014 17:09:52 GMT
Hi,
I figured out :
Just change "writable" in your configuration to true

ref:
https://cwiki.apache.org/confluence/display/DRILL/CREATE+TABLE+AS+(CTAS)+Command


2014-10-30 9:48 GMT-07:00 Sean Hsuan-Yi Chu <hsuanyichu@gmail.com>:

> Hi,
>
> I am trying to create a view from a table which looks like below:
>
> 0: jdbc:drill:zk=local> select * from `plays.csv`;
>
> +------------+
>
> |  columns   |
>
> +------------+
>
> | ["1599","As You Like It"] |
>
> | ["1601","Twelfth Night"] |
>
> | ["1594","Comedy of Errors"] |
>
> | ["1595","Romeo and Juliet"] |
>
> | ["1596","The Merchant of Venice"] |
>
> | ["1610","The Tempest"] |
>
> | ["1599","Hamlet"] |
>
> +------------+
>
>
> But it returns:
>
>
> 0: jdbc:drill:zk=local> create view viewZZZ AS
>
> . . . . . . . . . . . > select * from `plays.csv`;
>
> +------------+------------+
>
> |     ok     |  summary   |
>
> +------------+------------+
>
> | false      | Unable to create view. Schema [csvtest.default] is
> immutable.  |
>
> +------------+------------+
>
>
> Can anybody tell me what's wrong here???
>
>
> Thanks
>

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