You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@carbondata.apache.org by ja...@apache.org on 2018/02/09 02:27:39 UTC
carbondata git commit: [CARBONDATA-2138] Added documentation for
HEADER option while loading data
Repository: carbondata
Updated Branches:
refs/heads/master aebe55ebd -> 7c6c42f2d
[CARBONDATA-2138] Added documentation for HEADER option while loading data
Added documentation for HEADER option in load data
This closes #1938
Project: http://git-wip-us.apache.org/repos/asf/carbondata/repo
Commit: http://git-wip-us.apache.org/repos/asf/carbondata/commit/7c6c42f2
Tree: http://git-wip-us.apache.org/repos/asf/carbondata/tree/7c6c42f2
Diff: http://git-wip-us.apache.org/repos/asf/carbondata/diff/7c6c42f2
Branch: refs/heads/master
Commit: 7c6c42f2dad7686c437da1b510df121af1c6f59b
Parents: aebe55e
Author: sgururajshetty <sg...@gmail.com>
Authored: Tue Feb 6 20:58:59 2018 +0530
Committer: Jacky Li <ja...@qq.com>
Committed: Fri Feb 9 10:27:25 2018 +0800
----------------------------------------------------------------------
docs/data-management-on-carbondata.md | 11 +++++++++++
1 file changed, 11 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/carbondata/blob/7c6c42f2/docs/data-management-on-carbondata.md
----------------------------------------------------------------------
diff --git a/docs/data-management-on-carbondata.md b/docs/data-management-on-carbondata.md
index fba2916..61bb356 100644
--- a/docs/data-management-on-carbondata.md
+++ b/docs/data-management-on-carbondata.md
@@ -330,6 +330,16 @@ This tutorial is going to introduce all commands and data operations on CarbonDa
OPTIONS('COMMENTCHAR'='#')
```
+ - **HEADER:** When you load the CSV file without the file header and the file header is the same with the table schema, then add 'HEADER'='false' to load data SQL as user need not provide the file header. By default the value is 'true'.
+ false: CSV file is without file header.
+ true: CSV file is with file header.
+
+ ```
+ OPTIONS('HEADER'='false')
+ ```
+
+ NOTE: If the HEADER option exist and is set to 'true', then the FILEHEADER option is not required.
+
- **FILEHEADER:** Headers can be provided in the LOAD DATA command if headers are missing in the source files.
```
@@ -402,6 +412,7 @@ This tutorial is going to introduce all commands and data operations on CarbonDa
```
LOAD DATA local inpath '/opt/rawdata/data.csv' INTO table carbontable
options('DELIMITER'=',', 'QUOTECHAR'='"','COMMENTCHAR'='#',
+ 'HEADER'='false',
'FILEHEADER'='empno,empname,designation,doj,workgroupcategory,
workgroupcategoryname,deptno,deptname,projectcode,
projectjoindate,projectenddate,attendance,utilization,salary',