Clickhouse: How to drop database based on MySQL Engine

[rangez]

This problem occurs when I delete the database based on the MySQL storage engine.

This is My Create database stament:
SHOW CREATE DATABASE mydb; CREATE DATABASE mydb ENGINE = MySQL('localhost:3306', 'docker', 'docker', 'docker')

This is Exception when I try to drop database:
Code: 48. DB::Exception: Received from localhost:9000. DB::Exception: MySQL database engine does not support remove table..

[alexey-milovidov]

CC @zhang2014

[zhang2014]

I'll try to fix it. you can currently drop the database using the following command:

clickhouse :) DETACH DATABASE {need drop database name}
clickhouse :) exit
~ cd {clickhouse data path}
~ rm -rf metadata/{need drop database name}

[rangez]

thank you very much @zhang2014

[tonal]

Also mysql db don`t drop if not connect to it:

host2 :) CREATE DATABASE mysql_db ENGINE = MySQL('yandex.ru:3306', 'test_db', 'yandex_admin', '1234');

CREATE DATABASE mysql_db
ENGINE = MySQL('yandex.ru:3306', 'test_db', 'yandex_admin', '1234')

Ok
0 rows in set. Elapsed: 0.064 sec. 

host2 :) show databases;

SHOW DATABASES

┌─name─────┐
│ default  │
│ mysql_db │
│ system   │
└──────────┘

4 rows in set. Elapsed: 0.001 sec. 

host2 :) drop database mysql_db;

DROP DATABASE mysql_db

Received exception from server (version 19.13.3):
Code: 48. DB::Exception: Received from localhost:9000. DB::Exception: MySQL database engine does not support remove table.. 

0 rows in set. Elapsed: 0.313 sec. 

[zhang2014]

This is a feature that hasn't been implemented for some reason, and I will implement them as soon as possible : )

[jigetage]

detach database test-db

[alexey-milovidov]

I have to mention that silly automatic comments from "robot-clickhouse" and from "blinkov" is just a personal idea of one of our friends and we strongly discourage this idea.

[zhang2014]

maybe we can close this issue ?