Member since
11-23-2022
2
Posts
0
Kudos Received
0
Solutions
02-16-2023
08:03 PM
Hello, I have a question about the performance of the local index in Apache Phoenix For example, I have a table TBL_X having 6 columns (A , B ,C ,D E, F). 1. Primary Key is (A, B) 2. One of the query patterns is "Select * from TBL_X where A = 'val1' and C = 'val3' " For the better performance of the above query, I try to build the local index. Does [ Local index on (C, A) ] perform better than [ Local index on (C) ] ?? or Will there be no performance difference since A is already in the first part of the PK ??
... View more
Labels:
- Labels:
-
Apache HBase
-
Apache Phoenix
11-23-2022
06:15 PM
Some hdfs operations (hsync, append, ... ) are not supported with the erasure coding (ec) policy. Does hbase work well when the data folders of hbase are set to the erasure coding policy? Is Hbase compatible with HDFS-EC instead of HDFS-replica ?
... View more