drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Sun <j...@maprtech.com>
Subject Re: [Create view] Unable to create view. Schema [csvtest.default] is immutable.
Date Fri, 31 Oct 2014 18:30:45 GMT
You may want to make the "writable" attribute true in your schema:

  "writable": true

Thanks

-James

On 10/30/14, 9:48 AM, Sean Hsuan-Yi Chu wrote:
> 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
View raw message