kkfnui opened a new issue, #14202:
URL: https://github.com/apache/doris/issues/14202

   ### 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.1.3
   
   ### What's Wrong?
   
   There's a table which data loaded by routine load. And the data is nginx 
logs.
   When we do stat query, It comes out error message:
   ```
   'utf-8' codec can't decode byte 0xc0 in position 1: invalid start byte
   ```
   
   Query SQL:
   ```
     select
         '2022-11-11 09:00:00' time,
         'sg' region,
         host, 
         request_method,
         uri, 
         status, 
         count(1) cnt, 
         percentile_approx(upstream_response_time, 0.95) p95, 
         percentile_approx(upstream_response_time, 0.99) p99, 
         percentile_approx(upstream_response_time, 0.999) p999 
     from dwd_topnews_nginx_log
     where time >= '2022-11-11 09:00:00' and time <= '2022-11-11 09:10:00' and 
upstream_response_time is not null and upstream_response_time >0
         and host is not null and uri is not null and status is not null
   ```
   
   More info: https://l5555afz2r.feishu.cn/docx/QkMQdWZN3oB4YlxCWrdcBcqZnFd
   
   ### What You Expected?
   
   For data are loaded by routine load.
   So We hope that routine load will find the error data.
   And there shouldn't any error when query. 
   
   ### How to Reproduce?
   
   See also:
   https://l5555afz2r.feishu.cn/docx/QkMQdWZN3oB4YlxCWrdcBcqZnFd
   
   ### 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-unsubscr...@doris.apache.org.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

Reply via email to