Member since
10-08-2024
1
Post
1
Kudos Received
0
Solutions
10-08-2024
04:09 PM
1 Kudo
Hi team, Thanks for your time in advance. I have an issue bothering me a long time. Can somebody point me the right direction? I created a hbase instance in my local - no distribution, with phoenix coprocessors, then go to phoenix, run a sample DDL and upsert. For a simply select * from thetable, It shows the ids but null values for all of non-id columns. Settings: 1: hbase-2.6.0-hadoop3: I copied phoenix-server-hbase-2.6.jar to hbase_home/lib; then add coprocessors to hbase-site.xml: <property> <name>hbase.coprocessor.region.classes</name> <value> org.apache.phoenix.index.GlobalIndexChecker, org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver, org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver, org.apache.phoenix.coprocessor.ScanRegionObserver, org.apache.phoenix.coprocessor.ServerCachingEndpointImpl </value> </property> 2: phoenix-5.3.0: I introduced org.apache.phoenix:phoenix-core:5.3.0-SNAPSHOT to my local project. 3: then a simple DDL, upsert and query, can't see the values as in the resultset. DDL: CREATE TABLE IF NOT EXISTS A_TEST_1728428788967 (ID INTEGER NOT NULL PRIMARY KEY, NAME VARCHAR); UPSET: UPSERT INTO A_TEST_1728428788967 (ID, NAME) VALUES ('123', 'A test for a_test_1728428788967'); SELECT: SELECT * FROM A_TEST_1728428788967; --ID NAME --123 null <<<<<--------Here expecting to see "A test for a_test_1728428788967" but not. 4: I can see the values in hbase shell: hbase:030:0> scan 'A_TEST_1728428788967'; ROW COLUMN+CELL \x80\x000\x19 column=0:\x00\x00\x00\x00, timestamp=2024-10-08T19:06:29.756, value=x \x80\x000\x19 column=0:\x80\x0B, timestamp=2024-10-08T19:06:29.756, value=A test for a_test_1728428788967 5: here is the describe of the table: hbase:030:0> desc 'A_TEST_1728428788967'; Table A_TEST_1728428788967 is ENABLED A_TEST_1728428788967, {TABLE_ATTRIBUTES => {coprocessor$1 => '|org.apache.phoenix.coprocessor.ScanRegionObserver|805306366|', coprocessor$2 => '|org.apache.phoenix.coprocessor.UngroupedAggregateRegionObserver|80530 6366|', coprocessor$3 => '|org.apache.phoenix.coprocessor.GroupedAggregateRegionObserver|805306366|', coprocessor$4 => '|org.apache.phoenix.coprocessor.ServerCachingEndpointImpl|805306366|', coprocessor$5 => '|org. apache.phoenix.hbase.index.IndexRegionObserver|805306366|index.builder=org.apache.phoenix.index.PhoenixIndexBuilder,org.apache.hadoop.hbase.index.codec.class=org.apache.phoenix.index.PhoenixIndexCodec', METADATA => {'hbase.store.file-tracker.impl' => 'DEFAULT'}}} COLUMN FAMILIES DESCRIPTION {NAME => '0', INDEX_BLOCK_ENCODING => 'NONE', VERSIONS => '1', KEEP_DELETED_CELLS => 'FALSE', DATA_BLOCK_ENCODING => 'FAST_DIFF', TTL => 'FOREVER', MIN_VERSIONS => '0', REPLICATION_SCOPE => '0', BLOOMFILTER => 'ROW ', IN_MEMORY => 'false', COMPRESSION => 'NONE', BLOCKCACHE => 'true', BLOCKSIZE => '65536 B (64KB)'} Guessing maybe three issues, the coprocessors are not right, or I should not use local hbase instance, or I should downgrade version hbase to 2.5 and phoenix 5.2? Any suggestion will be appreciated greatly!
... View more
Labels:
- Labels:
-
Apache HBase
-
Apache Phoenix