[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/carbonstore-rebase Commit: 7c6c42f2dad7686c437da1b510df121af1c6f59b Parents: aebe55e Author: sgururajshetty <sgururajshe...@gmail.com> Authored: Tue Feb 6 20:58:59 2018 +0530 Committer: Jacky Li <jacky.li...@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',