Re: In load data, CSV row contains special char at start and end of value but insert as a NULL

2016-10-25 Thread Harmeet Singh
Thanks Ravi, This is working fine. -- View this message in context: http://apache-carbondata-mailing-list-archive.1130556.n5.nabble.com/In-load-data-CSV-row-contains-special-char-at-start-and-end-of-value-but-insert-as-a-NULL-tp2345p2348.html Sent from the Apache CarbonData Mailing List

Re: In load data, CSV row contains special char at start and end of value but insert as a NULL

2016-10-25 Thread ravipesala
Here age is int data type so it cannot insert special characters. Please try with string type and verify. -- View this message in context:

In load data, CSV row contains special char at start and end of value but insert as a NULL

2016-10-25 Thread Harmeet Singh
Hey Team, I am trying to load the data in CSV with special char. But if some rows contains some special char at start and end, the whole value is ignore and inserted Null value. I am expecting this values insert as a string if the start and end char are not match with quote char. Following are