Dropping data, schema, and graphs

In DataStax Studio, how to drop (delete) data, schema, and graphs.

Data, schema, and graphs can be dropped (deleted) in DataStax Studio as follows:

Procedure

Drop data

  • To drop all data without dropping a graph and schema, drop all vertices.
    g.V().drop().iterate()
  • To drop specific data, such as all author vertices, identify the vertices along with a drop traversal step.
    g.V().hasLabel('author').drop()
    Warning: Dropping vertices with this command will also drop all edges associated with the vertices. Any vertex at the other end of an edge will remain, but the edges and edge properties will be dropped from the data.
    Note: If a very large number of vertices will be dropped with the command shown above, DSE Graph may complain. In that case, modify the drop() command in the following manner:
    g.V().hasLabel('author').limit(100).drop()
    and repeat until all vertices are dropped.
  • To drop a specific value, such as author vertices, identify the vertices along with a drop traversal step.
    g.V().hasLabel('author').properties('gender').hasValue('M').drop()

    This query will drop the gender value for all vertices that have a gender value of M.

    gremlin> g.V().hasLabel('author').valueMap()
    ==>{gender=[F], name=[Julia Child]}
    ==>{gender=[F], name=[Patricia Curtan]}
    ==>{gender=[F], name=[Kelsie Kerr]}
    ==>{gender=[F], name=[Simone Beck]}
    ==>{gender=[F], name=[Alice Waters]}
    ==>{gender=[F], name=[Patricia Simon]}
    ==>{name=[James Beard]}
    ==>{name=[Fritz Streiff]}
    ==>{name=[Emeril Lagasse]}
  • To drop a property key from an edge, such as rated edges, identify the edges, the property key stars along with a drop traversal step.
    g.E().hasLabel('rated').properties('stars').drop()

    This query will drop the property key starsfor all edges that have a rated edge label.

    g.E().hasLabel('rated').properties('stars').valueMap()
    returns no values.
    Warning: For data created earlier than DSE 5.0.5, conditions exist that will drop all edges as well as the edge property during a property key drop. See Dropping edge property drops edges.

Drop schema

  • To drop the schema and all data without dropping the graph, use a clear() step. Running describe() after will verify that the schema is dropped. After the schema is dropped, new schema and data can be loaded to the graph.
    schema.clear()
    Important: Currently, certain schema elements such as a vertex label cannot be individually modified or removed. If a change to the schema is necessary, drop the whole schema as detailed above and recreate.

Dropping a graph

  • Dropping a graph will clear all schema and data as well as deleting the graph. A system command is required to drop a graph. In order to use system commands, the graph traversal alias must be cleared. A configuration reset clears the alias.
    gremlin> :remote config alias reset
    Note: System commands are not accessible when a graph is aliased.
    ==>Aliases cleared
  • Optional: If unsure of the graph name, examine what graphs exist. Note that system commands do not work in Studio, and must be run in Gremlin console.
    gremlin> system.graphs()
    ==>food
  • Drop the desired graph by running the drop() command in Gremlin console.
    gremlin> system.graph('food').drop()
    ==>null

Dropping an index