phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Siva <sbhavan...@gmail.com>
Subject Phoenix bulk loading
Date Thu, 12 Feb 2015 00:28:01 GMT
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.

Mime
View raw message