Replies: 1 comment
-
There's no such a config property and also no plan to support it.
This is also not supported in the connector because MySQL JDBC driver returns |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Trino Version: 403
The problem is described as follows:
We are migrating presto cluster tasks into trino cluster, but we met some questions of differences between the two computing engines.
First of all, Trino Mysql connector type mapping BIGINT UNSIGNED to DECIMAL(20, 0), but presto is still BIGINT.
We have a large number of python(pandas) query tasks by trino engine, pandas is very strict about data type handling, so we expect to find a config parameter that maps DECIMAL(20, 0) to BIGINT (or other integer data), to avoid having to modify a lot of historical code.
At the same time, we also expect to find a config parameter that maps varchar(1) to unbounded varchar, I only find parameter "jdbc-types-mapped-to-varchar", if we configure "jdbc-types-mapped-to-varchar=varchar", it will bring reduction of querying speed, Is there any parameter to mapping varchar(x)?
Look forward to the community help, thanks!
Beta Was this translation helpful? Give feedback.
All reactions