Login  Register

Re: [Discussion] Support Date/Time format for Timestamp columns to be defined at column level

Posted by Jean-Baptiste Onofré on Sep 26, 2016; 8:19pm
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/Discussion-Support-Date-Time-format-for-Timestamp-columns-to-be-defined-at-column-level-tp1422p1494.html

+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, "向志强" <[hidden email]> 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é
[hidden email]
http://blog.nanthrax.net
Talend - http://www.talend.com