No i haven't. I'll give that a try. Thanks.
________________________________ Scott Kinney | DevOps stem | m 510.282.1299 100 Rollins Road, Millbrae, California 94030 This e-mail and/or any attachments contain Stem, Inc. confidential and proprietary information and material for the sole use of the intended recipient(s). Any review, use or distribution that has not been expressly authorized by Stem, Inc. is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies. Thank you. ________________________________________ From: rahul 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, Jul 11, 2016 at 3:23 PM, Scott Kinney <scott.kin...@stem.com> wrote: > 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 have out data in s3 in a name/year/month/day and I dont want to have > to put this schema file in every directory is s3. that seems unmanageable. > > > Is there a way to set the schema from a file before making a query via the > REST api? > > > > ________________________________ > Scott Kinney | DevOps > stem <http://www.stem.com/> | m 510.282.1299 > 100 Rollins Road, Millbrae, California 94030 > > This e-mail and/or any attachments contain Stem, Inc. confidential and > proprietary information and material for the sole use of the intended > recipient(s). Any review, use or distribution that has not been expressly > authorized by Stem, Inc. is strictly prohibited. If you are not the > intended recipient, please contact the sender and delete all copies. Thank > you. >