ElasticSearch via sql4es (JDBC)

2017-10-23 Thread Charuta Rajopadhye
Hi Team, I am trying to connect to ElasticSearch via Drill. Came across this , but the work seems to be in progress. So i tried using JDBC storage plugin for ElasticSearch, and used sql4es jar for the same. But

Re: Newbie: Join queries in MySQL.

2017-10-15 Thread Charuta Rajopadhye
age- > From: Charuta Rajopadhye [mailto:charuta...@gmail.com] > Sent: Thursday, October 12, 2017 11:28 PM > To: dev@drill.apache.org > Subject: Re: Newbie: Join queries in MySQL. > > Hi Timothy, > > Thank you very much for your reply. > > Regards, > Charuta > >

Re: Newbie: Join queries in MySQL.

2017-10-12 Thread Charuta Rajopadhye
andwidth to pick them up? > > Thanks, > Tim > > ____ > From: Charuta Rajopadhye > Sent: Thursday, October 12, 2017 2:16:10 AM > To: dev@drill.apache.org > Subject: Newbie: Join queries in MySQL. > > Hi Team, > > > I have created a configurat

Newbie: Join queries in MySQL.

2017-10-12 Thread Charuta Rajopadhye
Hi Team, I have created a configuration for JDBC storage plugin in Drill, for a MySQL database. I am trying to fire join query on 2 tables. Both my tables have a column called 'id'/ Table defination: CREATE TABLE `simpleone` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, P

Resolving Maps in RecordReader

2017-10-04 Thread Charuta Rajopadhye
Hi Team, I am trying to implement storage plugin for a custom database. It supports objects, as datatype. As it uses Postgres JDBC driver, i am using the JDBC storage plugin for reference. In the RecordReader, for the datatype JAVA_OBJECT, i convert it into a string and pass it to the VarChar Copi

Resolving object type using ObjectVector

2017-09-14 Thread Charuta Rajopadhye
Hi Team, I am trying to implement a storage plugin for my database (it supports Postgres JDBC driver) and can store compound objects. I am able to parse primary objects in my RecordReader, but for object types: I create Copier of ObjectVector type, and have overridden it's copy method: private cl

Custom storage plugin for DB supporting PostgreSQL JDBC driver.

2017-09-07 Thread Charuta Rajopadhye
Hi Team, I am trying to develop a storage plugin for a database that supports JDBC PostgreSQL driver. Directly using the JDBC storage plugin does not work for my cause because, my database supports dynamic (objects) datatype, that JDBC storage plugin does not handle. In order to remedy this, i thi

Re: Custom extension storage plugin development

2017-08-29 Thread Charuta Rajopadhye
> > <https://github.com/paul-rogers/drill/wiki/Storage- > Plugin-Runtime-Interface> > > can give you the overview you are looking for ? May be you can start with > > asking specific questions. > > > > Thanks, > > Gelbana > > > > On Tue, Aug 29,

Custom extension storage plugin development

2017-08-29 Thread Charuta Rajopadhye
Hi Team, I need to develop an extension storage plugin for my data source. I have been through this and Apache Drill's documentation but did not fin

crateDB via Apache Drill

2017-08-22 Thread Charuta Rajopadhye
let me know if i am on the right track or it has to be something else altogether. Thanks and Regards, Charuta Rajopadhye