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

[杰 <25...@qq.com>]

hi, Harmeet


  not reproduce. pls provide more details.


reagrds
Jay


------------------ Original ------------------
From:  "Harmeet";<ha...@gmail.com>;
Date:  Fri, Oct 21, 2016 02:51 PM
To:  "dev"<de...@carbondata.incubator.apache.org>; 

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



Hey Jay, Thanks for your reply.

First case with Pipe symbols working fine, But still in second case i am
getting the same error. Below is my query :

csv file >> 
name; description; salary; age; dob
tammy; 'my name'; 900000; 22; 19/10/2019


0: jdbc:hive2://127.0.0.1:10000> load data local inpath
'hdfs://localhost:54310/home/harmeet/semiandquote.csv' into table one
OPTIONS("DELIMITER"="\;", 'QUOTECHAR'="'");

Error: org.apache.spark.sql.AnalysisException: missing EOF at 'OPTIONS' near
'one'; line 1 pos 93 (state=,code=0)

Please correnct if something getting wrong.



--
View this message in context: http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/Unable-to-load-CSV-using-differenent-delimiter-like-Pipe-and-Semicolon-etc-tp2140p2144.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at Nabble.com.

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

[Harmeet <ha...@gmail.com>]

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 ?





--
View this message in context: http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/Unable-to-load-CSV-using-differenent-delimiter-like-Pipe-and-Semicolon-etc-tp2140p2163.html
Sent from the Apache CarbonData Mailing List archive mailing list archive at Nabble.com.