import connectorx as cx
conn = 'mysql://username:password@server:port/database' # connection token
query = 'SELECT * FROM table' # query string
cx.read_sql(conn, query) # read data from MySQL
DECIMAL
float64, object(Clickhouse)
Clickhouse return DECIMAL in string, cannot support precision larger than 28
VARCHAR
object
object
datetime64[ns]
only support date after year 1970
object
DATETIME
datetime64[ns]
only support date after year 1970
TIMESTAMP
datetime64[ns]
int64, Int64(nullable)
TINYBLOB
object
object
MEDIUMBLOB
object
LONGBLOB
object
object
object