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 1CA2D200B84 for ; Tue, 20 Sep 2016 09:40:54 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 1B263160AC9; Tue, 20 Sep 2016 07:40:54 +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 54EC2160AA9 for ; Tue, 20 Sep 2016 09:40:53 +0200 (CEST) Received: (qmail 43554 invoked by uid 500); 20 Sep 2016 07:40:52 -0000 Mailing-List: contact commits-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 commits@carbondata.incubator.apache.org Received: (qmail 43543 invoked by uid 99); 20 Sep 2016 07:40:52 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Sep 2016 07:40:52 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id F319B1887E8 for ; Tue, 20 Sep 2016 07:40:51 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -4.646 X-Spam-Level: X-Spam-Status: No, score=-4.646 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=-1.426] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id AGYZfuw87PD8 for ; Tue, 20 Sep 2016 07:40:50 +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 1273A60E28 for ; Tue, 20 Sep 2016 07:40:48 +0000 (UTC) Received: (qmail 43518 invoked by uid 99); 20 Sep 2016 07:40:48 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 Sep 2016 07:40:48 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 0F489E0BDD; Tue, 20 Sep 2016 07:40:48 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: jackylk@apache.org To: commits@carbondata.incubator.apache.org Date: Tue, 20 Sep 2016 07:40:47 -0000 Message-Id: <0fd252232ac648519904acc2227849eb@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [1/2] incubator-carbondata git commit: update doc for adding information about COMMENTCHAR archived-at: Tue, 20 Sep 2016 07:40:54 -0000 Repository: incubator-carbondata Updated Branches: refs/heads/master b2e48a398 -> 591a4896c update doc for adding information about COMMENTCHAR Project: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/commit/ea338d60 Tree: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/tree/ea338d60 Diff: http://git-wip-us.apache.org/repos/asf/incubator-carbondata/diff/ea338d60 Branch: refs/heads/master Commit: ea338d60dcd4edd31c62ce5d4bad4ed9890fc71a Parents: b2e48a3 Author: lion-x Authored: Mon Sep 19 11:36:21 2016 +0800 Committer: jackylk Committed: Tue Sep 20 00:39:00 2016 -0700 ---------------------------------------------------------------------- docs/DML-Operations-on-Carbon.md | 15 ++++++++++----- 1 file changed, 10 insertions(+), 5 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-carbondata/blob/ea338d60/docs/DML-Operations-on-Carbon.md ---------------------------------------------------------------------- diff --git a/docs/DML-Operations-on-Carbon.md b/docs/DML-Operations-on-Carbon.md index 6c7197c..31cba8e 100644 --- a/docs/DML-Operations-on-Carbon.md +++ b/docs/DML-Operations-on-Carbon.md @@ -46,15 +46,20 @@ ### Usage Guideline Following are the options that can be used in load data: -- **DELIMITER:** Delimiters and Quote Characters can be provided in the load command. +- **DELIMITER:** Delimiters can be provided in the load command. ``` ruby - OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"') + OPTIONS('DELIMITER'=',') ``` -- **QUOTECHAR:** Delimiters and Quote Characters can be provided in the load command. +- **QUOTECHAR:** Quote Characters can be provided in the load command. ```ruby - OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"') + OPTIONS('QUOTECHAR'='"') + ``` +- **COMMENTCHAR:** Comment Characters can be provided in the load command if user want to comment lines. + + ```ruby + OPTIONS('COMMENTCHAR'='#') ``` - **FILEHEADER:** Headers can be provided in the LOAD DATA command if headers are missing in the source files. @@ -96,7 +101,7 @@ Following are the options that can be used in load data: ```ruby LOAD DATA local inpath '/opt/rawdata/data.csv' INTO table carbontable - options('DELIMITER'=',', 'QUOTECHAR'='"', + options('DELIMITER'=',', 'QUOTECHAR'='"', 'COMMENTCHAR'='#', 'FILEHEADER'='empno,empname, designation,doj,workgroupcategory, workgroupcategoryname,deptno,deptname,projectcode,