You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Jagadeesh G <ja...@gmail.com> on 2017/05/25 14:49:01 UTC
Can we Import the HDFS Query results to Any RDBMS using Apache Drill
Hello,
Hope you are doing Great!
My name is Jagadeesh,
I am new to the Aache Drill,I have a question that,
I would like to know that can we load the HDFS/Hive query results to any
RDBMS?
If yes, Please share me the reference link.
Your reply is highly appreciated.
Thanks,
Jagadeesh
Re: Can we Import the HDFS Query results to Any RDBMS using Apache
Drill
Posted by Chun Chang <cc...@mapr.com>.
You can easily write a simple program to query using drill and load the results into RDBMS.
________________________________
From: Abhishek Girish <ag...@apache.org>
Sent: Thursday, May 25, 2017 10:13:46 AM
To: user@drill.apache.org
Subject: Re: Can we Import the HDFS Query results to Any RDBMS using Apache Drill
Hello Jagadeesh,
Drill supports writing to disk via the CTAS command [1]. So you can read
from RDBMS and write to HDFS. However, currently we don't support the other
way round.
Just curious, can you share what you are trying to achieve here?
[1] https://drill.apache.org/docs/create-table-as-ctas/
-Abhishek
On Thu, May 25, 2017 at 7:49 AM, Jagadeesh G <jagadeeshitdeveloper@gmail.com
> wrote:
> Hello,
>
> Hope you are doing Great!
>
> My name is Jagadeesh,
>
> I am new to the Aache Drill,I have a question that,
> I would like to know that can we load the HDFS/Hive query results to any
> RDBMS?
>
> If yes, Please share me the reference link.
>
> Your reply is highly appreciated.
>
> Thanks,
> Jagadeesh
>
Re: Can we Import the HDFS Query results to Any RDBMS using Apache Drill
Posted by Abhishek Girish <ag...@apache.org>.
Hello Jagadeesh,
Drill supports writing to disk via the CTAS command [1]. So you can read
from RDBMS and write to HDFS. However, currently we don't support the other
way round.
Just curious, can you share what you are trying to achieve here?
[1] https://drill.apache.org/docs/create-table-as-ctas/
-Abhishek
On Thu, May 25, 2017 at 7:49 AM, Jagadeesh G <jagadeeshitdeveloper@gmail.com
> wrote:
> Hello,
>
> Hope you are doing Great!
>
> My name is Jagadeesh,
>
> I am new to the Aache Drill,I have a question that,
> I would like to know that can we load the HDFS/Hive query results to any
> RDBMS?
>
> If yes, Please share me the reference link.
>
> Your reply is highly appreciated.
>
> Thanks,
> Jagadeesh
>