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
