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 <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[email protected]><mailto:eaka [email protected]<mailto:[email protected]>>> 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 <[email protected]<mailto:[email protected]><mailto: [email protected]<mailto:[email protected]>>> 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 <[email protected]<mailto:[email protected]> <mailto:[email protected]>> wrote: Hi Erol, You can run limit 0 query from client to retrieve just the schema for your input. Thanks, Sorabh ________________________________ From: Erol Akarsu <[email protected]<mailto:[email protected]><mailto:[email protected]>> Sent: Thursday, March 1, 2018 5:28:52 AM To: [email protected]<mailto:[email protected]><mailto:[email protected]> 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
