Somehow, after "user dfs.tmp", I was able to create view. But "describe" for view does not give much information. I was expecting "describe" command would give type definitions of fields " employee_id | full_name | first_name | last_name | position_id | position_title | store_id | depart ". But it does give a very generic field type.
0: jdbc:drill:zk=local> create view mydonuts2 as SELECT * FROM cp.`employee.json` LIMIT 3; +-------+------------------------------------------------------------+ | ok | summary | +-------+------------------------------------------------------------+ | true | View 'mydonuts2' created successfully in 'dfs.tmp' schema | +-------+------------------------------------------------------------+ 1 row selected (0.283 seconds) 0: jdbc:drill:zk=local> describe mydonuts2; +--------------+------------+--------------+ | COLUMN_NAME | DATA_TYPE | IS_NULLABLE | +--------------+------------+--------------+ | * | ANY | YES | +--------------+------------+--------------+ 1 row selected (0.388 seconds) 0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` LIMIT 3; +--------------+------------------+-------------+------------+--------------+---------------------+-----------+--------+ | employee_id | full_name | first_name | last_name | position_id | position_title | store_id | depart | +--------------+------------------+-------------+------------+--------------+---------------------+-----------+--------+ | 1 | Sheri Nowmer | Sheri | Nowmer | 1 | President | 0 | 1 | | 2 | Derrick Whelply | Derrick | Whelply | 2 | VP Country Manager | 0 | 1 | | 4 | Michael Spence | Michael | Spence | 2 | VP Country Manager | 0 | 1 | +--------------+------------------+-------------+------------+--------------+---------------------+-----------+--------+ 3 rows selected (0.579 seconds) On Thu, Mar 1, 2018 at 3:18 PM, Erol Akarsu <eaka...@gmail.com> wrote: > Padma, > > I have not created any user. I just installed the system and run drill > with "sqlline.bat -u "jdbc:drill:zk=local" > Therefore, what is shortest procedure to achieve what you have described > in previous email? > > Thanks > > Erol Akarsu > > On Thu, Mar 1, 2018 at 3:00 PM, Padma Penumarthy <ppenumar...@mapr.com> > wrote: > >> 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 >> r...@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 >> r...@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 >> r...@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:u >> s...@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 >> >> > > > -- > > Erol Akarsu > > -- Erol Akarsu