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

[Lion.X]

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

[ravipesala]

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, 向志强 <[hidden email]> 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

[Lion.X]

trim the data when data loading.

2016-10-17 16:22 GMT+08:00 Ravindra Pesala <[hidden email]>:

> 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, 向志强 <[hidden email]> 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
>

[Qingqing Zhou]

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