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 <[email protected]> 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
> [email protected] <mailto:[email protected]>
> 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?