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/08/09 10:56:09 UTC
[GitHub] [doris] didasai opened a new issue, #22787: [Bug] odbc外部表，不定时出现查询mysql整张表的情况
didasai opened a new issue, #22787:
URL: https://github.com/apache/doris/issues/22787
### 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?
表结构如下：
```
CREATE EXTERNAL TABLE `ex_places` (
`place_id` char(20) NOT NULL,
`place_name` varchar(200) NULL,
`user_id` char(20) NULL,
`created` int(11) NULL,
`updated` int(11) NULL,
`timeout` int(11) NOT NULL DEFAULT "-1" COMMENT '位置超时时间 ms 默认-1无效 ',
`size_id` int(11) NOT NULL DEFAULT "0",
`adstyle_id` int(11) NULL,
`is_hide_ref` tinyint(4) NULL DEFAULT "0" COMMENT '是否隐藏页面 0：不隐藏 1：隐藏',
`is_nativevideo` char(1) NOT NULL DEFAULT "N" COMMENT '是否支持原生视频；N否 Y是 默认否',
`is_carousel_ad` varchar(2) NULL DEFAULT "N" COMMENT '是否是轮播广告',
`price_cpm` bigint(20) NOT NULL DEFAULT "10000",
`view_frequency_type` tinyint(4) NULL DEFAULT "1" COMMENT '1 ： day 2 : hour',
`view_frequency` int(11) NULL DEFAULT "0",
`view_frequency_rate` int(11) NULL DEFAULT "0",
`default_code` varchar(65533) NULL,
`google_code` varchar(65533) NULL,
`show_type` varchar(2) NOT NULL DEFAULT "lb" COMMENT 'sx:顺序 lb:轮播 ',
`memo` varchar(200) NULL,
`is_disable` char(1) NOT NULL DEFAULT "N" COMMENT 'N:不禁用 Y:禁用',
`autopartent` char(1) NOT NULL DEFAULT "Y" COMMENT '自动优化合作伙伴 N:手动优化 Y:自动优化',
`max_deal_price` bigint(20) NULL DEFAULT "0" COMMENT '最高成交价',
`status` tinyint(4) NOT NULL DEFAULT "1" COMMENT '1:没删除 2:已删除（是否删除）',
`cpc` bigint(20) NOT NULL DEFAULT "0" COMMENT 'cpc单价 分后3个0',
`exappid` varchar(20) NOT NULL DEFAULT "" COMMENT '应用id',
`file_path` varchar(65533) NULL COMMENT '图片ftp地址',
`labelids` varchar(20) NOT NULL DEFAULT "" COMMENT 'ex_places_label标签id 逗号,拼接多个',
`show_rate` float NOT NULL DEFAULT "0" COMMENT '位置平均展示率 2位小数',
`click_rate` float NOT NULL DEFAULT "0" COMMENT '位置平均点击率 2位小数',
`place_profit` float NOT NULL DEFAULT "-1" COMMENT '位置利润率',
`place_correction` float NOT NULL DEFAULT "0" COMMENT '位置数据修正百分比',
`minduration` int(11) NOT NULL DEFAULT "15" COMMENT '视频广告最小时长',
`maxduration` int(11) NOT NULL DEFAULT "15" COMMENT '视频广告最大时长',
`subprofit` float NOT NULL DEFAULT "0" COMMENT '子媒体利润率',
`mimes` varchar(2000) NOT NULL DEFAULT "" COMMENT '格式类型',
`place_img` varchar(200) NULL COMMENT '广告位截图',
`body_len` int(11) NOT NULL DEFAULT "0" COMMENT '内容长度',
`title_len` int(11) NOT NULL DEFAULT "0" COMMENT '标题长度',
`is_support_deeplink` char(1) NOT NULL DEFAULT "N" COMMENT '是否支持deeplink 是Y 否N',
`is_downloadable` char(1) NOT NULL DEFAULT "N" COMMENT '是否支持下载 是Y 否N',
`imgs_len` int(11) NOT NULL DEFAULT "1" COMMENT '支持多图数量',
`imgs_w` int(11) NOT NULL DEFAULT "0" COMMENT '多图图片宽度',
`imgs_h` int(11) NOT NULL DEFAULT "0" COMMENT '多图图片高度',
`is_nativetype_dspbanner` char(1) NOT NULL DEFAULT "N" COMMENT '是否强制按BANNER请求发送 Y是 N否',
`secure` char(1) NOT NULL DEFAULT "" COMMENT '安全协议 0：http 1：https \"不限制',
`icosize` varchar(10) NOT NULL DEFAULT "" COMMENT 'appico尺寸',
`rotata_profit` float NOT NULL DEFAULT "-1" COMMENT '轮播给媒体利润 默认是-1 不轮播 ',
`can302` char(1) NOT NULL DEFAULT "Y" COMMENT '是否支持302 Y/N',
`sendprice` char(1) NOT NULL DEFAULT "N" COMMENT '是否发送底价',
`export_name` varchar(500) NULL DEFAULT "" COMMENT '广告位导出名称',
`bundle` varchar(200) NOT NULL DEFAULT "" COMMENT '应用id',
`platform` varchar(10) NOT NULL DEFAULT "" COMMENT '平台',
`mr` varchar(65533) NULL,
`templates` varchar(200) NOT NULL DEFAULT "" COMMENT '模板ID,逗号拼接多个',
`ts` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`state` char(1) NOT NULL DEFAULT "Y" COMMENT 'Y:启用 N停用 D删除',
`istest` char(1) NOT NULL DEFAULT "N" COMMENT 'Y 测试 N非测试',
`is_click_coor_up` char(1) NOT NULL DEFAULT "N" COMMENT '是否支持点击坐标上报 Y or N',
`createdd` datetime NOT NULL,
`mediaadtype` varchar(10) NOT NULL DEFAULT ""
) 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" = "ex_public",
"table" = "ex_places"
);
```
mysql中不定时的出现如下sql：
```
SELECT `is_hide_ref` FROM `ex_places`
```
```
SELECT `place_id`, `size_id`, `adstyle_id`, `user_id`, `place_name`, `is_disable`, `export_name`, `price_cpm` FROM `ex_places`
```
### What You Expected?
希望mysql不会出现查询整张表的情况，而是根据实际sql情况来查询
顺便问下catalog会有这种情况吗
### 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] didasai closed issue #22787: [Bug] odbc外部表，不定时出现查询mysql整张表的情况
Posted by "didasai (via GitHub)" <gi...@apache.org>.
didasai closed issue #22787: [Bug] odbc外部表，不定时出现查询mysql整张表的情况
URL: https://github.com/apache/doris/issues/22787
--
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] zy-kkk commented on issue #22787: [Bug] odbc外部表，不定时出现查询mysql整张表的情况
Posted by "zy-kkk (via GitHub)" <gi...@apache.org>.
zy-kkk commented on issue #22787:
URL: https://github.com/apache/doris/issues/22787#issuecomment-1672512426
odbc 外表后续版本我们不再维护，请使用 JDBC catalog功能，JDBC Catalog不会出现不定时查询整张表的问题，JDBC catalog的查询是根据查询sql进行优化，只下发所需要的列的查询SQL给jdbc数据源
--
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