shutao917 commented on issue #11127:
URL: https://github.com/apache/doris/issues/11127#issuecomment-1193473526
> Could you please provide some error log in BE?
there is not log in be and fe。the doris cluster is upgrade from 1.0 to 1.1
table schema like this(the table is create when doris version is 1.0)：
CREATE EXTERNAL TABLE `x1` (
`id` BIGINT(20) NULL ,
`tenant_id` BIGINT(20) NULL ,
`dt_yearmonth_str` TEXT NULL
) ENGINE=ODBC
COMMENT "ODBC"
PROPERTIES (
"odbc_catalog_resource" = "xxxxx",
"database" = "aaaa",
"table" = "aaaaa.dim_accounting_period"
);
when i want to create a new table like below will get a error(the doris
version is upgrade to 1.1):
errCode = 2, detailMessage = String Type should not be used in key
column[dt_yearmonth_str].
so i change the sql to:
CREATE EXTERNAL TABLE `x2` (
`id` BIGINT(20) NULL ,
`tenant_id` BIGINT(20) NULL ,
`dt_yearmonth_str` VARCHAR(10) NULL
) ENGINE=ODBC
COMMENT "ODBC"
PROPERTIES (
"odbc_catalog_resource" = "xxxxx",
"database" = "aaaa",
"table" = "aaaaa.dim_accounting_period"
);
the table is create successful and select * from x2 is ok.
we had many odbc tables,so am i need to upgrade all table define?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
