[GitHub] [doris] LemonLiTree commented on issue #15421: [Bug] JSONB 类型没有对导入的数据进行校验

[GitBox <gi...@apache.org>]

LemonLiTree commented on issue #15421:
URL: https://github.com/apache/doris/issues/15421#issuecomment-1367099492

   这是跟导入严格模式有关系的：
   1. 通过stream load的导入非json数据的情况，strict_mode默认是关闭，这样的话错误数据会转化为null，也就是你上面的那种情况，如果需要filter则可以在stream load 参数中声明：-H "strict_mode: true"。具体可以参考官网的说明：https://doris.apache.org/zh-CN/docs/dev/data-operate/import/import-way/stream-load-manual
   2. 通过insert into插入非法数据，你可以看下 show variables like '%enable_insert_strict%';如果是false则返回ok，但插入并不成功，可以SET enable_insert_strict = true;插入则会提示失败。具体可以参考官网的说明：https://doris.apache.org/zh-CN/docs/dev/data-operate/import/import-scenes/load-strict-mode


-- 
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