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

Reply via email to