Hi, and thanks for understanding if I'm making some rookie mistakes here.
My top-level message is that I get the following error while querying from
MongoDB's sample database using Drill 1.2 (pulled and built this afternoon):

0: jdbc:drill:zk=local> select * from mongo.test.restaurants ;
Error: DATA_READ ERROR: Failure while reading ExtendedJSON typed value.
Expected a VALUE_STRING but received a token of
type VALUE_NUMBER_INT
 at [Source: org.apache.drill.exec.vector.complex.fn.SeekableBAIS@22692b36;
line: 1, column: 223]

Line  1
Column  224
Field  date
Fragment 0:0

I have loaded and successfully queried some data of my own from MongoDB
thru Drill, after enabling the Mongo storage plugin via the web client, so
I'm satisfied that the systems talk to each other. Often, sample databases
are frequently exercised so I thought this would be a tested/supported case.

Platform particulars:


   - Windows7 Pro SP1 x64, 16GB RAM
   - Drill 1.2 master (commit 48d8a59d1b97988c006f85daad0ae2fcb3a9cd06)
   - Built with JDK 1.7.0_55
   - Running under JDK 1.8.0_45
   - MongoDB v3.0.4 (downloaded and installed today  not built from source)


The mongo database was loaded via the instructions found at
https://docs.mongodb.org/getting-started/shell/import-data/

Apologies that my first message to this group was an issue. With a little
more setup and digging, I might be able to fix it myself.

Thanks,

George Spofford

Reply via email to