Padma,
I have changed dfs storage plugin through web interface as below. But I am
getting same error response.
{
"type": "file",
"enabled": true,
"connection": "file:///",
"config": null,
"workspaces": {
"root": {
"location": "/",
"writable": true,
"defaultInputFormat": null,
"allowAccessOutsideWorkspace": true
},
"tmp": {
"location": "/tmp",
"writable": true,
"defaultInputFormat": null,
"allowAccessOutsideWorkspace": true
}
},
On Thu, Mar 1, 2018 at 1:15 PM, Padma Penumarthy <[email protected]>
wrote:
> 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:eaka
> [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:eaka
> [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:u
> [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
>
>
--
Erol Akarsu
