As John hinted, a session is not maintained by the UI/REST api unless impersonation is enabled. So your alter session commands will have no effect on the query. That does not explain why you are not getting full results though. Is it possible that the query is getting an error because your session options are not taking effect and that error is not being reported correctly. I'm speculating that this might be a case that there are partial results that are returned, then the query hits a schema change exception (because maybe all text mode is not enabled) and that is causing early termination of the query.
On Fri, Jul 1, 2016 at 4:23 PM, Scott Kinney <[email protected]> wrote: > Not that I know of but I'm new to drill. > I've done 'alter system' for json all_text_mode & read_numbers_as_double. > Do you know of a setting that might cause something like this? > > ________________________________ > 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: John Omernik <[email protected]> > Sent: Friday, July 01, 2016 4:06 PM > To: [email protected] > Subject: Re: missing data in json structure when using web / api > > Are you using options that are maintained in the cli but not the rest API > due to a lack of impersonation? > > On Friday, July 1, 2016, Scott Kinney <[email protected]> wrote: > > > When i query from sqlline i can see all the data, very complicated / > > nested json structure but when i query with the api or the web ui a lot > of > > the data is missing. > > > > ? > > > > > > ________________________________ > > 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. > > > > > -- > Sent from my iThing >
