kdb+ Function Reference

This list is not necessarily exhaustive. If you spot something new, feel free to add it below!

Symbols

?	find/rand	.	index/apply/trap	@	index/apply/trap
^	fill	$	cast/if-else/dot product	~	match
#	take	_	drop/cut	,	join
!	dict/key	:	amend/return	::	generic null/global amend
/	comment/over/converge	\	abort/scan/iterate	\\	quit
/:	eachright	\:	eachleft	':	eachprior
'	signal/eachboth

Numbers

0:	prepare/save/load text
1:	binary
2:	dynamic load
1	write to stdout
2	write to stderr

Names

A	abs, aj, aj0, acos, all, and, any, asc, asin, asof, atan, attr, avg, avgs
B	bin
C	ceiling, cols, cor, cos, count, cov, cross, cut
D	delete, deltas, desc, dev, differ, distinct, div, do
E	each, ej, enlist, eval, except, exec, exit, exp
F	fby, fills, first, flip, floor, fkeys
G	get, getenv, group, gtime
H	hclose, hcount, hdel, hopen, hsym
I	iasc, idesc, if, ij, in, insert, inter, inv
K	key, keys
L	last, like, lj, load, log, lower, lsq, ltime, ltrim
M	mavg, max, maxs, mcount, md5, mdev, med, meta, min, mins, mmax, mmin, mmu, mod, msum
N	neg, next, not, null
O	or, over
P	parse, peach, pj, plist, prd, prds, prev, prior
R	rand, rank, ratios, raze, read0, read1, reciprocal, reverse, rload, rotate, rsave, rtrim
S	save, scan, select, set, setenv, show, signum, sin, sqrt, ss, ssr, string, sublist, sum, sums, sv, system
T	tables, tan, til, trim, txf, type
U	uj, ungroup, union, update, upper, upsert
V	value, var, view, views, vs
W	wavg, where, while, within, wj, wj1, wsum
X	xasc, xbar, xcol, xcols, xdesc, xexp, xgroup, xkey, xlog, xprev, xrank

Namespaces

The single letter namespaces - upper case and lowercase - are reserved for Kx use and should not be used to store user written code or data.

.Q namespace

for functions in the .Q namespace see the .Q unreference

.z namespace

.z.a	address	.z.ac	auth from cookie
.z.b	dependencies	.z.bm	bad message
.z.c	physical core count
.z.exit	action on exit	.z.f	file
.z.h	host	.z.i	PID
.z.k	release date	.z.K	version
.z.l	license	.z.n	gmt (timespan)
.z.N	local (timespan)	.z.o	OS
.z.p	gmt (timestamp)	.z.P	local (timestamp)
.z.pc	close	.z.pg	get
.z.ph	http get	.z.pi	input
.z.po	open	.z.pp	http post
.z.ps	set	.z.pw	validate user
.z.q	quiet mode	.z.s	self
.z.ts	timer	.z.u	userid
.z.vs	value set	.z.w	handle
.z.W	handles	.z.x	argv
.z.z	gmt time (datetime)	.z.Z	local time (datetime)
.z.[tTdD]	time/date shortcuts	.z.zd	zip defaults