Yep, I didn't set the workspace 'writable': true user error as usual ________________________________ Scott Kinney | DevOps stem | m 510.282.1299 100 Rollins Road, Millbrae, California 94030
This e-mail and/or any attachments contain Stem, Inc. confidential and proprietary information and material for the sole use of the intended recipient(s). Any review, use or distribution that has not been expressly authorized by Stem, Inc. is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies. Thank you. ________________________________________ From: Abhishek Girish <[email protected]> Sent: Wednesday, July 20, 2016 8:49 AM To: Drill User List Subject: Re: Error creating view Can you change the workspace to one where you would like the view to be created in? For example, you could say `use dfsl.tmp;` followed by your create view command. The error here says that the dfsl.default workspace is not writable. On Wed, Jul 20, 2016 at 8:27 AM, Scott Kinney <[email protected]> wrote: > I'm trying to create a view with this command: > > > create view dfsl.smiview as select * from dfsl.`/path/to/view.json`; > > ? > Error: PARSE ERROR: Unable to create or drop tables/views. Schema [dfsl] > is immutable. > > > [Error Id: da4ae9f6-016a-487a-a85d-7297d9e22187 on ops-apachedrill:31010] > (state=,code=0) > > > dfsl is just a copy of the default dfs storage plugin. > > > > > ________________________________ > Scott Kinney | DevOps > stem <http://www.stem.com/> | m 510.282.1299 > 100 Rollins Road, Millbrae, California 94030 > > This e-mail and/or any attachments contain Stem, Inc. confidential and > proprietary information and material for the sole use of the intended > recipient(s). Any review, use or distribution that has not been expressly > authorized by Stem, Inc. is strictly prohibited. If you are not the > intended recipient, please contact the sender and delete all copies. Thank > you. >
