phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ravi Kiran <maghamraviki...@gmail.com>
Subject Re: Error when Pig load data with PhoenixHBaseLoader
Date Sun, 05 Oct 2014 05:07:10 GMT
Hi Pham,

   From the logs , it looks like you are on phoenix 4.0.0 which doesn't
have support of PhoenixHbaseLoader. If possible, can you try with the
latest version
http://phoenix.apache.org/download.html as we have support for it from
4.1.0.

Regards
Ravi.

On Sat, Oct 4, 2014 at 9:36 PM, Pham Phuong Tu <tuphamphuong@gmail.com>
wrote:

> Hi guys.
>
> I want to load data from Phoenix to Pig but i received this error message
> when run command base on this tutorial from Phoenix's site:
> http://phoenix.apache.org/pig_integration.html
> <http://t.signauxtrois.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJW7t5XZs6538WTMcVPpMd0HHzW5v0wKg56dW7Yf2cTMkb02?t=http%3A%2F%2Fphoenix.apache.org%2Fpig_integration.html&si=5534200080891904&pi=10982922-b536-49e7-b787-52dca452e6ee>
>
> Here is my table descirbe:
> *+ Phoenix:*
>
> 0: jdbc:phoenix:localhost,bd2,bd37:2181> !describe DEVICE_ALL_APP1
>
>
> +------------+-------------+------------+-------------+------------+-----------+
>
> | TABLE_CAT  | TABLE_SCHEM | TABLE_NAME | COLUMN_NAME | DATA_TYPE  |
> TYPE_NAME |
>
>
> +------------+-------------+------------+-------------+------------+-----------+
>
> | null       | null        | DEVICE_ALL_APP1 | UUID        | 1          |
> CHAR |
>
> | null       | null        | DEVICE_ALL_APP1 | DEV_ID      | 1          |
> CHAR |
>
> | null       | null        | DEVICE_ALL_APP1 | APP_PACKAGE | 1          |
> CHAR |
>
> | null       | null        | DEVICE_ALL_APP1 | APP_VERSION | 1          |
> CHAR |
>
> | null       | null        | DEVICE_ALL_APP1 | TIME        | 4          |
> INTE |
>
> | null       | null        | DEVICE_ALL_APP1 | DAY_TIME    | 4          |
> INTE |
>
> | null       | null        | DEVICE_ALL_APP1 | HOUR_TIME   | 4          |
> INTE |
>
> | null       | null        | DEVICE_ALL_APP1 | STATUS      | 4          |
> INTE |
>
>
> +------------+-------------+------------+-------------+------------+-----------+
>
> *+ Hbase*
>
> hbase(main):011:0> describe 'DEVICE_ALL_APP1'
>
> DESCRIPTION
>                                                           ENABLED
>
>
>  'DEVICE_ALL_APP1', {TABLE_ATTRIBUTES => {coprocessor$1 =>
> '|org.apache.phoenix.coprocessor.ScanRegionObserver|1|', coprocessor$2 =
> true
>
>  > '|org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver|1|',
> coprocessor$3 => '|org.apache.phoenix.coprocessor.Grouped
>
>
>  AggregateRegionObserver|1|', coprocessor$4 =>
> '|org.apache.phoenix.coprocessor.ServerCachingEndpointImpl|1|',
> coprocessor$5 => '|o
>
>
>  rg.apache.phoenix.hbase.index.Indexer|1073741823|index.builder=org.apache.phoenix.index.PhoenixIndexBuilder,org.apache.hadoop.hbas
>
>
>  e.index.codec.class=org.apache.phoenix.index.PhoenixIndexCodec'}, {NAME
> => '0', DATA_BLOCK_ENCODING => 'FAST_DIFF', BLOOMFILTER =>
>
>
>   'ROW', REPLICATION_SCOPE => '0', VERSIONS => '1', COMPRESSION => 'NONE',
> MIN_VERSIONS => '0', TTL => '2147483647', KEEP_DELETED_C
>
>
>  ELLS => 'true', BLOCKSIZE => '65536', IN_MEMORY => 'false', BLOCKCACHE =>
> 'true'}
>
>
> 1 row(s) in 0.0620 seconds
>
> *Error when load data with Pig*
>
>> [root@bd1 ~]# pig
>> 2014-10-05 11:28:35,660 [main] INFO  org.apache.pig.Main - Apache Pig
>> version 0.12.1.2.1.1.0-385 (rexported) compiled Apr 16 2014, 15:59:00
>> 2014-10-05 11:28:35,660 [main] INFO  org.apache.pig.Main - Logging error
>> messages to: /root/pig_1412483315658.log
>> 2014-10-05 11:28:35,686 [main] INFO  org.apache.pig.impl.util.Utils -
>> Default bootup file /root/.pigbootup not found
>> 2014-10-05 11:28:36,223 [main] INFO
>> org.apache.hadoop.conf.Configuration.deprecation - mapred.job.tracker is
>> deprecated. Instead, use mapreduce.jobtracker.address
>> 2014-10-05 11:28:36,223 [main] INFO
>> org.apache.hadoop.conf.Configuration.deprecation - fs.default.name is
>> deprecated. Instead, use fs.defaultFS
>> 2014-10-05 11:28:36,223 [main] INFO
>> org.apache.pig.backend.hadoop.executionengine.HExecutionEngine - Connecting
>> to hadoop file system at: hdfs://bd1.local:8020
>> SLF4J: Class path contains multiple SLF4J bindings.
>> SLF4J: Found binding in
>> [jar:file:/usr/lib/hadoop/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
>> SLF4J: Found binding in
>> [jar:file:/usr/lib/pig/lib/phoenix-4.0.0.2.1.1.0-385-client.jar!/org/slf4j/impl/StaticLoggerBinder.class]
>> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
>> explanation.
>> SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
>> 2014-10-05 11:28:37,087 [main] INFO
>> org.apache.hadoop.conf.Configuration.deprecation - fs.default.name is
>> deprecated. Instead, use fs.defaultFS
>> grunt> register '/usr/lib/pig/lib/phoenix-4.0.0.2.1.1.0-385-client.jar'
>>
>> 2014-10-05 11:28:43,832 [main] INFO
>> org.apache.hadoop.conf.Configuration.deprecation - fs.default.name is
>> deprecated. Instead, use fs.defaultFS
>> grunt> A = load 'hbase://table/device_all_app1' using
>> org.apache.phoenix.pig.PhoenixHBaseLoader('localhost');
>> 2014-10-05 11:28:58,499 [main] ERROR org.apache.pig.tools.grunt.Grunt -
>> ERROR 1070: Could not resolve org.apache.phoenix.pig.PhoenixHBaseLoader
>> using imports: [, java.lang., org.apache.pig.builtin.,
>> org.apache.pig.impl.builtin.]
>> Details at logfile: /root/pig_1412483315658.log
>> grunt> A = load 'hbase://device_all_app1' using
>> org.apache.phoenix.pig.PhoenixHBaseLoader('localhost');
>> 2014-10-05 11:29:11,755 [main] ERROR org.apache.pig.tools.grunt.Grunt -
>> ERROR 1070: Could not resolve org.apache.phoenix.pig.PhoenixHBaseLoader
>> using imports: [, java.lang., org.apache.pig.builtin.,
>> org.apache.pig.impl.builtin.]
>> Details at logfile: /root/pig_1412483315658.log
>
> Thanks a lot.
> --
> *-----------------------------------------*
>
>
> *Pham Phuong TuBack-end & Big data developerSkype: phamphuongtu*
>

Mime
View raw message