hubgeter opened a new pull request, #39980:
URL: https://github.com/apache/doris/pull/39980

   bp #37687
   ## Proposed changes
   
   Supports reading CSV data using LF and CRLF as line separators.
   
   csv file:
   ```
   1,abc
   2,def\r
   3,qwe
   4,hello\r
   ```
   if you  `set keep_carriage_return = false`
   you will get :
   ```mysql
   1   abc
   2   def
   3   qwe
   4   hello
   ```
   Here, both \r\n and \n are used as delimiters.
   
   if you  `set keep_carriage_return = true`
   you will get :
   ```mysql
   1   abc
   2   def\r
   3   qwe
   4   hello\r
   ```
   Here only \n is used as a delimiter.
   
   It should be noted that `set keep_carriage_return = true` is valid for tvf, 
but not for stream load/mysql load. This means that when you perform stream 
load/mysql load, crlf and lf will be automatically used as delimiters, even if 
you `set keep_carriage_return = true`.
   
   


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

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