drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Neeraja Rentachintala <nrentachint...@maprtech.com>
Subject Re: [Create view] Unable to create view. Schema [csvtest.default] is immutable.
Date Fri, 31 Oct 2014 13:33:52 GMT
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

Mime
View raw message