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]> wrote: > Try creating a view and use describe. > > https://drill.apache.org/docs/describe/ > > Thanks > Padma > > > On Mar 1, 2018, at 9:22 AM, Erol Akarsu <[email protected]<mailto:eaka > [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]>> 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]>> > 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]>> > Sent: Thursday, March 1, 2018 5:28:52 AM > To: [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
