search

apache / doris

Apache Doris is an easy-to-use, high performance and unified analytics database.
https://doris.apache.org
Apache License 2.0
12.38k stars 3.22k forks source link

整理了使用上的不方便之处 #10200

Open qf8505 opened 2 years ago

qf8505 commented 2 years ago

Search before asking

Description

1.插入数据，如果分区不存在或者字段值过长，不报错，提示成功 2.fenodes和table.identifier参数与flink的不兼容 3.flink-cdc写入doris不支持日期同时写入分区和写入日期字段 4.删除分区下数据语法和hive等其他仓库不一致，特别是还要加前缀，看到的是2022-05-06，但是执行需要写p20220506，不利于使用 5.官方flink-cdc同步到doris文档未更新， 6.web页面写sql不支持选择执行

Solution

建议doris整合flink的时候能参数，jar包名称等统一一些，会更加方便使用，希望提示错误等更加准确方便一些

Are you willing to submit PR?

Code of Conduct

JNSimba commented 2 years ago

1.In strict mode, the error too many filtered rows will be reported. Please confirm whether doris has strict mode enabled. 2.What does incompatibility with flink mean? 3.can you give an example？ 5.https://doris.apache.org/zh-CN/docs/ecosystem/flink-doris-connector.html#%E4%BD%BF%E7%94%A8-flink-cdc-%E6%8E%A5%E5%85%A5-doris-%E7%A4%BA%E4%BE%8B-%E6%94%AF%E6%8C%81-insert-update-delete-%E4%BA%8B%E4%BB%B6 6.What does it mean to write sql on the web, can you give an example?

hanfengcan commented 2 years ago

第6个问题是想和Navicat那样可以选择某段SQL执行吧。如果使用Monaco-editor替换codemirror，是可以实现这种效果

qf8505 commented 2 years ago

ink-cdc写入doris不支持日期同时写入分区和写入日期字段

2.fenodes和table.identifier 改成 url和database-name 3.flinkcdc写入doris 数据库有createTime字段，同时写入doris表的dt分区和create_time两个字段。不支持 4.要改成和hive语法一致

JNSimba commented 2 years ago

2.fenodes和table.identifier 改成 url和database-name Fenodes is different from the url of jdbc, it is the http request address of fe, and supports multiple

3.flinkcdc写入doris 数据库有createTime字段，同时写入doris表的dt分区和create_time两个字段。不支持 Can you give an example, what I tested here can be run

4.要改成和hive语法一致 I think the main reason is that the partition of doris is different from the partition of hive. The partition of doris is divided into range partition and list partition. When you specify a specific value, it does not represent this partition.