Re: Accessing underlying scheme of input

[Padma Penumarthy]

Check if you have permissions to root directory or not.
You may have to specify the complete directory path (for which you have 
permissions for) in the create view command.

For example:

0: jdbc:drill:zk=local> create view 
dfs.root.`/Users/ppenumarthy/parquet/test-view` as select * from 
dfs.root.`/Users/ppenumarthy/parquet/0_0_0.parquet`;
+-------+----------------------------------------------------------------------------------------+
|  ok   |                                        summary                        
                 |
+-------+----------------------------------------------------------------------------------------+
| true  | View '/Users/ppenumarthy/parquet/test-view' created successfully in 
'dfs.root' schema  |
+-------+----------------------------------------------------------------------------------------+
1 row selected (0.148 seconds)
0: jdbc:drill:zk=local>


Thanks
Padma

On Mar 1, 2018, at 11:37 AM, Erol Akarsu 
<eaka...@gmail.com<mailto:eaka...@gmail.com>> wrote:

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 
<ppenumar...@mapr.com<mailto:ppenumar...@mapr.com>>
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 
<eaka...@gmail.com<mailto:eaka...@gmail.com><mailto:eaka
r...@gmail.com<mailto:r...@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>
<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>><mailto:eaka
r...@gmail.com<mailto: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>><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>
<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><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><mailto:u
s...@drill.apache.org<mailto:s...@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




--

Erol Akarsu