carbondata-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ravipes...@apache.org
Subject [04/25] carbondata git commit: [CARBONDATA-2138] Added documentation for HEADER option while loading data
Date Sat, 03 Mar 2018 12:43:51 GMT
[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 <sgururajshetty@gmail.com>
Authored: Tue Feb 6 20:58:59 2018 +0530
Committer: ravipesala <ravi.pesala@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',


Mime
View raw message