The problem dealing with the error of line break in the field when the Apache Kylin build cube

1. Production scene

Apache Kylin when build cube to build diemension will error, error content for a piece of data, after the investigation, found that there is the original data line character, but Kylin not recognized.

2. Solution ① Query The original data has newline characters field

Set table name A, field name is B,

SQL statement: SELECT * from A where C like '% ' | | Chr (10) | | '%';

② empty fields with line breaks

Set a table name of a, with a newline character field named B,

SQL statement: Update A set B =replace (b, ' To_char (Chr (10)) ', ');