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

Enhanced ER Model

Write Operations

Set(, =, [TIMESTAMP])

Set assigns a value of 1 to a bit in the binary matrix, thus associating the given row (the 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 Go, Java, 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:

Set(10, stargazer=1)
This sets a bit in the stargazer field, representing that the user with id=1 has starred the repository with id=10.

Set also supports providing a timestamp. To write the date that a user starred a repository:

Set(10, stargazer=1, 2016-01-01T00:00)
Set multiple bits in a single request:

Set(10, stargazer=1) Set(20, stargazer=1) Set(10, stargazer=2) Set(30, stargazer=2)
Set the field “pullrequests” to integer value 2 at column 10:

Set(10, pullrequests=2)