Re: Best way to set schema to handle different json structures

2016-07-11 Thread Scott Kinney
challapalli <challapallira...@gmail.com> Sent: Monday, July 11, 2016 3:51 PM To: user Subject: Re: Best way to set schema to handle different json structures Did you try creating a view with the merged schema? Then you can try running all your queries on top of that view. - Rahul On Mon,

Re: Best way to set schema to handle different json structures

2016-07-11 Thread rahul challapalli
Did you try creating a view with the merged schema? Then you can try running all your queries on top of that view. - Rahul On Mon, Jul 11, 2016 at 3:23 PM, Scott Kinney wrote: > We have several different json structures we want to run queries across. I > can take a

Best way to set schema to handle different json structures

2016-07-11 Thread Scott Kinney
We have several different json structures we want to run queries across. I can take a sample of each and merge the json together as python dictionaries then write that out to a file and have drill read that file first to set the schema but I dont think this will be very practical as we will