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. >