There were some issues with this in 1.2. I believe they have been resolved in the latest master if you want to try that out. We'll be rolling a 1.3 release shortly with these fixes.
-- Jacques Nadeau CTO and Co-Founder, Dremio On Wed, Nov 4, 2015 at 4:53 AM, Ulf Andreasson @ MapR < [email protected]> wrote: > All, > > I have a small mysql test system where I got some simple mysql tables. > Adding Drill to the mix I can see and use my MySQLDB and the db I specify > but I dont seem to be able to show tables ? This is true for all dbs/tables > in mysql as to my understanding !? > > [root@e1node01 uffe]# /opt/drill/bin/drill-conf -n admin -p admin > apache drill 1.3.0-SNAPSHOT > "got drill?" > 0: jdbc:drill:> SHOW DATABSES; > +---------------------+ > | SCHEMA_NAME | > +---------------------+ > | INFORMATION_SCHEMA | > | MySQLDB | > | cp.default | > | dfs.default | > | dfs.root | > | dfs.tmp | > | sys | > +---------------------+ > 7 rows selected (0.18 seconds) > 0: jdbc:drill:> USE MySQLDB; > +-------+--------------------------------------+ > | ok | summary | > +-------+--------------------------------------+ > | true | Default schema changed to [MySQLDB] | > +-------+--------------------------------------+ > 1 row selected (0.104 seconds) > 0: jdbc:drill:> SHOW TABLES; > +--+ > | | > +--+ > +--+ > No rows selected (0.14 seconds) > 0: jdbc:drill:> SELECT * FROM MySQLDB.uffe.`employee`; > +------+---------+--------+---------+ > | id | name | dept | salary | > +------+---------+--------+---------+ > | 100 | Thomas | Sales | 5000 | > +------+---------+--------+---------+ > 1 row selected (0.144 seconds) > > If I check the info.schema I can see they are there > > 0: jdbc:drill:> SELECT table_name FROM MySQLDB.information_schema.`tables` > WHERE table_schema='uffe'; > +-------------+ > | table_name | > +-------------+ > | employee | > | employee2 | > +-------------+ > 2 rows selected (0.148 seconds) > > The storage plugin is defined as > > { > "type": "jdbc", > "driver": "com.mysql.jdbc.Driver", > "url": "jdbc:mysql://e1node03:3306/", > "username": "ulf", > "password": "mapr", > "enabled": true > } > > Any ideas to why I cant use "SHOW TABLES" ? > > reg//ulf > > -------- > Ulf Andreasson | Ericsson Global Alliance Solution Engineer, MapR.com | +46 > 72 700 2295 >
