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

2016-10-19 Thread Qingqing Zhou 
On Mon, Oct 17, 2016 at 1:59 AM, 向志强  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

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

2016-10-17 Thread 向志强 
trim the data when data loading.

2016-10-17 16:22 GMT+08:00 Ravindra Pesala :

> Hi Lionx,
>
> Can you give more details on this feature?
> Are you talking about trim() function while querying? Or trim the data
> while loading to carbon?
>
> Regards,
> Ravi.
>
> On 17 October 2016 at 12:56, 向志强  wrote:
>
> > Hi all,
> > We are trying to support string trim feature in carbon.
> > The feature will be set in "Create Table".
> > Pls discuss in which level we should to support this feature, Tbl or Col?
> >
> > Thx,
> > Lionx
> >
>
>
>
> --
> Thanks & Regards,
> Ravi
>

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

2016-10-17 Thread Ravindra Pesala 
Hi Lionx,

Can you give more details on this feature?
Are you talking about trim() function while querying? Or trim the data
while loading to carbon?

Regards,
Ravi.

On 17 October 2016 at 12:56, 向志强  wrote:

> Hi all,
> We are trying to support string trim feature in carbon.
> The feature will be set in "Create Table".
> Pls discuss in which level we should to support this feature, Tbl or Col?
>
> Thx,
> Lionx
>



-- 
Thanks & Regards,
Ravi