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 <[email protected]>: > 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 >
