4:I[4707,[],""]
5:I[36423,[],""]
0:["DlkNbkaF0sVt-LGcMSrB-",[[["",{"children":["(docs)",{"children":[["slug","core/docs/how-to-guides/built-in-functions","c"],{"children":["__PAGE__",{}]}]}]},"$undefined","$undefined",true],["",{"children":["(docs)",{"children":[["slug","core/docs/how-to-guides/built-in-functions","c"],{"children":["__PAGE__",{},[["$L1","$L2",[["$","link","0",{"rel":"stylesheet","href":"/_next/static/css/fdd8ad8344288ba1.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","1",{"rel":"stylesheet","href":"/_next/static/css/28332d42fda6eb41.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","2",{"rel":"stylesheet","href":"/_next/static/css/3fcb26e617784d35.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","3",{"rel":"stylesheet","href":"/_next/static/css/759e73786642d0e5.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","4",{"rel":"stylesheet","href":"/_next/static/css/7abbed16da9a0c7f.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","5",{"rel":"stylesheet","href":"/_next/static/css/fcfd448045ba20d1.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","6",{"rel":"stylesheet","href":"/_next/static/css/c592245929443f8b.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","7",{"rel":"stylesheet","href":"/_next/static/css/3f54ae53c35e587a.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","8",{"rel":"stylesheet","href":"/_next/static/css/c79ad681e20db623.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","9",{"rel":"stylesheet","href":"/_next/static/css/a0782ca87e5e5c81.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","10",{"rel":"stylesheet","href":"/_next/static/css/79385d9e81ded76f.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","11",{"rel":"stylesheet","href":"/_next/static/css/d48262b88ab36017.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","12",{"rel":"stylesheet","href":"/_next/static/css/23b355e4d0161ab2.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","13",{"rel":"stylesheet","href":"/_next/static/css/a30a86860ab13977.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","14",{"rel":"stylesheet","href":"/_next/static/css/8a3dd7507d2ecfad.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","15",{"rel":"stylesheet","href":"/_next/static/css/1ca67eb3c8056324.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","16",{"rel":"stylesheet","href":"/_next/static/css/4fc98c5f719320d5.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","17",{"rel":"stylesheet","href":"/_next/static/css/940fb0b46a15a776.css","precedence":"next","crossOrigin":"$undefined"}]]],null],null]},[[[["$","link","0",{"rel":"stylesheet","href":"/_next/static/css/d59ba84c6f57800e.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","1",{"rel":"stylesheet","href":"/_next/static/css/89fcbff865908b21.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","2",{"rel":"stylesheet","href":"/_next/static/css/e048766267e1c8bc.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","3",{"rel":"stylesheet","href":"/_next/static/css/467ca1490084c57a.css","precedence":"next","crossOrigin":"$undefined"}]],"$L3"],null],null]},[null,["$","$L4",null,{"parallelRouterKey":"children","segmentPath":["children","(docs)","children"],"error":"$undefined","errorStyles":"$undefined","errorScripts":"$undefined","template":["$","$L5",null,{}],"templateStyles":"$undefined","templateScripts":"$undefined","notFound":"$undefined","notFoundStyles":"$undefined"}]],null]},[[[["$","link","0",{"rel":"stylesheet","href":"/_next/static/css/be71acf271985f66.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","1",{"rel":"stylesheet","href":"/_next/static/css/48d5e81bb2f2c88b.css","precedence":"next","crossOrigin":"$undefined"}],["$","link","2",{"rel":"stylesheet","href":"/_next/static/css/ba93eddb18cd7a25.css","precedence":"next","crossOrigin":"$undefined"}]],"$L6"],null],null],["$L7",null]]]]
8:I[18882,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","1630","static/chunks/1630-3b4f76d71971de59.js","9027","static/chunks/9027-6a794df3d5379f63.js","2499","static/chunks/2499-69614c76fc089d44.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","3185","static/chunks/app/layout-eea78f6d4a5b9a5f.js"],"default"]
9:I[16274,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","1630","static/chunks/1630-3b4f76d71971de59.js","9027","static/chunks/9027-6a794df3d5379f63.js","2499","static/chunks/2499-69614c76fc089d44.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","3185","static/chunks/app/layout-eea78f6d4a5b9a5f.js"],"default"]
a:I[95021,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","1630","static/chunks/1630-3b4f76d71971de59.js","9027","static/chunks/9027-6a794df3d5379f63.js","2499","static/chunks/2499-69614c76fc089d44.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","3185","static/chunks/app/layout-eea78f6d4a5b9a5f.js"],"default"]
b:I[25922,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","1630","static/chunks/1630-3b4f76d71971de59.js","9027","static/chunks/9027-6a794df3d5379f63.js","2499","static/chunks/2499-69614c76fc089d44.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","3185","static/chunks/app/layout-eea78f6d4a5b9a5f.js"],"ThemeProvider"]
c:I[37687,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","1630","static/chunks/1630-3b4f76d71971de59.js","9027","static/chunks/9027-6a794df3d5379f63.js","2499","static/chunks/2499-69614c76fc089d44.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","3185","static/chunks/app/layout-eea78f6d4a5b9a5f.js"],"LanguageProvider"]
d:I[67647,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","1630","static/chunks/1630-3b4f76d71971de59.js","9027","static/chunks/9027-6a794df3d5379f63.js","2499","static/chunks/2499-69614c76fc089d44.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","3185","static/chunks/app/layout-eea78f6d4a5b9a5f.js"],"SearchProvider"]
e:I[10455,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","1630","static/chunks/1630-3b4f76d71971de59.js","9027","static/chunks/9027-6a794df3d5379f63.js","2499","static/chunks/2499-69614c76fc089d44.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","3185","static/chunks/app/layout-eea78f6d4a5b9a5f.js"],"TabProvider"]
f:I[72972,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8218","static/chunks/aaea2bcf-3d71fa65747a4b58.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","9783","static/chunks/9783-ee70276ef2279b23.js","2793","static/chunks/2793-1c2d2883ff508ae2.js","6423","static/chunks/6423-8ea740d3a5a09956.js","9448","static/chunks/9448-fbccb7b5a2d8a0e7.js","9475","static/chunks/9475-861f321b0ff5097d.js","6369","static/chunks/app/(docs)/%5B...slug%5D/page-fb4206ffedb59e79.js"],""]
14:I[45509,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","1630","static/chunks/1630-3b4f76d71971de59.js","9027","static/chunks/9027-6a794df3d5379f63.js","2499","static/chunks/2499-69614c76fc089d44.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","3185","static/chunks/app/layout-eea78f6d4a5b9a5f.js"],"Root"]
15:I[45509,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","1630","static/chunks/1630-3b4f76d71971de59.js","9027","static/chunks/9027-6a794df3d5379f63.js","2499","static/chunks/2499-69614c76fc089d44.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","3185","static/chunks/app/layout-eea78f6d4a5b9a5f.js"],"List"]
16:I[45509,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","1630","static/chunks/1630-3b4f76d71971de59.js","9027","static/chunks/9027-6a794df3d5379f63.js","2499","static/chunks/2499-69614c76fc089d44.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","3185","static/chunks/app/layout-eea78f6d4a5b9a5f.js"],"Item"]
17:I[45509,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","1630","static/chunks/1630-3b4f76d71971de59.js","9027","static/chunks/9027-6a794df3d5379f63.js","2499","static/chunks/2499-69614c76fc089d44.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","3185","static/chunks/app/layout-eea78f6d4a5b9a5f.js"],"Trigger"]
18:I[45509,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","1630","static/chunks/1630-3b4f76d71971de59.js","9027","static/chunks/9027-6a794df3d5379f63.js","2499","static/chunks/2499-69614c76fc089d44.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","3185","static/chunks/app/layout-eea78f6d4a5b9a5f.js"],"Content"]
19:I[45509,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","1630","static/chunks/1630-3b4f76d71971de59.js","9027","static/chunks/9027-6a794df3d5379f63.js","2499","static/chunks/2499-69614c76fc089d44.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","3185","static/chunks/app/layout-eea78f6d4a5b9a5f.js"],"Link"]
1a:I[45509,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","1630","static/chunks/1630-3b4f76d71971de59.js","9027","static/chunks/9027-6a794df3d5379f63.js","2499","static/chunks/2499-69614c76fc089d44.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","3185","static/chunks/app/layout-eea78f6d4a5b9a5f.js"],"Indicator"]
1b:I[45509,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","1630","static/chunks/1630-3b4f76d71971de59.js","9027","static/chunks/9027-6a794df3d5379f63.js","2499","static/chunks/2499-69614c76fc089d44.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","3185","static/chunks/app/layout-eea78f6d4a5b9a5f.js"],"Viewport"]
1c:I[61692,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","1630","static/chunks/1630-3b4f76d71971de59.js","9027","static/chunks/9027-6a794df3d5379f63.js","2499","static/chunks/2499-69614c76fc089d44.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","3185","static/chunks/app/layout-eea78f6d4a5b9a5f.js"],"default"]
1d:I[68089,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","1630","static/chunks/1630-3b4f76d71971de59.js","9027","static/chunks/9027-6a794df3d5379f63.js","2499","static/chunks/2499-69614c76fc089d44.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","3185","static/chunks/app/layout-eea78f6d4a5b9a5f.js"],"default"]
1e:I[8027,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","1630","static/chunks/1630-3b4f76d71971de59.js","9027","static/chunks/9027-6a794df3d5379f63.js","2499","static/chunks/2499-69614c76fc089d44.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","3185","static/chunks/app/layout-eea78f6d4a5b9a5f.js"],"default"]
23:I[72454,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","1630","static/chunks/1630-3b4f76d71971de59.js","9027","static/chunks/9027-6a794df3d5379f63.js","2499","static/chunks/2499-69614c76fc089d44.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","3185","static/chunks/app/layout-eea78f6d4a5b9a5f.js"],"default"]
24:I[50016,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","6873","static/chunks/6873-5d43c09fd7e43ad6.js","1630","static/chunks/1630-3b4f76d71971de59.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","1857","static/chunks/app/(docs)/%5B...slug%5D/layout-736874508f2dced6.js"],"default"]
28:I[90472,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8310","static/chunks/0e5ce63c-169bbb42210724c3.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","359","static/chunks/359-826869051760b1e3.js","6873","static/chunks/6873-5d43c09fd7e43ad6.js","1630","static/chunks/1630-3b4f76d71971de59.js","8089","static/chunks/8089-7cdeff9e4dc4f1de.js","1857","static/chunks/app/(docs)/%5B...slug%5D/layout-736874508f2dced6.js"],"default"]
2a:I[30042,["3107","static/chunks/app/(docs)/%5B...slug%5D/error-2410a0818cbca4c6.js"],"default"]
10:T425,M140.032 33.7216H119.64C119.678 34.691 119.907 35.6433 120.314 36.5241C120.721 37.4048 121.297 38.1967 122.01 38.8543C123.442 40.1474 125.316 40.84 127.244 40.7886C130.215 40.7886 132.322 39.5454 133.565 37.0591H139.52C138.738 39.4842 137.204 41.5967 135.139 43.0895C132.843 44.7122 130.079 45.5382 127.269 45.4409C124.872 45.4791 122.507 44.8861 120.411 43.7216C118.406 42.5869 116.762 40.9083 115.67 38.8796C114.487 36.6516 113.895 34.1576 113.951 31.6356C113.897 29.1218 114.47 26.6342 115.62 24.398C116.681 22.3664 118.314 20.6899 120.316 19.5749C122.449 18.4191 124.844 17.8354 127.269 17.8809C129.618 17.8394 131.938 18.4079 134.001 19.5307C135.944 20.6012 137.541 22.2043 138.603 24.1514C139.727 26.2599 140.293 28.6209 140.247 31.0098C140.245 31.9179 140.173 32.8245 140.032 33.7216ZM134.457 29.2968C134.474 28.3719 134.289 27.4543 133.913 26.609C133.537 25.7636 132.98 25.011 132.282 24.4043C130.812 23.1506 128.929 22.4863 126.998 22.5395C125.198 22.5022 123.451 23.1507 122.111 24.3537C120.717 25.6329 119.852 27.3869 119.684 29.2715L134.457 29.2968Z11:T423,M170.34 33.7216H149.949C149.987 34.691 150.216 35.6433 150.623 36.5241C151.029 37.4048 151.606 38.1967 152.319 38.8543C153.75 40.1474 155.625 40.84 157.553 40.7886C160.503 40.7886 162.61 39.5454 163.874 37.0591H169.803C169.019 39.4829 167.485 41.5948 165.423 43.0895C163.127 44.7122 160.363 45.5382 157.553 45.4409C155.155 45.4791 152.79 44.8861 150.694 43.7216C148.689 42.5869 147.046 40.9083 145.954 38.8796C144.768 36.6522 144.174 34.1581 144.228 31.6356C144.176 29.1213 144.751 26.6337 145.903 24.398C146.964 22.3664 148.597 20.6899 150.6 19.5749C152.732 18.4191 155.128 17.8354 157.553 17.8809C159.902 17.8394 162.221 18.4079 164.285 19.5307C166.228 20.6012 167.824 22.2043 168.887 24.1514C170.011 26.2599 170.576 28.6209 170.53 31.0098C170.537 31.9173 170.473 32.8239 170.34 33.7216ZM164.765 29.2968C164.783 28.3719 164.597 27.4543 164.222 26.609C163.846 25.7636 163.289 25.011 162.591 24.4043C161.12 23.1506 159.238 22.4863 157.306 22.5395C155.505 22.5031 153.756 23.1514 152.414 24.3537C151.024 25.6357 150.162 27.3886 149.993 29.2715L164.765 29.2968Z12:T457,M184.88 19.139C186.576 18.2807 188.454 17.8469 190.354 17.8748C192.601 17.8495 194.81 18.4499 196.734 19.6086C198.659 20.7674 200.223 22.4389 201.252 24.4361C202.378 26.6368 202.943 29.0819 202.895 31.5537C202.937 34.0491 202.373 36.5173 201.252 38.7471C200.226 40.7799 198.658 42.4887 196.72 43.6839C194.807 44.8621 192.6 45.4756 190.354 45.4538C188.469 45.4788 186.605 45.045 184.924 44.1896C183.438 43.4364 182.119 42.3891 181.05 41.1112V57.6788H175.531V18.3173H181.05V22.2427C182.082 20.9384 183.39 19.8786 184.88 19.139ZM196.138 26.7686C195.442 25.4905 194.402 24.4329 193.136 23.7155C191.915 23.0315 190.539 22.6744 189.141 22.6788C187.755 22.6774 186.394 23.0439 185.196 23.7408C183.928 24.4778 182.888 25.5522 182.194 26.8445C181.401 28.3146 181.007 29.9663 181.05 31.6359C181.011 33.311 181.405 34.9677 182.194 36.4462C182.863 37.71 183.864 38.7675 185.089 39.5048C186.314 40.2421 187.717 40.6314 189.147 40.6308C190.552 40.6358 191.933 40.2601 193.142 39.5436C194.416 38.7882 195.455 37.6941 196.144 36.383C196.928 34.8917 197.32 33.2254 197.282 31.541C197.324 29.8777 196.929 28.2324 196.138 26.7686Z13:T461,M238.643 24.4362C239.681 22.4429 241.251 20.7764 243.179 19.6215C245.108 18.4666 247.318 17.8686 249.565 17.8939C251.473 17.8559 253.36 18.2902 255.058 19.1581C256.521 19.8933 257.803 20.9423 258.813 22.2302V18.3174H264.382V45.0051H258.813V41.0355C257.796 42.3665 256.488 43.4475 254.989 44.196C253.132 45.1033 251.078 45.5316 249.014 45.4422C246.949 45.3528 244.94 44.7484 243.168 43.684C241.24 42.4794 239.676 40.7729 238.643 38.7472C237.502 36.5232 236.927 34.0528 236.967 31.5538C236.921 29.0784 237.497 26.631 238.643 24.4362ZM257.669 26.8446C256.978 25.5579 255.949 24.4847 254.692 23.7409C253.485 23.0383 252.112 22.6716 250.716 22.679C249.323 22.672 247.952 23.0294 246.74 23.7156C245.485 24.4397 244.455 25.4962 243.763 26.7687C242.974 28.2331 242.582 29.8784 242.625 31.5412C242.587 33.2255 242.979 34.8918 243.763 36.3831C244.452 37.6942 245.491 38.7883 246.765 39.5437C247.959 40.2605 249.324 40.6405 250.716 40.6436C252.112 40.6598 253.487 40.3018 254.698 39.6069C255.963 38.8499 256.992 37.7554 257.669 36.4464C258.454 34.9623 258.846 33.3018 258.807 31.6233C258.846 29.9589 258.454 28.3126 257.669 26.8446Z1f:T428,M59.0318 25.4005H38.6399C38.678 26.3699 38.9071 27.3223 39.3138 28.203C39.7206 29.0838 40.2971 29.8756 41.0103 30.5333C42.4417 31.8263 44.3158 32.519 46.2441 32.4676C49.2151 32.4676 51.3221 31.2244 52.5653 28.7381H58.5197C57.7384 31.1631 56.2039 33.2756 54.1392 34.7684C51.8434 36.3912 49.0792 37.2171 46.2694 37.1199C43.8721 37.158 41.5069 36.5651 39.411 35.4005C37.4058 34.2658 35.7624 32.5873 34.6702 30.5586C33.4872 28.3306 32.8952 25.8365 32.9509 23.3146C32.8967 20.8008 33.4702 18.3132 34.6196 16.0769C35.681 14.0454 37.3136 12.3688 39.3162 11.2539C41.4487 10.098 43.8443 9.51438 46.2694 9.55984C48.6183 9.5184 50.9378 10.0868 53.0014 11.2097C54.9442 12.2801 56.5407 13.8833 57.6032 15.8304C58.7272 17.9388 59.293 20.2999 59.2467 22.6888C59.2449 23.5969 59.173 24.5035 59.0318 25.4005ZM53.4565 20.9758C53.4742 20.0508 53.2886 19.1333 52.9129 18.2879C52.5372 17.4425 51.9805 16.6899 51.2821 16.0832C49.8118 14.8296 47.9291 14.1652 45.9976 14.2185C44.1977 14.1811 42.4509 14.8297 41.1114 16.0327C39.7173 17.3118 38.8515 19.0659 38.6841 20.9505L53.4565 20.9758Z20:T429,M89.3405 25.4005H68.9485C68.9867 26.3699 69.2158 27.3223 69.6225 28.203C70.0293 29.0838 70.6057 29.8756 71.319 30.5333C72.7504 31.8263 74.6245 32.519 76.5528 32.4676C79.5027 32.4676 81.6097 31.2244 82.874 28.7381H88.8032C88.0195 31.1619 86.4854 33.2737 84.4226 34.7684C82.1268 36.3912 79.3626 37.2171 76.5528 37.1199C74.1555 37.158 71.7903 36.5651 69.6944 35.4005C67.6893 34.2658 66.0458 32.5873 64.9536 30.5586C63.7684 28.3312 63.1743 25.8371 63.2279 23.3146C63.1757 20.8003 63.7515 18.3126 64.903 16.0769C65.9644 14.0454 67.597 12.3688 69.5996 11.2539C71.7321 10.098 74.1277 9.51438 76.5528 9.55984C78.9017 9.5184 81.2212 10.0868 83.2848 11.2097C85.2276 12.2801 86.8241 13.8833 87.8866 15.8304C89.0107 17.9388 89.5764 20.2999 89.5301 22.6888C89.5366 23.5962 89.4732 24.5028 89.3405 25.4005ZM83.7652 20.9758C83.7829 20.0508 83.5973 19.1333 83.2216 18.2879C82.8458 17.4425 82.2892 16.6899 81.5908 16.0832C80.1205 14.8296 78.2378 14.1652 76.3063 14.2185C74.5046 14.1821 72.7562 14.8304 71.4138 16.0327C70.0245 17.3147 69.1616 19.0676 68.9928 20.9505L83.7652 20.9758Z21:T459,M103.878 10.818C105.574 9.95968 107.452 9.52585 109.352 9.55376C111.599 9.52847 113.808 10.1288 115.732 11.2876C117.657 12.4464 119.221 14.1179 120.25 16.1151C121.376 18.3157 121.941 20.7609 121.893 23.2326C121.935 25.728 121.371 28.1963 120.25 30.4261C119.224 32.4589 117.656 34.1677 115.718 35.3629C113.805 36.541 111.599 37.1546 109.352 37.1328C107.467 37.1578 105.603 36.7239 103.922 35.8685C102.436 35.1154 101.117 34.0681 100.048 32.7902V49.3578H94.5293V9.99623H100.048V13.9216C101.08 12.6174 102.388 11.5575 103.878 10.818ZM115.136 18.4476C114.44 17.1695 113.4 16.1119 112.134 15.3945C110.914 14.7104 109.537 14.3533 108.139 14.3578C106.753 14.3563 105.392 14.7228 104.194 15.4198C102.926 16.1568 101.886 17.2311 101.192 18.5234C100.399 19.9936 100.005 21.6453 100.048 23.3148C100.009 24.9899 100.404 26.6466 101.192 28.1252C101.861 29.389 102.862 30.4464 104.087 31.1838C105.312 31.9211 106.715 32.3104 108.145 32.3098C109.55 32.3148 110.931 31.9391 112.14 31.2225C113.414 30.4672 114.453 29.3731 115.142 28.062C115.926 26.5706 116.318 24.9044 116.28 23.22C116.322 21.5566 115.927 19.9114 115.136 18.4476Z22:T45a,M157.641 16.1152C158.679 14.1219 160.249 12.4553 162.177 11.3004C164.106 10.1456 166.316 9.54757 168.563 9.57285C170.471 9.53488 172.358 9.96918 174.057 10.8371C175.519 11.5722 176.801 12.6212 177.811 13.9091V9.99636H183.38V36.6841H177.811V32.7144C176.794 34.0455 175.486 35.1265 173.987 35.875C172.13 36.7822 170.076 37.2106 168.012 37.1212C165.947 37.0317 163.938 36.4273 162.167 35.363C160.238 34.1583 158.674 32.4518 157.641 30.4262C156.5 28.2022 155.925 25.7317 155.966 23.2328C155.919 20.7574 156.495 18.31 157.641 16.1152ZM176.667 18.5235C175.976 17.2369 174.947 16.1636 173.69 15.4199C172.483 14.7172 171.11 14.3505 169.714 14.3579C168.321 14.351 166.95 14.7083 165.738 15.3946C164.483 16.1186 163.453 17.1752 162.761 18.4477C161.972 19.9121 161.58 21.5573 161.623 23.2201C161.585 24.9045 161.977 26.5708 162.761 28.0621C163.45 29.3732 164.489 30.4673 165.763 31.2227C166.957 31.9394 168.322 32.3195 169.714 32.3225C171.11 32.3387 172.485 31.9808 173.696 31.2859C174.961 30.5288 175.99 29.4344 176.667 28.1253C177.452 26.6413 177.844 24.9808 177.805 23.3023C177.844 21.6379 177.452 19.9916 176.667 18.5235Z6:["$","html",null,{"lang":"en","suppressHydrationWarning":true,"children":["$","body",null,{"className":"__variable_516c7b __variable_7c30e7 __variable_27d86c","children":[["$","$L8",null,{}],["$","$L9",null,{}],["$","$La",null,{"color":"var(--primary-1100)","showSpinner":false}],["$","$Lb",null,{"disableTransitionOnChange":true,"children":["$","$Lc",null,{"children":["$","$Ld",null,{"children":["$","$Le",null,{"children":[["$","header",null,{"children":[["$","div",null,{"className":"banner","children":["$","p",null,{"children":["Show your appreciation for Deephaven by"," ",["$","a",null,{"href":"https://github.com/deephaven/deephaven-core","children":"starring us on GitHub"}],"."]}]}],["$","nav",null,{"children":[["$","$Lf",null,{"href":"/","aria-label":"Home","className":"mr-auto","children":["$","svg",null,{"width":"354","height":"58","className":"logo","viewBox":"0 0 354 58","fill":"none","xmlns":"http://www.w3.org/2000/svg","children":[["$","path",null,{"d":"M101.536 13.3994C104.158 14.7063 106.332 16.7636 107.782 19.3096C109.299 22.0579 110.06 25.1596 109.988 28.2982C110.066 31.4114 109.304 34.4882 107.782 37.2047C106.324 39.7149 104.149 41.7314 101.536 42.9948C98.5959 44.3883 95.371 45.0766 92.1179 45.0049H81.1191V11.345H92.1179C95.376 11.2719 98.6046 11.9761 101.536 13.3994ZM101.176 37.3058C103.283 35.1735 104.337 32.171 104.337 28.2982C104.337 24.4255 103.283 21.3724 101.176 19.1389C99.069 16.9476 96.0496 15.8499 92.1179 15.8456H86.6438V40.498H92.1179C96.0707 40.498 99.0964 39.4339 101.195 37.3058H101.176Z","fill":"var(--logo-text)"}],["$","path",null,{"d":"$10","fill":"var(--logo-text)"}],["$","path",null,{"d":"$11","fill":"var(--logo-text)"}],["$","path",null,{"d":"$12","fill":"var(--logo-text)"}],["$","path",null,{"d":"M227.195 19.1896C228.817 20.0748 230.137 21.424 230.988 23.0644C231.963 24.9828 232.443 27.1143 232.385 29.2654V45.005H226.885V30.0872C226.885 27.6978 226.287 25.8647 225.09 24.5878C223.753 23.3605 222.003 22.6795 220.188 22.6795C218.373 22.6795 216.624 23.3605 215.286 24.5878C214.072 25.852 213.466 27.6852 213.466 30.0872V45.005H207.947V9.16431H213.466V21.4146C214.425 20.2714 215.646 19.376 217.024 18.804C218.519 18.1792 220.126 17.8652 221.746 17.8811C223.644 17.8472 225.519 18.2975 227.195 19.1896Z","fill":"var(--logo-text)"}],["$","path",null,{"d":"$13","fill":"var(--logo-text)"}],["$","path",null,{"d":"M282.389 40.0681L289.943 18.3171H295.809L285.632 45.0049H279.045L268.932 18.3171H274.842L282.389 40.0681Z","fill":"var(--logo-text)"}],["$","path",null,{"d":"M324.097 33.7218H303.705C303.785 35.6789 304.637 37.5246 306.076 38.8545C307.507 40.1476 309.381 40.8402 311.309 40.7888C314.259 40.7888 316.366 39.5456 317.631 37.0593H323.585C322.806 39.4856 321.271 41.5988 319.204 43.0897C316.909 44.7124 314.144 45.5384 311.335 45.4411C308.927 45.4866 306.549 44.8934 304.445 43.7218C302.436 42.5891 300.79 40.9102 299.698 38.8798C298.515 36.6518 297.923 34.1578 297.978 31.6358C297.924 29.122 298.498 26.6344 299.647 24.3981C300.708 22.3666 302.341 20.6901 304.344 19.5751C306.476 18.4198 308.872 17.8362 311.297 17.8811C313.646 17.8396 315.965 18.4081 318.029 19.5309C319.973 20.5994 321.57 22.203 322.631 24.1516C323.759 26.2585 324.325 28.6206 324.274 31.01C324.285 31.9171 324.226 32.8237 324.097 33.7218ZM318.528 29.297C318.545 28.3716 318.358 27.4537 317.982 26.6083C317.605 25.7629 317.047 25.0106 316.347 24.4045C314.88 23.1507 312.999 22.4862 311.069 22.5397C309.267 22.5007 307.518 23.1494 306.177 24.3539C304.785 25.6341 303.921 27.388 303.756 29.2717L318.528 29.297Z","fill":"var(--logo-text)"}],["$","path",null,{"d":"M348.691 19.1893C350.35 20.0599 351.71 21.4101 352.591 23.0642C353.574 24.9798 354.057 27.1129 353.994 29.2652V45.0047H348.52V30.0869C348.52 27.6975 347.888 25.8644 346.731 24.5876C346.096 23.9439 345.331 23.4421 344.488 23.1152C343.645 22.7884 342.742 22.6439 341.839 22.6912C340.932 22.6447 340.025 22.7894 339.178 23.1162C338.331 23.4429 337.562 23.9442 336.921 24.5876C335.707 25.8518 335.107 27.6975 335.107 30.0869V45.0047H329.582V18.317H335.107V21.3701C336.041 20.2488 337.231 19.3686 338.577 18.8037C339.991 18.1885 341.517 17.8743 343.059 17.8809C345.015 17.8503 346.948 18.2996 348.691 19.1893Z","fill":"var(--logo-text)"}],["$","path",null,{"d":"M18.9191 38.1592H0V57.0783H18.9191V38.1592Z","fill":"#4DCCFA"}],["$","path",null,{"d":"M37.839 0.321045H18.9199V19.2401H37.839V0.321045Z","fill":"#4DCCFA"}],["$","path",null,{"d":"M37.839 38.1592H18.9199V57.0783H37.839V38.1592Z","fill":"#FDD041"}],["$","path",null,{"d":"M56.7589 19.24H37.8398V38.1591H56.7589V19.24Z","fill":"#F33666"}],["$","path",null,{"d":"M18.9191 0.321045H0V38.1592H18.9191V0.321045Z","fill":"#3A57E1"}]]}]}],["$","$L14",null,{"className":"NavigationMenuRoot","delayDuration":0,"children":[["$","$L15",null,{"className":"NavigationMenuList","children":[[["$","$L16","Products",{"children":[["$","$L17",null,{"className":"NavigationMenuTrigger primary-nav-products","children":["Products",["$","svg",null,{"width":"15","height":"15","viewBox":"0 0 15 15","fill":"none","xmlns":"http://www.w3.org/2000/svg","className":"CaretDown","aria-hidden":true,"children":["$","path",null,{"d":"M4.18179 6.18181C4.35753 6.00608 4.64245 6.00608 4.81819 6.18181L7.49999 8.86362L10.1818 6.18181C10.3575 6.00608 10.6424 6.00608 10.8182 6.18181C10.9939 6.35755 10.9939 6.64247 10.8182 6.81821L7.81819 9.81821C7.73379 9.9026 7.61934 9.95001 7.49999 9.95001C7.38064 9.95001 7.26618 9.9026 7.18179 9.81821L4.18179 6.81821C4.00605 6.64247 4.00605 6.35755 4.18179 6.18181Z","fill":"currentColor","fillRule":"evenodd","clipRule":"evenodd"}]}]]}],["$","$L18",null,{"className":"NavigationMenuContent primary-nav-products","children":["$","ul",null,{"className":"List","children":[["$","li","Community Core",{"className":"primary-nav-community-core","children":["$","$L19",null,{"asChild":true,"children":["$","$Lf",null,{"className":"ListItemLink","href":"/community","children":[["$","div",null,{"className":"ListItemHeading","children":"Community Core"}],["$","p",null,{"className":"ListItemText","children":"For individuals and small teams. Includes the Deephaven query engine, APIs and UI."}]]}]}]}],["$","li","Enterprise Core+",{"className":"primary-nav-enterprise-core","children":["$","$L19",null,{"asChild":true,"children":["$","$Lf",null,{"className":"ListItemLink","href":"/enterprise","children":[["$","div",null,{"className":"ListItemHeading","children":"Enterprise Core+"}],["$","p",null,{"className":"ListItemText","children":"For larger teams and enterprises. Includes accounts, access control, data workflows, worker scheduling and management, high availabilty and more."}]]}]}]}],["$","li","More open source projects",{"className":"primary-nav-more-projects primary-nav-divider-before","children":["$","$L19",null,{"asChild":true,"children":["$","$Lf",null,{"className":"ListItemLink","href":"/community/oss","children":[["$","div",null,{"className":"ListItemHeading","children":"More open source projects"}],"$undefined"]}]}]}]]}]}]]}],["$","$L16","Company",{"children":[["$","$L17",null,{"className":"NavigationMenuTrigger","children":["Company",["$","svg",null,{"width":"15","height":"15","viewBox":"0 0 15 15","fill":"none","xmlns":"http://www.w3.org/2000/svg","className":"CaretDown","aria-hidden":true,"children":["$","path",null,{"d":"M4.18179 6.18181C4.35753 6.00608 4.64245 6.00608 4.81819 6.18181L7.49999 8.86362L10.1818 6.18181C10.3575 6.00608 10.6424 6.00608 10.8182 6.18181C10.9939 6.35755 10.9939 6.64247 10.8182 6.81821L7.81819 9.81821C7.73379 9.9026 7.61934 9.95001 7.49999 9.95001C7.38064 9.95001 7.26618 9.9026 7.18179 9.81821L4.18179 6.81821C4.00605 6.64247 4.00605 6.35755 4.18179 6.18181Z","fill":"currentColor","fillRule":"evenodd","clipRule":"evenodd"}]}]]}],["$","$L18",null,{"className":"NavigationMenuContent","children":["$","ul",null,{"className":"List","children":[["$","li","About",{"className":"primary-nav-about","children":["$","$L19",null,{"asChild":true,"children":["$","$Lf",null,{"className":"ListItemLink","href":"/company/about","children":[["$","div",null,{"className":"ListItemHeading","children":"About"}],"$undefined"]}]}]}],["$","li","Newsroom",{"className":"primary-nav-newsroom","children":["$","$L19",null,{"asChild":true,"children":["$","$Lf",null,{"className":"ListItemLink","href":"/newsroom","children":[["$","div",null,{"className":"ListItemHeading","children":"Newsroom"}],"$undefined"]}]}]}],["$","li","Careers",{"className":"primary-nav-careers","children":["$","$L19",null,{"asChild":true,"children":["$","$Lf",null,{"className":"ListItemLink","href":"/company/careers","children":[["$","div",null,{"className":"ListItemHeading","children":"Careers"}],"$undefined"]}]}]}]]}]}]]}],["$","li","Docs",{"children":["$","$L19",null,{"asChild":true,"children":["$","$Lf",null,{"className":"NavigationMenuLink","href":"/docs","children":"Docs"}]}]}],["$","li","Blog",{"children":["$","$L19",null,{"asChild":true,"children":["$","$Lf",null,{"className":"NavigationMenuLink primary-nav-blog","href":"/blog","children":"Blog"}]}]}],["$","li","Request Demo",{"children":["$","$L19",null,{"asChild":true,"children":["$","$Lf",null,{"className":"NavigationMenuLink primary-nav-contact","href":"/landing-page/one-on-one","children":[["$","span",null,{"className":"show-1100","children":"Contact"}],["$","span",null,{"className":"hide-1100","children":"Request Demo"}]]}]}]}]],["$","$L1a",null,{"className":"NavigationMenuIndicator","children":["$","div",null,{"className":"Arrow"}]}]]}],["$","div",null,{"className":"ViewportPosition","children":["$","$L1b",null,{"className":"NavigationMenuViewport"}]}]]}],["$","$L1c",null,{}],["$","$Lf",null,{"href":"https://github.com/deephaven/deephaven-core","className":"btn-icon btn-github","title":"Deephaven Core Github","aria-label":"Deephaven Core Github"}],["$","$Lf",null,{"href":"/slack","className":"btn-icon btn-slack","title":"Join our Slack community","aria-label":"Join our Slack community"}],["$","$L1d",null,{"asChild":true,"children":["$","button",null,{"title":"Search Deephaven documentation","className":"btn-icon btn-search","aria-label":"Search Deephaven documentation"}]}],["$","$Lf",null,{"href":"https://controller.try-dh.demo.community.deephaven.io/","className":"btn notched try-sandbox","children":"Try Sandbox"}],["$","$L1e",null,{}]]}]]}],["$","main",null,{"id":"top","children":["$","$L4",null,{"parallelRouterKey":"children","segmentPath":["children"],"error":"$undefined","errorStyles":"$undefined","errorScripts":"$undefined","template":["$","$L5",null,{}],"templateStyles":"$undefined","templateScripts":"$undefined","notFound":["$","section",null,{"children":["$","article",null,{"style":{"display":"flex","alignItems":"center","justifyContent":"center","minHeight":"400px"},"children":["$","h1",null,{"children":"404 Not Found"}]}]}],"notFoundStyles":[]}]}],["$","footer",null,{"children":[["$","div",null,{"className":"footer-logo","children":["$","$Lf",null,{"href":"/","aria-label":"Deephaven Data Labs LLC","title":"Deephaven Data Labs LLC","children":["$","svg",null,{"width":"273","height":"50","viewBox":"0 0 273 50","fill":"none","xmlns":"http://www.w3.org/2000/svg","className":"logo-footer","children":[["$","path",null,{"d":"M20.5363 5.07833C23.1583 6.38525 25.3322 8.44257 26.7816 10.9886C28.2992 13.7368 29.0605 16.8386 28.9877 19.9772C29.0664 23.0903 28.3043 26.1671 26.7816 28.8836C25.3245 31.3938 23.1494 33.4104 20.5363 34.6738C17.5959 36.0673 14.371 36.7556 11.1179 36.6839H0.119141V3.02397H11.1179C14.376 2.95083 17.6046 3.65507 20.5363 5.07833ZM20.176 28.9848C22.2831 26.8525 23.3366 23.8499 23.3366 19.9772C23.3366 16.1045 22.2831 13.0514 20.176 10.8179C18.069 8.62658 15.0496 7.52881 11.1179 7.5246H5.6438V32.1769H11.1179C15.0707 32.1769 18.0964 31.1129 20.195 28.9848H20.176Z","fill":"var(--logo-text)"}],["$","path",null,{"d":"$1f","fill":"var(--logo-text)"}],["$","path",null,{"d":"$20","fill":"var(--logo-text)"}],["$","path",null,{"d":"$21","fill":"var(--logo-text)"}],["$","path",null,{"d":"M146.193 10.8685C147.815 11.7538 149.136 13.103 149.986 14.7434C150.961 16.6617 151.441 18.7933 151.383 20.9444V36.684H145.883V21.7661C145.883 19.3768 145.285 17.5436 144.088 16.2668C142.751 15.0394 141.001 14.3585 139.186 14.3585C137.371 14.3585 135.622 15.0394 134.284 16.2668C133.07 17.531 132.464 19.3641 132.464 21.7661V36.684H126.945V0.843262H132.464V13.0936C133.423 11.9504 134.644 11.0549 136.022 10.483C137.517 9.85813 139.124 9.54414 140.744 9.56008C142.642 9.52613 144.518 9.97646 146.193 10.8685Z","fill":"var(--logo-text)"}],["$","path",null,{"d":"$22","fill":"var(--logo-text)"}],["$","path",null,{"d":"M201.389 31.747L208.943 9.99609H214.809L204.632 36.6838H198.045L187.932 9.99609H193.842L201.389 31.747Z","fill":"var(--logo-text)"}],["$","path",null,{"d":"M243.095 25.4007H222.703C222.783 27.3579 223.635 29.2036 225.074 30.5335C226.505 31.8265 228.379 32.5191 230.307 32.4677C233.257 32.4677 235.364 31.2246 236.629 28.7383H242.583C241.804 31.1645 240.269 33.2777 238.203 34.7686C235.907 36.3914 233.143 37.2173 230.333 37.1201C227.925 37.1656 225.547 36.5724 223.443 35.4007C221.434 34.268 219.788 32.5891 218.696 30.5588C217.513 28.3308 216.921 25.8367 216.976 23.3148C216.922 20.801 217.496 18.3134 218.645 16.0771C219.706 14.0456 221.339 12.369 223.342 11.2541C225.474 10.0988 227.87 9.51514 230.295 9.56002C232.644 9.51858 234.963 10.087 237.027 11.2098C238.971 12.2783 240.568 13.8819 241.629 15.8306C242.757 17.9375 243.323 20.2996 243.272 22.689C243.283 23.5961 243.224 24.5027 243.095 25.4007ZM237.526 20.976C237.543 20.0505 237.356 19.1327 236.98 18.2873C236.603 17.4419 236.045 16.6895 235.345 16.0834C233.878 14.8297 231.997 14.1652 230.067 14.2187C228.265 14.1797 226.516 14.8284 225.175 16.0328C223.783 17.313 222.92 19.0669 222.754 20.9507L237.526 20.976Z","fill":"var(--logo-text)"}],["$","path",null,{"d":"M267.691 10.8685C269.35 11.7391 270.71 13.0893 271.591 14.7434C272.574 16.659 273.057 18.7921 272.994 20.9444V36.6839H267.52V21.7661C267.52 19.3767 266.888 17.5436 265.731 16.2668C265.096 15.6231 264.331 15.1213 263.488 14.7944C262.645 14.4676 261.742 14.3231 260.839 14.3704C259.932 14.3239 259.025 14.4686 258.178 14.7954C257.331 15.1221 256.562 15.6234 255.921 16.2668C254.707 17.531 254.107 19.3767 254.107 21.7661V36.6839H248.582V9.99621H254.107V13.0493C255.041 11.928 256.231 11.0478 257.577 10.4829C258.991 9.86775 260.517 9.55346 262.059 9.56005C264.015 9.5295 265.948 9.97876 267.691 10.8685Z","fill":"var(--logo-text)"}]]}]}]}],["$","div",null,{"className":"footer-links","children":[["$","nav",null,{"children":[["$","h2",null,{"children":"Community Core"}],["$","$Lf",null,{"href":"/core/docs","children":"Documentation"}],["$","$Lf",null,{"href":"/core/docs/reference/community-questions/cq-index/","children":"Community questions"}],["$","$Lf",null,{"href":"/community/license","children":"Open-core License"}],["$","a",null,{"href":"/core/client-api/python/","children":"Pydoc client"}],["$","a",null,{"href":"/core/pydoc/","children":"Pydoc server"}],["$","a",null,{"href":"/core/javadoc/","children":"Javadoc client/server"}],["$","a",null,{"href":"https://pkg.go.dev/github.com/deephaven/deephaven-core/go","children":"Godoc client"}],["$","a",null,{"href":"/core/client-api/cpp/","children":"C++ client"}]]}],["$","nav",null,{"children":[["$","h2",null,{"children":"Enterprise"}],["$","$Lf",null,{"href":"/enterprise/support","children":"Enterprise Support"}],["$","$Lf",null,{"href":"/enterprise/docs","children":"Documentation"}]]}],["$","nav",null,{"children":[["$","h2",null,{"children":"Social"}],["$","$Lf",null,{"href":"/blog","children":"Blog"}],["$","$Lf",null,{"href":"https://github.com/deephaven","children":"Github"}],["$","$Lf",null,{"href":"/slack","children":"Slack"}],["$","$Lf",null,{"href":"https://www.linkedin.com/company/deephaven","children":"Linkedin"}],["$","$Lf",null,{"href":"https://youtube.com/deephaven","children":"Youtube"}]]}],["$","nav",null,{"children":[["$","h2",null,{"children":"Company"}],["$","$Lf",null,{"href":"/company/about","children":"About"}],["$","$Lf",null,{"href":"/company/careers","children":"Careers"}],["$","$Lf",null,{"href":"/newsroom","children":"Newsroom"}],["$","$Lf",null,{"href":"/company/brand","children":"Brand Assets"}],["$","$Lf",null,{"href":"/company/contact","children":"Contact"}]]}]]}],["$","div",null,{"className":"legal","children":[["$","p",null,{"className":"mr-auto","children":["Copyright © ",2025," Deephaven Data Labs LLC"]}],["$","$Lf",null,{"href":"/company/privacy","children":"Privacy Policy"}],["$","$Lf",null,{"href":"/company/tos","children":"Terms of Service"}]]}]]}]]}]}]}]}],false,false,["$","$L23",null,{"gtmId":"GTM-5KDQ4L9","hubspotId":"19516115","retentionId":"Y46DJ4HLQV61","salesIntelId":"Mjc1MjcxNDM5NzhhMWUtMTY4Yi00MTZkLWIxNTMtMzllMjY1ZGY5NjZk","zoominfoId":true}]]}]}]
27:[]
26:[512,512,"$27","f000","m267.52 43.84 203.52 185.6 -22.72 22.72L416 222.848v208.832l-16 16h-96l-16 -16v-112H224v112l-16 16h-96l-16 -16V223.104L64 252.16l-22.72 -22.72 203.2 -185.6h23.04zM128 194.016v221.664h64v-112l16 -16h96l16 16v112h64V193.824L256 77.76 128 194.016z"]
25:{"prefix":"vs","iconName":"home","icon":"$26"}
29:["slug","core/docs/how-to-guides/built-in-functions","c"]
3:["$","section",null,{"children":[["$","$L24",null,{"secondaryNav":[{"slugs":["/docs","/core","/core/groovy","/core/ui","/core/plotly","/enterprise"],"languages":[{"value":"python","label":"Python"},{"value":"groovy","label":"Java (Groovy)"}],"links":[{"href":"/docs","text":"Home","icon":{"prefix":"vs","iconName":"home","icon":[512,512,[],"f000","m267.52 43.84 203.52 185.6 -22.72 22.72L416 222.848v208.832l-16 16h-96l-16 -16v-112H224v112l-16 16h-96l-16 -16V223.104L64 252.16l-22.72 -22.72 203.2 -185.6h23.04zM128 194.016v221.664h64v-112l16 -16h96l16 16v112h64V193.824L256 77.76 128 194.016z"]},"className":"secondary-nav-home","ariaLabel":"Docs home"},{"href":"/core/docs","text":"Core Engine","language":"python","versioned":true},{"href":"/core/groovy/docs","text":"Core Engine","language":"groovy","versioned":true},{"href":"/core/ui/docs","text":"UI & Dashboards","versioned":true},{"href":"/core/plotly/docs","text":"Plotting","versioned":true},{"href":"/enterprise/docs","text":"Enterprise","versioned":true}]},{"slugs":["/barrage/docs"],"links":[{"href":"/docs","text":"Home","icon":"$25","className":"secondary-nav-home","ariaLabel":"Docs home"},{"href":"/barrage/docs","text":"Barrage"}]},{"slugs":["/javascript/grid/docs"],"links":[{"href":"/docs","text":"Home","icon":"$25","className":"secondary-nav-home","ariaLabel":"Docs home"},{"href":"/javascript/grid/docs","text":"Data Grid"}]},{"slugs":["/vscode/docs"],"links":[{"href":"/docs","text":"Home","icon":"$25","className":"secondary-nav-home","ariaLabel":"Docs home"},{"href":"/vscode/docs","text":"VS Code Extension"}]}]}],["$","div",null,{"className":"docs full-bleed","children":[["$","$L28",null,{"sidebar":[{"label":"Introduction","path":"intro.md"},{"label":"Deephaven Overview","path":"conceptual/deephaven-overview.md"},{"label":"Getting Started","items":[{"label":"Quickstarts","items":[{"label":"Quickstart","path":"getting-started/quickstart.md"},{"label":"Jupyter Quickstart","path":"getting-started/jupyter-quickstart.md"},{"label":"Python Client Quickstart","path":"getting-started/pyclient-quickstart.md"}]},{"label":"A Crash Course in Deephaven","items":[{"label":"Crash Course Overview","path":"getting-started/crash-course/overview.md"},{"label":"Get Started","path":"getting-started/crash-course/get-started.md"},{"label":"Architecture Overview","path":"getting-started/crash-course/architecture-overview.md"},{"label":"Create Tables","path":"getting-started/crash-course/create-tables.md"},{"label":"Table Operations","path":"getting-started/crash-course/table-ops.md"},{"label":"Time and Calendars","path":"getting-started/crash-course/time-calendars.md"},{"label":"Query Strings","path":"getting-started/crash-course/query-strings.md"},{"label":"Python Integrations","path":"getting-started/crash-course/py-integrations.md"},{"label":"Real-time Plots","path":"getting-started/crash-course/plots.md"},{"label":"deephaven.ui","path":"getting-started/crash-course/deephaven-ui.md"},{"label":"Data I/O","path":"getting-started/crash-course/export-data.md"},{"label":"Configure your Instance","path":"getting-started/crash-course/configure.md"},{"label":"Wrapping Up","path":"getting-started/crash-course/crash-course-wrap-up.md"}]},{"label":"Install Deephaven","items":[{"label":"Docker","path":"getting-started/docker-install.md"},{"label":"pip","path":"getting-started/pip-install.md"},{"label":"Source code","path":"getting-started/launch-build.md"},{"label":"Production application","path":"getting-started/production-application.md"}]}]},{"label":"User Guide","items":[{"label":"Architectural details","items":[{"label":"Deephaven's design","path":"conceptual/deephaven-design.md"},{"label":"Incremental update model","path":"conceptual/table-update-model.md"},{"label":"Live DAG","path":"conceptual/dag.md"},{"label":"Table types","path":"conceptual/table-types.md"},{"label":"Core API design","path":"conceptual/deephaven-core-api.md"},{"label":"Servers & clients","path":"conceptual/client-server-model.md"}]},{"label":"Create, import, and export tables","items":[{"label":"Simple table constructors","items":[{"label":"Static tables","path":"how-to-guides/new-and-empty-table.md"},{"label":"Ring tables","path":"how-to-guides/ring-table.md"},{"label":"Time tables","path":"how-to-guides/time-table.md"},{"label":"Input tables","path":"how-to-guides/input-tables.md"}]},{"label":"Advanced table constructors","items":[{"label":"Write data to a real-time table","path":"how-to-guides/table-publisher.md"},{"label":"Generate tables with Python functions","path":"how-to-guides/function-generated-tables.md"}]},{"label":"CSV","items":[{"label":"Import CSV files","path":"how-to-guides/data-import-export/csv-import.md"},{"label":"Export CSV files","path":"how-to-guides/data-import-export/csv-export.md"}]},{"label":"HTML","items":[{"label":"Import HTML files","path":"how-to-guides/data-import-export/html-import.md"},{"label":"Export HTML files","path":"how-to-guides/data-import-export/html-export.md"}]},{"label":"Arrow Flight","path":"how-to-guides/data-import-export/arrow-flight.md"},{"label":"Iceberg","path":"how-to-guides/data-import-export/iceberg.md"},{"label":"Kafka","items":[{"label":"Kafka Overview","path":"how-to-guides/overview-kafka.md"},{"label":"Basic terms","path":"conceptual/kafka-in-deephaven.md"},{"label":"Connect to a Kafka stream","path":"how-to-guides/data-import-export/kafka-stream.md"}]},{"label":"Parquet","items":[{"label":"Supported Parquet formats","path":"how-to-guides/data-import-export/parquet-formats.md"},{"label":"Import Parquet files","path":"how-to-guides/data-import-export/parquet-import.md"},{"label":"Export to Parquet","path":"how-to-guides/data-import-export/parquet-export.md"}]},{"label":"PyArrow","path":"how-to-guides/pyarrow.md"},{"label":"SQL","items":[{"label":"SQL queries in Deephaven","path":"how-to-guides/data-import-export/execute-sql-queries.md"}]},{"label":"URI","path":"how-to-guides/use-uris.md"},{"label":"Table data service","path":"how-to-guides/data-import-export/table-data-service.md"},{"label":"Table listeners","path":"how-to-guides/table-listeners-python.md"},{"label":"Table iterators","path":"how-to-guides/iterate-table-data.md"},{"label":"Replay","path":"how-to-guides/replay-data.md"}]},{"label":"Work with tables","items":[{"label":"Metadata","path":"how-to-guides/metadata.md"},{"label":"Select and create columns","path":"how-to-guides/use-select-view-update.md"},{"label":"Drop, move, and rename columns","path":"how-to-guides/drop-move-rename-columns.md"},{"label":"Format columns","path":"how-to-guides/format-columns.md"},{"label":"Filter","path":"how-to-guides/use-filters.md"},{"label":"Sort","path":"how-to-guides/sort.md"},{"label":"Keyed transpose","path":"how-to-guides/keyed-transpose.md"},{"label":"Merge","path":"how-to-guides/merge-tables.md"},{"label":"Group and aggregate","items":[{"label":"Group and ungroup data","path":"how-to-guides/grouping-data.md"},{"label":"Single aggregation","path":"how-to-guides/dedicated-aggregations.md"},{"label":"Multi-aggregation","path":"how-to-guides/combined-aggregations.md"},{"label":"Rolling aggregations","path":"how-to-guides/rolling-aggregations.md"}]},{"label":"Hierarchical tables","items":[{"label":"Rollup tables","path":"how-to-guides/rollup-table.md"},{"label":"Tree tables","path":"how-to-guides/tree-table.md"}]},{"label":"Join","items":[{"label":"Exact and Relational Joins","path":"how-to-guides/joins-exact-relational.md"},{"label":"Inexact, time-series, and range joins","path":"how-to-guides/joins-timeseries-range.md"}]},{"label":"Partition","path":"how-to-guides/partitioned-tables.md"},{"label":"Snapshot","path":"how-to-guides/capture-table-history.md"},{"label":"Time","items":[{"label":"Work with calendars","path":"how-to-guides/business-calendar.md"},{"label":"Work with time","path":"conceptual/time-in-deephaven.md"},{"label":"Downsample data","path":"how-to-guides/downsampling.md"}]}]},{"label":"Query strings","items":[{"label":"Overview","path":"how-to-guides/query-string-overview.md"},{"label":"Literals","items":[{"label":"Boolean & numeric","path":"how-to-guides/boolean-numeric-literals.md"},{"label":"String & char","path":"how-to-guides/string-char-literals.md"},{"label":"Date-time","path":"how-to-guides/date-time-literals.md"}]},{"label":"Formulas, filters, and operators","items":[{"label":"Formulas","path":"how-to-guides/formulas.md"},{"label":"Filters","path":"how-to-guides/filters.md"},{"label":"Operators","path":"how-to-guides/operators.md"},{"label":"Casting","path":"how-to-guides/casting.md"},{"label":"Ternary-if","path":"how-to-guides/ternary-if-how-to.md"}]},{"label":"Built-ins","items":[{"label":"Built-in constants","path":"how-to-guides/built-in-constants.md"},{"label":"Built-in Variables","path":"how-to-guides/built-in-variables.md"},{"label":"Built-in functions","path":"how-to-guides/built-in-functions.md"}]},{"label":"Python","items":[{"label":"Query Scope","path":"how-to-guides/query-scope.md"},{"label":"Variables","path":"how-to-guides/python-variables.md"},{"label":"Functions","path":"how-to-guides/python-functions.md"},{"label":"Classes & Objects","path":"how-to-guides/python-classes.md"},{"label":"PyObjects","path":"how-to-guides/pyobjects.md"}]},{"label":"Data types","path":"how-to-guides/data-types.md"},{"label":"Nulls, infs, and NaNs","path":"how-to-guides/null-inf-nan.md"},{"label":"Arrays","path":"how-to-guides/work-with-arrays.md"},{"label":"Strings","path":"how-to-guides/work-with-strings.md"},{"label":"Java classes & objects","path":"how-to-guides/java-classes.md"}]},{"label":"Python","items":[{"label":"Deephaven's Python package","path":"how-to-guides/deephaven-python-package.md"},{"label":"Generate query strings","path":"how-to-guides/generate-query-strings.md"},{"label":"Read Javadocs","path":"how-to-guides/read-javadocs.md"},{"label":"Python library integrations","items":[{"label":"jpy","path":"how-to-guides/use-jpy.md"},{"label":"Numba","path":"how-to-guides/use-numba.md"},{"label":"NumPy","path":"how-to-guides/use-numpy.md"},{"label":"pandas","path":"how-to-guides/use-pandas.md"}]},{"label":"AI / ML","items":[{"label":"Workflows","path":"how-to-guides/ml-ai-no-learn.md"},{"label":"deephaven.learn","path":"how-to-guides/use-deephaven-learn.md"},{"label":"PyTorch","path":"how-to-guides/use-pytorch.md"},{"label":"SciKit-Learn","path":"how-to-guides/use-scikit-learn.md"},{"label":"TensorBoard","path":"how-to-guides/use-tensorboard.md"},{"label":"TensorFlow","path":"how-to-guides/use-tensorflow.md"}]},{"label":"Advanced Python topics","items":[{"label":"Execution Context","path":"conceptual/execution-context.md"},{"label":"Liveness scope","path":"conceptual/liveness-scope-concept.md"},{"label":"Systemic Object Marking","path":"conceptual/systemic-object-marking.md"}]},{"label":"Jupyter","path":"how-to-guides/jupyter.md"}]},{"label":"Plot","items":[{"label":"How to plot real-time data","path":"how-to-guides/plotting/overview.md"},{"label":"Deephaven Express","href":"https://deephaven.io/core/plotly/docs/"},{"label":"Matplotlib and Seaborn","path":"how-to-guides/plotting/matplot-seaborn.md"},{"label":"Plot without writing queries","path":"how-to-guides/user-interface/chart-builder.md"},{"label":"Built-in API","path":"how-to-guides/plotting/api-plotting.md"}]},{"label":"GUI","items":[{"label":"Use the GUI","items":[{"label":"Navigate the GUI","path":"how-to-guides/user-interface/navigating-the-ui.md"},{"label":"Set date-time format","path":"how-to-guides/set-date-time-format.md"},{"label":"Set table density","path":"how-to-guides/user-interface/set-table-density.md"},{"label":"Create and organize notebooks","path":"how-to-guides/user-interface/file-explorer.md"},{"label":"Markdown widgets","path":"how-to-guides/user-interface/markdown-widget.md"},{"label":"Real-time dashboards","items":[{"label":"deephaven.ui","path":"how-to-guides/deephaven-ui.md"},{"label":"Format tables in the UI","path":"how-to-guides/user-interface/formatting-tables.md"},{"label":"Filter without writing queries","path":"how-to-guides/user-interface/filters.md"},{"label":"Clickable links","path":"how-to-guides/user-interface/add-clickable-links.md"}]}]},{"label":"Customize the GUI","items":[{"label":"Custom themes","path":"how-to-guides/custom-themes.md"},{"label":"IFrames","path":"how-to-guides/use-iframes.md"}]}]},{"label":"Client APIs","items":[{"label":"Java","items":[{"label":"Extract data with a Java client","path":"how-to-guides/java-client.md"}]},{"label":"JS API","path":"how-to-guides/use-jsapi.md"},{"label":"Python","items":[{"label":"Overview","href":"https://deephaven.io/core/client-api/python/index.html"},{"label":"Initialize","href":"https://deephaven.io/core/client-api/python/examples.html#initialize"},{"label":"Binding to a table","href":"https://deephaven.io/core/client-api/python/examples.html#binding-to-a-table"},{"label":"Execute a query on a table","href":"https://deephaven.io/core/client-api/python/examples.html#execute-a-query-on-a-table"},{"label":"Sort a table","href":"https://deephaven.io/core/client-api/python/examples.html#sort-a-table"},{"label":"Filter a table","href":"https://deephaven.io/core/client-api/python/examples.html#filter-a-table"},{"label":"Query objects","href":"https://deephaven.io/core/client-api/python/examples.html#query-objects"},{"label":"Join two tables","href":"https://deephaven.io/core/client-api/python/examples.html#join-2-tables"},{"label":"Perform aggregations on table","href":"https://deephaven.io/core/client-api/python/examples.html#perform-aggregations-on-a-table"},{"label":"Convert a PyArrow table to a Deephaven table","href":"https://deephaven.io/core/client-api/python/examples.html#convert-a-pyarrow-table-to-a-deephaven-table"},{"label":"Execute a script server side","href":"https://deephaven.io/core/client-api/python/examples.html#execute-a-script-server-side"},{"label":"Subscribe to a ticking table","href":"https://deephaven.io/core/client-api/python/examples.html#subscribe-to-a-ticking-table"},{"label":"Error handling","href":"https://deephaven.io/core/client-api/python/examples.html#error-handling"},{"label":"Capture Python client tables","path":"how-to-guides/capture-tables.md"}]},{"label":"C++","items":[{"label":"Overview","href":"https://deephaven.io/core/client-api/cpp-examples/index.html"},{"label":"Getting started","href":"https://deephaven.io/core/client-api/cpp-examples/getting_started.html"},{"label":"Resource management","href":"https://deephaven.io/core/client-api/cpp-examples/resource_mgmt.html"},{"label":"Data I/O","href":"https://deephaven.io/core/client-api/cpp-examples/input_output.html"},{"label":"Fluent interface","href":"https://deephaven.io/core/client-api/cpp-examples/fluent.html"}]},{"label":"Go","items":[{"label":"Overview","href":"https://pkg.go.dev/github.com/deephaven/deephaven-core/go#section-readme"},{"label":"Fetch tables","href":"https://pkg.go.dev/github.com/deephaven/deephaven-core/go@v0.35.0/pkg/client#example-package-FetchTable"},{"label":"Import tables","href":"https://pkg.go.dev/github.com/deephaven/deephaven-core/go@v0.35.0/pkg/client#example-package-ImportTable"},{"label":"Create input tables","href":"https://pkg.go.dev/github.com/deephaven/deephaven-core/go@v0.35.0/pkg/client#example-package-InputTable"},{"label":"Run scripts","href":"https://pkg.go.dev/github.com/deephaven/deephaven-core/go@v0.35.0/pkg/client#example-package-RunScript"},{"label":"Table operations","href":"https://pkg.go.dev/github.com/deephaven/deephaven-core/go@v0.35.0/pkg/client#example-package-TableOps"}]},{"label":"R","items":[{"label":"Overview","href":"https://deephaven.io/core/client-api/r/index.html"},{"label":"Building blocks of the Deephaven R client","href":"https://deephaven.io/core/client-api/r/articles/rdeephaven.html#building-blocks-of-the-deephaven-r-client"},{"label":"Real-time data analysis","href":"https://deephaven.io/core/client-api/r/articles/rdeephaven.html#real-time-data-analysis"},{"label":"Powerful table operations","href":"https://deephaven.io/core/client-api/r/articles/rdeephaven.html#powerful-table-operations"},{"label":"Aggregations","href":"https://deephaven.io/core/client-api/r/articles/agg_by.html"},{"label":"Moving operations","href":"https://deephaven.io/core/client-api/r/articles/update_by.html"}]},{"label":"Flight SQL","path":"how-to-guides/flight-sql.md"},{"label":"Excel","items":[{"label":"Excel Client","path":"how-to-guides/excel/excel-client.md"}]},{"label":"Protobuf","items":[{"label":"Protobuf and RPC","path":"how-to-guides/protobuf.md"}]}]},{"label":"Plugins","items":[{"label":"Install and use plugins","path":"how-to-guides/install-use-plugins.md"},{"label":"Create your own plugin","path":"how-to-guides/create-plugins.md"}]},{"label":"Development tools","items":[{"label":"MCP","path":"how-to-guides/mcp.md"},{"label":"Copilot extension","path":"how-to-guides/copilot-extension.md"}]},{"label":"Best practices and troubleshooting","items":[{"label":"Think like a Deephaven ninja","path":"conceptual/ninja.md"},{"label":"Performance","items":[{"label":"Use performance tables","path":"how-to-guides/performance/performance-tables.md"},{"label":"Dial down the update frequency of ticking tables","path":"how-to-guides/performance/reduce-update-frequency.md"},{"label":"Data Indexes","path":"how-to-guides/data-indexes.md"},{"label":"Predicate Pushdown Filtering","path":"how-to-guides/predicate-pushdown.md"},{"label":"Parallelization","path":"conceptual/query-engine/parallelization.md"},{"label":"Synchronization and locking","path":"conceptual/query-engine/engine-locking.md"},{"label":"Python-Java boundary","path":"conceptual/python-java-boundary.md"},{"label":"Run Garbage Collection","path":"how-to-guides/performance/garbage-collection.md"},{"label":"Barrage metrics","path":"how-to-guides/performance/barrage-performance.md"},{"label":"Interpret Barrage metrics","path":"conceptual/barrage-metrics.md"},{"label":"Troubleshoot query performance","path":"conceptual/troubleshooting-steps.md"}]},{"label":"Errors and troubleshooting","items":[{"label":"Triage errors in queries","path":"how-to-guides/triage-errors.md"},{"label":"Decipher Python errors","path":"how-to-guides/python-errors.md"},{"label":"Debugging with PyCharm","path":"how-to-guides/debugging/pycharm-debugging.md"},{"label":"Retrieve logs","path":"how-to-guides/logs.md"},{"label":"Get version information","path":"how-to-guides/get-version.md"}]}]},{"label":"System setup and admin","items":[{"label":"Update Deephaven","path":"how-to-guides/configuration/updating-deephaven.md"},{"label":"Authentication","items":[{"label":"Anonymous","path":"how-to-guides/authentication/auth-anon.md"},{"label":"Keycloak","path":"how-to-guides/authentication/auth-keycloak.md"},{"label":"mTLS","path":"how-to-guides/authentication/auth-mtls.md"},{"label":"Pre-shared key","path":"how-to-guides/authentication/auth-psk.md"},{"label":"Username/password","path":"how-to-guides/authentication/auth-uname-pw.md"}]},{"label":"Configuration","items":[{"label":"Docker data volumes","path":"conceptual/docker-data-volumes.md"},{"label":"Adjust heap size","path":"how-to-guides/heap-size.md"},{"label":"Deephaven console service","path":"how-to-guides/configuration/console-service.md"},{"label":"Deephaven Docker application","path":"how-to-guides/configuration/docker-application.md"},{"label":"Application Mode","items":[{"label":"Application Mode","path":"how-to-guides/application-mode.md"},{"label":"Application Mode libraries","path":"how-to-guides/application-mode-libraries.md"},{"label":"Application Mode scripts","path":"how-to-guides/application-mode-script.md"}]},{"label":"Install packages","path":"how-to-guides/install-packages.md"},{"label":"Python packages","path":"how-to-guides/install-and-use-python-packages.md"},{"label":"Install and use Java packages","path":"how-to-guides/install-and-use-java-packages.md"},{"label":"Production application","path":"how-to-guides/configuration/configure-production-application.md"},{"label":"Deephaven configuration files","path":"how-to-guides/configuration/config-file.md"},{"label":"Web Defaults","path":"how-to-guides/configuration/configure-web.md"},{"label":"Custom environmental variables","path":"how-to-guides/custom-environmental-variables.md"},{"label":"Periodic Update Graph configuration","path":"conceptual/periodic-update-graph-configuration.md"},{"label":"Query table configuration","path":"conceptual/query-table-configuration.md"}]}]},{"label":"Cloud deployment","items":[{"label":"AWS EC2","path":"how-to-guides/aws-ec2.md"},{"label":"GCP","path":"how-to-guides/gcp-linux.md"}]}]},{"label":"Cheat sheets","items":[{"label":"Ultimate cheat sheet","path":"reference/cheat-sheets/cheat-sheet.md"},{"label":"Choose Python packages","path":"reference/cheat-sheets/choose-python-packages.md"},{"label":"Data import / export","items":[{"label":"Simple table constructors","path":"reference/cheat-sheets/simple-table-constructors.md"},{"label":"CSV","path":"reference/cheat-sheets/csv.md"},{"label":"Kafka","path":"reference/cheat-sheets/kafka.md"},{"label":"Parquet","path":"reference/cheat-sheets/parquet.md"},{"label":"URI","path":"reference/cheat-sheets/uri-cheat-sheet.md"}]},{"label":"Performance tables","path":"reference/cheat-sheets/performance-tables-cheat-sheet.md"},{"label":"Time operations","path":"reference/cheat-sheets/time-cheat-sheet.md"}]},{"label":"API documentation","items":[{"label":"Python (client)","href":"https://deephaven.io/core/client-api/python"},{"label":"Python (server)","href":"https://deephaven.io/core/pydoc"},{"label":"Java (client/server)","href":"https://deephaven.io/core/javadoc"},{"label":"JavaScript (client)","items":[{"label":"Javascript API Concepts","path":"reference/js-api/concepts.md"},{"label":"JavaScript","href":"https://deephaven.io/core/client-api/javascript/modules/dh.html"}]},{"label":"Go (client)","href":"https://pkg.go.dev/github.com/deephaven/deephaven-core/go"},{"label":"C++ (client)","href":"https://deephaven.io/core/client-api/cpp"},{"label":"C++ (examples)","href":"https://deephaven.io/core/client-api/cpp-examples"},{"label":"R (client)","href":"https://deephaven.io/core/client-api/r"},{"label":"Barrage (communication)","href":"https://deephaven.io/barrage/docs/"},{"label":"gRPC (communication)","href":"https://deephaven.io/core/javadoc/io/deephaven/proto/backplane/grpc/SessionServiceGrpc.html"},{"label":"Protobuf (communication)","href":"https://deephaven.io/core/client-api/protobuf/"}]},{"label":"Reference","items":[{"label":"Engine","items":[{"label":"await_update","path":"reference/table-operations/table-listeners/await-update.md"},{"label":"data_index","path":"reference/engine/data-index.md"},{"label":"has_data_index","path":"reference/engine/has-data-index.md"},{"label":"LivenessScope","path":"reference/engine/LivenessScope.md"},{"label":"liveness_scope","path":"reference/engine/liveness-scope.md"}]},{"label":"Create, import, and export tables","items":[{"label":"Simple table constructors","items":[{"label":"Tables","items":[{"label":"empty_table","path":"reference/table-operations/create/emptyTable.md"},{"label":"new_table","path":"reference/table-operations/create/newTable.md"},{"label":"time_table","path":"reference/table-operations/create/timeTable.md"},{"label":"input_table","path":"reference/table-operations/create/input-table.md"},{"label":"ring_table","path":"reference/table-operations/create/ringTable.md"},{"label":"tree","path":"reference/table-operations/create/tree.md"},{"label":"rollup","path":"reference/table-operations/create/rollup.md"},{"label":"with_attributes","path":"reference/table-operations/create/withAttributes.md"},{"label":"without_attributes","path":"reference/table-operations/create/withoutAttributes.md"}]},{"label":"Columns","items":[{"label":"bool_col","path":"reference/table-operations/create/boolCol.md"},{"label":"byte_col","path":"reference/table-operations/create/byteCol.md"},{"label":"char_col","path":"reference/table-operations/create/charCol.md"},{"label":"datetime_col","path":"reference/table-operations/create/dateTimeCol.md"},{"label":"double_col","path":"reference/table-operations/create/doubleCol.md"},{"label":"float_col","path":"reference/table-operations/create/floatCol.md"},{"label":"InputColumn","path":"reference/table-operations/create/inputColumn.md"},{"label":"int_col","path":"reference/table-operations/create/intCol.md"},{"label":"jobj_col","path":"reference/table-operations/create/jobj_col.md"},{"label":"long_col","path":"reference/table-operations/create/longCol.md"},{"label":"pyobj_col","path":"reference/table-operations/create/pyobj_col.md"},{"label":"short_col","path":"reference/table-operations/create/shortCol.md"},{"label":"string_col","path":"reference/table-operations/create/stringCol.md"}]}]},{"label":"Advanced table constructors","items":[{"label":"add_only_to_blink","path":"reference/table-operations/create/add-only-to-blink.md"},{"label":"blink_to_append_only","path":"reference/table-operations/create/blink-to-append-only.md"},{"label":"function_generated_table","path":"reference/table-operations/create/function_generated_table.md"},{"label":"DynamicTableWriter","path":"reference/table-operations/create/DynamicTableWriter.md"},{"label":"TablePublisher","path":"reference/table-operations/create/TablePublisher.md"},{"label":"remove_blink","path":"reference/table-operations/create/remove-blink.md"},{"label":"TableReplayer","path":"reference/table-operations/create/Replayer.md"},{"label":"TableDefinitionLike","path":"reference/table-operations/create/TableDefinitionLike.md"}]},{"label":"Arrow","items":[{"label":"read_feather","path":"reference/arrow/read-feather.md"},{"label":"to_arrow","path":"reference/arrow/to-arrow.md"},{"label":"to_table","path":"reference/arrow/to-table.md"}]},{"label":"Barrage","items":[{"label":"barrage_session","path":"reference/data-import-export/barrage/barrage-session.md"},{"label":"close","path":"reference/data-import-export/barrage/close.md"},{"label":"subscribe","path":"reference/data-import-export/barrage/subscribe.md"},{"label":"snapshot","path":"reference/data-import-export/barrage/snapshot-barrage.md"}]},{"label":"CSV","items":[{"label":"read_csv","path":"reference/data-import-export/CSV/readCsv.md"},{"label":"write_csv","path":"reference/data-import-export/CSV/writeCsv.md"}]},{"label":"HTML","items":[{"label":"to_html","path":"reference/data-import-export/HTML/to-html.md"}]},{"label":"Kafka","items":[{"label":"consume_to_partitioned_table","path":"reference/data-import-export/Kafka/consume-to-partitioned-table.md"},{"label":"consume","path":"reference/data-import-export/Kafka/consume.md"},{"label":"produce","path":"reference/data-import-export/Kafka/produce.md"}]},{"label":"Parquet","items":[{"label":"ColumnInstruction","path":"reference/data-import-export/Parquet/ColumnInstruction.md"},{"label":"read","path":"reference/data-import-export/Parquet/readTable.md"},{"label":"write","path":"reference/data-import-export/Parquet/writeTable.md"}]},{"label":"SQL","items":[{"label":"read_sql","path":"reference/data-import-export/SQL/read_sql.md"},{"label":"adbc.read_cursor","path":"reference/data-import-export/SQL/adbc.md"},{"label":"odbc.read_cursor","path":"reference/data-import-export/SQL/odbc.md"}]},{"label":"Iceberg","items":[{"label":"adapter","path":"reference/iceberg/adapter.md"},{"label":"adapater_aws_glue","path":"reference/iceberg/adapter-aws-glue.md"},{"label":"adapter_s3_rest","path":"reference/iceberg/adapter-s3-rest.md"},{"label":"IcebergCatalogAdapter","path":"reference/iceberg/iceberg-catalog-adapter.md"},{"label":"IcebergReadInstructions","path":"reference/iceberg/iceberg-read-instructions.md"},{"label":"IcebergTable","path":"reference/iceberg/iceberg-table.md"},{"label":"IcebergTableAdapter","path":"reference/iceberg/iceberg-table-adapter.md"},{"label":"IcebergTableWriter","path":"reference/iceberg/iceberg-table-writer.md"},{"label":"IcebergUpdateMode","path":"reference/iceberg/iceberg-update-mode.md"},{"label":"IcebergWriteInstructions","path":"reference/iceberg/iceberg-write-instructions.md"},{"label":"InferenceResolver","path":"reference/iceberg/inference-resolver.md"},{"label":"SchemaProvider","path":"reference/iceberg/schema-provider.md"},{"label":"SortOrderProvider","path":"reference/iceberg/sort-order-provider.md"},{"label":"TableParquetWriterOptions","path":"reference/iceberg/table-parquet-writer-options.md"},{"label":"UnboundResolver","path":"reference/iceberg/unbound-resolver.md"}]},{"label":"Iterate","items":[{"label":"iter_dict","path":"reference/data-import-export/iterate/iter-dict.md"},{"label":"iter_tuple","path":"reference/data-import-export/iterate/iter-tuple.md"},{"label":"iter_chunk_dict","path":"reference/data-import-export/iterate/iter-chunk-dict.md"},{"label":"iter_chunk_tuple","path":"reference/data-import-export/iterate/iter-chunk-tuple.md"}]},{"label":"URI","path":"reference/data-import-export/uri.md"}]},{"label":"Work with tables","items":[{"label":"Metadata","items":[{"label":"attributes","path":"reference/table-operations/metadata/attributes.md"},{"label":"columns","path":"reference/table-operations/metadata/columns.md"},{"label":"has_columns","path":"reference/table-operations/metadata/has_columns.md"},{"label":"is_blink","path":"reference/table-operations/metadata/is_blink.md"},{"label":"is_flat","path":"reference/table-operations/metadata/is_flat.md"},{"label":"is_refreshing","path":"reference/table-operations/metadata/is_refreshing.md"},{"label":"meta_table","path":"reference/table-operations/metadata/meta_table.md"},{"label":"size","path":"reference/table-operations/metadata/size.md"},{"label":"table_diff","path":"reference/table-operations/metadata/table_diff.md"},{"label":"to_string","path":"reference/table-operations/metadata/to_string.md"},{"label":"update_graph","path":"reference/table-operations/metadata/update_graph.md"}]},{"label":"Select","items":[{"label":"drop_columns","path":"reference/table-operations/select/drop-columns.md"},{"label":"flatten","path":"reference/table-operations/select/flatten.md"},{"label":"lazy_update","path":"reference/table-operations/select/lazy-update.md"},{"label":"move_columns","path":"reference/table-operations/select/move-columns.md"},{"label":"move_columns_down","path":"reference/table-operations/select/move-columns-down.md"},{"label":"move_columns_up","path":"reference/table-operations/select/move-columns-up.md"},{"label":"rename_columns","path":"reference/table-operations/select/rename-columns.md"},{"label":"select","path":"reference/table-operations/select/select.md"},{"label":"select_distinct","path":"reference/table-operations/select/select-distinct.md"},{"label":"update","path":"reference/table-operations/select/update.md"},{"label":"update_view","path":"reference/table-operations/select/update-view.md"},{"label":"view","path":"reference/table-operations/select/view.md"}]},{"label":"Filter","items":[{"label":"head","path":"reference/table-operations/filter/head.md"},{"label":"head_pct","path":"reference/table-operations/filter/head-pct.md"},{"label":"slice","path":"reference/table-operations/filter/slice.md"},{"label":"slice_pct","path":"reference/table-operations/filter/slice-pct.md"},{"label":"tail","path":"reference/table-operations/filter/tail.md"},{"label":"tail_pct","path":"reference/table-operations/filter/tail-pct.md"},{"label":"where","path":"reference/table-operations/filter/where.md"},{"label":"where_in","path":"reference/table-operations/filter/where-in.md"},{"label":"where_one_of","path":"reference/table-operations/filter/where-one-of.md"},{"label":"where_not_in","path":"reference/table-operations/filter/where-not-in.md"}]},{"label":"Sort","items":[{"label":"restrict_sort_to","path":"reference/table-operations/sort/restrict-sort.md"},{"label":"reverse","path":"reference/table-operations/sort/reverse.md"},{"label":"sort","path":"reference/table-operations/sort/sort.md"},{"label":"sort_descending","path":"reference/table-operations/sort/sort-descending.md"}]},{"label":"Format","items":[{"label":"format_columns","path":"reference/table-operations/format/format-columns.md"},{"label":"format_column_where","path":"reference/table-operations/format/format-column-where.md"},{"label":"format_row_where","path":"reference/table-operations/format/format-row-where.md"},{"label":"layout_hints","path":"reference/table-operations/format/layout-hints.md"},{"label":"keyed_transpose","path":"reference/table-operations/format/keyed-transpose.md"}]},{"label":"Merge","items":[{"label":"merge","path":"reference/table-operations/merge/merge.md"},{"label":"merge_sorted","path":"reference/table-operations/merge/merge-sorted.md"}]},{"label":"Group and aggregate","items":[{"label":"Group","items":[{"label":"group_by","path":"reference/table-operations/group-and-aggregate/groupBy.md"},{"label":"ungroup","path":"reference/table-operations/group-and-aggregate/ungroup.md"}]},{"label":"Single aggregation","items":[{"label":"avg_by","path":"reference/table-operations/group-and-aggregate/avgBy.md"},{"label":"count_by","path":"reference/table-operations/group-and-aggregate/countBy.md"},{"label":"first_by","path":"reference/table-operations/group-and-aggregate/firstBy.md"},{"label":"head_by","path":"reference/table-operations/group-and-aggregate/headBy.md"},{"label":"last_by","path":"reference/table-operations/group-and-aggregate/lastBy.md"},{"label":"max_by","path":"reference/table-operations/group-and-aggregate/maxBy.md"},{"label":"median_by","path":"reference/table-operations/group-and-aggregate/medianBy.md"},{"label":"min_by","path":"reference/table-operations/group-and-aggregate/minBy.md"},{"label":"std_by","path":"reference/table-operations/group-and-aggregate/stdBy.md"},{"label":"sum_by","path":"reference/table-operations/group-and-aggregate/sumBy.md"},{"label":"tail_by","path":"reference/table-operations/group-and-aggregate/tailBy.md"},{"label":"var_by","path":"reference/table-operations/group-and-aggregate/varBy.md"},{"label":"weighted_avg_by","path":"reference/table-operations/group-and-aggregate/weighted-avg-by.md"},{"label":"weighted_sum_by","path":"reference/table-operations/group-and-aggregate/weighted-sum-by.md"}]},{"label":"Multi-aggregation","items":[{"label":"agg_by","path":"reference/table-operations/group-and-aggregate/aggBy.md"},{"label":"partitioned_agg_by","path":"reference/table-operations/group-and-aggregate/partitionedAggBy.md"},{"label":"abs_sum_by","path":"reference/table-operations/group-and-aggregate/AbsSumBy.md"},{"label":"abs_sum","path":"reference/table-operations/group-and-aggregate/AggAbsSum.md"},{"label":"agg_all_by","path":"reference/table-operations/group-and-aggregate/AggAllBy.md"},{"label":"avg","path":"reference/table-operations/group-and-aggregate/AggAvg.md"},{"label":"count_","path":"reference/table-operations/group-and-aggregate/AggCount.md"},{"label":"count_distinct","path":"reference/table-operations/group-and-aggregate/AggCountDistinct.md"},{"label":"count_where","path":"reference/table-operations/group-and-aggregate/AggCountWhere.md"},{"label":"distinct","path":"reference/table-operations/group-and-aggregate/AggDistinct.md"},{"label":"first","path":"reference/table-operations/group-and-aggregate/AggFirst.md"},{"label":"formula","path":"reference/table-operations/group-and-aggregate/AggFormula.md"},{"label":"group","path":"reference/table-operations/group-and-aggregate/AggGroup.md"},{"label":"last","path":"reference/table-operations/group-and-aggregate/AggLast.md"},{"label":"max_","path":"reference/table-operations/group-and-aggregate/AggMax.md"},{"label":"median","path":"reference/table-operations/group-and-aggregate/AggMed.md"},{"label":"min_","path":"reference/table-operations/group-and-aggregate/AggMin.md"},{"label":"partition","path":"reference/table-operations/group-and-aggregate/AggPartition.md"},{"label":"pct","path":"reference/table-operations/group-and-aggregate/AggPct.md"},{"label":"sorted_first","path":"reference/table-operations/group-and-aggregate/AggSortedFirst.md"},{"label":"sorted_last","path":"reference/table-operations/group-and-aggregate/AggSortedLast.md"},{"label":"std","path":"reference/table-operations/group-and-aggregate/AggStd.md"},{"label":"sum_","path":"reference/table-operations/group-and-aggregate/AggSum.md"},{"label":"unique","path":"reference/table-operations/group-and-aggregate/AggUnique.md"},{"label":"var","path":"reference/table-operations/group-and-aggregate/AggVar.md"},{"label":"weighted_avg","path":"reference/table-operations/group-and-aggregate/AggWAvg.md"},{"label":"weighted_sum","path":"reference/table-operations/group-and-aggregate/AggWSum.md"}]}]},{"label":"Update By","items":[{"label":"update_by","path":"reference/table-operations/update-by-operations/updateBy.md"},{"label":"cum_max","path":"reference/table-operations/update-by-operations/cum-max.md"},{"label":"cum_min","path":"reference/table-operations/update-by-operations/cum-min.md"},{"label":"cum_prod","path":"reference/table-operations/update-by-operations/cum-prod.md"},{"label":"cum_sum","path":"reference/table-operations/update-by-operations/cum-sum.md"},{"label":"cum_count_where","path":"reference/table-operations/update-by-operations/cum-count-where.md"},{"label":"delta","path":"reference/table-operations/update-by-operations/delta.md"},{"label":"DeltaControl","path":"reference/table-operations/update-by-operations/DeltaControl.md"},{"label":"ema_tick","path":"reference/table-operations/update-by-operations/ema-tick.md"},{"label":"ema_time","path":"reference/table-operations/update-by-operations/ema-time.md"},{"label":"emmax_tick","path":"reference/table-operations/update-by-operations/emmax-tick.md"},{"label":"emmax_time","path":"reference/table-operations/update-by-operations/emmax-time.md"},{"label":"emmin_tick","path":"reference/table-operations/update-by-operations/emmin-tick.md"},{"label":"emmin_time","path":"reference/table-operations/update-by-operations/emmin-time.md"},{"label":"ems_tick","path":"reference/table-operations/update-by-operations/ems-tick.md"},{"label":"ems_time","path":"reference/table-operations/update-by-operations/ems-time.md"},{"label":"emstd_tick","path":"reference/table-operations/update-by-operations/emstd-tick.md"},{"label":"emstd_time","path":"reference/table-operations/update-by-operations/emstd-time.md"},{"label":"forward_fill","path":"reference/table-operations/update-by-operations/forward-fill.md"},{"label":"OperationControl","path":"reference/table-operations/update-by-operations/OperationControl.md"},{"label":"rolling_avg_tick","path":"reference/table-operations/update-by-operations/rolling-avg-tick.md"},{"label":"rolling_avg_time","path":"reference/table-operations/update-by-operations/rolling-avg-time.md"},{"label":"rolling_count_tick","path":"reference/table-operations/update-by-operations/rolling-count-tick.md"},{"label":"rolling_count_time","path":"reference/table-operations/update-by-operations/rolling-count-time.md"},{"label":"rolling_count__where_tick","path":"reference/table-operations/update-by-operations/rolling-count-where-tick.md"},{"label":"rolling_count_where_time","path":"reference/table-operations/update-by-operations/rolling-count-where-time.md"},{"label":"rolling_formula_tick","path":"reference/table-operations/update-by-operations/rolling-formula-tick.md"},{"label":"rolling_formula_time","path":"reference/table-operations/update-by-operations/rolling-formula-time.md"},{"label":"rolling_group_tick","path":"reference/table-operations/update-by-operations/rolling-group-tick.md"},{"label":"rolling_group_time","path":"reference/table-operations/update-by-operations/rolling-group-time.md"},{"label":"rolling_max_tick","path":"reference/table-operations/update-by-operations/rolling-max-tick.md"},{"label":"rolling_max_time","path":"reference/table-operations/update-by-operations/rolling-max-time.md"},{"label":"rolling_min_tick","path":"reference/table-operations/update-by-operations/rolling-min-tick.md"},{"label":"rolling_min_time","path":"reference/table-operations/update-by-operations/rolling-min-time.md"},{"label":"rolling_prod_tick","path":"reference/table-operations/update-by-operations/rolling-prod-tick.md"},{"label":"rolling_prod_time","path":"reference/table-operations/update-by-operations/rolling-prod-time.md"},{"label":"rolling_std_tick","path":"reference/table-operations/update-by-operations/rolling-std-tick.md"},{"label":"rolling_std_time","path":"reference/table-operations/update-by-operations/rolling-std-time.md"},{"label":"rolling_sum_tick","path":"reference/table-operations/update-by-operations/rolling-sum-tick.md"},{"label":"rolling_sum_time","path":"reference/table-operations/update-by-operations/rolling-sum-time.md"},{"label":"rolling_wavg_tick","path":"reference/table-operations/update-by-operations/rolling-wavg-tick.md"},{"label":"rolling_wavg_time","path":"reference/table-operations/update-by-operations/rolling-wavg-time.md"}]},{"label":"Join","items":[{"label":"aj","path":"reference/table-operations/join/aj.md"},{"label":"exact_join","path":"reference/table-operations/join/exact-join.md"},{"label":"full_outer_join","path":"reference/table-operations/join/full-outer-join.md"},{"label":"join","path":"reference/table-operations/join/join.md"},{"label":"left_outer_join","path":"reference/table-operations/join/left-outer-join.md"},{"label":"multi_join","path":"reference/table-operations/join/multi-join.md"},{"label":"natural_join","path":"reference/table-operations/join/natural-join.md"},{"label":"raj","path":"reference/table-operations/join/raj.md"},{"label":"range_join","path":"reference/table-operations/join/range-join.md"}]},{"label":"Partition","items":[{"label":"partition_by","path":"reference/table-operations/group-and-aggregate/partitionBy.md"},{"label":"filter","path":"reference/table-operations/partitioned-tables/partitioned-table-filter.md"},{"label":"from_constituent_tables","path":"reference/table-operations/partitioned-tables/from-constituent-tables.md"},{"label":"from_partitioned_table","path":"reference/table-operations/partitioned-tables/from-partitioned-table.md"},{"label":"get_constituent","path":"reference/table-operations/partitioned-tables/get-constituent.md"},{"label":"keys","path":"reference/table-operations/partitioned-tables/keys.md"},{"label":"Metadata methods","path":"reference/table-operations/partitioned-tables/metadata-methods.md"},{"label":"partitioned_transform","path":"reference/table-operations/partitioned-tables/partitioned-transform.md"},{"label":"merge","path":"reference/table-operations/partitioned-tables/partitioned-table-merge.md"},{"label":"sort","path":"reference/table-operations/partitioned-tables/partitioned-table-sort.md"},{"label":"proxy","path":"reference/table-operations/partitioned-tables/proxy.md"},{"label":"transform","path":"reference/table-operations/partitioned-tables/transform.md"}]},{"label":"Snapshot","items":[{"label":"snapshot","path":"reference/table-operations/snapshot/snapshot.md"},{"label":"snapshot_when","path":"reference/table-operations/snapshot/snapshot-when.md"}]},{"label":"Time","items":[{"label":"time_window","path":"reference/time/time-window.md"},{"label":"Date-time","items":[{"label":"dh_now","path":"reference/time/datetime/dh_now.md"},{"label":"dh_time_zone","path":"reference/time/datetime/dh_time_zone.md"},{"label":"dh_today","path":"reference/time/datetime/dh_today.md"},{"label":"simple_date_format","path":"reference/time/datetime/simple_date_format.md"},{"label":"time_zone_alias_add","path":"reference/time/datetime/time_zone_alias_add.md"},{"label":"time_zone_alias_rm","path":"reference/time/datetime/time_zone_alias_rm.md"},{"label":"to_date","path":"reference/time/datetime/to_date.md"},{"label":"to_datetime","path":"reference/time/datetime/to_datetime.md"},{"label":"to_j_duration","path":"reference/time/datetime/to_j_duration.md"},{"label":"to_j_instant","path":"reference/time/datetime/to_j_instant.md"},{"label":"to_j_local_date","path":"reference/time/datetime/to_j_local_date.md"},{"label":"to_j_local_time","path":"reference/time/datetime/to_j_local_time.md"},{"label":"to_j_period","path":"reference/time/datetime/to_j_period.md"},{"label":"to_j_time_zone","path":"reference/time/datetime/to_j_time_zone.md"},{"label":"to_j_zdt","path":"reference/time/datetime/to_j_zdt.md"},{"label":"to_np_datetime64","path":"reference/time/datetime/to_np_datetime64.md"},{"label":"to_np_timedelta64","path":"reference/time/datetime/to_np_timedelta64.md"},{"label":"to_pd_timestamp","path":"reference/time/datetime/to_pd_timestamp.md"},{"label":"to_pd_timedelta","path":"reference/time/datetime/to_pd_timedelta.md"},{"label":"to_time","path":"reference/time/datetime/to_time.md"},{"label":"to_timedelta","path":"reference/time/datetime/to_timedelta.md"}]},{"label":"Calendar","items":[{"label":"add_calendar","path":"reference/time/calendar/add-calendar.md"},{"label":"calendar","path":"reference/time/calendar/calendar.md"},{"label":"calendar_name","path":"reference/time/calendar/calendar-name.md"},{"label":"calendar_names","path":"reference/time/calendar/calendar-names.md"},{"label":"remove_calendar","path":"reference/time/calendar/remove-calendar.md"},{"label":"set_calendar","path":"reference/time/calendar/set-calendar.md"}]}]}]},{"label":"Query strings","items":[{"label":"Filters","items":[{"label":"Match filters","items":[{"label":"equals","path":"reference/query-language/match-filters/equals.md"},{"label":"not equals","path":"reference/query-language/match-filters/not-equals.md"},{"label":"icase in","path":"reference/query-language/match-filters/icase-in.md"},{"label":"icase not in","path":"reference/query-language/match-filters/icase-not-in.md"},{"label":"in","path":"reference/query-language/match-filters/in.md"},{"label":"not in","path":"reference/query-language/match-filters/not-in.md"}]}]},{"label":"Special variables and constants","path":"reference/query-language/variables/special-variables.md"},{"label":"Types","items":[{"label":"Arrays","path":"reference/query-language/types/arrays.md"},{"label":"date-time","path":"reference/query-language/types/date-time.md"},{"label":"Durations","path":"reference/query-language/types/durations.md"},{"label":"Casting","path":"reference/query-language/control-flow/casting.md"},{"label":"NaNs","path":"reference/query-language/types/NaNs.md"},{"label":"Nulls","path":"reference/query-language/types/nulls.md"},{"label":"Objects","path":"reference/query-language/types/objects.md"},{"label":"Periods","path":"reference/query-language/types/periods.md"},{"label":"Strings","path":"reference/query-language/types/strings.md"}]}]},{"label":"Data types","path":"reference/python/deephaven-python-types.md"},{"label":"numpy","items":[{"label":"dh_null_to_nan","path":"reference/numpy/dh-null-to-nan.md"},{"label":"to_numpy","path":"reference/numpy/to-numpy.md"},{"label":"to_table","path":"reference/numpy/to-table.md"},{"label":"to_np_busdaycalendar","path":"reference/numpy/to-np-busdaycalendar.md"}]},{"label":"pandas","items":[{"label":"to_pandas","path":"reference/pandas/to-pandas.md"},{"label":"to_table","path":"reference/pandas/to-table.md"}]},{"label":"Plot","items":[{"label":"one_click","path":"reference/plot/one-click.md"},{"label":"one_click_partitioned_table","path":"reference/plot/one-click-partitioned-table.md"},{"label":"plot_cat","path":"reference/plot/catPlot.md"},{"label":"plot_cat_hist","path":"reference/plot/catHistPlot.md"},{"label":"plot_ohlc","path":"reference/plot/ohlcPlot.md"},{"label":"plot_pie","path":"reference/plot/piePlot.md"},{"label":"plot_style","path":"reference/plot/plotStyle.md"},{"label":"plot_treemap","path":"reference/plot/treemapPlot.md"},{"label":"plot_xy","path":"reference/plot/plot.md"},{"label":"plot_xy_hist","path":"reference/plot/histPlot.md"},{"label":"SelectableDataSet","path":"reference/query-language/types/SelectableDataSet.md"}]},{"label":"Performance","items":[{"label":"garbage_collect","path":"reference/garbage-collect.md"}]},{"label":"Configuration","items":[{"label":"Application Mode configuration","path":"reference/app-mode/application-mode-config.md"}]},{"label":"Imports","items":[{"label":"Auto-imported functions","path":"reference/query-language/query-library/auto-imported-functions.md"},{"label":"Backend Imports","path":"reference/python/backend-imports.md"}]},{"label":"Version support matrix","path":"reference/version-matrix.md"}]},{"label":"Help and more","items":[{"label":"Deephaven example apps on GitHub","href":"https://github.com/deephaven-examples"},{"label":"FAQs","items":[{"label":"FAQ Overview","path":"reference/community-questions/cq-index.md"},{"label":"General","items":[{"label":"How can I find which Core version to which a feature or fix was added?","path":"reference/community-questions/how-do-i-find-a-specific-build.md"},{"label":"Is it possible to read a Parquet file from a remote location?","path":"reference/community-questions/is-it-possible-read-parquet-from-remote.md"},{"label":"When does Deephaven load data into memory for Parquet reads?","path":"reference/community-questions/when-does-dh-load-data-into-memory-parquet-reads.md"}]},{"label":"Installation","items":[{"label":"Is docker compose required?","path":"reference/community-questions/is-docker-compose-required.md"}]},{"label":"Configuration","items":[{"label":"How do I configure Deephaven to use another port?","path":"reference/community-questions/configure-dh-to-use-another-port.md"},{"label":"What's the minimum amount of memory I should allocate to a Deephaven server?","path":"reference/community-questions/whats-minimum-amount-memory-to-allocate.md"},{"label":"Is it possible disable the Deephaven console?","path":"reference/community-questions/possible-to-disable-console.md"},{"label":"How do I set the default timezone?","path":"reference/community-questions/set-timezone.md"},{"label":"How can I manage the number of cores Deephaven can use?","path":"reference/community-questions/manage-thread-pool-size.md"}]},{"label":"Table operations","items":[{"label":"Does Deephaven have a built-in ATR?","path":"reference/community-questions/average-true-range.md"},{"label":"How can I perform rolling operations without a fixed window size?","path":"reference/community-questions/can-i-perform-rolling-ops-without-fixed-window-size.md"},{"label":"How do I extract data from a table?","path":"reference/community-questions/extract-values-from-tables.md"},{"label":"How do I get the ISO week number from a datetime?","path":"reference/community-questions/iso-week-number.md"},{"label":"How do row keys and positional indices behave during table operations?","path":"reference/community-questions/shifts.md"},{"label":"Why do queries run faster the second time they are run?","path":"reference/community-questions/query-memoization.md"},{"label":"How do I create a partitioned blink table?","path":"reference/community-questions/partitioned-blink-tables-drop-attribute.md"},{"label":"How do I automatically execute Python code based on a Deephaven table column value?","path":"reference/community-questions/automatically-execute-python-code.md"},{"label":"When should I use `where_in` or `natural_join`?","path":"reference/community-questions/wherein-vs-naturaljoin.md"}]},{"label":"Troubleshooting","items":[{"label":"Can I reset the Python kernel without restarting the Deephaven Docker container?","path":"reference/community-questions/can-i-reset-py-kernel-without-restarting-dh.md"},{"label":"How do I solve a `hash table exceeds maximum size` error?","path":"reference/community-questions/hash-table-exceeds-maximum-size.md"},{"label":"How does memory work in the JVM?","path":"reference/community-questions/memory-jvm.md"},{"label":"What's the best approach to monitor Deephaven server health?","path":"reference/community-questions/monitor-dh-server-health.md"},{"label":"How do I import one Python script into another in the Deephaven IDE?","path":"reference/community-questions/import-python-script.md"},{"label":"Why am I getting an UpdateGraphConflictException?","path":"reference/community-questions/update-graph-conflict-exception.md"}]},{"label":"Server-side APIs","items":[{"label":"Is there a way to find out how much memory a table is using?","path":"reference/community-questions/find-how-much-memory-a-table-is-using.md"},{"label":"Does it make any difference if I separate table operations or chain them together?","path":"reference/community-questions/chained-operations.md"},{"label":"Why isn't `last_by` ticking?","path":"reference/community-questions/last-by-not-ticking.md"},{"label":"How can I periodically write a ticking table to disk?","path":"reference/community-questions/write-ticking-table-periodically.md"},{"label":"Does `deephaven.stream.kafka` use the Confluent consumer under the hood?","path":"reference/community-questions/does-deephaven-stream-kafka-use-confluent.md"},{"label":"How do I dynamically update a DataFrame from a table?","path":"reference/community-questions/dynamically-update-dataframe.md"},{"label":"How do I get data out of a table?","path":"reference/community-questions/how-do-i-get-data-out-of-a-deephaven-table.md"},{"label":"How do I create unrollable columns in the Python IDE?","path":"reference/community-questions/python-unrollable-column.md"},{"label":"Is it possible to convert one or more columns of a Deephaven table to JSON?","path":"reference/community-questions/possible-to-convert-columns-to-json.md"},{"label":"How do I convert vector columns to primitive array columns?","path":"reference/community-questions/convert-array-types.md"},{"label":"How do I troubleshoot type hints?","path":"reference/community-questions/how-do-i-troubleshoot-type-hints.md"},{"label":"How can I bin times to a specific time?","path":"reference/community-questions/bin-times-specific-time.md"},{"label":"How can I convert year, day, and minute to an Instant?","path":"reference/community-questions/convert-year-day-minute-instant.md"},{"label":"Why are my table operations producing incorrect results?","path":"reference/community-questions/why-do-my-python-type-hints-error.md"},{"label":"Why aren't my date-time table operations working as expected?","path":"reference/community-questions/python-vs-query-language-time-ops.md"},{"label":"How do I control what objects are displayed in the console?","path":"reference/community-questions/display-objects-python.md"}]},{"label":"Server-side APIs: Query language","items":[{"label":"Why are my table operations producing incorrect results?","path":"reference/community-questions/why-table-ops-producing-incorrect-results.md"},{"label":"How can I convert an integer date to a formatted string?","path":"reference/community-questions/convert-integer-date-to-formatted-string.md"},{"label":"How do I shift values in columns?","path":"reference/community-questions/how-do-i-shift-values-in-columns.md"}]},{"label":"Client APIs","items":[{"label":"Where can I find the password for the Deephaven IDE?","path":"reference/community-questions/find-password-for-ide.md"},{"label":"How do I increase the maximum message size?","path":"reference/community-questions/message-larger-than-max.md"}]},{"label":"Integrations: AWS","items":[{"label":"Why can't I read from S3?","path":"reference/community-questions/aws-timeout.md"},{"label":"How can I assume a specific role for S3?","path":"reference/community-questions/assume-role-s3-credentials.md"}]}]},{"label":"Engage in GitHub discussions","href":"https://github.com/deephaven/deephaven-core/discussions"},{"label":"File GitHub issues","href":"https://github.com/deephaven/deephaven-core/issues"},{"label":"Slack","href":"https://deephaven.io/slack"}]}],"slug":"core/docs/how-to-guides/built-in-functions","project":{"name":"Core","deployedPath":"deephaven/deephaven-core/docs","slug":"core","repoUrl":"https://github.com/deephaven/deephaven-core","repoPath":"docs/python","languages":["python"],"current":"main","homePage":"intro","hasSnapshots":true,"propGroups":{}},"projectCurrent":"main","branch":"main","branches":[{"label":"main","slug":"main"},{"label":"0.40.4","slug":"0.40.4"},{"label":"0.40.3","slug":"0.40.3"},{"label":"0.40.2","slug":"0.40.2"},{"label":"0.40.1","slug":"0.40.1"},{"label":"0.40.0","slug":"0.40.0"},{"label":"0.39.8","slug":"0.39.8"}]}],["$","$L4",null,{"parallelRouterKey":"children","segmentPath":["children","(docs)","children","$29","children"],"error":"$2a","errorStyles":[],"errorScripts":[],"template":["$","$L5",null,{}],"templateStyles":"$undefined","templateScripts":"$undefined","notFound":"$L2b","notFoundStyles":[]}]]}]]}]
2c:I[43878,["8083","static/chunks/app/(docs)/%5B...slug%5D/not-found-a36ae6a31cc48975.js"],"default"]
2b:["$","article",null,{"children":[["$","div",null,{"className":"markdown","children":[["$","h1",null,{"children":"404"}],["$","p",null,{"children":"Doc page not found. It may have moved or no longer exists."}]]}],["$","$L2c",null,{}]]}]
2d:I[44890,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8218","static/chunks/aaea2bcf-3d71fa65747a4b58.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","9783","static/chunks/9783-ee70276ef2279b23.js","2793","static/chunks/2793-1c2d2883ff508ae2.js","6423","static/chunks/6423-8ea740d3a5a09956.js","9448","static/chunks/9448-fbccb7b5a2d8a0e7.js","9475","static/chunks/9475-861f321b0ff5097d.js","6369","static/chunks/app/(docs)/%5B...slug%5D/page-fb4206ffedb59e79.js"],"default"]
2e:"$Sreact.suspense"
30:I[88669,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8218","static/chunks/aaea2bcf-3d71fa65747a4b58.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","9783","static/chunks/9783-ee70276ef2279b23.js","2793","static/chunks/2793-1c2d2883ff508ae2.js","6423","static/chunks/6423-8ea740d3a5a09956.js","9448","static/chunks/9448-fbccb7b5a2d8a0e7.js","9475","static/chunks/9475-861f321b0ff5097d.js","6369","static/chunks/app/(docs)/%5B...slug%5D/page-fb4206ffedb59e79.js"],"default"]
7:[["$","meta","0",{"name":"viewport","content":"width=device-width, initial-scale=1"}],["$","meta","1",{"charSet":"utf-8"}],["$","title","2",{"children":"Built-in query language functions | Deephaven"}],["$","meta","3",{"name":"description","content":"Like constants and variables, there are many built-in functions that can be called from the query language with no additional imports or setup. These built-in f..."}],["$","meta","4",{"name":"compiledAt","content":"2025-10-20T20:54:43.084Z"}],["$","meta","5",{"name":"inkeep:version","content":"core-current"}],["$","meta","6",{"name":"inkeep:docusaurus_tag","content":"core-current"}],["$","link","7",{"rel":"icon","href":"/favicon.ico","type":"image/x-icon","sizes":"16x16"}],["$","link","8",{"rel":"icon","href":"/icon.svg?ea04df7589c797b6","type":"image/svg+xml","sizes":"any"}],["$","meta","9",{"name":"next-size-adjust"}]]
1:null
2:[["$","$L2d",null,{"toc":[{"value":"Built-in functions","href":"#built-in-functions","depth":2,"numbering":[1,1],"parent":"root"},{"value":"Add Java classes to the query library","href":"#add-java-classes-to-the-query-library","depth":2,"numbering":[1,2],"parent":"root"},{"value":"Related documentation","href":"#related-documentation","depth":2,"numbering":[1,3],"parent":"root"}],"children":["$","ul",null,{"children":[["$","li",null,{"children":["$","a",null,{"href":"https://github.com/deephaven/deephaven-core/issues/new?title=Docs%20feedback%20on%20%2Fcore%2Fdocs%2Fhow-to-guides%2Fbuilt-in-functions.md","children":"Question? Give us feedback ↗"}]}],["$","li",null,{"children":["$","a",null,{"href":"https://github.com/deephaven/deephaven-core/tree/main/docs/python/how-to-guides/built-in-functions.md","children":"Edit this page on GitHub ↗"}]}],["$","li",null,{"children":["$","a",null,{"href":"#top","children":"↑ Back to top"}]}],false]}]}],["$","article",null,{"children":["$","div",null,{"className":"markdown","children":["$undefined",["$","h1",null,{"children":"Built-in query language functions"}],[["$","p",null,{"children":["Like ",["$","$Lf",null,{"href":".././built-in-constants","children":"constants"}]," and ",["$","$Lf",null,{"href":".././built-in-variables","children":"variables"}],", there are many built-in functions that can be called from the query language with no additional imports or setup. These built-in functions should be used over Python or other user-defined functions in query strings for two reasons:"]}],"\n",["$","ul",null,{"children":["\n",["$","li",null,{"children":"They are almost always more performant."}],"\n",["$","li",null,{"children":"They handle null values gracefully."}],"\n"]}],"\n",["$","p",null,{"children":["For more on why, see ",["$","$Lf",null,{"href":"../../conceptual/python-java-boundary","children":"The Python-Java boundary"}],"."]}],"\n",["$","h2",null,{"id":"built-in-functions","children":["Built-in functions",["$","$Lf",null,{"href":"#built-in-functions","aria-hidden":"true","tabIndex":"-1","children":["$","span",null,{"className":"icon icon-link"}]}]]}],"\n",["$","p",null,{"children":"Built-in functions range from simple mathematical functions to date-time arithmetic, string manipulation, and more."}],"\n",["$","p",null,{"children":["The following query calculates the absolute value of a column using the built-in ",["$","$Lf",null,{"href":"https://docs.deephaven.io/core/javadoc/io/deephaven/function/Numeric.html#abs(long)","children":["$","code",null,{"children":"abs"}]}]," function:"]}],"\n",["$","$2e",null,{"children":"$L2f"}],"\n",["$","$L30",null,{"objectsFile":"/snapshots/6954655e462bab6c8ae2d8be29e2073f.json","order":"source","path":"https://d2qmtmpk475t23.cloudfront.net/deephaven/deephaven-core/docs/main"}],"\n",["$","p",null,{"children":["The following query parses a column of strings containing integers into Java primitive ",["$","code",null,{"children":"int"}]," values using ",["$","$Lf",null,{"href":"https://docs.deephaven.io/core/javadoc/io/deephaven/function/Parse.html#parseInt(java.lang.String)","children":["$","code",null,{"children":"parseInt"}]}],":"]}],"\n",["$","$2e",null,{"children":"$L31"}],"\n",["$","$L30",null,{"objectsFile":"/snapshots/85ec239f324d43c20f27c3a12fc2abeb.json","order":"result,source","path":"https://d2qmtmpk475t23.cloudfront.net/deephaven/deephaven-core/docs/main"}],"\n",["$","p",null,{"children":["The following query uses the built-in ",["$","$Lf",null,{"href":"https://docs.deephaven.io/core/javadoc/io/deephaven/function/Logic.html#and(boolean...)","children":["$","code",null,{"children":"and"}]}]," function to evaluate whether or not three different columns are all ",["$","code",null,{"children":"true"}],":"]}],"\n",["$","$2e",null,{"children":"$L32"}],"\n",["$","$L30",null,{"objectsFile":"/snapshots/929c72b563a1703a9684a00b7563a4d6.json","order":"source,result","path":"https://d2qmtmpk475t23.cloudfront.net/deephaven/deephaven-core/docs/main"}],"\n",["$","p",null,{"children":["Built-in functions gracefully handle null values as input. For example, the following example calls the built-in ",["$","$Lf",null,{"href":"https://docs.deephaven.io/core/javadoc/io/deephaven/function/Numeric.html#sin(double)","children":["$","code",null,{"children":"sin"}]}]," function on a column that contains null values:"]}],"\n",["$","$2e",null,{"children":"$L33"}],"\n",["$","$L30",null,{"objectsFile":"/snapshots/3267b9fb9fe8130252ae28dcce076107.json","order":"source","path":"https://d2qmtmpk475t23.cloudfront.net/deephaven/deephaven-core/docs/main"}],"\n",["$","p",null,{"children":["This page does not provide a comprehensive list of all built-ins. For the complete list of functions built into the query language, see ",["$","$Lf",null,{"href":"../../reference/query-language/query-library/auto-imported-functions","children":"Auto-imported functions"}],"."]}],"\n",["$","h2",null,{"id":"add-java-classes-to-the-query-library","children":["Add Java classes to the query library",["$","$Lf",null,{"href":"#add-java-classes-to-the-query-library","aria-hidden":"true","tabIndex":"-1","children":["$","span",null,{"className":"icon icon-link"}]}]]}],"\n",["$","p",null,{"children":["To use a non-default Java class in a Deephaven Query Language (DQL) query string, you must first import the class into DQL using Python. For this, Deephaven offers the ",["$","$Lf",null,{"href":"https://docs.deephaven.io/core/pydoc/code/deephaven.query_library.html","children":["$","code",null,{"children":"query_library"}]}]," module."]}],"\n",["$","p",null,{"children":["The following example adds the ",["$","$Lf",null,{"href":"https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/net/URL.html","children":["$","code",null,{"children":"java.net.URL"}]}]," class to the query library then uses it in table operations."]}],"\n",["$","$2e",null,{"children":"$L34"}],"\n",["$","$L30",null,{"objectsFile":"/snapshots/5a9c870bcb4207436feca20cc2f79cfb.json","order":"source","path":"https://d2qmtmpk475t23.cloudfront.net/deephaven/deephaven-core/docs/main"}],"\n",["$","p",null,{"children":["You can also import static methods from a class into the query language to use them in table operations. The following example imports static methods from the ",["$","$Lf",null,{"href":"https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/StrictMath.html","children":["$","code",null,{"children":"java.lang.StrictMath"}]}]," class and uses them in table operations."]}],"\n",["$","div",null,{"className":"markdown-alert markdown-alert-note","children":[["$","p",null,{"className":"markdown-alert-title","children":[["$","svg",null,{"xmlns":"http://www.w3.org/2000/svg","width":"16","height":"16","fill":"currentColor","viewBox":"0 0 16 16","children":[["$","path",null,{"d":"M8 15A7 7 0 1 1 8 1a7 7 0 0 1 0 14m0 1A8 8 0 1 0 8 0a8 8 0 0 0 0 16"}],["$","path",null,{"d":"m8.93 6.588-2.29.287-.082.38.45.083c.294.07.352.176.288.469l-.738 3.468c-.194.897.105 1.319.808 1.319.545 0 1.178-.252 1.465-.598l.088-.416c-.2.176-.492.246-.686.246-.275 0-.375-.193-.304-.533zM9 4.5a1 1 0 1 1-2 0 1 1 0 0 1 2 0"}]]}],"Note"]}],"\n",["$","p",null,{"children":[["$","$Lf",null,{"href":"https://docs.deephaven.io/core/pydoc/code/deephaven.query_library.html#deephaven.query_library.import_static","children":["$","code",null,{"children":"import_static"}]}]," allows you to call methods without the class name. The class name is included in the examples below because methods of the same name also exist in the ",["$","$Lf",null,{"href":".././built-in-functions","children":"built-in"}]," ",["$","$Lf",null,{"href":"https://docs.deephaven.io/core/javadoc/io/deephaven/function/Numeric.html","children":["$","code",null,{"children":"io.deephaven.function.Numeric"}]}]," class."]}],"\n",["$","p",null,{"children":["In this case, you can no longer use just ",["$","code",null,{"children":"acos"}],", ",["$","code",null,{"children":"exp"}],", or any of the other method names that exist in both classes as it will be an ambiguous reference."]}],"\n"]}],"\n",["$","$2e",null,{"children":"$L35"}],"\n",["$","$L30",null,{"objectsFile":"/snapshots/30cc06f17feedb854d2dad4c9a8b22ba.json","order":"source","path":"https://d2qmtmpk475t23.cloudfront.net/deephaven/deephaven-core/docs/main"}],"\n",["$","h2",null,{"id":"related-documentation","children":["Related documentation",["$","$Lf",null,{"href":"#related-documentation","aria-hidden":"true","tabIndex":"-1","children":["$","span",null,{"className":"icon icon-link"}]}]]}],"\n",["$","ul",null,{"children":["\n",["$","li",null,{"children":["$","$Lf",null,{"href":".././query-string-overview","children":"Query string overview"}]}],"\n",["$","li",null,{"children":["$","$Lf",null,{"href":".././built-in-constants","children":"Built-in constants"}]}],"\n",["$","li",null,{"children":["$","$Lf",null,{"href":".././built-in-variables","children":"Built-in variables"}]}],"\n",["$","li",null,{"children":["$","$Lf",null,{"href":".././ternary-if-how-to","children":"Ternary conditional operator"}]}],"\n",["$","li",null,{"children":["$","$Lf",null,{"href":".././java-classes","children":"Java objects in query strings"}]}],"\n",["$","li",null,{"children":["$","$Lf",null,{"href":"../../reference/query-language/query-library/auto-imported-functions","children":"Auto-imported functions"}]}],"\n",["$","li",null,{"children":["$","$Lf",null,{"href":"../../reference/table-operations/create/emptyTable","children":["$","code",null,{"children":"empty_table"}]}]}],"\n",["$","li",null,{"children":["$","$Lf",null,{"href":"../../reference/table-operations/select/update","children":["$","code",null,{"children":"update"}]}]}],"\n"]}]]]}]}]]
36:I[5183,["5079","static/chunks/3c747828-41e9f46cc1337094.js","8218","static/chunks/aaea2bcf-3d71fa65747a4b58.js","2972","static/chunks/2972-84dca673fd243cee.js","4887","static/chunks/4887-05748514ec6f83c9.js","9783","static/chunks/9783-ee70276ef2279b23.js","2793","static/chunks/2793-1c2d2883ff508ae2.js","6423","static/chunks/6423-8ea740d3a5a09956.js","9448","static/chunks/9448-fbccb7b5a2d8a0e7.js","9475","static/chunks/9475-861f321b0ff5097d.js","6369","static/chunks/app/(docs)/%5B...slug%5D/page-fb4206ffedb59e79.js"],"default"]
37:T453,<pre class="shiki shiki-themes github-light github-dark" style="background-color:#fff;--shiki-dark-bg:#24292e;color:#24292e;--shiki-dark:#e1e4e8" tabindex="0"><code><span class="line"><span style="color:#D73A49;--shiki-dark:#F97583">from</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> deephaven </span><span style="color:#D73A49;--shiki-dark:#F97583">import</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> empty_table</span></span>
<span class="line"></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">source </span><span style="color:#D73A49;--shiki-dark:#F97583">=</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> empty_table(</span><span style="color:#005CC5;--shiki-dark:#79B8FF">10</span><span style="color:#24292E;--shiki-dark:#E1E4E8">).update([</span><span style="color:#032F62;--shiki-dark:#9ECBFF">"X = -ii"</span><span style="color:#24292E;--shiki-dark:#E1E4E8">, </span><span style="color:#032F62;--shiki-dark:#9ECBFF">"AbsX = abs(X)"</span><span style="color:#24292E;--shiki-dark:#E1E4E8">])</span></span>
<span class="line"></span></code></pre>2f:["$","div",null,{"className":"codeblock-wrapper","children":[["$","$L36",null,{"code":"from deephaven import empty_table\n\nsource = empty_table(10).update([\"X = -ii\", \"AbsX = abs(X)\"])\n"}],["$","div",null,{"className":"codeblock","data-lang":"python","dangerouslySetInnerHTML":{"__html":"$37"}}]]}]
38:Tb44,<pre class="shiki shiki-themes github-light github-dark" style="background-color:#fff;--shiki-dark-bg:#24292e;color:#24292e;--shiki-dark:#e1e4e8" tabindex="0"><code><span class="line"><span style="color:#D73A49;--shiki-dark:#F97583">from</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> deephaven </span><span style="color:#D73A49;--shiki-dark:#F97583">import</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> empty_table</span></span>
<span class="line"><span style="color:#D73A49;--shiki-dark:#F97583">from</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> random </span><span style="color:#D73A49;--shiki-dark:#F97583">import</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> choice</span></span>
<span class="line"></span>
<span class="line"></span>
<span class="line"><span style="color:#D73A49;--shiki-dark:#F97583">def</span><span style="color:#6F42C1;--shiki-dark:#B392F0"> rand_string_number</span><span style="color:#24292E;--shiki-dark:#E1E4E8">() -> </span><span style="color:#005CC5;--shiki-dark:#79B8FF">str</span><span style="color:#24292E;--shiki-dark:#E1E4E8">:</span></span>
<span class="line"><span style="color:#D73A49;--shiki-dark:#F97583">    return</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> choice([</span><span style="color:#005CC5;--shiki-dark:#79B8FF">str</span><span style="color:#24292E;--shiki-dark:#E1E4E8">(item) </span><span style="color:#D73A49;--shiki-dark:#F97583">for</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> item </span><span style="color:#D73A49;--shiki-dark:#F97583">in</span><span style="color:#005CC5;--shiki-dark:#79B8FF"> list</span><span style="color:#24292E;--shiki-dark:#E1E4E8">(</span><span style="color:#005CC5;--shiki-dark:#79B8FF">range</span><span style="color:#24292E;--shiki-dark:#E1E4E8">(</span><span style="color:#005CC5;--shiki-dark:#79B8FF">10</span><span style="color:#24292E;--shiki-dark:#E1E4E8">))])</span></span>
<span class="line"></span>
<span class="line"></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">source </span><span style="color:#D73A49;--shiki-dark:#F97583">=</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> empty_table(</span><span style="color:#005CC5;--shiki-dark:#79B8FF">10</span><span style="color:#24292E;--shiki-dark:#E1E4E8">).update(</span><span style="color:#032F62;--shiki-dark:#9ECBFF">"StringColumn = rand_string_number()"</span><span style="color:#24292E;--shiki-dark:#E1E4E8">)</span></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">result </span><span style="color:#D73A49;--shiki-dark:#F97583">=</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> source.update(</span><span style="color:#032F62;--shiki-dark:#9ECBFF">"IntegerColumn = parseInt(StringColumn)"</span><span style="color:#24292E;--shiki-dark:#E1E4E8">)</span></span>
<span class="line"></span></code></pre>31:["$","div",null,{"className":"codeblock-wrapper","children":[["$","$L36",null,{"code":"from deephaven import empty_table\nfrom random import choice\n\n\ndef rand_string_number() -> str:\n    return choice([str(item) for item in list(range(10))])\n\n\nsource = empty_table(10).update(\"StringColumn = rand_string_number()\")\nresult = source.update(\"IntegerColumn = parseInt(StringColumn)\")\n"}],["$","div",null,{"className":"codeblock","data-lang":"python","dangerouslySetInnerHTML":{"__html":"$38"}}]]}]
39:Td16,<pre class="shiki shiki-themes github-light github-dark" style="background-color:#fff;--shiki-dark-bg:#24292e;color:#24292e;--shiki-dark:#e1e4e8" tabindex="0"><code><span class="line"><span style="color:#D73A49;--shiki-dark:#F97583">from</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> deephaven </span><span style="color:#D73A49;--shiki-dark:#F97583">import</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> new_table</span></span>
<span class="line"><span style="color:#D73A49;--shiki-dark:#F97583">from</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> deephaven.column </span><span style="color:#D73A49;--shiki-dark:#F97583">import</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> bool_col</span></span>
<span class="line"></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">source </span><span style="color:#D73A49;--shiki-dark:#F97583">=</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> new_table(</span></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">    [</span></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">        bool_col(</span><span style="color:#032F62;--shiki-dark:#9ECBFF">"A"</span><span style="color:#24292E;--shiki-dark:#E1E4E8">, [</span><span style="color:#005CC5;--shiki-dark:#79B8FF">True</span><span style="color:#24292E;--shiki-dark:#E1E4E8">, </span><span style="color:#005CC5;--shiki-dark:#79B8FF">True</span><span style="color:#24292E;--shiki-dark:#E1E4E8">, </span><span style="color:#005CC5;--shiki-dark:#79B8FF">True</span><span style="color:#24292E;--shiki-dark:#E1E4E8">]),</span></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">        bool_col(</span><span style="color:#032F62;--shiki-dark:#9ECBFF">"B"</span><span style="color:#24292E;--shiki-dark:#E1E4E8">, [</span><span style="color:#005CC5;--shiki-dark:#79B8FF">True</span><span style="color:#24292E;--shiki-dark:#E1E4E8">, </span><span style="color:#005CC5;--shiki-dark:#79B8FF">True</span><span style="color:#24292E;--shiki-dark:#E1E4E8">, </span><span style="color:#005CC5;--shiki-dark:#79B8FF">False</span><span style="color:#24292E;--shiki-dark:#E1E4E8">]),</span></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">        bool_col(</span><span style="color:#032F62;--shiki-dark:#9ECBFF">"C"</span><span style="color:#24292E;--shiki-dark:#E1E4E8">, [</span><span style="color:#005CC5;--shiki-dark:#79B8FF">True</span><span style="color:#24292E;--shiki-dark:#E1E4E8">, </span><span style="color:#005CC5;--shiki-dark:#79B8FF">False</span><span style="color:#24292E;--shiki-dark:#E1E4E8">, </span><span style="color:#005CC5;--shiki-dark:#79B8FF">True</span><span style="color:#24292E;--shiki-dark:#E1E4E8">]),</span></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">    ]</span></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">)</span></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">result </span><span style="color:#D73A49;--shiki-dark:#F97583">=</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> source.update([</span><span style="color:#032F62;--shiki-dark:#9ECBFF">"IsOk = and(A, B, C)"</span><span style="color:#24292E;--shiki-dark:#E1E4E8">])</span></span>
<span class="line"></span></code></pre>32:["$","div",null,{"className":"codeblock-wrapper","children":[["$","$L36",null,{"code":"from deephaven import new_table\nfrom deephaven.column import bool_col\n\nsource = new_table(\n    [\n        bool_col(\"A\", [True, True, True]),\n        bool_col(\"B\", [True, True, False]),\n        bool_col(\"C\", [True, False, True]),\n    ]\n)\nresult = source.update([\"IsOk = and(A, B, C)\"])\n"}],["$","div",null,{"className":"codeblock","data-lang":"python","dangerouslySetInnerHTML":{"__html":"$39"}}]]}]
3a:T520,<pre class="shiki shiki-themes github-light github-dark" style="background-color:#fff;--shiki-dark-bg:#24292e;color:#24292e;--shiki-dark:#e1e4e8" tabindex="0"><code><span class="line"><span style="color:#D73A49;--shiki-dark:#F97583">from</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> deephaven </span><span style="color:#D73A49;--shiki-dark:#F97583">import</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> empty_table</span></span>
<span class="line"></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">source </span><span style="color:#D73A49;--shiki-dark:#F97583">=</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> empty_table(</span><span style="color:#005CC5;--shiki-dark:#79B8FF">40</span><span style="color:#24292E;--shiki-dark:#E1E4E8">).update(</span></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">    [</span><span style="color:#032F62;--shiki-dark:#9ECBFF">"X = (ii % 3 != 0) ? 0.1 * ii : NULL_DOUBLE"</span><span style="color:#24292E;--shiki-dark:#E1E4E8">, </span><span style="color:#032F62;--shiki-dark:#9ECBFF">"SinX = sin(X)"</span><span style="color:#24292E;--shiki-dark:#E1E4E8">]</span></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">)</span></span>
<span class="line"></span></code></pre>33:["$","div",null,{"className":"codeblock-wrapper","children":[["$","$L36",null,{"code":"from deephaven import empty_table\n\nsource = empty_table(40).update(\n    [\"X = (ii % 3 != 0) ? 0.1 * ii : NULL_DOUBLE\", \"SinX = sin(X)\"]\n)\n"}],["$","div",null,{"className":"codeblock","data-lang":"python","dangerouslySetInnerHTML":{"__html":"$3a"}}]]}]
3b:T965,<pre class="shiki shiki-themes github-light github-dark" style="background-color:#fff;--shiki-dark-bg:#24292e;color:#24292e;--shiki-dark:#e1e4e8" tabindex="0"><code><span class="line"><span style="color:#D73A49;--shiki-dark:#F97583">from</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> deephaven </span><span style="color:#D73A49;--shiki-dark:#F97583">import</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> empty_table</span></span>
<span class="line"><span style="color:#D73A49;--shiki-dark:#F97583">from</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> deephaven </span><span style="color:#D73A49;--shiki-dark:#F97583">import</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> query_library</span></span>
<span class="line"></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">query_library.import_class(</span><span style="color:#032F62;--shiki-dark:#9ECBFF">"java.net.URL"</span><span style="color:#24292E;--shiki-dark:#E1E4E8">)</span></span>
<span class="line"></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">source </span><span style="color:#D73A49;--shiki-dark:#F97583">=</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> empty_table(</span><span style="color:#005CC5;--shiki-dark:#79B8FF">1</span><span style="color:#24292E;--shiki-dark:#E1E4E8">).update(</span></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">    [</span></span>
<span class="line"><span style="color:#032F62;--shiki-dark:#9ECBFF">        "DeephavenUrl = new URL(`https://deephaven.io/`)"</span><span style="color:#24292E;--shiki-dark:#E1E4E8">,</span></span>
<span class="line"><span style="color:#032F62;--shiki-dark:#9ECBFF">        "Protocol = DeephavenUrl.getProtocol()"</span><span style="color:#24292E;--shiki-dark:#E1E4E8">,</span></span>
<span class="line"><span style="color:#032F62;--shiki-dark:#9ECBFF">        "Host = DeephavenUrl.getHost()"</span><span style="color:#24292E;--shiki-dark:#E1E4E8">,</span></span>
<span class="line"><span style="color:#032F62;--shiki-dark:#9ECBFF">        "Path = DeephavenUrl.getPath()"</span><span style="color:#24292E;--shiki-dark:#E1E4E8">,</span></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">    ]</span></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">)</span></span>
<span class="line"></span></code></pre>34:["$","div",null,{"className":"codeblock-wrapper","children":[["$","$L36",null,{"code":"from deephaven import empty_table\nfrom deephaven import query_library\n\nquery_library.import_class(\"java.net.URL\")\n\nsource = empty_table(1).update(\n    [\n        \"DeephavenUrl = new URL(`https://deephaven.io/`)\",\n        \"Protocol = DeephavenUrl.getProtocol()\",\n        \"Host = DeephavenUrl.getHost()\",\n        \"Path = DeephavenUrl.getPath()\",\n    ]\n)\n"}],["$","div",null,{"className":"codeblock","data-lang":"python","dangerouslySetInnerHTML":{"__html":"$3b"}}]]}]
3c:T968,<pre class="shiki shiki-themes github-light github-dark" style="background-color:#fff;--shiki-dark-bg:#24292e;color:#24292e;--shiki-dark:#e1e4e8" tabindex="0"><code><span class="line"><span style="color:#D73A49;--shiki-dark:#F97583">from</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> deephaven </span><span style="color:#D73A49;--shiki-dark:#F97583">import</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> empty_table</span></span>
<span class="line"><span style="color:#D73A49;--shiki-dark:#F97583">from</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> deephaven </span><span style="color:#D73A49;--shiki-dark:#F97583">import</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> query_library</span></span>
<span class="line"></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">query_library.import_static(</span><span style="color:#032F62;--shiki-dark:#9ECBFF">"java.lang.StrictMath"</span><span style="color:#24292E;--shiki-dark:#E1E4E8">)</span></span>
<span class="line"></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">source </span><span style="color:#D73A49;--shiki-dark:#F97583">=</span><span style="color:#24292E;--shiki-dark:#E1E4E8"> empty_table(</span><span style="color:#005CC5;--shiki-dark:#79B8FF">10</span><span style="color:#24292E;--shiki-dark:#E1E4E8">).update(</span></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">    [</span></span>
<span class="line"><span style="color:#032F62;--shiki-dark:#9ECBFF">        "X = randomDouble(-1.67, 1.67)"</span><span style="color:#24292E;--shiki-dark:#E1E4E8">,</span></span>
<span class="line"><span style="color:#032F62;--shiki-dark:#9ECBFF">        "AcosX = StrictMath.acos(X)"</span><span style="color:#24292E;--shiki-dark:#E1E4E8">,</span></span>
<span class="line"><span style="color:#032F62;--shiki-dark:#9ECBFF">        "ExpX = io.deephaven.function.Numeric.exp(X)"</span><span style="color:#24292E;--shiki-dark:#E1E4E8">,</span></span>
<span class="line"><span style="color:#032F62;--shiki-dark:#9ECBFF">        "ExponentX = StrictMath.getExponent(X)"</span><span style="color:#24292E;--shiki-dark:#E1E4E8">,</span></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">    ]</span></span>
<span class="line"><span style="color:#24292E;--shiki-dark:#E1E4E8">)</span></span>
<span class="line"></span></code></pre>35:["$","div",null,{"className":"codeblock-wrapper","children":[["$","$L36",null,{"code":"from deephaven import empty_table\nfrom deephaven import query_library\n\nquery_library.import_static(\"java.lang.StrictMath\")\n\nsource = empty_table(10).update(\n    [\n        \"X = randomDouble(-1.67, 1.67)\",\n        \"AcosX = StrictMath.acos(X)\",\n        \"ExpX = io.deephaven.function.Numeric.exp(X)\",\n        \"ExponentX = StrictMath.getExponent(X)\",\n    ]\n)\n"}],["$","div",null,{"className":"codeblock","data-lang":"python","dangerouslySetInnerHTML":{"__html":"$3c"}}]]}]