You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@carbondata.apache.org by ra...@apache.org on 2018/03/03 12:43:51 UTC
[04/25] carbondata git commit: [CARBONDATA-2138] Added documentation
for HEADER option while loading data
[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/4033f4ce
Tree: http://git-wip-us.apache.org/repos/asf/carbondata/tree/4033f4ce
Diff: http://git-wip-us.apache.org/repos/asf/carbondata/diff/4033f4ce
Branch: refs/heads/branch-1.3
Commit: 4033f4ce4f1ba280fca662de07c1253c7896b9e5
Parents: fd481f5
Author: sgururajshetty <sg...@gmail.com>
Authored: Tue Feb 6 20:58:59 2018 +0530
Committer: ravipesala <ra...@gmail.com>
Committed: Sat Mar 3 17:40:07 2018 +0530
----------------------------------------------------------------------
docs/data-management-on-carbondata.md | 11 +++++++++++
1 file changed, 11 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/carbondata/blob/4033f4ce/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',