How to delete the property index from mixed index.

[LoverAndrew]

For example, how to delete "del_full_text_20210610" from vertex_idx manually.

Vertex Index Name              | Type        | Unique    | Backing        | Key:           Status |
---------------------------------------------------------------------------------------------------
vertex_idx                     | Mixed       | false     | search         | label_name:    ENABLED |
                               |             |           |                | name:         ENABLED |
                               |             |           |                | tags:         ENABLED |
                               |             |           |                | del_full_text_20210610:    ENABLED |

[mad]

When property deleted from schema it is deleted from index too

graph = JanusGraphFactory.build().
set("storage.backend","berkeleyje").
set("storage.directory","/tmp/graph").
set("index.search.backend","lucene").
set("index.search.directory","/tmp/graph").
open()
mgmt = graph.openManagement()
p1 = mgmt.makePropertyKey('p1').cardinality(Cardinality.SINGLE).dataType(String.class).make()
p2 = mgmt.makePropertyKey('p2').cardinality(Cardinality.SINGLE).dataType(String.class).make()
mgmt.buildIndex("idx", Vertex.class).addKey(p1, Mapping.STRING.asParameter()).addKey(p2, Mapping.STRING.asParameter()).buildMixedIndex("search")
mgmt.printIndexes()
mgmt.printPropertyKeys()
mgmt.commit();

// But mixed index should be dropped manually and any vertices with this property

mgmt = graph.openManagement()
p1 = mgmt.getOrCreatePropertyKey('p1')
p1.remove()
mgmt.commit();

mgmt = graph.openManagement()
mgmt.printPropertyKeys()
mgmt.printIndexes()
mgmt.commit();

gremlin> graph = JanusGraphFactory.build().
......1> set("storage.backend","berkeleyje").
......2> set("storage.directory","/tmp/graph").
......3> set("index.search.backend","lucene").
......4> set("index.search.directory","/tmp/graph").
......5> open()
==>standardjanusgraph[berkeleyje:/tmp/graph]
gremlin> mgmt = graph.openManagement()
==>org.janusgraph.graphdb.database.management.ManagementSystem@12e3f4ae
gremlin> p1 = mgmt.makePropertyKey('p1').cardinality(Cardinality.SINGLE).dataType(String.class).make()
==>p1
gremlin> p2 = mgmt.makePropertyKey('p2').cardinality(Cardinality.SINGLE).dataType(String.class).make()
==>p2
gremlin> mgmt.buildIndex("idx", Vertex.class).addKey(p1, Mapping.STRING.asParameter()).addKey(p2, Mapping.STRING.asParameter()).buildMixedIndex("search")
==>idx
gremlin> mgmt.printIndexes()
==>------------------------------------------------------------------------------------------------
Graph Index (Vertex)           | Type        | Unique    | Backing        | Key:           Status |
---------------------------------------------------------------------------------------------------
idx                            | Mixed       | false     | search         | p1:           ENABLED |
                               |             |           |                | p2:           ENABLED |
---------------------------------------------------------------------------------------------------
Graph Index (Edge)             | Type        | Unique    | Backing        | Key:           Status |
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
Relation Index (VCI)           | Type        | Direction | Sort Key       | Order    |     Status |
---------------------------------------------------------------------------------------------------

gremlin> mgmt.printPropertyKeys()
==>------------------------------------------------------------------------------------------------
Property Key Name              | Cardinality | Data Type                                          |
---------------------------------------------------------------------------------------------------
p1                             | SINGLE      | class java.lang.String                             |
p2                             | SINGLE      | class java.lang.String                             |
---------------------------------------------------------------------------------------------------

gremlin> mgmt.commit();
==>null
gremlin> 
gremlin> // But mixed index should be dropped manually and any vertices with this property
==>true
gremlin> 
gremlin> mgmt = graph.openManagement()
==>org.janusgraph.graphdb.database.management.ManagementSystem@60861e5d
gremlin> p1 = mgmt.getOrCreatePropertyKey('p1')
==>p1
gremlin> p1.remove()
==>null
gremlin> mgmt.commit();
==>null
gremlin> 
gremlin> mgmt = graph.openManagement()
==>org.janusgraph.graphdb.database.management.ManagementSystem@7131d668
gremlin> mgmt.printPropertyKeys()
==>------------------------------------------------------------------------------------------------
Property Key Name              | Cardinality | Data Type                                          |
---------------------------------------------------------------------------------------------------
p2                             | SINGLE      | class java.lang.String                             |
---------------------------------------------------------------------------------------------------

gremlin> mgmt.printIndexes()
==>------------------------------------------------------------------------------------------------
Graph Index (Vertex)           | Type        | Unique    | Backing        | Key:           Status |
---------------------------------------------------------------------------------------------------
idx                            | Mixed       | false     | search         | p2:           ENABLED |
---------------------------------------------------------------------------------------------------
Graph Index (Edge)             | Type        | Unique    | Backing        | Key:           Status |
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
Relation Index (VCI)           | Type        | Direction | Sort Key       | Order    |     Status |
---------------------------------------------------------------------------------------------------

[LoverAndrew]

According your guide, it didn't work.

gremlin> mgmt = graph.openManagement()
==>org.janusgraph.graphdb.database.management.ManagementSystem@82d6eda
gremlin> p1 = mgmt.makePropertyKey('p1').cardinality(Cardinality.SINGLE).dataType(String.class).make()
==>p1
gremlin> p2 = mgmt.makePropertyKey('p2').cardinality(Cardinality.SINGLE).dataType(String.class).make()
==>p2
gremlin> mgmt.buildIndex("idx", Vertex.class).addKey(p1, Mapping.STRING.asParameter()).addKey(p2, Mapping.STRING.asParameter()).buildMixedIndex("search")
==>idx
gremlin> mgmt.commit();
==>null
gremlin> mgmt = graph.openManagement()
==>org.janusgraph.graphdb.database.management.ManagementSystem@7ed015b0
gremlin> mgmt.printIndexes()
==>------------------------------------------------------------------------------------------------
Graph Index (Vertex)           | Type        | Unique    | Backing        | Key:           Status |
---------------------------------------------------------------------------------------------------
idx                            | Mixed       | false     | search         | p1:           ENABLED |
                               |             |           |                | p2:           ENABLED |
---------------------------------------------------------------------------------------------------
Graph Index (Edge)             | Type        | Unique    | Backing        | Key:           Status |
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
Relation Index (VCI)           | Type        | Direction | Sort Key       | Order    |     Status |
---------------------------------------------------------------------------------------------------

gremlin> p1 = mgmt.getOrCreatePropertyKey('p1')
==>p1
gremlin> p1.remove()
==>null
gremlin> mgmt.commit();
==>null
gremlin> mgmt = graph.openManagement()
==>org.janusgraph.graphdb.database.management.ManagementSystem@14f07033
gremlin>  mgmt.printPropertyKeys()
==>------------------------------------------------------------------------------------------------
Property Key Name              | Cardinality | Data Type                                          |
---------------------------------------------------------------------------------------------------
p2                             | SINGLE      | class java.lang.String                             |
---------------------------------------------------------------------------------------------------

gremlin> mgmt.printIndexes()
==>------------------------------------------------------------------------------------------------
Graph Index (Vertex)           | Type        | Unique    | Backing        | Key:           Status |
---------------------------------------------------------------------------------------------------
idx                            | Mixed       | false     | search         | p1:           ENABLED |
                               |             |           |                | p2:           ENABLED |
---------------------------------------------------------------------------------------------------
Graph Index (Edge)             | Type        | Unique    | Backing        | Key:           Status |
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
Relation Index (VCI)           | Type        | Direction | Sort Key       | Order    |     Status |
---------------------------------------------------------------------------------------------------

[zichen-fei]

rebuild index
mgmt.updateIndex(mgmt.getGraphIndex("p2"),SchemaAction.REINDEX).get()
mgmt.commitI()