I hit that same issue many times but the problem resolved after I upgraded to a pre release of Drill 1.2
On Thu, Oct 15, 2015 at 9:21 AM, Jacques Nadeau <[email protected]> wrote: > I believe that this error is due to an incompatibility between Mongo's > Extended JSON support and Drill's extended JSON support that is fixed in > 1.2 (release imminent e.g. next 24-48 hours). If you want to try out the > fix immediately, you would need to grab the master branch of Drill and > build it yourself. > > > > -- > Jacques Nadeau > CTO and Co-Founder, Dremio > > On Thu, Oct 15, 2015 at 6:35 AM, Mangold, James < > [email protected]> wrote: > > > Hi, > > > > I am trying to query a collection in mongo directly, using this query: > > > > select * from mongo.omegatestbed.testshard4 where ENTITY_ID = 1216515 > > limit 1; > > > > ENTITY_ID is indexed, ascending. The columns in the collection may have > > differing data types for the same column name. I get this error: > > > > > > > > Error: SYSTEM ERROR: JsonParseException: Failure while reading > > ExtendedJSON typed value. Expected a VALUE_NUMBER_INT but received a > token > > of type VALUE_STRING > > at [Source: > org.apache.drill.exec.vector.complex.fn.SeekableBAIS@74ad855e > > <mailto:org.apache.drill.exec.vector.complex.fn.SeekableBAIS@74ad855e>; > > line: 1, column: 36] > > > > Fragment 1:48 > > > > I did run alter system set `store.mongo.all_text_mode` = true prior to > > doing this. > > > > > > > > I have no idea what's wrong or how to query this data. Even worse is that > > I said limit 1. I wouldn't think it would get any other rows. > > > > > > > > Thanks, > > > > James Mangold > > > > Interactive Data > > > > [email protected]<mailto: > [email protected] > > > > > > > > > ******************************************************* > > This message (including any files transmitted with it) may contain > > confidential and/or proprietary information, is the property of > Interactive > > Data Corporation and/or its subsidiaries, and is directed only to the > > addressee(s). If you are not the designated recipient or have reason to > > believe you received this message in error, please delete this message > from > > your system and notify the sender immediately. An unintended recipient's > > disclosure, copying, distribution, or use of this message or any > > attachments is prohibited and may be unlawful. > > ******************************************************* > > >
