Hello all, is there a way to specify to keep NULL values for the columns which were not there in csv file as part of bulk loading?
Requirement I have is, few row in csv file contains all the column, but rows contain only few columns. In Hbase, if the given record doesnt have desired columns, it just ignore the columns and it goes for next record while loading the data from ImportTsv. 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 P_TEST_2_COLS --input /user/sbhavanari/p_h_test_2_cols_less.csv --import-columns NAME,LEADID,D --zookeeper 172.31.45.176:2181:/hbase Thanks, Siva.
