carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CARBONDATA-37) Support Date/Time format for Timestamp columns to be defined at column level
Date Tue, 11 Oct 2016 04:11:20 GMT

    [ https://issues.apache.org/jira/browse/CARBONDATA-37?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15564396#comment-15564396
] 

ASF GitHub Bot commented on CARBONDATA-37:
------------------------------------------

Github user lion-x commented on a diff in the pull request:

    https://github.com/apache/incubator-carbondata/pull/219#discussion_r82722044
  
    --- Diff: core/src/main/java/org/apache/carbondata/core/keygenerator/directdictionary/timestamp/TimeStampDirectDictionaryGenerator.java
---
    @@ -117,15 +117,24 @@ private TimeStampDirectDictionaryGenerator() {
        * @return dictionary value
        */
       @Override public int generateDirectSurrogateKey(String memberStr) {
    -    SimpleDateFormat timeParser = new SimpleDateFormat(CarbonProperties.getInstance()
    -        .getProperty(CarbonCommonConstants.CARBON_TIMESTAMP_FORMAT,
    -            CarbonCommonConstants.CARBON_TIMESTAMP_DEFAULT_FORMAT));
    +    String timeString;
    +    String formatString;
    +    if (memberStr.contains(CarbonCommonConstants.COLON_SPC_CHARACTER)){
    --- End diff --
    
    because in some format like XXXX-XX-XX 00:00:00.000, it has colon, it will make mistake
when separating the memberstring.
    for example member string like, 2016-08-11 00:00:00.000:yyyy-MM-dd HH.mm.ss.SSS


> Support Date/Time format for Timestamp columns to be defined at column level
> ----------------------------------------------------------------------------
>
>                 Key: CARBONDATA-37
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-37
>             Project: CarbonData
>          Issue Type: Improvement
>            Reporter: Vimal Das Kammath
>            Assignee: Lionx
>
> Carbon support defining the Date/Time format. But the configuration for the same is present
in carbon.properties and hence is global for all tables.
> This global configuration for timestamp format cannot support scenarios where different
tables or different Timestamp columns in the same table.
> Suggest to provide option in the create table DDL itself to define the format for each
Timestamp column. Also provide defaults so that users can create table with Timestamp columns
without having to always define the Date/Time format.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message