Call Us: US - +1 845 478 5244 | UK - +44 20 7193 7850 | AUS - +61 2 8005 4826

Distributed Database System

Arguments and Types

  • field The field specifies on which Pilosa field the query will operate. Valid field names are lower case strings; they start with an alphanumeric character, and contain only alphanumeric characters and _-. They must be 64 characters or less in length.
  • TIMESTAMP This is a timestamp in the following format YYYY-MM-DDTHH:MM (e.g. 2006-01-02T15:04)
  • UINT An unsigned integer (e.g. 42839)
  • BOOL A boolean value, true or false
  • ATTR_NAME Must be a valid identifier [A-Za-z][A-Za-z0-9._-]*
  • ATTR_VALUE Can be a string, float, integer, or bool.
  • CALL Any query
  • ROW_CALL Any query which returns a row, such as RowUnionDifferenceXorIntersectNot
  • []ATTR_VALUE Denotes an array of ATTR_VALUEs. (e.g. ["a", "b", "c"])

Write Operations





Set assigns a value of 1 to a bit in the binary matrix, thus associating the given row (the <ROW> value) in the given field with the given column.

While using “Set” in PQL is a convenient way to get familiar with Pilosa, it’s almost always better to use the import functionality in the GoJava, and Python clients to ingest lots of data.

Result Type: boolean

A return value of true indicates that the bit was changed to 1.

A return value of false indicates that the bit was already set to 1 and nothing changed.


Set the bit at row 1, column 10: