Make "writable": true for the workspace (dfs.root) in the storage plugin configuration.
Thanks Padma On Mar 1, 2018, at 10:10 AM, Erol Akarsu <eaka...@gmail.com<mailto:eaka...@gmail.com>> wrote: Thanks Padma. I am getting problem while creating view 0: jdbc:drill:zk=local> create view mydonuts as SELECT * FROM cp.`employee.json` LIMIT 3; Error: VALIDATION ERROR: Root schema is immutable. Creating or dropping tables/views is not allowed in root schema.Select a schema using 'USE schema' command. [Error Id: 68a31047-5a4e-4768-8722-55648d9a80f6 on DESKTOP-8OANV3A:31010] (state=,code=0) 0: jdbc:drill:zk=local> On Thu, Mar 1, 2018 at 12:49 PM, Padma Penumarthy <ppenumar...@mapr.com<mailto:ppenumar...@mapr.com>> wrote: Try creating a view and use describe. https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_docs_describe_&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=XVqW14B9eGK9QR_fKKCb5H5LxKnqNMmq1U7RdNlhq1c&m=blTmu-WQJa5RUrxqG46o20B-a-UP0yCHKGqcBo1ETlI&s=SxKqC4w_I5bbnNAtIvzO_9qptLP-KsHi0iIbjtzyrc8&e= Thanks Padma On Mar 1, 2018, at 9:22 AM, Erol Akarsu <eaka...@gmail.com<mailto:eaka...@gmail.com><mailto:eaka r...@gmail.com<mailto:r...@gmail.com>>> wrote: When Use limit 0 query, I am getting only field names. I am looking for json schema for input that will describe input type 0: jdbc:drill:> select * from `clicks/clicks.json` limit 0; +-----------+-------+-------+------------+-------------+ | trans_id | date | time | user_info | trans_info | +-----------+-------+-------+------------+-------------+ +-----------+-------+-------+------------+-------------+ No On Thu, Mar 1, 2018 at 11:24 AM, Erol Akarsu <eaka...@gmail.com<mailto:eaka...@gmail.com><mailto: eaka...@gmail.com<mailto:eaka...@gmail.com>>> wrote: I am sorry Sorabh Can you give an example? I am still learning Drill Thanks On Thu, Mar 1, 2018 at 11:11 AM Sorabh Hamirwasia <shamirwa...@mapr.com<mailto:shamirwa...@mapr.com> <mailto:shamirwa...@mapr.com>> wrote: Hi Erol, You can run limit 0 query from client to retrieve just the schema for your input. Thanks, Sorabh ________________________________ From: Erol Akarsu <eaka...@gmail.com<mailto:eaka...@gmail.com><mailto:eaka...@gmail.com>> Sent: Thursday, March 1, 2018 5:28:52 AM To: user@drill.apache.org<mailto:user@drill.apache.org><mailto:user@drill.apache.org> Subject: Accessing underlying scheme of input I know Apache drill is creating a json schema for input data file or hdfs input before user query on it. I like to know whether or not Apache drill has API that will help user to obtain that derived schema for say an json file or excel file or hive input. I appreciate your help Erol Akarsu Sent from Mail for Windows 10 -- Erol Akarsu -- Erol Akarsu -- Erol Akarsu