ApsaraDB for HBase Publishes Full-Text Indexing Service to Handle Complex Queries

Reasons for Enhancing HBase’s Retrieval Ability

  1. The query based on any combination of conditions cannot be satisfied.
  2. Fuzzy queries cannot be efficiently supported.
  3. Word-breaking queries are not supported.
  4. Multi-dimensional sorting/paging cannot be efficiently supported.
  5. The query result set cannot be classified.

Full-Text Indexing Service of ApsaraDB for HBase

  1. Arbitrary query with complex conditions
  2. Multi-dimensional sorting
  3. Complex conditional paging
  4. Word-breaking keyword Query
  5. Classification of matching result sets
  6. Common stats, such as min, max, avg, and sum

Differences from Self-Built Architecture

How to Use the Full-Text Indexing Service

Enable Service

Create an Index

wget http://public-hbase.oss-cn-hangzhou.aliyuncs.com/installpackage/solr-7.3.1-ali-1.0.tgz
tar zxvf solr-7.3.1-ali-1.0.tgz
ZK_HOST=zk1:2181,zk2:2181,zk3:2181/solr
create  'solrdemo',{NAME=>'info',  REPLICATION_SCOPE=> '1'}
solr-7.3.1-ali-1.0/bin/solr zk upconfig -d _democonfig  -n democollection_config -z zk1:2181/solr
curl "http://hostname:8983/solr/admin/collections?action=CREATE&name=democollection&numShards=1&replicationFactor=1&collection.configName=democollection_config"
<? xml version="1.0"? >
<indexer table="solrdemo">
<field name="name_s" value="info:q2" type="string"/>
<field name="age_i" value="info:q3" type="int"/>
<param name="update_version_l" value="true"/>
</indexer>
solr-7.3.1-ali-1.0/bin/solr-indexer add  \
-n demoindex \
-f indexer_conf.xml \
-c democollection

Querying and Retrieval

Conclusion

  • The tool for index management is simpler and easier to use.
  • SQL portal provides access to the full-text indexing service.
  • The next-generation replication mechanism of the full-text engine is more efficient.
  • In addition to asynchronous indexes, synchronous indexes will also be supported in the future.

--

--

--

Follow me to keep abreast with the latest technology news, industry insights, and developer trends. Alibaba Cloud website:https://www.alibabacloud.com

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Binary Trees

K-Palindrome

Speed up your HTTP Web Requests with Asyncio Library in Python

Guide to Ruby Enumerables

Text2Knowledge Tutorial

Haraka v2 — The Short Input Hash

Tinkercad Circuits:避障自走車 Obstacle avoidance Car

Crossing a Mile Stone

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alibaba Cloud

Alibaba Cloud

Follow me to keep abreast with the latest technology news, industry insights, and developer trends. Alibaba Cloud website:https://www.alibabacloud.com

More from Medium

Stream avro data from kafka over ssl to Apache pinot

Use your own connector with Twitter and Aiven for Apache Kafka®

Apache Kafka

Master Pinot & Kevin the Minion