We have table contains a NOTE column, this column contains lines of text separated by new lines. When I export the data from .csv through bulkloader, Phoenix is failing with error and Hbase terminates the text till encounters the new line and assumes rest of NOTE as new record.
Is there a way to specify new line separator in Hbase or Phoenix bulk load? With phoenix: HADOOP_CLASSPATH=/usr/hdp/2.2.0.0-2041/hbase/lib/hbase-protocol.jar:/usr/hdp/2.2.0.0-2041/hbase/conf hadoop jar /usr/hdp/2.2.0.0-2041/phoenix/phoenix-4.2.0.2.2.0.0-2041-client.jar org.apache.phoenix.mapreduce.CsvBulkLoadTool --table test_leadwarehouse --input /user/sbhavanari/test_leadwarehouse.csv --zookeeper <zookeeper Ip>:2181:/hbase With hbase importtsv: base org.apache.hadoop.hbase.mapreduce.ImportTsv '-Dimporttsv.separator=,' -Dimporttsv.columns=<col_list> test_leadwarehouse /user/data/test_leadwarehouse.csv