CINXE.COM
Multi Stage Query Engine | StarTree
<!DOCTYPE html><html lang="en"><head><meta charSet="utf-8"/><title>Multi Stage Query Engine | StarTree</title><meta name="robots" content="index,follow"/><meta name="description" content="Run complex SQL queries without sacrificing blazing-fast query performance, gaining the business insights your teams need in real-time."/><meta property="og:title" content="Multi Stage Query Engine | StarTree"/><meta property="og:description" content="Run complex SQL queries without sacrificing blazing-fast query performance, gaining the business insights your teams need in real-time."/><meta property="og:url" content="https://startree.ai/products/multi-stage-query-engine"/><meta property="og:image" content="https://startreecms.wpenginepowered.com/wp-content/uploads/2024/08/Open-Graph.jpg"/><link rel="canonical" href="https://startree.ai/products/multi-stage-query-engine"/><meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"/><link rel="apple-touch-icon" sizes="180x180" href="/favicon/apple-touch-icon.png"/><link rel="icon" type="image/png" sizes="32x32" href="/favicon/favicon-32x32.png"/><link rel="icon" type="image/png" sizes="16x16" href="/favicon/favicon-16x16.png"/><link rel="manifest" href="/favicon/site.webmanifest"/><link rel="mask-icon" href="/favicon/safari-pinned-tab.svg" color="#5bbad5"/><meta name="msapplication-TileColor" content="#ffffff"/><meta name="theme-color" content="#ffffff"/><meta name="twitter:card" content="summary"/><meta name="next-head-count" content="18"/><link rel="preload" href="/_next/static/media/f7040064460a9b21-s.p.woff2" as="font" type="font/woff2" crossorigin="anonymous" data-next-font="size-adjust"/><link rel="preload" href="/_next/static/media/122c360d7fe6d395-s.p.woff2" as="font" type="font/woff2" crossorigin="anonymous" data-next-font="size-adjust"/><link rel="preload" href="/_next/static/css/bc63c7c42c15cc71.css" as="style"/><link rel="stylesheet" href="/_next/static/css/bc63c7c42c15cc71.css" data-n-g=""/><link rel="preload" href="/_next/static/css/25cae41c71aa3ee0.css" as="style"/><link rel="stylesheet" href="/_next/static/css/25cae41c71aa3ee0.css" data-n-p=""/><noscript data-n-css=""></noscript><script defer="" nomodule="" src="/_next/static/chunks/polyfills-78c92fac7aa8fdd8.js"></script><script id="brightEdge" src="//cdn.bc0a.com/autopilot/f00000000304780/autopilot_sdk.js" data-cfasync="false" defer="" data-nscript="beforeInteractive"></script><script defer="" src="/_next/static/chunks/114.c67adae6ed23d0f1.js"></script><script defer="" src="/_next/static/chunks/442.2c3608a8ab0d9442.js"></script><script src="/_next/static/chunks/webpack-7f5c6789c515ac4f.js" defer=""></script><script src="/_next/static/chunks/framework-9620da855a94eb57.js" defer=""></script><script src="/_next/static/chunks/main-4c5a65bf32bd6706.js" defer=""></script><script src="/_next/static/chunks/pages/_app-af3bd3ce1347445d.js" defer=""></script><script src="/_next/static/chunks/31d4e3d1-0a655c6d6ff6e9de.js" defer=""></script><script src="/_next/static/chunks/9e82d048-ffb998b39e497a2e.js" defer=""></script><script src="/_next/static/chunks/854-338aa8ccdafb1663.js" defer=""></script><script src="/_next/static/chunks/927-252a7a71f883e286.js" defer=""></script><script src="/_next/static/chunks/463-f9292cf30fcf41ef.js" defer=""></script><script src="/_next/static/chunks/399-7a231d8f7c5f17a1.js" defer=""></script><script src="/_next/static/chunks/78-432c7488e888c80f.js" defer=""></script><script src="/_next/static/chunks/pages/%5B...slug%5D-b6cc7d45f8a3bac1.js" defer=""></script><script src="/_next/static/KP-lAfE2gKozH6Xb-rQVr/_buildManifest.js" defer=""></script><script src="/_next/static/KP-lAfE2gKozH6Xb-rQVr/_ssgManifest.js" defer=""></script><style id="__jsx-3450457828">:root{--font-mulish:'__Mulish_1ed915', '__Mulish_Fallback_1ed915';--font-fira:'__Fira_Code_74c79e', '__Fira_Code_Fallback_74c79e'}</style></head><body class="font-body"><div id="__next"><header class="fixed inset-x-0 top-0 z-50 h-[60px] w-full bg-indigo transition-all duration-300 lg:h-[89px] bg-transparent"><div class="header-container h-full"><div class="flex h-full items-center justify-between gap-4"><div class="z-50 flex items-center gap-[71px]"><div class="relative z-50 w-[100px] cursor-pointer lg:w-[118px]"><a aria-label="Back to Home" class="nav-logo transition-colors text-indigo" href="/"><svg width="100%" height="100%" viewBox="0 0 119 21" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M12.65 15.607c0 3.3-2.893 4.893-6.186 4.893-3.078 0-5.357-1.286-6.464-3.64l3.446-1.928c.433 1.257 1.479 1.99 3.018 1.99 1.265 0 2.122-.43 2.122-1.315 0-2.236-7.94-1.01-7.94-6.393 0-3.118 2.679-4.86 5.847-4.86 2.5 0 4.643 1.128 5.846 3.239L8.954 9.429a2.607 2.607 0 0 0-2.465-1.561c-.982 0-1.785.428-1.785 1.257 0 2.26 7.942.854 7.942 6.482M36.785 12.425c0-2.568-1.817-4.31-4.285-4.31s-4.247 1.742-4.247 4.31c0 2.568 1.815 4.311 4.247 4.311s4.285-1.74 4.285-4.31Zm3.972-7.643v15.29h-3.971V18.26c-1.108 1.375-2.772 2.232-5.018 2.232-4.093 0-7.479-3.518-7.479-8.075 0-4.557 3.386-8.071 7.479-8.071 2.246 0 3.91.853 5.017 2.232V4.775l3.972.007ZM51.615 4.475v4.403c-2.06-.243-4.679.675-4.679 3.886v7.307h-3.971V4.781h3.971v2.63c.8-2.08 2.74-2.936 4.679-2.936ZM71.369 8.571v6.361c0 1.654 1.2 1.682 3.475 1.56v3.572c-5.572.611-7.45-1.007-7.45-5.135V8.564h-2.675V4.775h2.675V.489h3.975v4.286h3.475v3.79h-3.475M85.146 4.475v4.403c-2.06-.243-4.675.675-4.675 3.886v7.307H76.5V4.781h3.971v2.63c.797-2.08 2.736-2.936 4.675-2.936ZM97.61 10.99a3.732 3.732 0 0 0-3.817-3.086c-2.121 0-3.571 1.132-4.032 3.09h7.857m-3.45 5.931a4.286 4.286 0 0 0 3.45-1.528l3.214 1.832c-1.428 2.082-3.753 3.275-6.71 3.275-5.168 0-8.433-3.518-8.433-8.075 0-4.557 3.293-8.072 8.126-8.072 4.557 0 7.785 3.572 7.785 8.072a8.821 8.821 0 0 1-.153 1.621H89.822c.553 2.015 2.25 2.872 4.339 2.872l.007.003ZM114.603 10.99a3.733 3.733 0 0 0-3.818-3.086c-2.125 0-3.571 1.132-4.032 3.09h7.857m-3.45 5.931a4.284 4.284 0 0 0 3.45-1.528l3.214 1.832c-1.446 2.082-3.757 3.275-6.71 3.275-5.172 0-8.432-3.518-8.432-8.075 0-4.557 3.292-8.072 8.125-8.072 4.553 0 7.785 3.572 7.785 8.072a8.821 8.821 0 0 1-.153 1.621h-11.625c.557 2.015 2.246 2.872 4.339 2.872l.007.003ZM20.043 8.571v6.361c0 1.654 1.2 1.682 3.479 1.56v3.572c-5.572.611-7.45-1.007-7.45-5.135V8.564h-2.675V4.775h2.675V.489h3.97v4.286h3.48v3.79h-3.48M63.114 10.857h-4.596V4.643a.282.282 0 0 0-.06-.175.304.304 0 0 0-.154-.103.268.268 0 0 0-.183 0 .275.275 0 0 0-.142.117l-5.415 8.958a.333.333 0 0 0-.042.142.297.297 0 0 0 .143.254.311.311 0 0 0 .146.04h4.6v6.217a.286.286 0 0 0 .21.279c.06.018.123.018.183 0a.293.293 0 0 0 .142-.118l5.411-8.957a.26.26 0 0 0 .043-.147.282.282 0 0 0-.143-.25.26.26 0 0 0-.146-.043" fill="currentColor"></path></svg></a></div><nav class="flex items-center gap-8 max-lg:hidden"><a class="nav-link z-50 relative text-indigo" aria-label="Platform" href="/products/startree-cloud"><span style="will-change:opacity">Platform</span></a><button type="button" class="nav-link z-50 relative text-indigo" aria-label="Solutions"><span style="will-change:opacity">Solutions</span></button><a class="nav-link z-50 relative text-indigo" aria-label="For Developers" href="https://dev.startree.ai/"><span style="will-change:opacity">For Developers</span></a><a class="nav-link z-50 relative text-indigo" aria-label="Resources" href="/resources"><span style="will-change:opacity">Resources</span></a><a class="nav-link z-50 relative text-indigo" href="/partners"><span style="will-change:opacity">Partners</span></a><a class="nav-link z-50 relative text-indigo" href="/pricing"><span style="will-change:opacity">Pricing</span></a><div class="pointer-events-none absolute inset-0 h-screen min-w-full backdrop-blur-xl" style="opacity:0;will-change:opacity"></div><div class="absolute inset-x-0 top-0 z-30 min-w-full origin-top overflow-hidden rounded-[3px] bg-white pt-[89px]" style="pointer-events:none;opacity:0;will-change:opacity"><div class="min-h-[250px]"></div></div></nav></div><div class="flex gap-2"><div class="flex items-center gap-x-6"><a class="nav-button text-[15px] font-medium leading-[1.1] tracking-[-0.15px] transition-colors text-indigo hover:text-ocean" href="/search"><svg class="w-[14px]" aria-hidden="true" xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 14 14"><path d="M6.125 10.5a4.375 4.375 0 1 0 0-8.75 4.375 4.375 0 0 0 0 8.75ZM9.219 9.219l3.031 3.031" stroke="currentColor"></path></svg></a><a class="nav-button text-[15px] font-medium leading-[1.1] tracking-[-0.15px] transition-colors max-xl:hidden text-indigo hover:text-ocean" target="_blank" href="https://startree.cloud/login">Login</a><a class="gradient-border-mask nav-button text-indigo" href="/saas-signup">Start for free</a><a class="nav-button text-[15px] font-medium leading-[1.1] tracking-[-0.15px] transition-colors max-xl:hidden text-indigo hover:text-ocean" href="/demo">Book a demo</a></div><div class="-mr-[15px] lg:hidden" role="button" tabindex="0"><div class="hamburger-react" aria-label="Show menu" aria-expanded="false" role="button" style="cursor:pointer;height:48px;position:relative;transition:0.4s cubic-bezier(0, 0, 0, 1);user-select:none;width:48px;outline:none" tabindex="0"><div style="background:#001e43;height:2px;left:15px;position:absolute;width:18px;top:17px;transition:0.4s cubic-bezier(0, 0, 0, 1);transform:none"></div><div style="background:#001e43;height:2px;left:15px;position:absolute;width:18px;top:23px;transition:0.2s cubic-bezier(0, 0, 0, 1);transform:none"></div><div style="background:#001e43;height:2px;left:15px;position:absolute;width:18px;top:29px;transition:0.4s cubic-bezier(0, 0, 0, 1);transform:none"></div></div></div></div></div></div></header><main class=""><section id="" class="relative isolate overflow-hidden_ overflow-clip bg-sky"><div class="pt-[60px] lg:pt-[89px] container"><div><div aria-hidden="true" class="pointer-events-none absolute rounded-full top-[-1430px] left-[-1100px] size-[2000px] md:size-[2117px]" style="background:radial-gradient(47.38% 47.38% at 50% 42.81%, #F94F8D 0%, rgba(233,244,252,0.02) 75.48%, rgba(233,248,255,0.00) 92.49%)"></div><div aria-hidden="true" class="pointer-events-none absolute rounded-full bottom-[-2000px] right-[-3120px] size-[3750px] lg:size-[4309px]" style="background:radial-gradient(47.38% 47.38% at 50% 42.81%, #21C6DC 8.43%, rgba(233, 248, 255, 0.00) 92.49%)"></div><div class="relative isolate overflow-hidden pb-12 lg:pb-[120px]"><div class="container pt-6 md:pt-[72px] md:grid md:grid-cols-2 md:items-center md:gap-6"><div class=""><div class="flex w-full flex-col text-center md:text-left"><h6 class="text-label-l mb-2.5 w-full text-ocean md:mb-4">Multi-Stage Query Engine</h6><h1 class="w-full text-h1 md:w-full text-indigo mb-3 md:mb-6">Analyze your data at your speed</h1><div class="prose w-full max-md:text-balance text-18 md:max-w-lg text-ocean"><p>Run complex SQL queries without sacrificing blazing-fast query performance, gaining the business insights your teams need in real-time.</p> </div><div class="flex w-auto items-center gap-[18px] md:gap-6 mt-[22px] justify-center md:justify-start md:mt-11"><a target="" class="hero-button w-auto " href="/demo"><div class="text-center rounded-full focus-visible:outline focus-visible:outline-2 focus-visible:outline-offset-2 focus-visible:outline-white px-[25px] relative overflow-hidden group isolate overflow-hidden w-auto py-3 md:px-8 md:py-4 text-link-m bg-turmeric text-indigo" type="button" text="[object Object]"><div>Book a demo</div><div class="absolute -z-10 size-[98px] bg-[radial-gradient(50%_50%_at_50%_50%,_#FFFFFF_0%,_rgba(233,248,255,0.00)_100%)] opacity-0 transition-[opacity,transform] group-hover:opacity-100" style="left:0px;top:0px"><div class="absolute inset-0 m-auto size-14 bg-[radial-gradient(50%_50%_at_50%_50%,_#A6E8F1_0%,_rgba(233,248,255,0.00)_100%)]"></div></div></div></a><a target="" class="hero-button w-auto " href="/saas-signup"><div class="text-link-m group flex items-center gap-2 w-auto text-indigo">Start for free<span aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" fill="none" class="w-2.5 translate-x-0 transition-transform ease-[0.76,0,0.24,1] group-hover:translate-x-1.5 text-indigo" viewBox="0 0 12 12"><path d="M1 6h10.125M6.625 1.5l4.5 4.5-4.5 4.5" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round"></path></svg></span></div></a></div></div></div><div class="relative w-full max-sm:mx-auto md:ml-auto md:mt-0 mt-14"><img alt="Multi Stage Query Engine" loading="lazy" width="464" height="460" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 max-lg:w-full max-sm:mx-auto max-sm:w-[80%] md:ml-auto" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FMulti-stage-query-engine.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FMulti-stage-query-engine.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FMulti-stage-query-engine.svg&w=1080&q=75"/></div></div></div></div></div></section><section id="" class="relative isolate overflow-hidden_ overflow-clip bg-indigo-900 pt-12 lg:pt-[120px] pb-12 lg:pb-[120px]"><div class="space-y-8 md:space-y-20 container"><div class=""><div class="flex w-full flex-col text-center md:text-left"><h2 class="w-full text-h3 md:max-w-2xl text-white">Deliver fast and accurate insights across large datasets</h2></div></div><div><div class="grid gap-5 md:grid-cols-2 lg:grid-cols-3 lg:gap-6"><div class="relative isolate flex min-h-[180px] flex-col items-start justify-between gap-10 overflow-hidden rounded-lg p-5 ring-1 md:min-h-[240px] lg:min-h-[280px] lg:p-6 bg-indigo xl:min-h-[380px] ring-white/[0.03]"><img alt="Fastest Performance Yellow" loading="lazy" width="128" height="128" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 h-10 w-auto md:h-12 xl:h-16" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Ffastest-performance-yellow.png&w=128&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Ffastest-performance-yellow.png&w=256&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Ffastest-performance-yellow.png&w=256&q=75"/><div><h3 class="text-22 text-balance !font-semibold !leading-[1.2] text-sky">Improve query performance</h3></div></div><div class="relative isolate flex min-h-[180px] flex-col items-start justify-between gap-10 overflow-hidden rounded-lg p-5 ring-1 md:min-h-[240px] lg:min-h-[280px] lg:p-6 bg-indigo xl:min-h-[380px] ring-white/[0.03]"><img alt="64x64 Cost Icon Purple V1" loading="lazy" width="128" height="128" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 h-10 w-auto md:h-12 xl:h-16" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2F64x64-cost-icon_purple-v1.png&w=128&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2F64x64-cost-icon_purple-v1.png&w=256&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2F64x64-cost-icon_purple-v1.png&w=256&q=75"/><div><h3 class="text-22 text-balance !font-semibold !leading-[1.2] text-sky">Allocate resources more effectively without increasing costs</h3></div></div><div class="relative isolate flex min-h-[180px] flex-col items-start justify-between gap-10 overflow-hidden rounded-lg p-5 ring-1 md:min-h-[240px] lg:min-h-[280px] lg:p-6 bg-indigo xl:min-h-[380px] ring-white/[0.03]"><img alt="64x64 Scalability Icon Blue V1" loading="lazy" width="128" height="128" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 h-10 w-auto md:h-12 xl:h-16" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2F64x64-scalability-icon_blue-v1.png&w=128&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2F64x64-scalability-icon_blue-v1.png&w=256&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2F64x64-scalability-icon_blue-v1.png&w=256&q=75"/><div><h3 class="text-22 text-balance !font-semibold !leading-[1.2] text-sky">Scale to handle increased data volumes and query complexity</h3></div></div></div></div></div></section><section id="" class="relative isolate overflow-visible bg-white pt-12 lg:pt-[120px] pb-[28px] md:pb-12 lg:pb-20"><div class="space-y-8 md:space-y-20 container"><div class=""><div class="flex w-full flex-col text-center md:text-left"><h2 class="w-full text-h2 md:custom text-indigo mb-3 md:mb-6" style="max-width:700px">Run complex queries with native query-time joins</h2><div class="prose w-full max-md:text-balance text-18 md:custom text-indigo-600" style="max-width:460px"><p>Unlock timely and accurate insights from your data in motion and power your real-time analytics application.</p> </div></div></div><div class="grid gap-6 lg:grid-cols-4 lg:pt-10"><nav class="max-lg:hidden lg:sticky lg:top-40 lg:space-y-[26px] lg:self-start"><a href="#joins-support" class="text-label-s flex text-left transition-colors text-indigo">Joins Support</a><a href="#multi-stage-execution-model" class="text-label-s flex text-left transition-colors text-ocean">Multi-Stage Execution Model</a><a href="#indexing-and-pruning" class="text-label-s flex text-left transition-colors text-ocean">Indexing and Pruning</a><a href="#data-layout" class="text-label-s flex text-left transition-colors text-ocean">Data Layout</a></nav><div class="space-y-[27px] lg:col-span-3"><div class="relative isolate flex items-stretch justify-between overflow-hidden rounded-lg bg-sky-25 max-md:flex-col-reverse md:rounded-xl" id="joins-support"><div class="flex flex-1 flex-col justify-between gap-6 p-6 pt-0 md:pt-6 xl:px-10 xl:py-12"><div class="max-w-[365px]_ w-full md:max-w-[331px]"><h4 class="text-h4 text-indigo">Joins Support</h4><div class="text-18 mt-2.5 text-ocean md:mt-4"><p>Optimize query performance and the execution of joins at scale with native support for serving joins with subseconds latency. The Multi-Stage Query Engine supports all three types of join strategies: Broadcast Joins, Shuffle Hash Distributed Joins, and Lookup Joins. With this capability, StarTree covers the entire spectrum of data joins, providing full coverage from user-facing analytics all the way up to ad hoc analytics.</p> </div></div></div><img alt="Query Feature Joins V1" loading="lazy" width="464" height="460" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 relative aspect-[464/300] w-[60%] max-w-[464px] shrink-0 max-md:mx-auto max-sm:mb-4 lg:w-full" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Fquery-feature_joins-v1.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Fquery-feature_joins-v1.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Fquery-feature_joins-v1.svg&w=1080&q=75"/><div aria-hidden="true" class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] left-[-577px] top-[-660px] bg-[radial-gradient(50%_50%_at_50%_50%,_#37D992_0%,_rgba(242,251,255,0.00)_100%)]"></div><div class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] bottom-[-730px] right-[-697px] bg-[radial-gradient(50%_50%_at_50%_50%,_#21C6DC_0%,_rgba(242,251,255,0.00)_100%)]"></div></div><div class="relative isolate flex items-stretch justify-between overflow-hidden rounded-lg bg-sky-25 max-md:flex-col-reverse md:rounded-xl" id="multi-stage-execution-model"><div class="flex flex-1 flex-col justify-between gap-6 p-6 pt-0 md:pt-6 xl:px-10 xl:py-12"><div class="max-w-[365px]_ w-full md:max-w-[331px]"><h4 class="text-h4 text-indigo">Multi-Stage Execution Model</h4><div class="text-18 mt-2.5 text-ocean md:mt-4"><p>The multi-stage execution model is designed to handle complex multi-stage data processing. It includes an intermediate compute stage (consisting of a set of processing servers and a data exchange mechanism) that allows StarTree to handle more complex processing requirements by offloading computation from the brokers.</p> </div></div></div><img alt="Multi Stage Query Engine" loading="lazy" width="464" height="460" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 relative aspect-[464/300] w-[60%] max-w-[464px] shrink-0 max-md:mx-auto max-sm:mb-4 lg:w-full" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FMulti-stage-query-engine.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FMulti-stage-query-engine.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FMulti-stage-query-engine.svg&w=1080&q=75"/><div aria-hidden="true" class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] bottom-[-645px] left-[-803px] bg-[radial-gradient(50%_50%_at_50%_50%,_#37D992_0%,_rgba(242,251,255,0.00)_100%)]"></div><div class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] right-[-739px] top-[-408px] -rotate-12 bg-[radial-gradient(50%_50%_at_50%_50%,_#48809F_0%,_rgba(242,251,255,0.00)_100%)]"></div></div><div class="relative isolate flex items-stretch justify-between overflow-hidden rounded-lg bg-sky-25 max-md:flex-col-reverse md:rounded-xl" id="indexing-and-pruning"><div class="flex flex-1 flex-col justify-between gap-6 p-6 pt-0 md:pt-6 xl:px-10 xl:py-12"><div class="max-w-[365px]_ w-full md:max-w-[331px]"><h4 class="text-h4 text-indigo">Indexing and Pruning</h4><div class="text-18 mt-2.5 text-ocean md:mt-4"><p>StarTree offers a rich set of indexing and pruning techniques to speed up query processing on individual tables. These techniques help reduce the overhead of scanning and aggregations to improve query latency and throughput.</p> </div></div></div><img alt="Query Feature Indexing V1" loading="lazy" width="464" height="400" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 relative aspect-[464/300] w-[60%] max-w-[464px] shrink-0 max-md:mx-auto max-sm:mb-4 lg:w-full" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Fquery-feature_indexing-v1.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Fquery-feature_indexing-v1.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Fquery-feature_indexing-v1.svg&w=1080&q=75"/><div aria-hidden="true" class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] bottom-[-730px] right-[-697px] -rotate-12 bg-[radial-gradient(50%_50%_at_50%_50%,_#6F42C1_0%,_rgba(242,251,255,0.00)_100%)]"></div><div class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px]"></div></div><div class="relative isolate flex items-stretch justify-between overflow-hidden rounded-lg bg-sky-25 max-md:flex-col-reverse md:rounded-xl" id="data-layout"><div class="flex flex-1 flex-col justify-between gap-6 p-6 pt-0 md:pt-6 xl:px-10 xl:py-12"><div class="max-w-[365px]_ w-full md:max-w-[331px]"><h4 class="text-h4 text-indigo">Data Layout</h4><div class="text-18 mt-2.5 text-ocean md:mt-4"><p>Improve join performance by adapting based on the data layout. StarTree optimizes joins to account for data that is partitioned but not co-located, data that is partitioned and co-located, and random layouts (data is neither partitioned nor co-located).</p> </div></div></div><img alt="Query Feature Layout V1" loading="lazy" width="464" height="300" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 relative aspect-[464/300] w-[60%] max-w-[464px] shrink-0 max-md:mx-auto max-sm:mb-4 lg:w-full" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Fquery-feature_layout-v1.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Fquery-feature_layout-v1.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Fquery-feature_layout-v1.svg&w=1080&q=75"/><div aria-hidden="true" class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] bottom-[-645px] left-[-803px] bg-[radial-gradient(50%_50%_at_50%_50%,_#F94F8D_0%,_rgba(242,251,255,0.00)_100%)]"></div><div class="pointer-events-none absolute -z-10 h-[850px] w-[1100px] rounded-full opacity-80 xl:h-[1000px] xl:w-[1250px] right-[-739px] top-[-408px] -rotate-12 bg-[radial-gradient(50%_50%_at_50%_50%,_#07ACC2_0%,_rgba(242,251,255,0.00)_100%)]"></div></div></div></div></div></section><section id="" class="relative isolate overflow-hidden_ overflow-clip bg-white pt-[28px] md:pt-12 lg:pt-20 pb-[28px] md:pb-12 lg:pb-20"><div class="space-y-8 md:space-y-20 container"><div class=""><div class="relative isolate overflow-hidden rounded-lg bg-indigo-900 py-14 md:rounded-xl md:py-[104px]"><div class="mx-md:text-balance mx-auto max-w-2xl md:max-w-[721px]" style="opacity:0;will-change:opacity"><div style="opacity:0;will-change:opacity,transform;transform:translateY(-10px)"><img alt="Stripe Logo White" loading="lazy" width="360" height="150" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 mx-auto h-6" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Fstripe_logo-white.svg&w=384&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Fstripe_logo-white.svg&w=750&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2Fstripe_logo-white.svg&w=750&q=75"/></div><figure class="mt-10 md:mt-12"><blockquote class="text-28 text-center text-sky max-lg:px-3" style="opacity:0;will-change:opacity,transform;transform:translateY(-10px)"><div><p>“We migrated our old time series aggregation system from a different framework to Apache Pinot. With Pinot, we can ingest an entire stream of data and send multiple queries at it, and it will be equally performant. This offers a lot of flexibility — it allows us to lower the cost of operating, and opens up real-time analytics to folks that weren’t Scala experts but know how to write SQL queries.”</p> </div></blockquote><figcaption class="mt-10 flex items-center justify-center gap-x-5 md:mt-12"><div class="size-12 overflow-hidden rounded-full bg-sky-25 md:size-16" style="opacity:0;will-change:opacity"><img alt="Johan Adami Stripe" loading="lazy" width="250" height="250" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 undefined" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2FJohan-Adami-Stripe.png&w=256&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2FJohan-Adami-Stripe.png&w=640&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2FJohan-Adami-Stripe.png&w=640&q=75"/></div><div><div class="text-h8 text-white" style="opacity:0;will-change:opacity,transform;transform:translateY(-10px)">Johan Adami</div><div class="text-16 mt-px text-sky-200" style="opacity:0;will-change:opacity,transform;transform:translateY(-10px)">Software Engineer</div></div></figcaption></figure></div><div aria-hidden="true" class="pointer-events-none absolute bottom-[-900px] left-[-50%] -z-10 size-[1950px] rounded-full bg-[radial-gradient(50%_50%_at_50%_50%,_#21C6DC_0%,_rgba(20,92,132,0.00)_100%)] opacity-70 md:bottom-[-1492px] md:left-[-30%]"></div></div></div></div></section><section id="" class="relative isolate overflow-hidden_ overflow-clip bg-white pt-[28px] md:pt-12 lg:pt-20 pb-12 lg:pb-[120px]"><div class="space-y-8 md:space-y-20 container"><div class=""><div class="flex w-full flex-col text-center md:text-left"><h6 class="text-label-l mb-2.5 w-full text-ocean md:mb-4">keep exploring</h6><h2 class="w-full text-h2 md:max-w-2xl text-indigo">The most powerful real-time analytics platform</h2></div></div><div class="grid gap-5 md:grid-cols-2 lg:grid-cols-12 lg:gap-6"><a class="aspect-[2/1]_ group relative isolate flex flex-col overflow-hidden rounded-lg bg-sky p-5 md:justify-between lg:rounded-xl lg:p-8 lg:even:flex-col-reverse lg:aspect-[690/490]_ lg:col-span-7 group" href="/products/tiered-storage"><svg class="absolute right-8 top-8 w-[14px] opacity-0 transition-opacity group-hover:opacity-100" xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 14 13"><path stroke="#00152E" stroke-linecap="round" stroke-width="1.32" d="M1 6.4h12.15"></path><path stroke="#00152E" stroke-linecap="round" stroke-linejoin="round" stroke-width="1.32" d="m7.75 1 5.4 5.4-5.4 5.4"></path></svg><div><h3 class="text-h4 text-balancex text-indigo">Simplified tiered storage</h3><div class="text-18 mt-2.5 text-ocean max-lg:text-balance md:mt-4 lg:max-w-[540px]">Analyze all your data, new and historical, without slowing down queries or blowing your budget. StarTree automatically stores the data you access most often for super-fast results.</div></div><img alt="Tiered Storage Horizontal V1" loading="lazy" width="626" height="236" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 undefined" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Ftiered_storage-horizontal-v1.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Ftiered_storage-horizontal-v1.svg&w=1920&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F09%2Ftiered_storage-horizontal-v1.svg&w=1920&q=75"/><div aria-hidden="true" class="pointer-events-none absolute -z-10 rounded-full left-[-889px] top-[-1400px] aspect-1 size-[1778px] bg-[radial-gradient(50%_50%_at_50%_50%,_#37D992_0%,_rgba(233,248,255,0.00)_100%)]"></div><div aria-hidden="true" class="pointer-events-none -z-10 scale-90 absolute bottom-[-1400px] right-[-1006px] aspect-1 size-[1778px] bg-[radial-gradient(50%_50%_at_50%_50%,_#21C6DC_0%,_rgba(233,248,255,0.00)_100%)]"></div></a><a class="aspect-[2/1]_ group relative isolate flex flex-col overflow-hidden rounded-lg bg-sky p-5 md:justify-between lg:rounded-xl lg:p-8 lg:even:flex-col-reverse lg:aspect-[486/490]_ lg:col-span-5 group" href="/products/indexing"><svg class="absolute right-8 top-8 w-[14px] opacity-0 transition-opacity group-hover:opacity-100" xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 14 13"><path stroke="#00152E" stroke-linecap="round" stroke-width="1.32" d="M1 6.4h12.15"></path><path stroke="#00152E" stroke-linecap="round" stroke-linejoin="round" stroke-width="1.32" d="m7.75 1 5.4 5.4-5.4 5.4"></path></svg><div><h3 class="text-h4 text-balancex text-indigo">Powerful, flexible indexing</h3><div class="text-18 mt-2.5 text-ocean max-lg:text-balance md:mt-4">Harness extensive indexing to analyze your data, any way you want. Unlike other techniques which work on a single column, the star-tree index is built on multiple columns, using pre-aggregated results.</div></div><img alt="Simplified Tiered Storage 1" loading="lazy" width="968" height="532" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 undefined" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FSimplified-Tiered-Storage-1.png&w=1080&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FSimplified-Tiered-Storage-1.png&w=2048&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FSimplified-Tiered-Storage-1.png&w=2048&q=75"/></a><a class="aspect-[2/1]_ group relative isolate flex flex-col overflow-hidden rounded-lg bg-sky p-5 md:justify-between lg:rounded-xl lg:p-8 lg:even:flex-col-reverse lg:aspect-[588/490]_ lg:col-span-6 group" href="/products/real-time-upserts"><svg class="absolute right-8 top-8 w-[14px] opacity-0 transition-opacity group-hover:opacity-100" xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 14 13"><path stroke="#00152E" stroke-linecap="round" stroke-width="1.32" d="M1 6.4h12.15"></path><path stroke="#00152E" stroke-linecap="round" stroke-linejoin="round" stroke-width="1.32" d="m7.75 1 5.4 5.4-5.4 5.4"></path></svg><div><h3 class="text-h4 text-balancex text-indigo">Scalable real-time upserts</h3><div class="text-18 mt-2.5 text-ocean max-lg:text-balance md:mt-4 lg:max-w-[500px]">Upserts are two operations in one. If a data record doesn’t exist, it performs an insert. If it does already exist, it performs an update. StarTree can perform upserts scalably at millons of rows per second.</div></div><img alt="Scalable Real Time Upserts" loading="lazy" width="464" height="460" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 undefined" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F07%2FScalable-real-time-upserts.svg&w=640&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F07%2FScalable-real-time-upserts.svg&w=1080&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F07%2FScalable-real-time-upserts.svg&w=1080&q=75"/></a><a class="aspect-[2/1]_ group relative isolate flex flex-col overflow-hidden rounded-lg bg-sky p-5 md:justify-between lg:rounded-xl lg:p-8 lg:even:flex-col-reverse lg:aspect-[588/490]_ lg:col-span-6 group" href="/products/autoscaling-minions"><svg class="absolute right-8 top-8 w-[14px] opacity-0 transition-opacity group-hover:opacity-100" xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 14 13"><path stroke="#00152E" stroke-linecap="round" stroke-width="1.32" d="M1 6.4h12.15"></path><path stroke="#00152E" stroke-linecap="round" stroke-linejoin="round" stroke-width="1.32" d="m7.75 1 5.4 5.4-5.4 5.4"></path></svg><div><h3 class="text-h4 text-balancex text-indigo">Autoscaling minions</h3><div class="text-18 mt-2.5 text-ocean max-lg:text-balance md:mt-4 lg:max-w-[500px]">Save costs on your cloud infrastructure with autoscaling minions. Ensure tasks are processed efficiently and drop the legwork of repartitioning data post-ingestion and merging smaller segments into larger ones.</div></div><img alt="Auto Scaling Minions 2" loading="lazy" width="1176" height="902" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 undefined" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FAuto-scaling-minions-2.png&w=1200&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FAuto-scaling-minions-2.png&w=3840&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F08%2FAuto-scaling-minions-2.png&w=3840&q=75"/><div aria-hidden="true" class="pointer-events-none absolute -z-10 rounded-full right-[-813px] top-[-1300px] size-[1778px] bg-[radial-gradient(50%_50%_at_50%_50%,_#AE95DC_0%,_rgba(233,248,255,0.00)_100%)]"></div><div aria-hidden="true" class="pointer-events-none -z-10 scale-90"></div></a></div></div></section></main><div class="space-y-4 bg-indigo py-4 md:pb-[60px] md:pt-16"><div class="header-container"><div class="relative isolate overflow-hidden rounded-lg bg-white/[0.03] px-6 py-10 md:rounded-xl md:px-8 md:py-16 lg:px-20 lg:py-[125px]"><h2 class="text-cta relative z-10 max-w-xl text-sky-25">Ready to deploy real-time analytics?</h2><div class="text-18 prose prose-sky relative z-10 mt-3 !max-w-xl !text-sky-200 md:mt-6"><p>Start for free or book a demo with our team.</p> </div><div class="relative z-10 mt-[22px] flex items-center gap-x-[18px] sm:gap-x-6 md:mt-[47px]"><a class="cta-button block" href="/saas-signup"><div class="text-center rounded-full focus-visible:outline focus-visible:outline-2 focus-visible:outline-offset-2 focus-visible:outline-white px-[25px] relative overflow-hidden group isolate overflow-hidden py-3 md:px-8 md:py-4 text-link-m bg-turmeric text-indigo"><div>Start for free</div><div class="absolute -z-10 size-[98px] bg-[radial-gradient(50%_50%_at_50%_50%,_#FFFFFF_0%,_rgba(233,248,255,0.00)_100%)] opacity-0 transition-[opacity,transform] group-hover:opacity-100" style="left:0px;top:0px"><div class="absolute inset-0 m-auto size-14 bg-[radial-gradient(50%_50%_at_50%_50%,_#A6E8F1_0%,_rgba(233,248,255,0.00)_100%)]"></div></div></div></a><a class="cta-button block" href="/demo"><div class="text-link-m group flex items-center gap-2 text-white">Book a demo<span aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" fill="none" class="w-2.5 translate-x-0 transition-transform ease-[0.76,0,0.24,1] group-hover:translate-x-1.5 text-white" viewBox="0 0 12 12"><path d="M1 6h10.125M6.625 1.5l4.5 4.5-4.5 4.5" stroke="currentColor" stroke-linecap="round" stroke-linejoin="round"></path></svg></span></div></a></div><div class="pointer-events-none absolute left-[-90%] top-[-40%] aspect-[2311/1052] w-[910px] bg-[radial-gradient(50%_50%_at_50%_50%,_#21C6DC_0%,_rgba(77,_209,_227,_0.00)_100%)] blur-lg [clip-path:_ellipse(1155px_526px_at_50%_50%)] sm:w-[150%] xl:top-[-110%] xl:w-[2311px] transition-transform duration-[3000ms] rotate-[0deg] scale-100 rotate-[0deg] scale-100"></div><div class="pointer-events-none absolute bottom-[-50%] right-[-90%] aspect-[2311/1052] w-[910px] bg-[radial-gradient(50%_50%_at_50%_50%,_#6F42C1_0%,_rgba(111,_66,_193,_0.00)_100%)] blur-lg [clip-path:_ellipse(1155px_526px_at_50%_50%)] md:w-[130%] xl:bottom-[-140%] xl:w-[2311px] transition-transform duration-[3000ms] rotate-[0deg] scale-100 rotate-[0deg] scale-100"></div></div></div></div><footer class="pb-8 pt-10 md:pb-10 md:pt-[60px] bg-indigo" aria-labelledby="footer-heading"><h2 id="footer-heading" class="sr-only">Footer</h2><div class="container"><div class="be-ix-link-block"></div><div class="grid grid-cols-2 gap-x-6 gap-y-10 sm:grid-cols-3 md:gap-9 lg:flex lg:justify-between lg:gap-[9px]"><div class="w-full lg:max-w-[192px]"><h3 class="text-label-l text-river-200">Platform</h3><ul class="mt-5 w-full space-y-[14px] lg:mt-9 lg:max-w-[165px] lg:space-y-[18px]"><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/startree-cloud">Platform Overview</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/startree-thirdeye">Anomaly Detection</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/real-time-upserts">Real-Time Upserts</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/tiered-storage">Tiered Storage</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/indexing">Indexing</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/multi-stage-query-engine">Multi-Stage Query Engine</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/autoscaling-minions">Autoscaling Minions</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/products/data-manager">Integrations</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/security-compliance">Security & Compliance</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/deployment-options">Deployment Options</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/partners">Partner</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/pricing">Pricing</a></li></ul></div><div class="w-full lg:max-w-[192px]"><h3 class="text-label-l text-river-200">Industries</h3><ul class="mt-5 w-full space-y-[14px] lg:mt-9 lg:max-w-[165px] lg:space-y-[18px]"><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/financial-services">Financial Services</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/retail">Retail</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/gaming">Gaming</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/delivery-and-ridesharing">Delivery & Ridesharing</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/human-resources">Human Resources</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/healthcare">Healthcare</a></li></ul></div><div class="w-full lg:max-w-[192px]"><h3 class="text-label-l text-river-200">Use cases</h3><ul class="mt-5 w-full space-y-[14px] lg:mt-9 lg:max-w-[165px] lg:space-y-[18px]"><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/fraud-detection">Fraud Detection</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/personalization">Personalization</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/solutions/business-metrics-monitoring">Business Metrics Monitoring</a></li></ul></div><div class="w-full lg:max-w-[192px]"><h3 class="text-label-l text-river-200">For Developers</h3><ul class="mt-5 w-full space-y-[14px] lg:mt-9 lg:max-w-[165px] lg:space-y-[18px]"><li><a target="_blank" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="https://dev.startree.ai/docs/">Docs</a></li><li><a target="_blank" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="https://support.startree.ai/">Support</a></li><li><a target="_blank" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="https://dev.startree.ai/docs/community/">Community</a></li></ul></div><div class="w-full lg:max-w-[192px]"><h3 class="text-label-l text-river-200">Resources</h3><ul class="mt-5 w-full space-y-[14px] lg:mt-9 lg:max-w-[165px] lg:space-y-[18px]"><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/user-stories">User Stories</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/resources/category/blog">Blog</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/resources/category/videos">Videos</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/glossary">Glossary</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/resources/category/events-webinars">Events & Webinars</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/resources/category/fundamentals">Fundamentals</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/rta-summit">RTA Summit</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/all-stars">StarTree All-Stars</a></li></ul></div><div class="w-full lg:max-w-[192px]"><h3 class="text-label-l text-river-200">Company</h3><ul class="mt-5 w-full space-y-[14px] lg:mt-9 lg:max-w-[165px] lg:space-y-[18px]"><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/about">About</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/careers">Careers</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/news">Press</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/contact-us">Contact</a></li><li><a target="" class="text-nav-link footer-link block !leading-[1.1] text-sky-100 transition-colors duration-300 hover:text-white" href="/legal">Legal</a></li><li></li></ul></div></div><div class="mt-10 flex gap-x-6 gap-y-6 max-sm:flex-col-reverse lg:mt-[140px] lg:gap-x-[167px]"><img alt="Svg 223107605 1699873195" loading="lazy" width="80" height="80" decoding="async" data-nimg="1" class="fade-in relative z-10 opacity-100 transition-opacity duration-200 max-sm:max-w-14" style="color:transparent" srcSet="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F06%2Fsvg-223107605-1699873195.svg&w=96&q=75 1x, /_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F06%2Fsvg-223107605-1699873195.svg&w=256&q=75 2x" src="/_next/image?url=https%3A%2F%2Fstartree.wpenginepowered.com%2Fwp-content%2Fuploads%2F2024%2F06%2Fsvg-223107605-1699873195.svg&w=256&q=75"/><div class="w-full max-w-[459px] shrink-0"><h3 class="text-22-t mb-5 !font-normal !leading-[1.2] !tracking-[-0.22px] text-sky md:mb-7">Get the latest updates</h3><form class="flex w-full items-center gap-x-4 rounded-full border border-white/10 bg-white/[0.03] px-5 py-3.5 md:px-6 md:py-3.5"><input type="email" name="email" required="" class="flex-1 border-0 bg-transparent p-0 text-[15px] leading-[1.1] tracking-[-0.3px] text-sky outline-0 ring-0 placeholder:text-white/50 focus:ring-0" placeholder="Your email address"/><button type="submit" class="w-2.5 shrink-0"><svg xmlns="http://www.w3.org/2000/svg" fill="none" class="text-white" viewBox="0 0 12 12"><path stroke="currentColor" stroke-linecap="round" stroke-width="1.1" d="M1 6h10.125"></path><path stroke="currentColor" stroke-linecap="round" stroke-linejoin="round" stroke-width="1.1" d="m6.625 1.5 4.5 4.5-4.5 4.5"></path></svg><span class="sr-only">Subscribe</span></button></form></div></div><div class="mt-10 flex gap-y-6 max-md:flex-col md:items-end md:justify-between lg:mt-[160px] xl:items-center"><div class="flex flex-1 gap-x-10 gap-y-6 max-lg:flex-col lg:items-center xl:gap-x-[126px]"><p class="text-link-s text-sky/40">© <!-- -->2024<!-- --> <!-- -->StarTree Inc. All rights reserved.</p><div class="flex flex-wrap gap-x-6 gap-y-2"><a class="text-link-s block text-sky-25/60 transition-colors duration-300 hover:text-sky" href="/startree-trademark-policy">Trademark Policy</a><a class="text-link-s block text-sky-25/60 transition-colors duration-300 hover:text-sky" href="/privacy-policy">Privacy Policy</a><a class="text-link-s block text-sky-25/60 transition-colors duration-300 hover:text-sky" href="/terms-conditions">Terms of Use</a><a class="text-link-s block text-sky-25/60 transition-colors duration-300 hover:text-sky" href="/responsible-disclosure">Responsible Disclosure</a></div></div><div class="flex space-x-4 max-md:order-first"><a target="_blank" href="https://www.linkedin.com/company/startreedata/"><span class="block transition-colors duration-300 text-sky hover:text-sky/80"><span class="sr-only">linkedin</span><div class="w-5" aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 20 20"><path fill="currentColor" fill-rule="evenodd" d="M2.285 17.45h3.171V6.9h-3.17v10.55ZM17.081 11.577v5.874h-3.104v-5.548c0-1.414-.5-2.284-1.602-2.284-.713-.008-1.354.47-1.602 1.196a2.28 2.28 0 0 0-.1.87v5.766H7.567V7.226h3.104V8.64c.583-1.081 1.652-1.744 2.804-1.74 2.003 0 3.605 1.522 3.605 4.677ZM3.915 2.685c-.814-.09-1.54.556-1.623 1.44-.004.045-.006.09-.007.135.001.873.653 1.579 1.456 1.577.028 0 .056 0 .084-.002.814.088 1.54-.555 1.623-1.44.003-.046.006-.09.007-.135.029-.843-.576-1.55-1.35-1.582-.064-.002-.127 0-.19.007Z" clip-rule="evenodd"></path></svg></div></span></a><a target="_blank" href="https://www.youtube.com/startreedata"><span class="block transition-colors duration-300 text-sky hover:text-sky/80"><span class="sr-only">youtube</span><div class="w-5" aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 20 20"><path fill="currentColor" d="M15.057 3H4.685C2.65 3 1 4.75 1 6.908v5.5c0 2.158 1.65 3.908 3.685 3.908h10.372c2.035 0 3.685-1.75 3.685-3.909V6.908C18.742 4.75 17.092 3 15.057 3Zm-2.492 6.925L7.714 12.38c-.13.066-.279-.034-.279-.186V7.131c0-.154.153-.254.283-.184l4.851 2.608c.145.077.142.297-.004.37Z"></path></svg></div></span></a><a target="_blank" href="https://twitter.com/startreedata"><span class="block transition-colors duration-300 text-sky hover:text-sky/80"><span class="sr-only">x</span><div class="w-5" aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 20 20"><path fill="currentColor" d="m10.956 8.85 5.424-6.173h-1.285l-4.711 5.36-3.76-5.36H2.284l5.688 8.106-5.688 6.473H3.57l4.972-5.661 3.972 5.661h4.338M4.034 3.626h1.974l9.086 12.728H13.12"></path></svg></div></span></a></div></div></div></footer></div><script id="__NEXT_DATA__" type="application/json">{"props":{"pageProps":{"page":{"ID":3139,"post_author":"4","post_date":"2024-08-31 22:33:09","post_date_gmt":"2024-08-31 22:33:09","post_title":"Multi-Stage Query Engine","post_status":"publish","comment_status":"closed","ping_status":"closed","post_name":"multi-stage-query-engine","post_modified":"2024-11-09 20:27:28","post_modified_gmt":"2024-11-09 20:27:28","post_parent":267,"guid":"https://startree.ai/?page_id=3139","menu_order":4,"post_type":"page","filter":"raw","url":"https://startree.ai/products/multi-stage-query-engine","page_options":{"header_color":"white","is_first_component_overflowing_nav":true,"footer_color":"indigo","banner":{"background_color":"indigo"},"popup":{"variants":"blue"}},"sections":[{"acf_fc_layout":"section","components":[{"acf_fc_layout":"mastheads","mastheads":[{"acf_fc_layout":"page_masthead","layout":"two_col","gradient":"red_blue","text_card":{"subheading":"Multi-Stage Query Engine","heading":"Analyze your data at your speed","content":"\u003cp\u003eRun complex SQL queries without sacrificing blazing-fast query performance, gaining the business insights your teams need in real-time.\u003c/p\u003e\n","links":[{"link":{"link":{"title":"Book a demo","url":"/demo/"},"type":"button","button":{"type":"default","background_color":"tumeric","size":"default","custom_classes":"hero-button"},"text":{"color":"indigo"}}},{"link":{"link":{"title":"Start for free","url":"/saas-signup/"},"type":"text","button":{"type":"default","size":"default"},"text":{"color":"indigo","custom_classes":"hero-button"}}}],"options":{"text_alignment":"left","mobile_text_alignment":"left","subheading_tag":"h6","subheading_font_size":"default","subheading_font_color":"ocean","heading_tag":"h1","heading_font_size":"default","heading_font_color":"indigo","heading_max_width":"w-full","content_font_size":"18","content_font_color":"ocean","content_max_width":"max-w-lg","custom_y_spacing":"default"},"page_callout":{"layout":"row"}},"add_asset":true,"asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Multi-stage-query-engine.svg","alt":"Multi Stage Query Engine","width":464,"height":460}}},"asset_spacing":"default"}]}],"padding_top":"none","padding_bottom":"none","inner_spacing":"none","has_container":true,"background":{"background_color":"sky"}},{"acf_fc_layout":"section","components":[{"acf_fc_layout":"text_card","text_card":{"heading":"Deliver fast and accurate insights across large datasets","options":{"text_alignment":"left","mobile_text_alignment":"left","subheading_tag":"h6","subheading_font_size":"default","subheading_font_color":"ocean","heading_tag":"h2","heading_font_size":"h3","heading_font_color":"white","heading_max_width":"max-w-2xl","content_font_size":"18","content_font_color":"indigo-600","content_max_width":"w-full","custom_y_spacing":"default"},"page_callout":{"layout":"row"}}},{"acf_fc_layout":"grids","grids":[{"acf_fc_layout":"icon_hover_cards","layout":"default","card_bg_color":"indigo","cards":[{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/fastest-performance-yellow.png","alt":"Fastest Performance Yellow","width":128,"height":128},"heading":"Improve query performance","content":"\u003cp\u003eStarTree\u0026#8217;s Multi-Stage Query Engine lets you break down complex queries into smaller, more manageable stages to more efficiently process large datasets and reduce query latency. You can also process different stages of a query in parallel for faster query execution and better performance.\u003c/p\u003e\n","theme":"yellow"},{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/09/64x64-cost-icon_purple-v1.png","alt":"64x64 Cost Icon Purple V1","width":128,"height":128},"heading":"Allocate resources more effectively without increasing costs","content":"\u003cp\u003eManage and schedule different stages of query execution based on available resources to prevent resource contention. The Multi-Stage Query Engine can dynamically balance query loads to optimize CPU usage and reduce bottlenecks.\u003c/p\u003e\n","theme":"purple"},{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/09/64x64-scalability-icon_blue-v1.png","alt":"64x64 Scalability Icon Blue V1","width":128,"height":128},"heading":"Scale to handle increased data volumes and query complexity","content":"\u003cp class=\"p1\"\u003eThe Multi-Stage Query Engine uses stage-specific optimizations to improve query efficiency and can scale horizontally to handle larger query loads. The multi-stage architecture is designed to better manage complex queries that involve multiple aggregations, joins, and filters.\u003c/p\u003e\n","theme":"blue"}],"resource_callout":[{"ID":499,"post_title":"TEST — What is Apache Pinot?","categories":[{"id":4,"name":"eBooks \u0026amp; Whitepapers","slug":"ebooks-whitepapers"}],"acf":{"preview":{"thumbnail":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/A4-1.svg","alt":"A4 1","width":245,"height":258},"intro":"Apache Pinot is an open source distributed database designed for real-time, user-facing analytics.","show_video_icon":true,"resource_callout_thumbnail":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/image-31.jpg","alt":"Image 31","width":518,"height":292},"theme":"grey_green"},"layout":"papers"}}],"text_card":{"options":{"text_alignment":"left","mobile_text_alignment":"left","subheading_tag":"h6","subheading_font_size":"default","subheading_font_color":"ocean","heading_tag":"h2","heading_font_size":"default","heading_font_color":"indigo","heading_max_width":"w-full","content_font_size":"18","content_font_color":"ocean","content_max_width":"w-full","custom_y_spacing":"default"},"page_callout":{"layout":"row"}}}]}],"padding_top":"120","padding_bottom":"120","inner_spacing":"80","has_container":true,"background":{"background_color":"indigo-900"}},{"acf_fc_layout":"section","components":[{"acf_fc_layout":"text_card","text_card":{"heading":"Run complex queries with native query-time joins","content":"\u003cp\u003eUnlock timely and accurate insights from your data in motion and power your real-time analytics application.\u003c/p\u003e\n","options":{"text_alignment":"left","mobile_text_alignment":"left","subheading_tag":"h6","subheading_font_size":"default","subheading_font_color":"ocean","heading_tag":"h2","heading_font_size":"h2","heading_font_color":"indigo","heading_max_width":"custom","custom_heading_max_width":"700","content_font_size":"18","content_font_color":"indigo-600","content_max_width":"custom","custom_content_max_width":"460","custom_y_spacing":"default"},"page_callout":{"layout":"row"}}},{"acf_fc_layout":"content","content":[{"acf_fc_layout":"sticky_nav_and_card_scroll","cards":[{"label":"Joins Support","heading":"Joins Support","content":"\u003cp\u003eOptimize query performance and the execution of joins at scale with native support for serving joins with subseconds latency. The Multi-Stage Query Engine supports all three types of join strategies: Broadcast Joins, Shuffle Hash Distributed Joins, and Lookup Joins. With this capability, StarTree covers the entire spectrum of data joins, providing full coverage from user-facing analytics all the way up to ad hoc analytics.\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/09/query-feature_joins-v1.svg","alt":"Query Feature Joins V1","width":464,"height":460}}},"theme":"green_blue"},{"label":"Multi-Stage Execution Model","heading":"Multi-Stage Execution Model","content":"\u003cp\u003eThe multi-stage execution model is designed to handle complex multi-stage data processing. It includes an intermediate compute stage (consisting of a set of processing servers and a data exchange mechanism) that allows StarTree to handle more complex processing requirements by offloading computation from the brokers.\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Multi-stage-query-engine.svg","alt":"Multi Stage Query Engine","width":464,"height":460}}},"theme":"green_grey"},{"label":"Indexing and Pruning","heading":"Indexing and Pruning","content":"\u003cp\u003eStarTree offers a rich set of indexing and pruning techniques to speed up query processing on individual tables. These techniques help reduce the overhead of scanning and aggregations to improve query latency and throughput.\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/09/query-feature_indexing-v1.svg","alt":"Query Feature Indexing V1","width":464,"height":400}}},"theme":"purple"},{"label":"Data Layout","heading":"Data Layout","content":"\u003cp\u003eImprove join performance by adapting based on the data layout. StarTree optimizes joins to account for data that is partitioned but not co-located, data that is partitioned and co-located, and random layouts (data is neither partitioned nor co-located).\u003c/p\u003e\n","asset":{"type":"image","image":{"image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/09/query-feature_layout-v1.svg","alt":"Query Feature Layout V1","width":464,"height":300}}},"theme":"red_blue"}]}]}],"padding_top":"120","padding_bottom":"80","inner_spacing":"80","has_container":true,"overflow":true,"background":{"background_color":"white"}},{"acf_fc_layout":"section","components":[{"acf_fc_layout":"content","content":[{"acf_fc_layout":"testimonial_slider","testimonials":[{"ID":4687,"post_title":"Stripe - Johan Adami","acf":{"quote":"\u003cp\u003e\u0026#8220;We migrated our old time series aggregation system from a different framework to Apache Pinot. With Pinot, we can ingest an entire stream of data and send multiple queries at it, and it will be equally performant. This offers a lot of flexibility — it allows us to lower the cost of operating, and opens up real-time analytics to folks that weren\u0026#8217;t Scala experts but know how to write SQL queries.\u0026#8221;\u003c/p\u003e\n","job_role":"Software Engineer","logo":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/stripe_logo-black.svg","alt":"Stripe Logo Black","width":360,"height":150},"inverted_logo":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/stripe_logo-white.svg","alt":"Stripe Logo White","width":360,"height":150},"avatar":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/09/Johan-Adami-Stripe.png","alt":"Johan Adami Stripe","width":250,"height":250},"name":"Johan Adami"}}],"is_dark":true}]}],"padding_top":"80","padding_bottom":"80","inner_spacing":"80","has_container":true,"background":{"background_color":"white"}},{"acf_fc_layout":"section","components":[{"acf_fc_layout":"text_card","text_card":{"subheading":"keep exploring","heading":"The most powerful real-time analytics platform","options":{"text_alignment":"left","mobile_text_alignment":"left","subheading_tag":"h6","subheading_font_size":"default","subheading_font_color":"ocean","heading_tag":"h2","heading_font_size":"h2","heading_font_color":"indigo","heading_max_width":"max-w-2xl","content_font_size":"18","content_font_color":"ocean","content_max_width":"w-full","custom_y_spacing":"default"},"page_callout":{"layout":"row"}}},{"acf_fc_layout":"grids","grids":[{"acf_fc_layout":"use_case_grid","cards":[{"link":{"title":"Tiered Storage","url":"/products/tiered-storage"},"heading":"Simplified tiered storage","content":"Analyze all your data, new and historical, without slowing down queries or blowing your budget. StarTree automatically stores the data you access most often for super-fast results.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/09/tiered_storage-horizontal-v1.svg","alt":"Tiered Storage Horizontal V1","width":626,"height":236},"theme":"ocean_river","width":"7"},{"link":{"title":"Indexing","url":"/products/indexing"},"heading":"Powerful, flexible indexing","content":"Harness extensive indexing to analyze your data, any way you want. Unlike other techniques which work on a single column, the star-tree index is built on multiple columns, using pre-aggregated results.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Simplified-Tiered-Storage-1.png","alt":"Simplified Tiered Storage 1","width":968,"height":532},"width":"5"},{"link":{"title":"Real-Time Upserts","url":"/products/real-time-upserts"},"heading":"Scalable real-time upserts","content":"Upserts are two operations in one. If a data record doesn’t exist, it performs an insert. If it does already exist, it performs an update. StarTree can perform upserts scalably at millons of rows per second.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Scalable-real-time-upserts.svg","alt":"Scalable Real Time Upserts","width":464,"height":460},"width":"6"},{"link":{"title":"Autoscaling Minions","url":"/products/autoscaling-minions"},"heading":"Autoscaling minions","content":"Save costs on your cloud infrastructure with autoscaling minions. Ensure tasks are processed efficiently and drop the legwork of repartitioning data post-ingestion and merging smaller segments into larger ones.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Auto-scaling-minions-2.png","alt":"Auto Scaling Minions 2","width":1176,"height":902},"theme":"jade","width":"6"}]}]}],"padding_top":"80","padding_bottom":"120","inner_spacing":"80","has_container":true,"background":{"background_color":"white"}}],"seo":{"title":"Multi Stage Query Engine | StarTree","description":"Run complex SQL queries without sacrificing blazing-fast query performance, gaining the business insights your teams need in real-time."},"featured_image":{"width":1120,"height":600}},"postListing":{},"options":{"menu":{"header_links":[{"link":{"title":"Platform","url":"/products/startree-cloud","target":""},"has_submenu":true,"submenu":{"submenu_type":"platform","platform":{"nav":[{"heading":"","links":[{"link":{"title":"Anomaly Detection","url":"/products/startree-thirdeye","target":""},"description":"Explore StarTree ThirdEye.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Anomaly-Detection.svg","alt":"Anomaly Detection","width":44,"height":44},"layout":""}]},{"heading":"Features","links":[{"link":{"title":"Real-Time Upserts","url":"/products/real-time-upserts","target":""},"description":"Perform inserts \u0026 updates.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Real-Time-Updates.svg","alt":"Real Time Updates","width":44,"height":44},"layout":""},{"link":{"title":"Tiered Storage","url":"/products/tiered-storage","target":""},"description":"Analyze all your data.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Tiered-Storage.svg","alt":"Tiered Storage","width":44,"height":44},"layout":""},{"link":{"title":"Indexing","url":"/products/indexing","target":""},"description":"Create flexible indexes.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Indexing.svg","alt":"Indexing","width":44,"height":44},"layout":""},{"link":{"title":"Multi-Stage Query Engine","url":"/products/multi-stage-query-engine","target":""},"description":"Run complex SQL queries.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Multi-stage-query-engine.svg","alt":"Multi Stage Query Engine","width":44,"height":44},"layout":""},{"link":{"title":"Autoscaling Minions","url":"/products/autoscaling-minions","target":""},"description":"Save costs on your infra.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Auto-scaling-minions.svg","alt":"Auto Scaling Minions","width":44,"height":44},"layout":""},{"link":{"title":"Fast \u0026 Scalable Data Ingestion","url":"/products/data-manager","target":""},"description":"Explore StarTree Data Manager.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/data_manger_icon-bkg.svg","alt":"Data Manger Icon Bkg","width":44,"height":44},"layout":""}]},{"heading":"Technology","links":[{"link":{"title":"Security \u0026 Compliance","url":"/security-compliance","target":""},"description":"Enterprise-grade security.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Security.svg","alt":"Security","width":44,"height":44},"layout":""},{"link":{"title":"Deployment Options","url":"/deployment-options","target":""},"description":"BYoC or use our SaaS.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Deployment-options.svg","alt":"Deployment Options Icon","width":44,"height":44},"layout":""},{"link":{"title":"Technology Partners","url":"/partners","target":""},"description":"AWS, Google Cloud \u0026 Azure.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Partners.svg","alt":"Partners","width":44,"height":44},"layout":""}]}],"featured_link":{"link":{"title":"Platform Overview","url":"/products/startree-cloud","target":""},"description":"Meet StarTree Cloud, the fully-managed DBaaS.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Frame-1948759746-1.svg","alt":"Frame 1948759746","width":304,"height":281},"layout":"platform"}},"solutions":{"nav":false},"developers":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"links":false},"resources":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"nav":false}}},{"link":{"title":"Solutions","url":"/#","target":""},"has_submenu":true,"submenu":{"submenu_type":"solutions","platform":{"nav":false,"featured_link":{"link":null,"description":"","image":false,"layout":false}},"solutions":{"nav":[{"heading":"By Industry","links":[{"link":{"title":"Financial Services","url":"/solutions/financial-services","target":""},"description":"Build personal finance products.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Fintech.svg","alt":"Fintech","width":44,"height":44},"layout":""},{"link":{"title":"Transportation, Delivery, \u0026 Rideshare","url":"/solutions/delivery-and-ridesharing","target":""},"description":"Power your location-based services.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/devliery-rideshare_icon-bkg.svg","alt":"Devliery Rideshare Icon Bkg","width":44,"height":44},"layout":""},{"link":{"title":"Retail","url":"/solutions/retail","target":""},"description":"Understand shopping habits.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Shopping.svg","alt":"Shopping","width":44,"height":44},"layout":""},{"link":{"title":"Human Resources","url":"/solutions/hr","target":""},"description":"Enhance employee experiences.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/hr_icon-bkg.svg","alt":"Hr Icon Bkg","width":44,"height":44},"layout":""},{"link":{"title":"Gaming","url":"/solutions/gaming","target":""},"description":"Deliver hyper-personalized gaming analytics.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/gaming_icon-bkg.svg","alt":"Gaming Icon Bkg","width":44,"height":44},"layout":""},{"link":{"title":"Healthcare","url":"/solutions/healthcare","target":""},"description":"Provide personalized patient care.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/healthcare_icon-bkg.svg","alt":"Healthcare Icon Bkg","width":44,"height":44},"layout":""}]},{"heading":"By use case","links":[{"link":{"title":"Fraud Detection","url":"/solutions/fraud-detection","target":""},"description":"Detect fraud in real-time.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Fraud-detection.svg","alt":"Fraud Detection","width":44,"height":44},"layout":""},{"link":{"title":"Business Metrics Monitoring","url":"/solutions/business-metrics-monitoring","target":""},"description":"Track key performance indicators.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Analytics.svg","alt":"Analytics","width":44,"height":44},"layout":""},{"link":{"title":"Personalization","url":"/solutions/personalization","target":""},"description":"Tailor products with real-time data.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Personalisation.svg","alt":"Personalisation","width":44,"height":44},"layout":""}]}]},"developers":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"links":false},"resources":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"nav":false}}},{"link":{"title":"For Developers","url":"https://dev.startree.ai/","target":""},"has_submenu":true,"submenu":{"submenu_type":"developers","platform":{"nav":false,"featured_link":{"link":null,"description":"","image":false,"layout":false}},"solutions":{"nav":false},"developers":{"featured_link":{"link":{"title":"Docs","url":"https://dev.startree.ai/docs","target":"_blank"},"description":"Start building your real-time analytics application.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/Group-64280.svg","alt":"Group 64280","width":199,"height":280},"layout":"devs"},"links":[{"link":{"title":"Support","url":"https://support.startree.ai/","target":"_blank"},"description":"Get first-rate support from dedicated engineers.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/06/Frame-1948759621.jpg","alt":"Frame 1948759621","width":844,"height":492},"layout":""},{"link":{"title":"Community","url":"https://dev.startree.ai/docs/community/","target":"_blank"},"description":"Join our real-time community.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/06/Frame-1948759621-1.jpg","alt":"Frame 1948759621 1","width":844,"height":492},"layout":""}]},"resources":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"nav":false}}},{"link":{"title":"Resources","url":"/resources","target":""},"has_submenu":true,"submenu":{"submenu_type":"resources","platform":{"nav":false,"featured_link":{"link":null,"description":"","image":false,"layout":false}},"solutions":{"nav":false},"developers":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"links":false},"resources":{"featured_link":{"link":{"title":"User Stories","url":"/user-stories","target":""},"description":"Meet the leading companies who use StarTree and Apache Pinot.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/08/hr_slider-image-v1.png","alt":"Hr Slider Image V1","width":2400,"height":1434},"layout":"resources"},"nav":[{"link":{"title":"Blog","url":"/resources/category/blog/","target":""},"description":"Explore articles, guides \u0026 content.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Blog.svg","alt":"Blog","width":44,"height":44},"layout":""},{"link":{"title":"Videos","url":"/resources/category/videos/","target":""},"description":"Learn more with walkthroughs.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Video.svg","alt":"Video","width":44,"height":44},"layout":""},{"link":{"title":"Glossary","url":"/glossary/","target":""},"description":"Your real-time analytics 101.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Glossary.svg","alt":"Glossary","width":44,"height":44},"layout":""},{"link":{"title":"Webinars","url":"https://startree.ai/resources/tag/webinar","target":""},"description":"Sign up to an online webinar. ","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Webinars.svg","alt":"Webinars","width":44,"height":44},"layout":""},{"link":{"title":"Events","url":"https://startree.ai/resources/category/events-webinars","target":""},"description":"Attend a StarTree event.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/Event.svg","alt":"Event","width":44,"height":44},"layout":""},{"link":{"title":"StarTree All-Stars","url":"https://dev.startree.ai/community/all-stars","target":"_blank"},"description":"Join our real-time community.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/07/All-star.svg","alt":"All Star","width":44,"height":44},"layout":""},{"link":{"title":"RTA Summit","url":"https://startree.ai/rta-summit","target":""},"description":"Attend Real-Time Analytics Summit.","image":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/11/64x64-rtas_icon-bkg.svg","alt":"64x64 Rtas Icon Bkg","width":44,"height":44},"layout":""}]}}},{"link":{"title":"Partners","url":"/partners","target":""},"has_submenu":false,"submenu":{"submenu_type":false,"platform":{"nav":false,"featured_link":{"link":null,"description":"","image":false,"layout":false}},"solutions":{"nav":false},"developers":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"links":false},"resources":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"nav":false}}},{"link":{"title":"Pricing","url":"/pricing","target":""},"has_submenu":false,"submenu":{"submenu_type":false,"platform":{"nav":false,"featured_link":{"link":null,"description":"","image":false,"layout":false}},"solutions":{"nav":false},"developers":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"links":false},"resources":{"featured_link":{"link":null,"description":"","image":false,"layout":false},"nav":false}}}]},"cta":{"heading":"Ready to deploy real-time analytics?","content":"\u003cp\u003eStart for free or book a demo with our team.\u003c/p\u003e\n","button_link":{"title":"Start for free","url":"/saas-signup","target":""},"text_link":{"title":"Book a demo","url":"/demo","target":""},"stats":[{"stat":"20,000","supporting_content":"QPS"},{"stat":"\u003c1s","supporting_content":"query latency"},{"stat":"Petabyte","supporting_content":"data scale"}]},"footer":{"footer_links":[{"heading":"Platform","nav":[{"link":{"title":"Platform Overview","url":"/products/startree-cloud","target":""}},{"link":{"title":"Anomaly Detection","url":"/products/startree-thirdeye","target":""}},{"link":{"title":"Real-Time Upserts","url":"/products/real-time-upserts","target":""}},{"link":{"title":"Tiered Storage","url":"/products/tiered-storage","target":""}},{"link":{"title":"Indexing","url":"/products/indexing","target":""}},{"link":{"title":"Multi-Stage Query Engine","url":"/products/multi-stage-query-engine","target":""}},{"link":{"title":"Autoscaling Minions","url":"/products/autoscaling-minions","target":""}},{"link":{"title":"Integrations","url":"/products/data-manager","target":""}},{"link":{"title":"Security \u0026 Compliance","url":"/security-compliance","target":""}},{"link":{"title":"Deployment Options","url":"/deployment-options","target":""}},{"link":{"title":"Partner","url":"/partners","target":""}},{"link":{"title":"Pricing","url":"/pricing","target":""}}]},{"heading":"Industries","nav":[{"link":{"title":"Financial Services","url":"/solutions/financial-services","target":""}},{"link":{"title":"Retail","url":"/solutions/retail","target":""}},{"link":{"title":"Gaming","url":"/solutions/gaming","target":""}},{"link":{"title":"Delivery \u0026 Ridesharing","url":"/solutions/delivery-and-ridesharing","target":""}},{"link":{"title":"Human Resources","url":"/solutions/human-resources","target":""}},{"link":{"title":"Healthcare","url":"/solutions/healthcare","target":""}}]},{"heading":"Use cases","nav":[{"link":{"title":"Fraud Detection","url":"/solutions/fraud-detection","target":""}},{"link":{"title":"Personalization","url":"/solutions/personalization","target":""}},{"link":{"title":"Business Metrics\u2028Monitoring","url":"/solutions/business-metrics-monitoring","target":""}}]},{"heading":"For Developers","nav":[{"link":{"title":"Docs","url":"https://dev.startree.ai/docs/","target":"_blank"}},{"link":{"title":"Support","url":"https://support.startree.ai/","target":"_blank"}},{"link":{"title":"Community","url":"https://dev.startree.ai/docs/community/","target":"_blank"}}]},{"heading":"Resources","nav":[{"link":{"title":"User Stories","url":"/user-stories","target":""}},{"link":{"title":"Blog","url":"/resources/category/blog","target":""}},{"link":{"title":"Videos","url":"/resources/category/videos","target":""}},{"link":{"title":"Glossary","url":"/glossary","target":""}},{"link":{"title":"Events \u0026 Webinars","url":"/resources/category/events-webinars","target":""}},{"link":{"title":"Fundamentals","url":"/resources/category/fundamentals","target":""}},{"link":{"title":"RTA Summit","url":"/rta-summit","target":""}},{"link":{"title":"StarTree All-Stars","url":"/all-stars","target":""}}]},{"heading":"Company","nav":[{"link":{"title":"About","url":"/about","target":""}},{"link":{"title":"Careers","url":"/careers","target":""}},{"link":{"title":"Press","url":"/news","target":""}},{"link":{"title":"Contact","url":"/contact-us","target":""}},{"link":{"title":"Legal","url":"/legal","target":""}},{"link":""}]}],"newletter":{"heading":"Get the latest updates"},"legal_links":[{"link":{"title":"Trademark Policy","url":"/startree-trademark-policy","target":""}},{"link":{"title":"Privacy Policy","url":"/privacy-policy","target":""}},{"link":{"title":"Terms of Use","url":"/terms-conditions","target":""}},{"link":{"title":"Responsible Disclosure","url":"/responsible-disclosure","target":""}}],"socials":[{"logo":"linkedin","url":"https://www.linkedin.com/company/startreedata/"},{"logo":"youtube","url":"https://www.youtube.com/startreedata"},{"logo":"x","url":"https://twitter.com/startreedata"}],"logo":{"logo":{"url":"https://startree.wpenginepowered.com/wp-content/uploads/2024/06/svg-223107605-1699873195.svg","alt":"Svg 223107605 1699873195","width":80,"height":80}},"copyright_text":"StarTree Inc. All rights reserved."},"links":{"login":{"title":"Login","url":"https://startree.cloud/login","target":"_blank"},"start_for_free":{"title":"Start for free","url":"/saas-signup/","target":""},"demo":{"title":"Book a demo","url":"/demo/","target":""}}}},"__N_SSG":true},"page":"/[...slug]","query":{"slug":["products","multi-stage-query-engine"]},"buildId":"KP-lAfE2gKozH6Xb-rQVr","isFallback":false,"isExperimentalCompile":false,"dynamicIds":[79114,76442],"gsp":true,"scriptLoader":[]}</script></body></html>