SQL Reference

this sql reference section includes details about the different data types, functions, and operators available when writing queries for {{ocient}} for an introduction to the general query syntax and working with queries in ocient, see query ocient docid\ pj83zadmfz4dqseq5on7n for information on the sql syntax conventions used throughout the ocient documentation, see the sql syntax conventions docid 32zfmno8mwgrfuy2lsjz4 page data types data types docid\ g9 6amoszrxd9exdwggcz functions & operators aggregate functions docid\ a794p1hruev25euof9svc sorted aggregate functions docid\ wds8rkcmp08swtccthtgc window aggregate functions docid\ ck097 7hkjcqouu hxylo scalar data conversion functions docid\ z eke1vfdl6dccamv52ur date and time functions docid\ ollvrg4vjupmvwhgpupdu time zone functions docid\ f8elldnuxgrzirili8c4p formatting functions docid\ g ia4znpotfx2kegcvv2r math functions and operators docid\ jbcpq ilyezmmxoz8csfr character and binary functions docid\ t4v9mfehdtbx8w 6ipulp matrix functions and operators docid\ uplpscv6tgx3s4qlmv9c0 tuple functions and operators docid\ k1tb1haf90usfjkxkl rq other functions and expressions docid\ bldix6qqhtnj mgu6lntm array functions and operators docid\ ymza gmw5298nhgmbsuyn hyperloglog functions docid\ lsrp6umq ruz2rnmfx6 7 network type functions docid\ egbatxnamusv6rlsnmqsi geospatial functions & operators attribute functions docid\ gat6uiiectf ysibhiv u conversion functions docid\ xwqsjw7ilwis8jliqujvr linestring functions docid\ wg zsriizjfn3xpyw13lp linestring constructors docid 23wnavad2bwc2enidb6wy point constructors docid\ xcyhlciuwq ll4op5kfo polygon constructors docid\ kh okeoguvnbioqtvv1ha spatial measurement docid\ wl 1wpoiuauejgdvofohc spatial operators docid\ k seycheuebhzs21kem6v spatial relationships docid\ cai7h lh9vyvdihc8nrh spatiotemporal measurement docid\ t5lzn2qtkihkqs7zjttxu spatiotemporal operators docid\ ujzu ikrvmucbv0el6kkn ddl sql statements cluster and node management docid\ bnlgs0qq1wre7ndja8q0x database, tables, views, and indexes docid\ ejutg6wjnk5eg55kizq8d data pipelines docid\ tqsshgl ifitlhjt78mbd distributed tasks docid ak14li9mhye9szzwi1t5 machine learning models docid\ cq7pmtrfsxiaz5dp2d9bs users, groups, and service classes docid\ iwkirup8638xpra30vnl3 data integrity and storage docid 95mk5gpibah8w1zqvh5aa query analysis docid\ qajnit4hq47vdj9tspeso statistics cache management docid\ k31wsvzlzeqve stza dcl sql statements data control language (dcl) statement reference docid 7jq6fizrghsmuumsa4qiq machine learning execution machine learning model functions docid\ jsgwuw5og56fzrve5h10g other sql reference errors and warnings docid\ zbqrcnzopmklz 9bxxnzu reserved words docid\ k4 hgg15i9h5ywwuuznar system catalog reference docid\ rltcwjqbqxytn5q4a5up5