CREATE Table in RT index

General Discussions - English
1

@Sergey @adrian
Hi ,
Would it be possible creating a table in RT index…?

manticore>create table rt_1(id int , name text) morphology='stem_en';

please let me know the RT index config file for CREATE TABLE.

2

No, it’s not possible. The error is self-explanatory:

mysql> create table rt_1(id int , name text) morphology='stem_en';
ERROR 1064 (42000): error adding index 'rt_1': can not add multiple attributes with same name 'id'

The correct command is:

mysql> create table rt_1(name text) morphology='stem_en';
Query OK, 0 rows affected (0.06 sec)

The corresponding config for it is:

index rt_1
{
    type = rt
    path = idx_rt_1
    rt_field = name
    morphology = stem_en
    stored_fields = name
}
1 Like