Can you give re storage engine configuration you are using for the csv.default.
> On Oct 30, 2014, at 9:48 AM, Sean Hsuan-Yi Chu <hsuanyichu@gmail.com> 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
|