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\ rlskzzscthcwe12dnsehy for information on the sql syntax conventions used throughout the ocient documentation, see the sql syntax conventions docid\ xwxcjgujvz3h0ldtot gs page data types data types docid\ jklzoceo9ij3akjz5r bi functions & operators aggregate functions docid\ zrac69qenzyasqgj5woq8 window aggregate functions docid\ yil5g89brwhxuqbmawiar scalar data conversion functions docid\ wxb1nwhra9g0lv6uk9lzq date and time functions docid\ xwimgbnxwbuufgm9fqej1 time zone functions docid\ znicufcjqyby4pvjxular formatting functions docid\ aclxyap vc nitdjjoeq math functions and operators docid\ fpjn4e63 o7tdrno0sg v character and binary functions docid\ h7i0divmh6cmadxzhsi9j matrix functions and operators docid\ iq4wlrmjge4avqvi0c 8 tuple functions and operators docid\ y8bea6 vwd6ud6qtudoes other functions and expressions docid\ sf23apami4vwhed bpem array functions and operators docid\ imlc3bk23fgefieyv 0mg hyperloglog functions docid 45odcf u70i5s7ngbz9gn network type functions docid 8rp8mbilrxtnc grswdmf geospatial functions & operators attribute functions docid\ yzitmkmyxkeu7r6cntc5a conversion functions docid\ l 4bbb9ayyg7wylg5ltmq linestring functions docid 4rydqn3pevreftzqwzaqv linestring constructors docid 6uezqid8dcteeex56nu i point constructors docid\ fsfzuzxxkqdygtxlhvutg polygon constructors docid\ ydhdag fujbsgtwiqdtl spatial measurement docid\ swxyidktpfo 1rw15l3wq spatial operators docid\ nmeng1 xs7g55ks6jbrwk spatial relationships docid\ fvbf3zgu l24y1bqdtnd4 spatiotemporal measurement docid\ py20tggfthft07gsdu5b2 spatiotemporal operators docid\ bk87nieddtgdcco8n6asg ddl sql statements cluster and node management docid\ os6ixwvq3vqyxxebcnfde databases docid 5gexlsola5mpwhnhlm8zn schemas docid\ afuz9fotopc8jqgletoat tables docid tp6ahq7papbrxirtqxyn indexes docid 1 xil30f18pjfnfxu4khl data pipelines docid 0qxabe6vs9pbygbrfmnah distributed tasks docid\ nzcumjzl9xke v0x8uxho machine learning models docid\ cvgbq68buupk4dltsgj2v users, groups, and service classes docid\ tltjovpwkjdggrcxmy2ov data integrity and storage docid 7tj31yczxztnkp54z92fa query analysis docid\ tu2oj1nn9zxenlht1nky3 query management docid\ yazxwbhdbpfwaehfgf6o9 statistics cache management docid\ z z mpwmx8es7g4fsmjlb dcl sql statements data control language (dcl) statement reference docid\ otlj4xmmckz1yfviq9vxu machine learning execution machine learning model functions docid\ x1e 9lz6mo mguoh2rah other sql reference errors and warnings docid\ jdioanniixa8vjzdvey1c reserved words docid\ apkfof ey yd2jm4t z3i system catalog docid\ fg0berygjpzqfr7dp pqv