需要先創建表：

CREATE TABLE IF NOT EXISTS population (

state CHAR(2) NOT NULL, city VARCHAR NOT NULL, population BIGINT

CONSTRAINT my_pk PRIMARY KEY (state, city));

在phoenix 目錄下執行

hadoop jar /home/phoenix-4.6.0-HBase-1.0-bin/phoenix-4.6.0-HBase-1.0-client.jar ? org.apache.phoenix.mapreduce.CsvBulkLoadTool -t POPULATION -i /datas/us_population.csv

-t ：tableName

-i: input file 文件必須在hdfs文件上。

后查詢表數據是空。

問題：?ERROR mapreduce.CsvBulkLoadTool: Error Wrong FS: file:/home/hadoop/tmp/partitions_101bd67a-ec2c-4808-bc9f-bf4cd6ea74b9, expected: hdfs://node11:9000 occurred submitting CSVBulkLoad

參數意義：

-a,--array-delimiter Array element delimiter (optional)

-c,--import-columns Comma-separated list of columns to be

imported

-d,--delimiter Input delimiter, defaults to comma

-e,--escape Supply a custom escape character, default is

a backslash

-g,--ignore-errors Ignore input errors

-h,--help Show this help and quit

-i,--input Input CSV path (mandatory)

-it,--index-table Phoenix index table name when just loading

this particualar index table

-o,--output Output path for temporary HFiles (optional)

-q,--quote Supply a custom phrase delimiter, defaults

to double quote character

-s,--schema Phoenix schema name (optional)

-t,--table Phoenix table name (mandatory)

-z,--zookeeper Supply zookeeper connection details

(optional)

原文：http://www.cnblogs.com/zhanggl/p/5191912.html