Re: Source for drill-calcite

[Vitalii Diravka]

Hi Rahul,

Updating of Calcite onto 1.16.0 version is on review.
You can test it if you wish, but it requires some changes in Drill code.
Please find the PR here:
https://github.com/mapr/incubator-calcite/pull/18

Kind regards
Vitalii

On Wed, Mar 28, 2018 at 4:28 PM, Kunal Khatua  wrote:

> Yes, that is correct.
> On 3/28/2018 3:45:13 AM, Rahul Raj 
> wrote:
> Is Drill fork of Calcite maintained at
> https://github.com/mapr/incubator-calcite/?
>
> I assume that the required calcite branch for Drill 13.0 is
> DrillCalcite1.15.0. I would like to test a newer patch from calcite on
> Drill 13.0.
>
> Regards,
> Rahul
>
> --
>  This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom it is
> addressed. If you are not the named addressee then you should not
> disseminate, distribute or copy this e-mail. Please notify the sender
> immediately and delete this e-mail from your system.
>

Re: create table in mysql db

[Andries Engelbrecht]

Unfortunately Drill can not write to MySQL, only read. Perhaps write to a CSV 
file on HDFS and then import the CSV file into MySQL.

Regards
--Andries


On 3/28/18, 5:50 AM, "Shrinivas Deshmukh"  
wrote:

Hi,

This is Shrinivas.

I am joining a mysql db table with a csv file in hdfs. I want to store the
results in a new mysql db table. I get an error :  Schema [MySQL.dummy] is
immutable.

MySQL is my mysql plugin name and dummy is the database name.

Here is my MySQL plugin configuration :
{
  "type": "jdbc",
  "driver": "com.mysql.jdbc.Driver",
  "url": "jdbc:mysql://host:3306",
  "username": "root",
  "password": "",
  "enabled": true
}

Please help me.

Thank you.

Regards,
Shrinivas Deshmukh.

Re: Source for drill-calcite

[Kunal Khatua]

Yes, that is correct.
On 3/28/2018 3:45:13 AM, Rahul Raj  wrote:
Is Drill fork of Calcite maintained at
https://github.com/mapr/incubator-calcite/?

I assume that the required calcite branch for Drill 13.0 is
DrillCalcite1.15.0. I would like to test a newer patch from calcite on
Drill 13.0.

Regards,
Rahul

--
 This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom it is
addressed. If you are not the named addressee then you should not
disseminate, distribute or copy this e-mail. Please notify the sender
immediately and delete this e-mail from your system.

create table in mysql db

[Shrinivas Deshmukh]

Hi,

This is Shrinivas.

I am joining a mysql db table with a csv file in hdfs. I want to store the
results in a new mysql db table. I get an error :  Schema [MySQL.dummy] is
immutable.

MySQL is my mysql plugin name and dummy is the database name.

Here is my MySQL plugin configuration :
{
  "type": "jdbc",
  "driver": "com.mysql.jdbc.Driver",
  "url": "jdbc:mysql://host:3306",
  "username": "root",
  "password": "",
  "enabled": true
}

Please help me.

Thank you.

Regards,
Shrinivas Deshmukh.

Source for drill-calcite

[Rahul Raj]

Is Drill fork of Calcite maintained at
https://github.com/mapr/incubator-calcite/?

I assume that the required calcite branch for Drill 13.0 is
DrillCalcite1.15.0. I would like to test a newer patch from calcite on
Drill 13.0.

Regards,
Rahul

-- 
 This email and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to whom it is 
addressed. If you are not the named addressee then you should not 
disseminate, distribute or copy this e-mail. Please notify the sender 
immediately and delete this e-mail from your system.

Re: Apache Drill.

[Divya Gehlot]

Unfortunately ,Apache Drill doesnt support distributed installation on
windows Machines
However it does supports embedded installation which is nothing but
standalone installation

On 22 March 2018 at 21:50, Robert Smith  wrote:

> Hi Apache,
>
> I wonder if you can help me please on a issue I am having on installing
> Apache Drill on one of my AWS EC2 Window 10 Servers.
>
> Basically I have successfully installed Apache Drill locally on my laptop
> to test, but when I install it on the AWS EC2 Windows 10 Server and I try
> to run it, I get a java.lang.NullPointerException error.
>
> Any advice would be appreciated.
>
> I have attached the Apache Drill sqlline.log in anticipation you able to
> assist.
>
> I look forward to hearing from you.
>
> Kind regards
> Robert Smith.
>
>