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]> 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]> > 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]> >> Sent: Thursday, March 1, 2018 5:28:52 AM >> To: [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
