Unknown Host Name issue

HI All I am facing following issue when I am trying to query alluxio deployed in docker having host name from Drill. Scenario is as follows . Docker has been started with hostname tomcat on machine xyz.us.abc.com . Alluxio has been started inside this docker and alluxio

RE: Issue in executing query on Drill Cluster

in both cases, (i) in embedded mode, and (ii) in the 4 node Drillbit cluster ? Thanks, Khurram From: Chetan Kothari mailto:chetan.koth...@oracle.com"chetan.koth...@oracle.com> Sent: Tuesday, October 17, 2017 9:43:42 PM To: HYPERLINK &quo

RE: Predicate Pushdown in Drill

. Thanks. --Robert From: Chetan Kothari mailto:chetan.koth...@oracle.com"chetan.koth...@oracle.com> Sent: Tuesday, October 17, 2017 7:28 AM To: HYPERLINK "mailto:user@drill.apache.org"user@drill.apache.org Subject: RE: Predicate

Issue in executing query on Drill Cluster

HI All When I am firing following query against dataset present in alluxio from embedded-drill, it is working normally. select REQ_HIST_REQUISITION_NUMBER, CONVERT_FROM(REQ_HIST_CREATION_DATE,'UTF8') AS REQ_HIST_CREATION_DATE , CONVERT_FROM(REQ_HIST_END_DATE,'UTF8') AS

RE: Predicate Pushdown in Drill

Hi All Any inputs on following query? Regards Chetan -Original Message- From: Chetan Kothari Sent: Monday, October 16, 2017 9:07 AM To: user@drill.apache.org Subject: Predicate Pushdown in Drill Does Drill support predicate pushdown when executing join queries against

Predicate Pushdown in Drill

Does Drill support predicate pushdown when executing join queries against single datastore or against multiple federated datastores? If yes, can you share more inputs on how Drill supports Predicate Pushdown for inner join, outer join and self-join queries. Regards Chetan

RE: Access to Drill 1.9.0

avoid such errors. I wonder if someone familiar with the Alluxio client might be able to comment on how best to manage their dependency…- Paul > On Oct 7, 2017, at 12:00 AM, Chetan Kothari <chetan.koth...@oracle.com> wrote:> > I am getting following error when I am trying to integrat

RE: Access to Drill 1.9.0

bK10=XdafK486-x96ZJoTcDF35EpcYc2j9nO0sbpt27_VGCg=zUOB0RDFLKJDe0b0M9qP85NUhoxLbCW6QCJBWyJl4L8=Ht1E8ZGR16aJBKcI3ILJGdXrOTAZuAIC6YfBrM09cfk= > Best regards, Rob > On Oct 6, 2017, at 10:28 PM, Chetan Kothari <chetan.koth...@oracle.com> wrote: > > I am not able to download Apache Drill

Access to Drill 1.9.0

I am not able to download Apache Drill 1.9.0 from Drill Site. https://drill.apache.org/download/ Any inputs on how to get binaries of Drill 1.9.0 Regards Chetan

Issue in queying file present in swift compliant object storage

I have registered plug-in to connect to container of Oracle Storage Cloud Service using Swift library. I am able to query files present in top level in container of Oracle Storage Cloud Service. For example - oscs.`select * from test_tsv` ( test_tsv is file present as objet in container I

Drill with Alluxio

I am facing problem while running use alluxio query after configuring alluxio with Drill. I am not able to connect to alluxio due to java.io.IOException: Frame size (67108864) larger than max length (16777216)!   Any input on this will be useful.   Error Id:

RE: Best way to partition the data

I am facing problem while running use alluxio query after configuring alluxio with Drill. I am not able to connect to alluxio due to java.io.IOException: Frame size (67108864) larger than max length (16777216)!   Any input on this will be useful.   Error Id:

RE: Querying Streaming Data using Drill

IBaQ=RoP1YumCXCgaWHvlZYR8PQcxBKCX5YTpkKY057SbK10=XdafK486-x96ZJoTcDF35EpcYc2j9nO0sbpt27_VGCg=_sbH_Ztnc2gGMatSIcqTEJ5Oy1A4Q6mDnQPvVOCqwhg=13f8RiuuC2F7dMIIuzBERWl6jIjmZuMu-X9SnCVxNP4=         Thanks & Regards, B Anil Kumar.   On Tue, Aug 29, 2017 at 10:26 AM, Chetan Kothari mailto:chetan.koth...@or

RE: Querying Streaming Data using Drill

=UCGsbhOa9QLDAmUEfJYiq_cOfGg5dUi1RdcPB7YTMMQ= Thanks, Padma On Aug 29, 2017, at 10:14 AM, Chetan Kothari mailto:chetan.koth...@oracle.com%3cmailto:chetan.koth...@oracle.com"chetan.koth...@oracle.com<mailto:chetan.koth...@oracle.com>> wrote: Is there any support for quer

Querying Streaming Data using Drill

Is there any support for querying streaming data using Drill? Presto provides out-of-box Kafka and Amazon Kinesis Connectors for querying streaming data. Regards Chetan

RE: Drill with Alluxio

Any input on following query?   Regards Chetan   From: Chetan Kothari Sent: Wednesday, August 23, 2017 11:47 AM To: user@drill.apache.org Subject: Drill with Alluxio   Has anyone used Drill to query data cached in Alluxio? ( We are using Spark along with Alluxio ) Can someone share

Drill with Alluxio

Has anyone used Drill to query data cached in Alluxio? ( We are using Spark along with Alluxio ) Can someone share inputs on how we can integrate Drill with Alluxio?   Regards Chetan      

RE: Explain Plan for Parquet data is taking a lot of timre

Hi All Any inputs on this? Why creating metadata files recursively should took 1457445 ms when refresh metadata on this path is already done? Regards Chetan - -Original Message- From: Jeena Vinod Sent: Sunday, March 5, 2017 10:44 PM To:

Metadata Caching

Hi All As I understand, we can trigger generation of the Parquet Metadata Cache File by using REFRESH TABLE METADATA . It seems we need to run this command on a directory, nested or flat, once during the session. Why we need to run for every session? That implies if I use REST API to

RE: Query on performance using Drill and Amazon s3.

To: user@drill.apache.org Subject: RE: Query on performance using Drill and Amazon s3.   Hi chetan,   Projjwal has the issue. Me too asked the same question   On Feb 20, 2017 7:56 PM, "Chetan Kothari" mailto:chetan.koth...@oracle.com"chetan.koth...@oracle.com> wro

RE: Query on performance using Drill and Amazon s3.

Hi Nitin   Where does the query execute? Does Drill execute query on AWS and fetch results to be displayed?   Regards Chetan   -Original Message- From: Nitin Pawar [mailto:nitinpawar...@gmail.com] Sent: Monday, February 20, 2017 6:19 PM To: user@drill.apache.org Subject: Re: Query

Support for Kafka

Is there any support to query kakfa from Drill? If not, what is the roadmap/plan to support this feature? Regards Chetan

Drill with object storage using Stocator

I am trying to integrate Drill with Oracle Storage Cloud Service using Stocator. But I get following error when I try to use stocator schema. Any input on this will be helpful. Caused by: org.apache.drill.exec.work.foreman.ForemanException: Unexpected exception during fragment