You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@carbondata.apache.org by 向志强 <li...@gmail.com> on 2016/09/24 08:41:50 UTC
[Discussion] Support Date/Time format for Timestamp columns to be
defined at column level
Hi, all
In recent days, I am trying to handle issues CARBONDATA-37. We are trying
to support that Date format can be set at column level.
There is a doubt that we should feedback the the same format for Date
column or feedback a uniform format. Absolutely.
For example.
we create a table and define two cols which data type is Date. But the Date
format is different.
col1(Date) col2(Date)
2016-09-24 2016-09-25 00:00:00
when querying, for two formats below, which should be returned?
col1(Date) col2(Date)
2016-09-24 2016-09-25 00:00:00
or
col1(Date) col2(Date)
2016-09-24 00:00:00 2016-09-25 00:00:00
if we set YYYY-MM-DD HH:MM:SS as default format.
Best wishes!
RE: [Discussion] Support Date/Time format for Timestamp columns to
be defined at column level
Posted by Jihong Ma <Ji...@huawei.com>.
I agree we should allow specifying timestamp format at column level, and respect that at data loading as well as query time. Is there technical reason which prevent us from doing that? Otherwise, respecting the specification should be the way to go.
col1(Date) col2(Date)
> > 2016-09-24 2016-09-25 00:00:00
Regards.
Jihong
-----Original Message-----
From: Venkata Gollamudi [mailto:g.ramana.v1@gmail.com]
Sent: Monday, September 26, 2016 1:05 PM
To: dev@carbondata.incubator.apache.org
Subject: Re: [Discussion] Support Date/Time format for Timestamp columns to be defined at column level
I completely agree with Vimal das.
On Sat, Sep 24, 2016, 10:05 PM Vimal Das Kammath <vi...@gmail.com>
wrote:
> Hi,
>
> The date format at column level should be to support loading data into
> carbon from csv files which have multiple columns with different date
> format. Currently data loading will fail if the multiple date columns are
> in different format.
>
> For the query result, my opinion is that the all the date columns in the
> result should be in a single format.
>
> Regards
> Vimal
>
>
> On Sep 24, 2016 2:11 PM, "向志强" <li...@gmail.com> wrote:
>
> > Hi, all
> >
> > In recent days, I am trying to handle issues CARBONDATA-37. We are trying
> > to support that Date format can be set at column level.
> >
> > There is a doubt that we should feedback the the same format for Date
> > column or feedback a uniform format. Absolutely.
> >
> > For example.
> >
> > we create a table and define two cols which data type is Date. But the
> Date
> > format is different.
> >
> > col1(Date) col2(Date)
> > 2016-09-24 2016-09-25 00:00:00
> >
> > when querying, for two formats below, which should be returned?
> >
> > col1(Date) col2(Date)
> > 2016-09-24 2016-09-25 00:00:00
> >
> > or
> >
> > col1(Date) col2(Date)
> > 2016-09-24 00:00:00 2016-09-25 00:00:00
> >
> > if we set YYYY-MM-DD HH:MM:SS as default format.
> >
> >
> > Best wishes!
> >
>
Re: [Discussion] Support Date/Time format for Timestamp columns to be
defined at column level
Posted by Venkata Gollamudi <g....@gmail.com>.
I completely agree with Vimal das.
On Sat, Sep 24, 2016, 10:05 PM Vimal Das Kammath <vi...@gmail.com>
wrote:
> Hi,
>
> The date format at column level should be to support loading data into
> carbon from csv files which have multiple columns with different date
> format. Currently data loading will fail if the multiple date columns are
> in different format.
>
> For the query result, my opinion is that the all the date columns in the
> result should be in a single format.
>
> Regards
> Vimal
>
>
> On Sep 24, 2016 2:11 PM, "向志强" <li...@gmail.com> wrote:
>
> > Hi, all
> >
> > In recent days, I am trying to handle issues CARBONDATA-37. We are trying
> > to support that Date format can be set at column level.
> >
> > There is a doubt that we should feedback the the same format for Date
> > column or feedback a uniform format. Absolutely.
> >
> > For example.
> >
> > we create a table and define two cols which data type is Date. But the
> Date
> > format is different.
> >
> > col1(Date) col2(Date)
> > 2016-09-24 2016-09-25 00:00:00
> >
> > when querying, for two formats below, which should be returned?
> >
> > col1(Date) col2(Date)
> > 2016-09-24 2016-09-25 00:00:00
> >
> > or
> >
> > col1(Date) col2(Date)
> > 2016-09-24 00:00:00 2016-09-25 00:00:00
> >
> > if we set YYYY-MM-DD HH:MM:SS as default format.
> >
> >
> > Best wishes!
> >
>
Re: [Discussion] Support Date/Time format for Timestamp columns tobe
defined at column level
Posted by Aniket Adnaik <an...@gmail.com>.
+1 single date/time format.
Regards,
Aniket
On Thu, Sep 29, 2016 at 12:50 PM, Kumar Vishal <ku...@gmail.com>
wrote:
> +1 I agree vimals opinion
>
> On Sep 29, 2016 17:22, "杰" <25...@qq.com> wrote:
>
> > +1 agree to vimal's opinion
> >
> > ---Original---
> > From: "bill.zhou"<zg...@163.com>
> > Date: 2016/9/29 17:07:04
> > To: "dev"<de...@carbondata.incubator.apache.org>;
> > Subject: Re: [Discussion] Support Date/Time format for Timestamp columns
> > tobe defined at column level
> >
> >
> > +1 I agree Vimal's opinion.
> > if user want other formatted, he can use function to convert.
> >
> > Regards
> > Bill
> >
> >
> >
> > --
> > View this message in context: http://apache-carbondata-
> > mailing-list-archive.1130556.n5.nabble.com/Discussion-
> > Support-Date-Time-format-for-Timestamp-columns-to-be-
> > defined-at-column-level-tp1422p1560.html
> > Sent from the Apache CarbonData Mailing List archive mailing list archive
> > at Nabble.com.
>
Re: [Discussion] Support Date/Time format for Timestamp columns tobe
defined at column level
Posted by Kumar Vishal <ku...@gmail.com>.
+1 I agree vimals opinion
On Sep 29, 2016 17:22, "杰" <25...@qq.com> wrote:
> +1 agree to vimal's opinion
>
> ---Original---
> From: "bill.zhou"<zg...@163.com>
> Date: 2016/9/29 17:07:04
> To: "dev"<de...@carbondata.incubator.apache.org>;
> Subject: Re: [Discussion] Support Date/Time format for Timestamp columns
> tobe defined at column level
>
>
> +1 I agree Vimal's opinion.
> if user want other formatted, he can use function to convert.
>
> Regards
> Bill
>
>
>
> --
> View this message in context: http://apache-carbondata-
> mailing-list-archive.1130556.n5.nabble.com/Discussion-
> Support-Date-Time-format-for-Timestamp-columns-to-be-
> defined-at-column-level-tp1422p1560.html
> Sent from the Apache CarbonData Mailing List archive mailing list archive
> at Nabble.com.
Re: [Discussion] Support Date/Time format for Timestamp columns tobe defined at column level
Posted by 杰 <25...@qq.com>.
+1 agree to vimal's opinion
---Original---
From: "bill.zhou"<zg...@163.com>
Date: 2016/9/29 17:07:04
To: "dev"<de...@carbondata.incubator.apache.org>;
Subject: Re: [Discussion] Support Date/Time format for Timestamp columns tobe defined at column level
+1 I agree Vimal's opinion.
if user want other formatted, he can use function to convert.
Regards
Bill
--
View this message in context: http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/Discussion-Support-Date-Time-format-for-Timestamp-columns-to-be-defined-at-column-level-tp1422p1560.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at Nabble.com.
Re: [Discussion] Support Date/Time format for Timestamp columns to
be defined at column level
Posted by "bill.zhou" <zg...@163.com>.
+1 I agree Vimal's opinion.
if user want other formatted, he can use function to convert.
Regards
Bill
--
View this message in context: http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/Discussion-Support-Date-Time-format-for-Timestamp-columns-to-be-defined-at-column-level-tp1422p1560.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at Nabble.com.
Re: [Discussion] Support Date/Time format for Timestamp columns to be
defined at column level
Posted by Jean-Baptiste Onofré <jb...@nanthrax.net>.
+1
Regards
JB
On 09/24/2016 06:35 PM, Vimal Das Kammath wrote:
> Hi,
>
> The date format at column level should be to support loading data into
> carbon from csv files which have multiple columns with different date
> format. Currently data loading will fail if the multiple date columns are
> in different format.
>
> For the query result, my opinion is that the all the date columns in the
> result should be in a single format.
>
> Regards
> Vimal
>
>
> On Sep 24, 2016 2:11 PM, "\u5411\u5fd7\u5f3a" <li...@gmail.com> wrote:
>
>> Hi, all
>>
>> In recent days, I am trying to handle issues CARBONDATA-37. We are trying
>> to support that Date format can be set at column level.
>>
>> There is a doubt that we should feedback the the same format for Date
>> column or feedback a uniform format. Absolutely.
>>
>> For example.
>>
>> we create a table and define two cols which data type is Date. But the Date
>> format is different.
>>
>> col1(Date) col2(Date)
>> 2016-09-24 2016-09-25 00:00:00
>>
>> when querying, for two formats below, which should be returned?
>>
>> col1(Date) col2(Date)
>> 2016-09-24 2016-09-25 00:00:00
>>
>> or
>>
>> col1(Date) col2(Date)
>> 2016-09-24 00:00:00 2016-09-25 00:00:00
>>
>> if we set YYYY-MM-DD HH:MM:SS as default format.
>>
>>
>> Best wishes!
>>
>
--
Jean-Baptiste Onofr�
jbonofre@apache.org
http://blog.nanthrax.net
Talend - http://www.talend.com
Re: [Discussion] Support Date/Time format for Timestamp columns to be
defined at column level
Posted by Vimal Das Kammath <vi...@gmail.com>.
Hi,
The date format at column level should be to support loading data into
carbon from csv files which have multiple columns with different date
format. Currently data loading will fail if the multiple date columns are
in different format.
For the query result, my opinion is that the all the date columns in the
result should be in a single format.
Regards
Vimal
On Sep 24, 2016 2:11 PM, "向志强" <li...@gmail.com> wrote:
> Hi, all
>
> In recent days, I am trying to handle issues CARBONDATA-37. We are trying
> to support that Date format can be set at column level.
>
> There is a doubt that we should feedback the the same format for Date
> column or feedback a uniform format. Absolutely.
>
> For example.
>
> we create a table and define two cols which data type is Date. But the Date
> format is different.
>
> col1(Date) col2(Date)
> 2016-09-24 2016-09-25 00:00:00
>
> when querying, for two formats below, which should be returned?
>
> col1(Date) col2(Date)
> 2016-09-24 2016-09-25 00:00:00
>
> or
>
> col1(Date) col2(Date)
> 2016-09-24 00:00:00 2016-09-25 00:00:00
>
> if we set YYYY-MM-DD HH:MM:SS as default format.
>
>
> Best wishes!
>
Re: [Discussion] Support Date/Time format for Timestamp columns to be
defined at column level
Posted by 向志强 <li...@gmail.com>.
Hi,all
I have done this issue.
Pls check:
PR 219
https://github.com/apache/incubator-carbondata/pull/219
2016-09-24 16:41 GMT+08:00 向志强 <li...@gmail.com>:
> Hi, all
>
> In recent days, I am trying to handle issues CARBONDATA-37. We are trying
> to support that Date format can be set at column level.
>
> There is a doubt that we should feedback the the same format for Date
> column or feedback a uniform format. Absolutely.
>
> For example.
>
> we create a table and define two cols which data type is Date. But the
> Date format is different.
>
> col1(Date) col2(Date)
> 2016-09-24 2016-09-25 00:00:00
>
> when querying, for two formats below, which should be returned?
>
> col1(Date) col2(Date)
> 2016-09-24 2016-09-25 00:00:00
>
> or
>
> col1(Date) col2(Date)
> 2016-09-24 00:00:00 2016-09-25 00:00:00
>
> if we set YYYY-MM-DD HH:MM:SS as default format.
>
>
> Best wishes!
>