全文检索的安装与使用

一   安装步骤

$ tar xvfj GBase8a_MPP_Cluster-NoLicense-fulltext-9.5.2.38-redhat7.3-x86_64.tar.bz2

gcinstall_fulltext/

gcinstall_fulltext/gcwareGroup.json

gcinstall_fulltext/fulltext.py

gcinstall_fulltext/license.txt

gcinstall_fulltext/InstallTar.py

gcinstall_fulltext/FileCheck.py

gcinstall_fulltext/rootPwd.json

gcinstall_fulltext/extendCfg.xml

gcinstall_fulltext/replaceStop.py

gcinstall_fulltext/SSHThread.py

gcinstall_fulltext/demo.options

gcinstall_fulltext/RestoreLocal.py

gcinstall_fulltext/InstallFuns.py

gcinstall_fulltext/rmt.py

gcinstall_fulltext/example.xml

gcinstall_fulltext/CGConfigChecker.py

gcinstall_fulltext/pexpect.py

gcinstall_fulltext/cluster.conf

gcinstall_fulltext/gccopy.py

gcinstall_fulltext/gbase_data_timezone.sql

gcinstall_fulltext/gcexec.py

gcinstall_fulltext/unInstall_fulltext.py

gcinstall_fulltext/SetSysEnv.py

gcinstall_fulltext/CorosyncConf.py

gcinstall_fulltext/BUILDINFO

gcinstall_fulltext/dependRpms

gcinstall_fulltext/gcinstall_fulltext.py

gcinstall_fulltext/fulltext.tar.bz2

$ gcluster_services all stop

Stopping GCMonit success!

Stopping gcrecover :                                       [  OK  ]

Stopping gcluster :                                        [  OK  ]

Stopping gcware :                                          [  OK  ]

Stopping gbase :                                           [  OK  ]

Stopping syncserver :                                      [  OK  ]

$ ./gcinstall_fulltext.py --dbaUserPwd=gbase

CoordinateHost:

10.10.8.*    10.10.8.*

DataHost:

10.10.8.*    10.10.8.*

Are you sure to install fulltext on these gcluster nodes. ([Y,y]/[N,n])? y

10.10.8.* Install fulltext successfully.

10.10.8.*  Install fulltext successfully.

二  全文检索语法

GBase 8a MPP Cluster全文索引的建立共支持三种模式：

1.  CREATE TABLE语句建立全文索引

该方法是在用户创建表时,可以同时创建全文索引，需要使用FULLTEXT关键字进行创建。

CREATE TABLE sms (MB_No char(11),MB_Text varchar(1000) DEFAULT NULL, FULLTEXT idx_t (MB_Text));

 CREATE TABLE text1 (col1 varchar(100), FULLTEXT INDEX fti_col1 (col1) INDEX_DATA_PATH='/home/fti/');

2.CREATE INDEX语句建立全文索引

该方法是在用户建立表后，指明表中哪一列需要建立全文索引，需要使用FULLTEXT关键字。

CREATE FULLTEXT INDEX idx_t ON sms(MB_Text) INDEX_DATA_PATH='/home/fti/';

UPDATE INDEX idx_t ON sms;

3.ALTER TABLE...ADD INDEX语句建立全文索引

该方法是在用户建立表后，通过修改表定义的方法指明哪一列需要建立全文索引

CREATE TABLE sms (MB_No char(11),MB_Text varchar(1000) DEFAULT NULL);

ALTER TABLE sms add fulltext index idx_t (MB_Text) INDEX_DATA_PATH='/home/fti/';

 如果用户创建索引的时候未指定索引数据存放路径，则索引数据会保存在{datadir}/{DATABASE}/目录下，数据库的metadata文件夹中（{datadir}是对应集群配置文件下的参数），如C00001.FTD。

$ ll

total 12

drwx------. 2 gbase gbase    6 Mar 31 17:02 C00001.FTD

-rw-------. 1 gbase gbase 1056 Mar 31 17:02 C00001.fti

-rw-------. 1 gbase gbase  428 Mar 31 17:02 table.info.A

-rw-------. 1 gbase gbase  428 Mar 31 16:40 table.info.B