Re: [Discussion] Support String Trim For Table Level or Col Level

Posted by Qingqing Zhou on Oct 20, 2016; 3:49am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/Discussion-Support-String-Trim-For-Table-Level-or-Col-Level-tp1990p2062.html

On Mon, Oct 17, 2016 at 1:59 AM, 向志强 <[hidden email]> wrote:
> trim the data when data loading.
>

This looks like a query processor (e.g., Spark) 's functionality instead
of Carbon's. User can even request some other transformations, like a
complicate SELECTE statement, while loading the data. One way to do this
is using INSERT statement. For example:

INSERT INTO target_table (SELECT trim(a), trim(b) FROM
your_mapped_csv_table) ;

Regards,
Qingqing