Hello team,
Im using starrocks 4.0.1, and able to ...
# questions-and-troubleshootingl
Lý Thành
12/01/2025, 9:57 AMHello team,
Im using starrocks 4.0.1, and able to create catelog to connect to Postgres and select data from table.
but got error with oracle, starrocks can connect, and show tables, but can not select table,
I got this error when select oracle table:
SQL Error [1064] [42000]: DECIMAL's precision should range from 1 to 76
------my oracle catelog ------------
CREATE EXTERNAL CATALOG LMSSIT
PROPERTIES
(
"type"="jdbc",
"user"=*"***"*,
"password"=*"***"*,
"jdbc_uri"="jdbcoraclethin:@10.0.200.211521LMSSIT",
"driver_url"="https://repo1.maven.org/maven2/com/oracle/database/jdbc/ojdbc10/19.18.0.0/ojdbc10-19.18.0.0.jar",
"driver_class"="oracle.jdbc.driver.OracleDriver"
);
----- I can show tables from oracle ----------
s
Simo Wang
12/01/2025, 6:12 PMHi, what’s the original data type of this column?
Simo Wang
12/01/2025, 6:13 PMmaybe you can try to create an external table manually so sr can get a better column type mapping
Simo Wang
12/01/2025, 6:18 PMl
Lý Thành
12/02/2025, 1:49 AMThanks u @Simo Wang, i will try this wave,
@thanks u
Lý Thành
12/02/2025, 3:07 AMthanks uu, i can connect to oracle by using Exernal table, and able to join data from oracle and postgres, that so impressed.
🙌 1
s
Simo Wang
12/02/2025, 4:07 AMwhat’s the original data type of this column and also what’s the data type you use to create the external table? we can see if there is a room for enhancement regarding of the data type mapping