Much better! Thanks ... now I even see the full schema when doing the show :-)
0: jdbc:drill:> SHOW DATABASES; +-----------------------------+ | SCHEMA_NAME | +-----------------------------+ | INFORMATION_SCHEMA | | MySQLDB.hive | | MySQLDB.hue | | MySQLDB.information_schema | | MySQLDB.metrics | | MySQLDB.mysql | | MySQLDB.oozie | | MySQLDB.test | | MySQLDB.uffe | | MySQLDB | | cp.default | | dfs.default | | dfs.root | | dfs.tmp | | sys | +-----------------------------+ 15 rows selected (0.181 seconds) 0: jdbc:drill:> USE MySQLDB.uffe; +-------+-------------------------------------------+ | ok | summary | +-------+-------------------------------------------+ | true | Default schema changed to [MySQLDB.uffe] | +-------+-------------------------------------------+ 1 row selected (0.135 seconds) 0: jdbc:drill:> SHOW TABLES; +---------------+-------------+ | TABLE_SCHEMA | TABLE_NAME | +---------------+-------------+ | MySQLDB.uffe | employee | | MySQLDB.uffe | employee2 | +---------------+-------------+ 2 rows selected (0.249 seconds) 0: jdbc:drill:> describe employee; +--------------+--------------------+--------------+ | COLUMN_NAME | DATA_TYPE | IS_NULLABLE | +--------------+--------------------+--------------+ | id | INTEGER | NO | | name | CHARACTER VARYING | YES | | dept | CHARACTER VARYING | YES | | salary | INTEGER | YES | +--------------+--------------------+--------------+ 4 rows selected (0.229 seconds) 0: jdbc:drill:> select * from employee; +------+---------+--------+---------+ | id | name | dept | salary | +------+---------+--------+---------+ | 100 | Thomas | Sales | 5000 | +------+---------+--------+---------+ 1 row selected (0.24 seconds) reg//ulf -------- Ulf Andreasson | Ericsson Global Alliance Solution Engineer, MapR.com | +46 72 700 2295 On Wed, Nov 4, 2015 at 6:04 PM, Jacques Nadeau <[email protected]> wrote: > The two commits you want are: > > 22e5316: DRILL-3992: Add/fix support for JDBC schemas (tested against > oracle and derby) > 2f894af: DRILL-3956: Add support for MySQL text type > > > Those are both newer than your commit. > > > > -- > Jacques Nadeau > CTO and Co-Founder, Dremio > > On Wed, Nov 4, 2015 at 8:59 AM, Ulf Andreasson @ MapR < > [email protected]> wrote: > > > Ah ok ... sorry .... types faster than reads :( > > > > > > -------- > > Ulf Andreasson | Ericsson Global Alliance Solution Engineer, MapR.com | > +46 > > 72 700 2295 > > > > > > On Wed, Nov 4, 2015 at 5:59 PM, Ulf Andreasson @ MapR < > > [email protected]> wrote: > > > > > This was cloned on Oct 31st, id > e4b94a78487f844be4fe71c4b9bf88b16c7f42f7 > > > > > > reg//ulf > > > > > > -------- > > > Ulf Andreasson | Ericsson Global Alliance Solution Engineer, MapR.com | > > +46 > > > 72 700 2295 > > > > > > > > >
