Re: How could I get _id from MongoDB?

try this set store.mongo.bson.record.reader = false; On 12/08/2016 12:41 AM, Dana Jin wrote: Hello guys, I have a trouble to query to MongoDB using Drill, so I’d like to ask for some help. :) When I queried to drill like: SELECT _id FROM ……mongodb…… LIMIT 1; The result looks like:

HTTPD storage plugin

Hello I want to know how and where to configure HTTPD Storage plugin. How it working? Can i convert my IP address to location, country using httpd plugin. -- --- Thanks & Regards Sanjiv Kumar

How could I get _id from MongoDB?

Hello guys, I have a trouble to query to MongoDB using Drill, so I’d like to ask for some help. :) When I queried to drill like: SELECT _id FROM ……mongodb…… LIMIT 1; The result looks like: [cid:AF8CBBA2-744E-44C9-807A-D752D5461BEF] The value should be like ‘540f9b7eee6da146f690166c’ Could

Re: Exception : IndexOutOfBoundsException: index: 0, length: 264 - ... querying mongodb

I am not able to reproduce your issue at least with your one sample record, reproduce step: (1) from mongodb, display your sample record: >db.kath.find().pretty(); { "_id" : ObjectId("58402ad5757d7fede822e641"), "rule_list" : [ "x",

Re: Exception : IndexOutOfBoundsException: index: 0, length: 264 - ... querying mongodb

The length of utf8 encoded byte array is not guarantee to be the same as String.length(). A fix should be in BsonRecordReader.writeString(). On Wed, Dec 7, 2016 at 3:11 AM, yousuf wrote: > > Hi > > I'm currently exploring apache drill, running on a cluster mode. my >

Re: Batch load of unstructured data in Drill

Hi Stefán, Yes, thanks, I know about CTAS possibility and it works fine. And much faster then direct JSON read. I'm looking for possibility to load batch data from other sources. For example from Kafka Connect Sink module. On Wed, Dec 7, 2016 at 4:33 PM, Stefán Baxter

Re: Batch load of unstructured data in Drill

Hi Alexander, Drill allows you to both a) query the data directly in json format and b) convert it to Parqet (have a look at the CTAS function) Hope that helps, -Stefán On Wed, Dec 7, 2016 at 1:08 PM, Alexander Reshetov < alexander.v.reshe...@gmail.com> wrote: > Hello, > > I want to load

Re: how to use Drill as the OLAP tool in the data warehouse reporting app

(Also Alla, you should tell your webdevs that your companies website doesn't render properly on a 4k screen ;) ) On Wed, Dec 7, 2016 at 9:07 AM, Tom Barber wrote: > Not to suggest something silly, but having seen stuff like this 100's of > times... are you sure you're

Re: [1.9.0] : Error: SYSTEM ERROR: MalformedInputException: Input length = 1

Is your data the same on 1.6.0 and 1.9.0, or did your data change by any chance when/after upgrading from 1.6.0 to 1.9.0 ? On Wed, Dec 7, 2016 at 12:22 PM, Pratik Khedkar < pratik.khed...@games24x7.com> wrote: > Hi Team, > > I am getting below error after upgrading drill from 1.6 to 1.9. >

Re: how to use Drill as the OLAP tool in the data warehouse reporting app

Not to suggest something silly, but having seen stuff like this 100's of times... are you sure you're not over engineering the solution because its hipster not because its actually the best way to do things? :) Cheers Tom On Wed, Dec 7, 2016 at 7:29 AM, WeiWan wrote: > Hi