SQL Reference

this sql reference section includes details about the different data types, functions, and operators available when writing queries for for an introduction to the general query syntax and working with queries in ocient, see query ocient docid\ s0dywbqubbanzcnc4z9fx for information on the sql syntax conventions used throughout the ocient documentation, see the sql syntax conventions docid\ gqoyzhlfznsryrw4gttgq page data types data types docid\ czxgepf3prq9ufwhwbiuy functions & operators aggregate functions docid\ roka1ck6hndmod1smej1s sorted aggregate functions docid\ xa9jf8l59tk 4facsfczh window aggregate functions docid\ knh6ndwnm hzuab9dwzrz scalar data conversion functions docid\ iteimff9ycez0ctcfgqb date and time functions docid\ hem zd qwquv8dfnvnqz8 time zone functions docid\ iwtcunl3t9rlghwvu2dsx formatting functions docid\ naengoslrgk2ikpyh6lkc math functions and operators docid\ saa2re dvaqcs gtjp3ps character and binary functions docid\ ja8cont33tonx ktruedj matrix functions and operators docid\ nhymyoadealtcppijauc5 tuple functions and operators docid\ mrrm7nwt xwcg zvmy6 p other functions and expressions docid\ d5nz44sy24y5 bp ygu7d array functions and operators docid\ xuk0z8dmxpgmogszpdw6w hyperloglog functions docid\ phb7ceh0zkhenc5beasgb network type functions docid\ ezupx17nbsz6c4g5e7o o geospatial functions & operators attribute functions docid 9c9mesl ut uqgh8qmpq9 conversion functions docid\ ln31h9xuiniz 9q3nd0m linestring functions docid waxmx64wjb9bhjibuf8b linestring constructors docid\ ja2bwo8hlbgf8s2gffhvk point constructors docid 9nnprzt3hqeet7csvwwxe polygon constructors docid 6s1zu ro01da1k 1py5xk spatial measurement docid\ vgbw5fb dtz1vzsb6lria spatial operators docid\ pifo3jqjej4vo8mp3zkyd spatial relationships docid\ j48pdvqo xrpcwp eecyi spatiotemporal measurement docid\ z sg ji6rbv01v5wtlzz2 spatiotemporal operators docid\ m7egwhp4eqnp5gr81gvwq ddl sql statements cluster and node management docid\ c4g2tdqxhblp1aavwmzgq databases docid\ uy5crlqbr0ymvtqzwna6x schemas docid\ m9zbpvfqpm96jidxyhqvi tables docid\ yhp4b1irv haf8f3df ww indexes docid\ n7zyxmwfavae6fnmv2uvw data pipelines docid\ pbyszqvu5wonpgoso qto distributed tasks docid\ lp3hitukekekfy1vmalei machine learning models docid\ jyvggzczktiksnbvb4msz users, groups, and service classes docid\ jygpvmqcl3xgpbvftt4qp data integrity and storage docid\ ozuc8svtn 2ep jceanrv query analysis docid 5rvt6idm alkrqjsrm1em query management docid\ sxjfpnzfaa2gpkwiq3lv7 statistics cache management docid\ n3oao1btccvdhboru m1r dcl sql statements data control language (dcl) statement reference docid\ f55ngxtki0f7kkmyatvug machine learning execution machine learning model functions docid\ ydyzvrbfpkxymmiv3bid1 other sql reference errors and warnings docid\ xhkkwud at3llhh77niqx reserved words docid\ t4nfcihztip15 vcu4xwv system catalog reference docid\ qwdubbtvh5e84jotgojzw