Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 55E0F200BB8 for ; Sat, 29 Oct 2016 05:31:05 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 5491E160B03; Sat, 29 Oct 2016 03:31:05 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 9A53F160AE4 for ; Sat, 29 Oct 2016 05:31:04 +0200 (CEST) Received: (qmail 23550 invoked by uid 500); 29 Oct 2016 03:31:03 -0000 Mailing-List: contact issues-help@carbondata.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@carbondata.incubator.apache.org Delivered-To: mailing list issues@carbondata.incubator.apache.org Received: (qmail 23541 invoked by uid 99); 29 Oct 2016 03:31:03 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 29 Oct 2016 03:31:03 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 3A50CC1A28 for ; Sat, 29 Oct 2016 03:31:03 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -6.218 X-Spam-Level: X-Spam-Status: No, score=-6.218 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_HI=-5, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-2.999, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id 0W-tcgcRq1uv for ; Sat, 29 Oct 2016 03:31:02 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with SMTP id A54A85F54E for ; Sat, 29 Oct 2016 03:31:01 +0000 (UTC) Received: (qmail 23514 invoked by uid 99); 29 Oct 2016 03:31:00 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 29 Oct 2016 03:31:00 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id BAB432C14F9 for ; Sat, 29 Oct 2016 03:31:00 +0000 (UTC) Date: Sat, 29 Oct 2016 03:31:00 +0000 (UTC) From: "ASF GitHub Bot (JIRA)" To: issues@carbondata.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (CARBONDATA-37) Support Date/Time format for Timestamp columns to be defined at column level MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Sat, 29 Oct 2016 03:31:05 -0000 [ https://issues.apache.org/jira/browse/CARBONDATA-37?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15617327#comment-15617327 ] ASF GitHub Bot commented on CARBONDATA-37: ------------------------------------------ Github user QiangCai commented on a diff in the pull request: https://github.com/apache/incubator-carbondata/pull/219#discussion_r85632919 --- Diff: integration/spark/src/main/scala/org/apache/spark/sql/execution/command/carbonTableSchema.scala --- @@ -1244,6 +1246,29 @@ case class LoadTableUsingKettle( Seq.empty } + private def validateDateFormat(dateFormat: String, table: CarbonTable): Unit = { + val dimensions = table.getDimensionByTableName(tableName).asScala + if (dateFormat != null) { + if (dateFormat.trim == "") { + throw new MalformedCarbonCommandException("Error: Option DateFormat is set an empty " + --- End diff -- better to remove "Error: " for all exception message > 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)