Email: support@essaywriterpros.com
Call Us: US - +1 845 478 5244 | UK - +44 20 7193 7850 | AUS - +61 2 8005 4826

Schema Integration

Row (BSI)

Spec:

Row([<COMPARISON_VALUE> <COMPARISON_OPERATOR>] <FIELD> <COMPARISON_OPERATOR> <COMPARISON_VALUE>)

Description:

The Row query is overloaded to work on integer values as well as timestamp values. Returns bits that are true for the comparison operator.

Result Type: object with attrs and columns

Examples:

In our source data, commitactivity was counted over the last year. The following greater-than Row query returns all columns with a field value greater than 100 (repositories having more than 100 commits):

Row(commitactivity > 100)
{{"attrs":{},"columns":[10]}
  • columns are repositories which had at least 100 commits in the last year.

BSI range queries support the following operators:

OPERATORNAMEVALUE
>greater-than, GTinteger
<less-than, LTinteger
<=less-than-or-equal-to, LTEinteger
>=greater-than-or-equal-to, GTEinteger
==equal-to, EQinteger
!=not-equal-to, NEQinteger or null

A bounded interval can be specified by chaining the < and <= operators (but not others). For example:

Row(50 < commitactivity < 150)
{{"attrs":{},"columns":[10]}

As of Pilosa 1.0, the “between” syntax Row(frame=stats, commitactivity >< [50, 150]) is no longer supported.