You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2021/08/24 06:49:29 UTC

[GitHub] [incubator-doris] yangmingjie opened a new issue #6497: 可能是doris-flink-connecter的问题-数据换行报错

yangmingjie opened a new issue #6497:
URL: https://github.com/apache/incubator-doris/issues/6497


   在使用doris-connector的时候，数据导入到doris一部分的试试报错：
   ![image](https://user-images.githubusercontent.com/5827183/130569914-51f90209-1f28-44a4-a2f2-7cd1c4d1ce94.png)
   
   
   最后发现问题如下：
   
   mysql数据库中有个字段mateName是varchar（255），如下：
   ![image](https://user-images.githubusercontent.com/5827183/130567216-94860c88-8c43-41b3-8de9-bc1b0a7204f5.png)
   拷贝出来后内容，有换行：
   ![image](https://user-images.githubusercontent.com/5827183/130567284-6fc3d660-34e3-4b2a-9353-433b7b60081b.png)
   
   


-- 
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] [incubator-doris] wwm2333 commented on issue #6497: 可能是doris-flink-connecter的问题-数据换行报错

Posted by GitBox <gi...@apache.org>.
wwm2333 commented on issue #6497:
URL: https://github.com/apache/incubator-doris/issues/6497#issuecomment-911417494


   We had the same problem


-- 
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] [incubator-doris] JNSimba commented on issue #6497: 可能是doris-flink-connecter的问题-数据换行报错

Posted by GitBox <gi...@apache.org>.
JNSimba commented on issue #6497:
URL: https://github.com/apache/incubator-doris/issues/6497#issuecomment-904378667


   Currently it is the csv text import method. The default column separator is \t and the row separator \n. If there are these two characters in the data, this error will occur. You can modify the parameters sink.properties.line_delimiter and sink.properties.column_separator to try


-- 
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] [incubator-doris] yangmingjie commented on issue #6497: 可能是doris-flink-connecter的问题-数据换行报错

Posted by GitBox <gi...@apache.org>.
yangmingjie commented on issue #6497:
URL: https://github.com/apache/incubator-doris/issues/6497#issuecomment-906956884


   > Currently it is the csv text import method. The default column separator is \t and the row separator \n. If there are these two characters in the data, this error will occur. You can modify the parameters sink.properties.line_delimiter and sink.properties.column_separator to try
   
   多谢大佬  
   
   但是我们试验这还是有一样的问题 我们的设置如下：
   
   ![image](https://user-images.githubusercontent.com/5827183/131081684-4a9130f1-b33f-4ddd-9d88-acd450a953be.png)
   


-- 
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] [incubator-doris] JNSimba edited a comment on issue #6497: 可能是doris-flink-connecter的问题-数据换行报错

Posted by GitBox <gi...@apache.org>.
JNSimba edited a comment on issue #6497:
URL: https://github.com/apache/incubator-doris/issues/6497#issuecomment-911468104


   Try to set  line_delimiter and column_separator to different value. the same prefix value may cause doris to be indistinguishable 


-- 
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] [incubator-doris] JNSimba commented on issue #6497: 可能是doris-flink-connecter的问题-数据换行报错

Posted by GitBox <gi...@apache.org>.
JNSimba commented on issue #6497:
URL: https://github.com/apache/incubator-doris/issues/6497#issuecomment-911468104


   Try to set  sink.properties.line_delimiter and sink.properties.column_separator to different value


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