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:[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
