question How to get the last key/value of rowpefix filter in hbase ? in Support Questions

question How to get the last key/value of rowpefix filter in hbase ? in Support Questions https://community.cloudera.com/t5/Support-Questions/How-to-get-the-last-key-value-of-rowpefix-filter-in-hbase/m-p/187065#M149167 Hello ,My hbase table rowkey are in following format:vin1ts1vin1ts2vin1ts3vin2ts1vin2ts2vin2ts3vin2ts4etc....I would like to get the last available key of each ROWPREFIX , where ROWPREFIX ={VIN1, VIN2, VIN3,...}Example: for RowPrefix= VIN1, It should return "Rowkey=vin1ts3" & its values.--------I am trying to use the reverse scan feature as below:Scan scan = new Scan();scan.setCaching(1) FilterList allFilters = new FilterList(FilterList.Operator.MUST_PASS_ALL); allFilters.addFilter(new PrefixFilter(Bytes.toBytes(prefixFilterValue))); scan.setFilter(allFilters); scan.setReversed(true); //Read the latest available key and value scan.setMaxResultSize(1); ResultScanner scanner = tblConn.getScanner(scan); Result result = scanner.next(); LOGGER.log(Level.INFO, "Latest Key " + Bytes.toString(result.getRow()));scanner.close(); -----------Above code works but takes around ~40 second to retrieve the target rowkey.Is there any better approach to get the same since 40 second is not sufficing our business condition ?Or do I need to set any scan property to reduce the scanner time ?Any pointers would be appreciated..CLUSER INFO:HDP:HDP-2.5.5.0hbase -version: Version 1.1.2.2.5.5.0-157, r002c801447187c620c26ffc130ff17a9b0a62ac1, Fri Apr 21 01:13:10 UTC 2017Regards,Revan Wed, 04 Jul 2018 13:24:23 GMT wabale_revan 2018-07-04T13:24:23Z