If you use INFOBRIGHT, you will not be familiar with this word.
There are currently four formats. 1. binary.2. txt_variable3. mysql4. infobright
What does it mean? Let me explain it in detail.BINARY represents BINARY data. That is to say, raw data is saved in binary format. For specific formats, see the official White Paper, which is easy to download. TXT_VARIABLE indicates CSV text. The default column separator is ";". MYSQL stands for CSV format text compatible with MYSQL. The default Delimiter is "Horizontal tab". INFOBRIGHT, representing the intermediate result set generated by the distributed import tool DLP, can only be used to import intermediate data of DLP.
The loading speeds of these formats are arranged from high to low in the following order:INFOBRIGHT ---> BINARY ---> TXT_VARIABLE ---> MYSQL. We can see that MYSQL load is slowest. However, MYSQL can print more error messages for debugging.
Setting method:Set @ bh_dataformat = 'whatever the type.
This article is from "god, let's see it !" Blog, please be sure to keep this source http://yueliangdao0608.blog.51cto.com/397025/887262