You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by "Geercken, Uwe" <Uw...@swissport.com> on 2015/10/19 08:17:18 UTC
JDBC storage
Hello,
Can somebody please post a valid json syntax for the jdbc plugin?
Can't get it going....
Uwe
Uwe Geercken
Application- & Projectmanager
________________________________
[http://galaxy.swissport.com/customtext/Swissport%20International%20Ltd.%20Station%20Zurich_sign.gif]
Swissport International Ltd. Station Zurich
BZBI
CH-8058 Zurich-Airport
SWITZERLAND
Phone
+41 43 81 50359
Fax
+43 815 03 60
Mobile
+41786954707
Uwe.Geercken@swissport.com<ma...@swissport.com>
Swissport is the world's largest provider of ground and cargo handling services in the aviation industry. The company provides services on behalf of some 700 client-companies and handles around 229 million passengers and 3.9 million flights (movements) per year. The company operates 120 warehouses and moves approx. 4.1 million tonnes of cargo. With a workforce of around 60,000 personnel, Swissport is active at more than 270 stations in 48 countries across five continents, and generates annual consolidated operating revenue of CHF 3.0 billion.
Important Note: This email is confidential. If you have received this email by error, please notify the sender immediately by return email, and delete this message. Unauthorized use, disclosure or copying is strictly prohibited and may be unlawful. Swissport International Ltd. disclaims any liability for any action taken in reliance on the content of this email. The comments or statements expressed in this email are not necessarily those of Swissport International Ltd. or its subsidiaries or affiliates. Although this email and its attachments are believed to be free of any virus or similar defect, no responsibility is held by Swissport International Ltd. for any loss or damage arising in any way from the receipt or use thereof.
[http://galaxy.swissport.com/pix/aircraftleafsmall.jpg]Save Paper - Do you really need to print this e-mail?
RE: JDBC storage
Posted by "Geercken, Uwe" <Uw...@swissport.com>.
Thank you Rajkumar - It did work.
One point though:
I called my storage "mysql". Querying: select * from mysql.dim_carrier does not work, although I have specified the dbname in the storage config.
But when I include the dbname in the query it does work: select * from mysql.mydbname.dim_carrier
So when it is required to specify the dbname in the query anyway, then I can remove it from the config. And I tested that this does also work.
Rgds,
Uwe
-----Original Message-----
From: Rajkumar Singh [mailto:rsingh@maprtech.com]
Sent: Montag, 19. Oktober 2015 11:07
To: user@drill.apache.org
Subject: Re: JDBC storage
Please try with the following configuration and make sure that you have mysql connector jar into the DRILL_HOME/jars/3rdparty
{
"type": "jdbc",
"driver": "com.mysql.jdbc.Driver",
"url": "jdbc:mysql://hostname:3306/dbname",
"username": "root",
"password": "password",
"enabled": true
}
> On 19-Oct-2015, at 11:47 AM, Geercken, Uwe <Uw...@swissport.com> wrote:
>
> Hello,
>
> Can somebody please post a valid json syntax for the jdbc plugin?
>
> Can’t get it going….
>
> Uwe
>
> Uwe Geercken
> Application- & Projectmanager
>
>
>
> Swissport International Ltd. Station Zurich BZBI
> CH-8058 Zurich-Airport
> SWITZERLAND
> Phone
> +41 43 81 50359
> Fax
> +43 815 03 60
> Mobile
> +41786954707
> Uwe.Geercken@swissport.com <ma...@swissport.com>
> Swissport is the world's largest provider of ground and cargo handling services in the aviation industry. The company provides services on behalf of some 700 client-companies and handles around 229 million passengers and 3.9 million flights (movements) per year. The company operates 120 warehouses and moves approx. 4.1 million tonnes of cargo. With a workforce of around 60,000 personnel, Swissport is active at more than 270 stations in 48 countries across five continents, and generates annual consolidated operating revenue of CHF 3.0 billion.
> Important Note: This email is confidential. If you have received this email by error, please notify the sender immediately by return email, and delete this message. Unauthorized use, disclosure or copying is strictly prohibited and may be unlawful. Swissport International Ltd. disclaims any liability for any action taken in reliance on the content of this email. The comments or statements expressed in this email are not necessarily those of Swissport International Ltd. or its subsidiaries or affiliates. Although this email and its attachments are believed to be free of any virus or similar defect, no responsibility is held by Swissport International Ltd. for any loss or damage arising in any way from the receipt or use thereof.
> Save Paper - Do you really need to print this e-mail?
Re: JDBC storage
Posted by Rajkumar Singh <rs...@maprtech.com>.
Please try with the following configuration and make sure that you have mysql connector jar into the DRILL_HOME/jars/3rdparty
{
"type": "jdbc",
"driver": "com.mysql.jdbc.Driver",
"url": "jdbc:mysql://hostname:3306/dbname",
"username": "root",
"password": "password",
"enabled": true
}
> On 19-Oct-2015, at 11:47 AM, Geercken, Uwe <Uw...@swissport.com> wrote:
>
> Hello,
>
> Can somebody please post a valid json syntax for the jdbc plugin?
>
> Can’t get it going….
>
> Uwe
>
> Uwe Geercken
> Application- & Projectmanager
>
>
>
> Swissport International Ltd. Station Zurich
> BZBI
> CH-8058 Zurich-Airport
> SWITZERLAND
> Phone
> +41 43 81 50359
> Fax
> +43 815 03 60
> Mobile
> +41786954707
> Uwe.Geercken@swissport.com <ma...@swissport.com>
> Swissport is the world's largest provider of ground and cargo handling services in the aviation industry. The company provides services on behalf of some 700 client-companies and handles around 229 million passengers and 3.9 million flights (movements) per year. The company operates 120 warehouses and moves approx. 4.1 million tonnes of cargo. With a workforce of around 60,000 personnel, Swissport is active at more than 270 stations in 48 countries across five continents, and generates annual consolidated operating revenue of CHF 3.0 billion.
> Important Note: This email is confidential. If you have received this email by error, please notify the sender immediately by return email, and delete this message. Unauthorized use, disclosure or copying is strictly prohibited and may be unlawful. Swissport International Ltd. disclaims any liability for any action taken in reliance on the content of this email. The comments or statements expressed in this email are not necessarily those of Swissport International Ltd. or its subsidiaries or affiliates. Although this email and its attachments are believed to be free of any virus or similar defect, no responsibility is held by Swissport International Ltd. for any loss or damage arising in any way from the receipt or use thereof.
> Save Paper - Do you really need to print this e-mail?