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:[email protected]] Sent: Montag, 19. Oktober 2015 11:07 To: [email protected] 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 <[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?
