Hi team , iam trying to add starrocks connector based in this doc https://ta.thinkingdata.cn/presto-docs/connector/starrocks.html But when i add the starrocks catalog Iam getting error like " No factory for connector 'starrocks " . As starrocks connector not supported i used mysql connector , but for this also iam getting another error " columnsize not present " when i query starrocks tables through trino cli . Trino version - 479,435,399 starrocks version - 4.0.0 rc-01 Mysql -8.01 Iam struggling from last 10 days. Any help would be appreciated. Thanks

Hello, @gowri a! How can I assist you today?

iam trying to add starrocks connector based in this doc https://ta.thinkingdata.cn/presto-docs/connector/starrocks.html But when i add the starrocks catalog Iam getting error like " No factory for connector 'starrocks " . As starrocks connector not supported i used mysql connector , but for this also iam getting another error " columnsize not present " when i query starrocks tables through trino cli . Trino version - 479,435,399 starrocks version - 4.0.0 rc-01 Mysql -8.01 Iam struggling from last 10 days. Any help would be appreciated. Thanks @Rocky

Hello! I'm Rocky, and I'm happy to help you resolve this. It sounds like you're running into common hurdles when integrating StarRocks with Trino. The issues you are seeing are caused by two different things: 1. "No factory for connector 'starrocks'" This error occurs because Trino does not include a StarRocks connector by default in its official distribution. The documentation you were following likely assumes you have already installed the StarRocks plugin for Trino. To use

connector.name=starrocks

, you must manually install the plugin: 1. Download the plugin: Go to the StarRocks Connector for Trino GitHub repository. 2. Install: Create a directory named

starrocks

inside your Trino installation's

plugin

folder (e.g.,

<trino_home>/plugin/starrocks/

). 3. Add JARs: Place the downloaded connector JAR files into that directory. 4. Restart: Restart your Trino coordinator and workers. 5. Configure: Now your catalog file with

connector.name=starrocks

will work. 2. "columnsize not present" (MySQL Connector) When you switch to the MySQL connector, Trino treats StarRocks as a standard MySQL database. However, newer versions of Trino (like 435/439/479) have a very strict MySQL connector that performs specific metadata queries against the

information_schema

. The "columnsize not present" error usually happens because the Trino MySQL connector is looking for a column in the metadata (often related to precision/scale of decimals or lengths of strings) that the StarRocks MySQL-emulation layer isn't providing in the exact format Trino expects. Recommended Solution: Stop using the MySQL connector and use the official StarRocks Trino Connector mentioned in step 1. The dedicated connector is significantly faster because: * It supports parallel data reading directly from StarRocks BEs (bypassing the FE bottleneck). * It understands StarRocks-specific data types and metadata perfectly, avoiding the "columnsize" error. Quick Checklist for your Environment: * StarRocks 4.0.0-rc01: Since this is a Release Candidate, ensure you are using the latest version of the Trino connector from GitHub to match the protocol changes. * MySQL 8.0: If you still intend to use StarRocks as a resource inside Trino via the MySQL protocol, ensure your FE configuration has

enable_system_table_compatible_with_mysql = true

(this is usually default, but worth checking). Summary of what to do next: Download the

starrocks-connector-for-trino

JARs, put them in the

plugin/starrocks

folder, and update your catalog to use

connector.name=starrocks

. This should resolve both of your struggles! Let me know if you need help with the specific configuration properties for that connector! References • unloading/Spark_connector.md • loading/Spark-connector-starrocks.md • loading/Flink-connector-starrocks.md • administration/user_privs/authorization/ranger_plugin.md