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

Architecture and Working of Hive

Other Operations

Options

Spec:

Options(<CALL>, columnAttrs=<BOOL>, excludeColumns=<BOOL>, excludeRowAttrs=<BOOL>, shards=[UINT ...])

Description:

Modifies the given query as follows:

  • columnAttrs: Include column attributes in the result (Default: false).
  • excludeColumns: Exclude column IDs from the result (Default: false).
  • excludeRowAttrs: Exclude row attributes from the result (Default: false).
  • shards: Run the query using only the data from the given shards. By default, the entire data set (i.e. data from all shards) is used.

Result Type: Same result type as <CALL>.

Examples:

Return column attributes:

Options(Row(f1=10), columnAttrs=true)
{"attrs":{},"columns":[100]}],"columnAttrs":[{"id":100,"attrs":{"foo":"bar"}}

Run the query against shards 0 and 2 only:

Options(Row(f1=10), shards=[0, 2])
{"attrs":{},"columns":[100, 2097152]}