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


Reply via email to