hi, Harmeet
not reproduce. pls provide more details. reagrds Jay ------------------ Original ------------------ From: "Harmeet";<[email protected]>; Date: Fri, Oct 21, 2016 02:51 PM To: "dev"<[email protected]>; 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.
