问题现象
全文支持blob uri 格式:
索引列为varchar uri,
uri 协议为hbase,
更新全文索引报错。
gbase> show create table t_write1;
+----------+---------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------+
| Table
| Create Table
|
+----------+---------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------+
| t_write1 | CREATE TABLE "t_write1" (
"a" int(11) DEFAULT NULL,
"b" varchar(2048) URI DEFAULT NULL,
FULLTEXT "h1" ("b")
) ENGINE=EXPRESS DEFAULT CHARSET=utf8 TABLESPACE='sys_tables
pace' |
GBase 8a MPP Cluster 最佳实践
5 FAQ
文档版本(2022-02-11)
南大通用数据技术股份有限公司
175
+----------+---------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------+
1 row in set (Elapsed: 00:00:00.00)
2、数据如下,数据通过demo-blob-on-hadoop-for-java灌入
gbase> select * from t_write;
+------+-------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------+
| a
| b
|
+------+-------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------+
|
1 | hbase://gc65.gbase.cn:9090/HbaseStream/file/252181202008311007411
4848xxxxx0xxxxxxxxx262148xxxxxxxxxxxxxx\r\nCONTENT-LENGTH:14848\r
\nLAST-MODIFIED:Mon, 31 Aug 2020 02:07:41 GMT\r\n\r\n |
+------+-------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------+
3、创建全文索引,更新报错
gbase> create fulltext index h1 on t_write1(b);
Records: 0
Duplicates: 0
Warnings: 0
gbase> update index h1 on t_write;
ERROR 1702 (HY000): gcluster table error: FULLTEXT:Not supported URI
path at row 0 reason: can not open the uri :hbase://gc65.gbase.cn:9090/Hba
seStream/file/2521812020083110074114848xxxxx0xxxxxxxxx262148xxxxxxxxx
xxxxx. Can not find correctly BLOB URI configuration...
4、gbcti的配置文件如下:
[gbase@namenode cfg]$ cat gbfticfg.xml
GBase 8a MPP Cluster 最佳实践
5 FAQ
文档版本(2022-02-11)
南大通用数据技术股份有限公司
176
解决方法
将
GBase 8a MPP Cluster 最佳实践
5 FAQ
文档版本(2022-02-11)
南大通用数据技术股份有限公司
177