It's true that you need to query CSV files in that way, but the error here just means that the workspace you are using is defined as immutable (cannot be written to).
See the CREATE VIEW command section in the tutorial: https://cwiki.apache.org/confluence/display/DRILL/Lesson+2%3A+Run+Queries+with+ANSI+SQL On Fri, Oct 31, 2014 at 6:13 AM, Christopher Matta <[email protected]> wrote: > When querying a CSV/TSV/PSV document each row is returned as an array. You > have to give meaning to the columns by casting them: > > SELECT CAST(columns[0] as INT) as `id`, CAST(columns[1] as > VARCHAR(128)) as `play` FROM `plays.csv`; > > > > Chris Matta > [email protected] > 215-701-3146 > > On Thu, Oct 30, 2014 at 12:48 PM, Sean Hsuan-Yi Chu <[email protected]> > 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 > > >
