0

i have existing Phoenix table abc i wanna Bulk Data Loading via MapReduce And then used the following command to load the csv file

hadoop jar /root/Phoenix/apache-phoenix-4.8.0-HBase-0.98-bin/phoenix-4.8.0-HBase-0.98-client.jar org.apache.phoenix.mapreduce.CsvBulkLoadTool --t abc --input /example.csv

but, it does not seem to find the table abc

Exception in thread "main" java.lang.IllegalArgumentException: Table ABC not found

i try change command table name --t 'abc' and --t "abc" but it doesn't work how can i use table name small letter ??

And also, i found same case

http://apache-phoenix-user-list.1124778.n5.nabble.com/Load-into-Phoenix-table-via-CsvBulkLoadTool-cannot-find-table-and-fails-td2792.html

thanks

judid
  • 1
  • 1
  • I have done similar thing and able to reproduce the issue you are saying. But I think in the job parameter, you can do use the string toUpperCase method for the same. I believe It will work. – Sonu Dec 26 '16 at 12:54

1 Answers1

0

I got the same error, after a lot of debugging I realized that phoenix converts you input "abc" into all caps "ABC" and tries to look for a table with this name. And Phoenix is case sensitive as mentioned here.

Try to create your table in phoenix shell with all caps and then run the same command, it should work just fine.

Sample table creation and bulk upload via mapreduce:

CREATE TABLE "CODEFREQUENCY" (pk VARCHAR PRIMARY KEY,"week"."weekNum" VARCHAR,"week"."addition" VARCHAR,"week"."deletion" VARCHAR);

HADOOP_CLASSPATH=$(hbase mapredcp):~/Installs/Hbase/conf/:~/Installs/apache-phoenix-4.10.0-HBase-1.2-bin/ ./hadoop jar ~/Installs/apache-phoenix-4.10.0-HBase-1.2-bin/phoenix-4.10.0-HBase-1.2-client.jar org.apache.phoenix.mapreduce.CsvBulkLoadTool -Dfs.permissions.umask-mode=000 -d $'\t' -t CODEFREQUENCY --input /hbase/Code_Frequency.csv
cosmoonot
  • 2,161
  • 3
  • 32
  • 38
Piyush Saxena
  • 127
  • 1
  • 5