Mysql field type decimal convert to String

[samz406]

hello! I use command ,extract data from Mysql.
CREATE table sales_fact_sample_flat_1 ENGINE=MergeTree order by the_year AS SELECT * FROM mysql(192.168.103.44:3306, cboard,sales_fact_sample_flat, root,admin);
I found a problem that the field of mysql decimal convert string.

mysql

clickhouse

Is that right?

[4ertus2]

Decimal conversion for external storages and dictionaries is not supported yet.
As workaround you may try to create Decimal ALIAS columns for Strings ones with toDecimal() expression.

[samz406]

ok，I have another question. mysql can be use
mysql(192.168.103.44:3306, cboard,sales_fact_sample_flat, root,admin),
this is convenience, it can be auto create table and insert data. So i want to extract data from oracle to clckhouse,can you give me some advise? soon I want extract source data from db2, mogodb,Postgres hdfs and so on!

[4ertus2]

There're external dictionaries https://clickhouse.yandex/docs/en/operations/table_engines/dictionary/

There're also readonly ODBC/JDBC engines. But they are still not in docs. You may configure odbc.ini and then create table with ENGINE = odbc('dsn=test', table). It uses unixodbc under the hood.

[filimonov]

Reopening that, just to have it in backlog, and don't forget about that problem

[4ertus2]

Same issue with enums #3985

[4ertus2]

More general request #1270

[kitaisreal]

Fixed in scope of #11512.
With mysql_datatypes_support_level specified to decimal.