[
https://issues.apache.org/jira/browse/PHOENIX-7649?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Viraj Jasani updated PHOENIX-7649:
----------------------------------
Fix Version/s: 5.4.0
(was: 5.3.0)
> 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
> Priority: Major
> Fix For: 5.4.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)
