DELETE

Syntax

DELETE [deleteItem [, ...]] FROM [MAPPING] mapping_name with_clause [IF bool_expr]

deleteItem:
      family_name ':*'
    | family_name ':' column_name
    | alias_name

Description

  • Delete data from the table referenced by mapping_name using the WITH or WITH INDEX clause.
  • If no delete_items are specified, then the entire row is deleted. If families and/or column names are specified in delete_items, then just those elements are deleted from the row.

Example

        HConnection conn = HConnectionManager.newConnection();

        conn.execute("CREATE TEMP MAPPING fooMapping FOR TABLE foo "
                     + "("
                     + "keyval KEY, "
                     + "family1 ("
                     + "  val1 INT ALIAS val11, "
                     + "  val2 INT ALIAS val12, "
                     + "  val3 INT ALIAS val13, "
                     + "  val4 INT ALIAS val14, "
                     + "  val5 STRING ALIAS val15"
                     + "))");

        conn.execute("DELETE FROM fooMapping WITH CLIENT FILTER WHERE val1 > 4");

        conn.execute("DELETE family1:val1, val12 FROM fooMapping WITH CLIENT FILTER WHERE val1 > 5");

        conn.execute("DELETE family1:* FROM fooMapping WITH CLIENT FILTER WHERE val1 > 7");