SET Commands

Session-level configuration via SET statements and environment variables.

SET Statements

Statement	Description
`SET shuffle.partitions = N`	Override the shuffle bucket count (positive integer). Pass `0` to restore auto-sizing.

SET shuffle.partitions = 8;
SELECT * FROM large_table;

Variable	Default	Description
`KRISHIV_COORDINATOR`	—	gRPC endpoint for distributed mode.
`KRISHIV_COORDINATOR_BEARER_TOKEN`	—	Bearer token sent to the coordinator.
`KRISHIV_EXECUTOR_TASK_BEARER_TOKEN`	—	Bearer token for executor gRPC.
`KRISHIV_PLAN_CACHE_MAX_ENTRIES`	256	Maximum cached query plans per SQL engine.
`KRISHIV_QUERY_MEMORY_LIMIT_BYTES`	none	Per-engine DataFusion memory pool limit; 0 = unbounded.
`KRISHIV_MATCH_RECOGNIZE_STREAMING_LIMIT`	100000	Max rows materialised for MATCH_RECOGNIZE on streaming sources.
`KRISHIV_DURABILITY_PROFILE`	dev-local	One of `dev-local`, `single-node-durable`, `distributed-durable`.