You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "didasai (via GitHub)" <gi...@apache.org> on 2023/06/27 08:34:07 UTC
[GitHub] [doris] didasai opened a new issue, #21246: [Bug] 外部表连接mysql数据库，json类型不兼容
didasai opened a new issue, #21246:
URL: https://github.com/apache/doris/issues/21246
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues.
### Version
1.2.4
### What's Wrong?
json格式数据变成16进制字符串了
mysql:
```sql
CREATE TABLE `test_json_table` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
`jsonval` json DEFAULT NULL COMMENT '值',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
```
data:
doris:
```sql
CREATE EXTERNAL TABLE `test_json_table` (
`id` int(11) NOT NULL COMMENT '自增id',
`jsonval` varchar(65533) NULL COMMENT '值'
) ENGINE=ODBC
COMMENT 'MYSQL'
PROPERTIES (
"host" = "xxx",
"port" = "xxx",
"user" = "xxx",
"password" = "xxx",
"driver" = "MySQL ODBC 5.7 Unicode Driver",
"odbc_type" = "mysql",
"charest" = "utf8",
"database" = "xxx",
"table" = "xxx"
);
```
data:
### What You Expected?
能正常显示json
### How to Reproduce?
_No response_
### Anything Else?
_No response_
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
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-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] zy-kkk commented on issue #21246: [Bug] 外部表连接mysql数据库，json类型不兼容
Posted by "zy-kkk (via GitHub)" <gi...@apache.org>.
zy-kkk commented on issue #21246:
URL: https://github.com/apache/doris/issues/21246#issuecomment-1609266676
Please use the JDBC Catalog feature, ODBC is no longer maintained
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] didasai closed issue #21246: [Bug] 外部表连接mysql数据库，json类型不兼容
Posted by "didasai (via GitHub)" <gi...@apache.org>.
didasai closed issue #21246: [Bug] 外部表连接mysql数据库，json类型不兼容
URL: https://github.com/apache/doris/issues/21246
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org