Re: Unable to load CSV using differenent delimiter like "|"(Pipe)and";" (Semicolon) etc

Posted by Harmeet on Oct 21, 2016; 9:35am
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/Unable-to-load-CSV-using-differenent-delimiter-like-Pipe-and-Semicolon-etc-tp2140p2163.html

Hey Jay,

I am getting still same error. My code is up to date. I am creating new database and new table for testing. Following are details:

>> Create database
0: jdbc:hive2://127.0.0.1:10000> create database needb;
+---------+--+
| result  |
+---------+--+
+---------+--+
No rows selected (6.227 seconds)

>> use database
0: jdbc:hive2://127.0.0.1:10000> use needb;
+---------+--+
| result  |
+---------+--+
+---------+--+
No rows selected (0.081 seconds)

>> Create table
0: jdbc:hive2://127.0.0.1:10000> create table one(name string, description string, salary double, age int, dob timestamp) stored by 'carbondata';
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (1.297 seconds)

>> CSV File Data
name; description; salary; age; dob
tammy; my name; 900000; 22; 19/10/2019

>> Load Data
0: jdbc:hive2://127.0.0.1:10000> load data inpath 'hdfs://localhost:54310/home/harmeet/semiandquote.csv' into table one options('DELIMITER'="\;");
Error: org.apache.spark.sql.AnalysisException: missing EOF at 'options' near 'one'; line 1 pos 87 (state=,code=0)

I am still not figure out, what is missing ?