Rahul Kumar created PHOENIX-7649:
------------------------------------
Summary: Seconday uncovered Index on BSON data is not receiving
mutation
Key: PHOENIX-7649
URL: https://issues.apache.org/jira/browse/PHOENIX-7649
Project: Phoenix
Issue Type: Bug
Reporter: Rahul Kumar
Assignee: Rahul Kumar
Fix For: 5.3.0
There is a difference in behaviour on indexing BSON col for uncovered indexes.
For eg, I tried creating a covered({*}test_bson_idx{*}) and uncovered
index({*}test_bson_idx_uncov{*}) with same column but uncovered index dint get
update for UPSERT row.
{code:java}
0: jdbc:phoenix:zookeeper-0.zookeeper-headles> CREATE TABLE test_bson (PK1
VARCHAR NOT NULL, C1 VARCHAR, COL BSON, CONSTRAINT pk PRIMARY KEY(PK1));
2025-06-25 12:20:12,847 INFO [main] client.HBaseAdmin - Operation: CREATE,
Table Name: default:TEST_BSON, procId: 51716 completed
0: jdbc:phoenix:zookeeper-0.zookeeper-headles> CREATE UNCOVERED INDEX
test_bson_idx_uncov ON test_bson(COL);
2025-06-25 12:21:19,465 INFO [main] schema.MetaDataClient - STORAGE--ENCODING:
ONE_CELL_PER_COLUMN--NON_ENCODED_QUALIFIERS
2025-06-25 12:21:19,466 INFO [main] schema.MetaDataClient - Using CQSI level
Default Index State=b for Index=TEST_BSON_IDX_UNCOV ON TEST_BSON
2025-06-25 12:21:20,604 INFO [main] client.HBaseAdmin - Operation: CREATE,
Table Name: default:TEST_BSON_IDX_UNCOV, procId: 51719 completed
2025-06-25 12:21:20,624 INFO [main] schema.MetaDataClient - Created index
TEST_BSON_IDX_UNCOV at 1750854080610
0: jdbc:phoenix:zookeeper-0.zookeeper-headles> CREATE INDEX test_bson_idx ON
test_bson(COL);
2025-06-25 12:21:40,729 INFO [main] schema.MetaDataClient - STORAGE--ENCODING:
ONE_CELL_PER_COLUMN--NON_ENCODED_QUALIFIERS
2025-06-25 12:21:40,729 INFO [main] schema.MetaDataClient - Using CQSI level
Default Index State=b for Index=TEST_BSON_IDX ON TEST_BSON
2025-06-25 12:21:41,867 INFO [main] client.HBaseAdmin - Operation: CREATE,
Table Name: default:TEST_BSON_IDX, procId: 51722 completed
2025-06-25 12:21:41,883 INFO [main] schema.MetaDataClient - Created index
TEST_BSON_IDX at 1750854101870
0: jdbc:phoenix:zookeeper-0.zookeeper-headles> UPSERT INTO test_bson
VALUES('pk401', '401', '{"status": "enabled", "name": { "first": "Harry",
"middle": "Peter", "last": "Watson"}}');
0: jdbc:phoenix:zookeeper-0.zookeeper-headles> select * from
test_bson_idx_uncov;
0: jdbc:phoenix:zookeeper-0.zookeeper-headles> select * from test_bson_idx;
0:COL
:PK1 Xpk4010COL�� �bXstatuenabledname9firstHarrymiddlePeterlastWatsonpk401
0: jdbc:phoenix:zookeeper-0.zookeeper-headles> {code}
Also, in above covered index COL is null and PK1 is binary coded which is not
as expected.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
