Does Drill support Full-text search as in Elasticsearch

[Ayush Pandey <ay...@gmail.com>]

Hello everyone,
I am trying to benchmark Apache Drill Vs Elastic Search. The first question that I am trying to answer is: Whether Apache Drill supports Full-Text search as is the case with Elasticsearch.

I have dumped data in Drill in Apache Parquet format.

Re: Does Drill support Full-text search as in Elasticsearch

[Saurabh Mahapatra <sa...@gmail.com>]

Hey Ayush,

Just to add to what Aman said: I think the request that I have heard is a
SQL interface to Elasticsearch especially when you are joining result with
another data source like a RDMBS. Is that what you are trying to
accomplish? But the guts of the technology i.e. indexing, search, sharding
etc. is different.

Nice to see a IIT KGP email in the thread. Welcome. Are you using this for
a project at the insti?:)

Saurabh

On Wed, Dec 6, 2017 at 4:09 PM, Aman Sinha <am...@apache.org> wrote:

> Hi,
> no, currently Drill does not support full-text search and it is unlikely it
> will do so natively in the near future.  Instead, since other products such
> as Elasticsearch are specialized for it, it would be better to add ES
> storage plugins in Drill to push down such full-text search filters into
> ES.  There was some effort in the past by the community to develop that but
> it did not make it into the product.
>
> -Aman
>
> On Tue, Dec 5, 2017 at 5:08 AM, Ayush Pandey <ayushpandey.iitkgp@gmail.com
> >
> wrote:
>
> > Hello everyone,
> > I am trying to benchmark Apache Drill Vs Elastic Search. The first
> > question that I am trying to answer is: Whether Apache Drill supports
> > Full-Text search as is the case with Elasticsearch.
> >
> > I have dumped data in Drill in Apache Parquet format.
>

Re: Does Drill support Full-text search as in Elasticsearch

[Aman Sinha <am...@apache.org>]

Hi,
no, currently Drill does not support full-text search and it is unlikely it
will do so natively in the near future.  Instead, since other products such
as Elasticsearch are specialized for it, it would be better to add ES
storage plugins in Drill to push down such full-text search filters into
ES.  There was some effort in the past by the community to develop that but
it did not make it into the product.

-Aman

On Tue, Dec 5, 2017 at 5:08 AM, Ayush Pandey <ay...@gmail.com>
wrote:

> Hello everyone,
> I am trying to benchmark Apache Drill Vs Elastic Search. The first
> question that I am trying to answer is: Whether Apache Drill supports
> Full-Text search as is the case with Elasticsearch.
>
> I have dumped data in Drill in Apache Parquet format.