phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <>
Subject Load into Phoenix table via CsvBulkLoadTool cannot find table and fails
Date Sun, 23 Oct 2016 14:39:54 GMT

My stack

Hbase: hbase-1.2.3
Phoenix: apache-phoenix-4.8.1-HBase-1.2-bin

As a suggestion I tried to load an Hbase file via


I created a dummy table in Hbase as below

create 'dummy', 'price_info'

Then in Phoenix I created a table on Hbase table

create table "dummy" (PK VARCHAR PRIMARY KEY, "price_info"."ticker"
VARCHAR,"price_info"."timecreated" VARCHAR, "price_info"."price" VARCHAR);

And then used the following comman to load the csv file

hadoop jar phoenix-4.8.1-HBase-1.2-client.jar
--table dummy --input /data/prices/2016-10-23/prices.1477228923115

However, it does not seem to find the table dummy !

2016-10-23 14:38:39,442 INFO  [main] metrics.Metrics: Initializing metrics
system: phoenix
2016-10-23 14:38:39,479 INFO  [main] impl.MetricsConfig: loaded properties
2016-10-23 14:38:39,529 INFO  [main] impl.MetricsSystemImpl: Scheduled
snapshot period at 10 second(s).
2016-10-23 14:38:39,529 INFO  [main] impl.MetricsSystemImpl: phoenix
metrics system started
Exception in thread "main" java.lang.IllegalArgumentException: Table DUMMY
not found
        at org.apache.phoenix.util.SchemaUtil.generateColumnInfo(Schema
        at org.apache.phoenix.mapreduce.AbstractBulkLoadTool.buildImpor
        at org.apache.phoenix.mapreduce.AbstractBulkLoadTool.loadData(A
        at org.apache.phoenix.mapreduce.CsvBulkLoadTool.main(CsvBulkLoa
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
        at java.lang.reflect.Method.invoke(
        at org.apache.hadoop.util.RunJar.main(

I tried putting it inside "" etc but no joy I am afraid!

Dr Mich Talebzadeh

LinkedIn *

*Disclaimer:* Use it at your own risk. Any and all responsibility for any
loss, damage or destruction of data or any other property which may arise
from relying on this email's technical content is explicitly disclaimed.
The author will in no case be liable for any monetary damages arising from
such loss, damage or destruction.

View raw message