Open Source Full-text Search Engine Database

<!doctype html><html lang="en"><head> <meta charset="utf-8"> <title>Open Source Full-text Search Engine Database</title> <link rel="shortcut icon" href="https://cratedb.com/hubfs/cratedb-favicon.png"> <meta name="description" content="CrateDB is a hyper-fast search engine and open source database for full-text data, leveraging native SQL. You can combine multiple other data formats."> <style> .cr-header-full-height { height: 100vh; } </style>   <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/template_assets/103134656537/1676853350416/sf2-crate/js/jquery-3.5.1.min.js"></script> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta property="og:description" content="CrateDB is a hyper-fast search engine and open source database for full-text data, leveraging native SQL. You can combine multiple other data formats."> <meta property="og:title" content="Open Source Full-text Search Engine Database"> <meta name="twitter:description" content="CrateDB is a hyper-fast search engine and open source database for full-text data, leveraging native SQL. You can combine multiple other data formats."> <meta name="twitter:title" content="Open Source Full-text Search Engine Database"> <style> a.cta_button{-moz-box-sizing:content-box !important;-webkit-box-sizing:content-box !important;box-sizing:content-box !important;vertical-align:middle}.hs-breadcrumb-menu{list-style-type:none;margin:0px 0px 0px 0px;padding:0px 0px 0px 0px}.hs-breadcrumb-menu-item{float:left;padding:10px 0px 10px 10px}.hs-breadcrumb-menu-divider:before{content:'›';padding-left:10px}.hs-featured-image-link{border:0}.hs-featured-image{float:right;margin:0 0 20px 20px;max-width:50%}@media (max-width: 568px){.hs-featured-image{float:none;margin:0;width:100%;max-width:100%}}.hs-screen-reader-text{clip:rect(1px, 1px, 1px, 1px);height:1px;overflow:hidden;position:absolute !important;width:1px} </style> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/template_assets/52693799430/1721897980656/sf2-crate/css/main.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/template_assets/52694827330/1729004392151/sf2-crate/css/theme-overrides.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/55523967869/1722426745670/module_55523967869_Header_Notif_Bar.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/52694764069/1701097527939/module_52694764069_menu-section.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/53642957898/1710775451648/module_53642957898_code-tabs.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/52697609066/1633080952018/module_52697609066_advanced-richtext.min.css"> <link rel="stylesheet" href="https://cdn2.hubspot.net/hub/-1/hub_generated/module_assets/-35056501883/1732641106642/module_-35056501883_Video.min.css"> <style> #oembed_container-module_16965990352877 .oembed_custom-thumbnail_icon svg { fill: #19c0ea; } </style> <style> #oembed_container-module_17174162025917 .oembed_custom-thumbnail_icon svg { fill: #19c0ea; } </style> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/124127418129/1716804134819/module_124127418129_Related_Content_23.min.css"> <link rel="stylesheet" href="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/91968152433/1731315229164/module_91968152433_Accordion_22.min.css">  <style id="hs_editor_style" type="text/css"> #hs_cos_wrapper_module_16965990352877 { display: block !important; padding-left: 20px !important; padding-right: 20px !important } #hs_cos_wrapper_module_17174162025917 { display: block !important; padding-left: 20px !important; padding-right: 20px !important } #hs_cos_wrapper_module_16965990352877 { display: block !important; padding-left: 20px !important; padding-right: 20px !important } #hs_cos_wrapper_module_17174162025917 { display: block !important; padding-left: 20px !important; padding-right: 20px !important } /* HubSpot Non-stacked Media Query Styles */ @media (min-width:768px) { .dnd_area-row-3-vertical-alignment > .row-fluid { display: -ms-flexbox !important; -ms-flex-direction: row; display: flex !important; flex-direction: row; } .dnd_area-row-4-vertical-alignment > .row-fluid { display: -ms-flexbox !important; -ms-flex-direction: row; display: flex !important; flex-direction: row; } .cell_16965990352873-vertical-alignment { display: -ms-flexbox !important; -ms-flex-direction: column !important; -ms-flex-pack: center !important; display: flex !important; flex-direction: column !important; justify-content: center !important; } .cell_16965990352873-vertical-alignment > div { flex-shrink: 0 !important; } .cell_16965990352872-vertical-alignment { display: -ms-flexbox !important; -ms-flex-direction: column !important; -ms-flex-pack: center !important; display: flex !important; flex-direction: column !important; justify-content: center !important; } .cell_16965990352872-vertical-alignment > div { flex-shrink: 0 !important; } .cell_17174162025912-vertical-alignment { display: -ms-flexbox !important; -ms-flex-direction: column !important; -ms-flex-pack: center !important; display: flex !important; flex-direction: column !important; justify-content: center !important; } .cell_17174162025912-vertical-alignment > div { flex-shrink: 0 !important; } .cell_1717416204772-vertical-alignment { display: -ms-flexbox !important; -ms-flex-direction: column !important; -ms-flex-pack: center !important; display: flex !important; flex-direction: column !important; justify-content: center !important; } .cell_1717416204772-vertical-alignment > div { flex-shrink: 0 !important; } } /* HubSpot Styles (default) */ .dnd_area-row-0-background-layers { background-image: url('https://cratedb.com/hubfs/cr-header-mesh.jpg') !important; background-position: center center !important; background-size: cover !important; background-repeat: no-repeat !important; } .dnd_area-row-1-padding { padding-left: 20px !important; padding-right: 0px !important; } .dnd_area-row-2-padding { padding-top: 10px !important; padding-bottom: 20px !important; } .dnd_area-row-2-background-layers { background-image: linear-gradient(rgba(243, 243, 243, 1), rgba(243, 243, 243, 1)) !important; background-position: left top !important; background-size: auto !important; background-repeat: no-repeat !important; } .dnd_area-row-3-padding { padding-bottom: 40px !important; } .dnd_area-row-4-padding { padding-top: 40px !important; } .dnd_area-row-5-padding { padding-top: 80px !important; padding-bottom: 80px !important; } .dnd_area-row-5-background-layers { background-image: linear-gradient(rgba(243, 243, 243, 1), rgba(243, 243, 243, 1)) !important; background-position: left top !important; background-size: auto !important; background-repeat: no-repeat !important; } .dnd_area-row-6-padding { padding-top: 40px !important; padding-bottom: 40px !important; } .dnd_area-row-7-padding { padding-top: 40px !important; padding-bottom: 40px !important; } .dnd_area-row-7-background-layers { background-image: linear-gradient(rgba(241, 241, 241, 1), rgba(241, 241, 241, 1)) !important; background-position: left top !important; background-size: auto !important; background-repeat: no-repeat !important; } .cell_17014231453083-padding { padding-left: 0px !important; padding-right: 0px !important; } .cell_16965990352873-padding { padding-left: 0px !important; padding-right: 0px !important; } /* HubSpot Styles (mobile) */ @media (max-width: 767px) { .dnd_area-row-1-padding { padding-top: 40px !important; padding-bottom: 40px !important; } } </style>  <script> var _hsp = window._hsp = window._hsp || []; window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} var useGoogleConsentModeV2 = true; var waitForUpdateMillis = 1000; if (!window._hsGoogleConsentRunOnce) { window._hsGoogleConsentRunOnce = true; gtag('consent', 'default', { 'ad_storage': 'denied', 'analytics_storage': 'denied', 'ad_user_data': 'denied', 'ad_personalization': 'denied', 'wait_for_update': waitForUpdateMillis }); if (useGoogleConsentModeV2) { _hsp.push(['useGoogleConsentModeV2']) } else { _hsp.push(['addPrivacyConsentListener', function(consent){ var hasAnalyticsConsent = consent && (consent.allowed || (consent.categories && consent.categories.analytics)); var hasAdsConsent = consent && (consent.allowed || (consent.categories && consent.categories.advertisement)); gtag('consent', 'update', { 'ad_storage': hasAdsConsent ? 'granted' : 'denied', 'analytics_storage': hasAnalyticsConsent ? 'granted' : 'denied', 'ad_user_data': hasAdsConsent ? 'granted' : 'denied', 'ad_personalization': hasAdsConsent ? 'granted' : 'denied' }); }]); } } gtag('js', new Date()); gtag('set', 'developer_id.dZTQ1Zm', true); gtag('config', 'G-6J80J11VFJ'); </script> <script async src="https://www.googletagmanager.com/gtag/js?id=G-6J80J11VFJ"></script>   <script> var _hsp = window._hsp = window._hsp || []; window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} var useGoogleConsentModeV2 = true; var waitForUpdateMillis = 1000; var hsLoadGtm = function loadGtm() { if(window._hsGtmLoadOnce) { return; } if (useGoogleConsentModeV2) { gtag('set','developer_id.dZTQ1Zm',true); gtag('consent', 'default', { 'ad_storage': 'denied', 'analytics_storage': 'denied', 'ad_user_data': 'denied', 'ad_personalization': 'denied', 'wait_for_update': waitForUpdateMillis }); _hsp.push(['useGoogleConsentModeV2']) } (function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','GTM-WHMDSK'); window._hsGtmLoadOnce = true; }; _hsp.push(['addPrivacyConsentListener', function(consent){ if(consent.allowed || (consent.categories && consent.categories.analytics)){ hsLoadGtm(); } }]); </script>  <link rel="canonical" href="https://cratedb.com/data-model/full-text"> <meta property="og:url" content="https://cratedb.com/data-model/full-text"> <meta name="twitter:card" content="summary"> <meta http-equiv="content-language" content="en">    <meta property="og:image" content="https://cratedb.com/hubfs/cr-featured-image-23.jpg"> <meta property="og:image:width" content="1200"> <meta property="og:image:height" content="630"> <meta property="og:image:alt" content="CrateDB - Data Insights at Scale"> <meta name="generator" content="HubSpot"></head> <body class="">  <noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-WHMDSK" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>  <div class="body-wrapper hs-content-id-147538685531 hs-site-page page "> <div id="hs_cos_wrapper_Header_Notif_Bar" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"></div> <div data-global-resource-path="sf2-crate/templates/partials/header-landify.html"> <header class="header" style="color: #ffffff ;" id="top"> <a href="#main-content" class="header__skip">Skip to content</a> <div class="header__container content-wrapper"> <div class="header__logo header__logo--main"> <div id="hs_cos_wrapper_site_logo" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module widget-type-logo" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"> <span id="hs_cos_wrapper_site_logo_hs_logo_widget" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_logo" style="" data-hs-cos-general-type="widget" data-hs-cos-type="logo"><a href="/" id="hs-link-site_logo_hs_logo_widget" style="border-width:0px;border:0px;"><img src="https://cratedb.com/hubfs/CrateDB-logo-blue-white.svg" class="hs-image-widget " height="204" style="height: auto;width:1433px;border-width:0px;border:0px;" width="1433" alt="CrateDB logo" title="CrateDB logo" loading="eager"></a></span> </div> </div> <div class="header_nav_column" style="text-align: center ;"> <div class="header_nav"> <div class="header--toggle header__navigation--toggle"></div> <div class="header__close--toggle"></div> <div class="header__navigation header--element"> <div id="hs_cos_wrapper_navigation-primary" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"> <nav aria-label="Main menu" class="navigation-primary"> <ul class="submenu level-1"> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link active-branch" title="Product">Product</a> <ul class="submenu level-2"> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link" title="Database">Database</a> <ul class="submenu level-3"> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/database" class="menu-link" title="Overview">Overview</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/database/cloud" class="menu-link" title="CrateDB Cloud">CrateDB Cloud</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/database/self-managed" class="menu-link" title="CrateDB Self-Managed">CrateDB Self-Managed</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/database/sql-examples" class="menu-link" title="SQL examples">SQL examples</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/database/integrations" class="menu-link" title="Integrations">Integrations</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/database/security" class="menu-link" title="Security">Security</a> </li> </ul> </li> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link active-branch" title="Data models">Data models</a> <ul class="submenu level-3"> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/data-model/time-series" class="menu-link" title="Time-series">Time-series</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/data-model/json" class="menu-link" title="Document/JSON">Document/JSON</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/data-model/vector" class="menu-link" title="Vector">Vector</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/data-model/full-text" class="menu-link active-item" aria-current="page" title="Full-text">Full-text</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/data-model/geospatial" class="menu-link" title="Spatial">Spatial</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/data-model/relational" class="menu-link" title="Relational">Relational</a> </li> </ul> </li> </ul> </li> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link" title="Use cases">Use cases</a> <ul class="submenu level-2"> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/ai-ml-database" class="menu-link" title="AI/ML integration">AI/ML integration</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/chatbots/" class="menu-link" title="AI-powered chatbots">AI-powered chatbots</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/iot-database" class="menu-link" title="Internet of Things">Internet of Things</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/digital-twins-database" class="menu-link" title="Digital twins">Digital twins</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/geospatial-analytics" class="menu-link" title="Geospatial analytics">Geospatial analytics</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/log-database" class="menu-link" title="Log & event analysis">Log & event analysis</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/use-cases/database-consolidation" class="menu-link" title="Database consolidation">Database consolidation</a> </li> </ul> </li> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link" title="Industries">Industries</a> <ul class="submenu level-2"> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/energy" class="menu-link" title="Energy">Energy</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/financial-services" class="menu-link" title="Financial Services">Financial Services</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/fmcg" class="menu-link" title="FMCG">FMCG</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/logistics" class="menu-link" title="Logistics">Logistics</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/manufacturing" class="menu-link" title="Manufacturing">Manufacturing</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/oil-gas-mining" class="menu-link" title="Oil, gas & mining">Oil, gas & mining</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/smart-cities" class="menu-link" title="Smart city solutions">Smart city solutions</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/tech-platforms" class="menu-link" title="Technology platforms">Technology platforms</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/telco" class="menu-link" title="Telco">Telco</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/industries/transportation" class="menu-link" title="Transportation">Transportation</a> </li> </ul> </li> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link" title="Resources">Resources</a> <ul class="submenu level-2"> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/stories" class="menu-link" title="User stories">User stories</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/academy" class="menu-link" title="Academy">Academy</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/library" class="menu-link" title="Asset library">Asset library</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/blog" class="menu-link" title="Blog">Blog</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/event" class="menu-link" title="Events">Events</a> </li> </ul> </li> <li class="has-submenu menu-item hs-skip-lang-url-rewrite"> <a href="javascript:;" class="menu-link" title="Developer">Developer</a> <ul class="submenu level-2"> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="/docs/guide/home/" class="menu-link" title="Documentation">Documentation</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/database/drivers-tools" class="menu-link" title="Drivers and tools">Drivers and tools</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/community" class="menu-link" title="Community">Community</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://github.com/crate/crate/" class="menu-link" target="_blank" rel="noopener" title="GitHub">GitHub</a> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/support" class="menu-link" title="Support">Support</a> </li> </ul> </li> <li class="no-submenu menu-item hs-skip-lang-url-rewrite"> <a href="https://cratedb.com/pricing" class="menu-link" title="Pricing">Pricing</a> </li> </ul> </nav></div> <div class="header__cta__column mb"> <div class="header__cta"> <div id="hs_cos_wrapper_module_161720035400929" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="ly-cta-div header-icons"> <div class="cr-gh-header"> <a href="https://github.com/crate/" title="Follow CrateDB on GitHub" rel="noreferrer" target="_blank"> <svg version="1.0" height="20" width="20" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 496 512" aria-labelledby="github5" role="img"><path d="M165.9 397.4c0 2-2.3 3.6-5.2 3.6-3.3.3-5.6-1.3-5.6-3.6 0-2 2.3-3.6 5.2-3.6 3-.3 5.6 1.3 5.6 3.6zm-31.1-4.5c-.7 2 1.3 4.3 4.3 4.9 2.6 1 5.6 0 6.2-2s-1.3-4.3-4.3-5.2c-2.6-.7-5.5.3-6.2 2.3zm44.2-1.7c-2.9.7-4.9 2.6-4.6 4.9.3 2 2.9 3.3 5.9 2.6 2.9-.7 4.9-2.6 4.6-4.6-.3-1.9-3-3.2-5.9-2.9zM244.8 8C106.1 8 0 113.3 0 252c0 110.9 69.8 205.8 169.5 239.2 12.8 2.3 17.3-5.6 17.3-12.1 0-6.2-.3-40.4-.3-61.4 0 0-70 15-84.7-29.8 0 0-11.4-29.1-27.8-36.6 0 0-22.9-15.7 1.6-15.4 0 0 24.9 2 38.6 25.8 21.9 38.6 58.6 27.5 72.9 20.9 2.3-16 8.8-27.1 16-33.7-55.9-6.2-112.3-14.3-112.3-110.5 0-27.5 7.6-41.3 23.6-58.9-2.6-6.5-11.1-33.3 2.6-67.9 20.9-6.5 69 27 69 27 20-5.6 41.5-8.5 62.8-8.5s42.8 2.9 62.8 8.5c0 0 48.1-33.6 69-27 13.7 34.7 5.2 61.4 2.6 67.9 16 17.7 25.8 31.5 25.8 58.9 0 96.5-58.9 104.2-114.8 110.5 9.2 7.9 17 22.9 17 46.4 0 33.7-.3 75.4-.3 83.6 0 6.5 4.6 14.4 17.3 12.1C428.2 457.8 496 362.9 496 252 496 113.3 383.5 8 244.8 8zM97.2 352.9c-1.3 1-1 3.3.7 5.2 1.6 1.6 3.9 2.3 5.2 1 1.3-1 1-3.3-.7-5.2-1.6-1.6-3.9-2.3-5.2-1zm-10.8-8.1c-.7 1.3.3 2.9 2.3 3.9 1.6 1 3.6.7 4.3-.7.7-1.3-.3-2.9-2.3-3.9-2-.6-3.6-.3-4.3.7zm32.4 35.6c-1.6 1.3-1 4.3 1.3 6.2 2.3 2.3 5.2 2.6 6.5 1 1.3-1.3.7-4.3-1.3-6.2-2.2-2.3-5.2-2.6-6.5-1zm-11.4-14.7c-1.6 1-1.6 3.6 0 5.9 1.6 2.3 4.3 3.3 5.6 2.3 1.6-1.3 1.6-3.9 0-6.2-1.4-2.3-4-3.3-5.6-2z"></path></svg> </a> </div> <div class="cr-gh-header cr-search-header"> <a href="/search" class="search-btn menu-link" title="Search on cratedb.com"> <svg xmlns="http://www.w3.org/2000/svg" width="18" height="18" viewbox="0 0 512 512"><path d="M416 208c0 45.9-14.9 88.3-40 122.7L502.6 457.4c12.5 12.5 12.5 32.8 0 45.3s-32.8 12.5-45.3 0L330.7 376c-34.4 25.2-76.8 40-122.7 40C93.1 416 0 322.9 0 208S93.1 0 208 0S416 93.1 416 208zM208 352a144 144 0 1 0 0-288 144 144 0 1 0 0 288z"></path></svg> </a> </div> </div> <div class="ly-cta-div" style="margin-right:0;"> <div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="140734001567"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLLN26yv8kQRp2WAoeOu9bNBbkLvTvRFUszq%2FYx5PHh5KDMckqiVw13YriNZl%2FdwfLQhIBdngdVl9Lx2IjudAdjrNLPdfhOwxbALtLSGiVSiJme4GD1HjmmjV%2BLWcWF9BI7hRc97dyKGXNt5JHxSRJoHlvLASH5kuFKzd92WI2YJWJb%2BFVwL%2FkowhjQ7LStla2KXRfev%2Bt5hHZ6w0AIdYbL%2Bw5TrWqqtyhZwdCt8vhgIqhu3f3Em59QiBrX4OknB3IvxW9zy0KkmILmwktRj%2BbA%3D&portalId=19927462" target="_blank" class="hs-inline-web-interactive-140734001567 cta-btn login-cta menu-link " data-hubspot-cta-id="140734001567"> Log In </a> </div> </div> <div class="ly-cta-div"> <div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="178336831256"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLIJe21Dd%2BqMBXuwhUEwIxeKvQRteMuuvBgS0cjHs7WtGTrDP%2FOCVzg%2F92IOl9VbWfNtTIu%2FKC6mz8pqjKES7LqJM2rA5K6VXfMhvFaG4WQW2LFPe9AVNyYpYDsMuKe%2FlqIfbRifuiV29ECfFn%2BRra2Unad4SCh6ECtacrskeaY%2FWA%3D%3D&portalId=19927462" target="_blank" rel="noopener" class="hs-inline-web-interactive-178336831256 cr-btn-div cr-btn-2 " data-hubspot-cta-id="178336831256"> Start free </a> </div> </div> <style> .ly-cta-div a.cta-btn.login-cta{ color:#000000; background-color:#FFFFFF; font-size:16px; } .ly-cta-div a.cta-btn.signup-cta{ color:#000000; background-color:#FFFFFF; font-size:16px; } .ly-cta-div a.cta-btn{ display:inline-block; position:relative; padding:10px 25px; font-family:sans-serif; transition: all .4s ease; line-height:21px; border-radius:5px; cursor:pointer; text-decoration:none; font-weight: 600; } .ly-cta-div a.cta-btn:hover{ opacity:.7; } .cr-gh-header.cr-search-header { padding: 0; margin-right: 0; } div#hs_cos_wrapper_module_161720035400929 { display: inline-block; } </style></div> </div> </div> </div> </div> </div> <div class="header__cta__column lg"> <div class="header__cta"> <div id="hs_cos_wrapper_module_161720035400929" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="ly-cta-div header-icons"> <div class="cr-gh-header"> <a href="https://github.com/crate/" title="Follow CrateDB on GitHub" rel="noreferrer" target="_blank"> <svg version="1.0" height="20" width="20" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 496 512" aria-labelledby="github5" role="img"><path d="M165.9 397.4c0 2-2.3 3.6-5.2 3.6-3.3.3-5.6-1.3-5.6-3.6 0-2 2.3-3.6 5.2-3.6 3-.3 5.6 1.3 5.6 3.6zm-31.1-4.5c-.7 2 1.3 4.3 4.3 4.9 2.6 1 5.6 0 6.2-2s-1.3-4.3-4.3-5.2c-2.6-.7-5.5.3-6.2 2.3zm44.2-1.7c-2.9.7-4.9 2.6-4.6 4.9.3 2 2.9 3.3 5.9 2.6 2.9-.7 4.9-2.6 4.6-4.6-.3-1.9-3-3.2-5.9-2.9zM244.8 8C106.1 8 0 113.3 0 252c0 110.9 69.8 205.8 169.5 239.2 12.8 2.3 17.3-5.6 17.3-12.1 0-6.2-.3-40.4-.3-61.4 0 0-70 15-84.7-29.8 0 0-11.4-29.1-27.8-36.6 0 0-22.9-15.7 1.6-15.4 0 0 24.9 2 38.6 25.8 21.9 38.6 58.6 27.5 72.9 20.9 2.3-16 8.8-27.1 16-33.7-55.9-6.2-112.3-14.3-112.3-110.5 0-27.5 7.6-41.3 23.6-58.9-2.6-6.5-11.1-33.3 2.6-67.9 20.9-6.5 69 27 69 27 20-5.6 41.5-8.5 62.8-8.5s42.8 2.9 62.8 8.5c0 0 48.1-33.6 69-27 13.7 34.7 5.2 61.4 2.6 67.9 16 17.7 25.8 31.5 25.8 58.9 0 96.5-58.9 104.2-114.8 110.5 9.2 7.9 17 22.9 17 46.4 0 33.7-.3 75.4-.3 83.6 0 6.5 4.6 14.4 17.3 12.1C428.2 457.8 496 362.9 496 252 496 113.3 383.5 8 244.8 8zM97.2 352.9c-1.3 1-1 3.3.7 5.2 1.6 1.6 3.9 2.3 5.2 1 1.3-1 1-3.3-.7-5.2-1.6-1.6-3.9-2.3-5.2-1zm-10.8-8.1c-.7 1.3.3 2.9 2.3 3.9 1.6 1 3.6.7 4.3-.7.7-1.3-.3-2.9-2.3-3.9-2-.6-3.6-.3-4.3.7zm32.4 35.6c-1.6 1.3-1 4.3 1.3 6.2 2.3 2.3 5.2 2.6 6.5 1 1.3-1.3.7-4.3-1.3-6.2-2.2-2.3-5.2-2.6-6.5-1zm-11.4-14.7c-1.6 1-1.6 3.6 0 5.9 1.6 2.3 4.3 3.3 5.6 2.3 1.6-1.3 1.6-3.9 0-6.2-1.4-2.3-4-3.3-5.6-2z"></path></svg> </a> </div> <div class="cr-gh-header cr-search-header"> <a href="/search" class="search-btn menu-link" title="Search on cratedb.com"> <svg xmlns="http://www.w3.org/2000/svg" width="18" height="18" viewbox="0 0 512 512"><path d="M416 208c0 45.9-14.9 88.3-40 122.7L502.6 457.4c12.5 12.5 12.5 32.8 0 45.3s-32.8 12.5-45.3 0L330.7 376c-34.4 25.2-76.8 40-122.7 40C93.1 416 0 322.9 0 208S93.1 0 208 0S416 93.1 416 208zM208 352a144 144 0 1 0 0-288 144 144 0 1 0 0 288z"></path></svg> </a> </div> </div> <div class="ly-cta-div" style="margin-right:0;"> <div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="140734001567"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLLN26yv8kQRp2WAoeOu9bNBbkLvTvRFUszq%2FYx5PHh5KDMckqiVw13YriNZl%2FdwfLQhIBdngdVl9Lx2IjudAdjrNLPdfhOwxbALtLSGiVSiJme4GD1HjmmjV%2BLWcWF9BI7hRc97dyKGXNt5JHxSRJoHlvLASH5kuFKzd92WI2YJWJb%2BFVwL%2FkowhjQ7LStla2KXRfev%2Bt5hHZ6w0AIdYbL%2Bw5TrWqqtyhZwdCt8vhgIqhu3f3Em59QiBrX4OknB3IvxW9zy0KkmILmwktRj%2BbA%3D&portalId=19927462" target="_blank" class="hs-inline-web-interactive-140734001567 cta-btn login-cta menu-link " data-hubspot-cta-id="140734001567"> Log In </a> </div> </div> <div class="ly-cta-div"> <div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="178336831256"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLIJe21Dd%2BqMBXuwhUEwIxeKvQRteMuuvBgS0cjHs7WtGTrDP%2FOCVzg%2F92IOl9VbWfNtTIu%2FKC6mz8pqjKES7LqJM2rA5K6VXfMhvFaG4WQW2LFPe9AVNyYpYDsMuKe%2FlqIfbRifuiV29ECfFn%2BRra2Unad4SCh6ECtacrskeaY%2FWA%3D%3D&portalId=19927462" target="_blank" rel="noopener" class="hs-inline-web-interactive-178336831256 cr-btn-div cr-btn-2 " data-hubspot-cta-id="178336831256"> Start free </a> </div> </div> <style> .ly-cta-div a.cta-btn.login-cta{ color:#000000; background-color:#FFFFFF; font-size:16px; } .ly-cta-div a.cta-btn.signup-cta{ color:#000000; background-color:#FFFFFF; font-size:16px; } .ly-cta-div a.cta-btn{ display:inline-block; position:relative; padding:10px 25px; font-family:sans-serif; transition: all .4s ease; line-height:21px; border-radius:5px; cursor:pointer; text-decoration:none; font-weight: 600; } .ly-cta-div a.cta-btn:hover{ opacity:.7; } .cr-gh-header.cr-search-header { padding: 0; margin-right: 0; } div#hs_cos_wrapper_module_161720035400929 { display: inline-block; } </style></div> </div> </div> </div> </header></div> <main id="main-content" class="body-container-wrapper"> <div class="container-fluid body-container body-container--about"> <div class="row-fluid-wrapper"> <div class="row-fluid"> <div class="span12 widget-span widget-type-cell " style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-1 dnd_area-row-0-background-layers dnd-section dnd_area-row-0-background-image"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-2 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_16896903067153" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"> <div class="cr-clusters-items-wrapper " id="module_16896903067153"> <style> #module_16896903067153.cr-clusters-items-wrapper { /*max-width: 1760px;*/ margin: 0 auto; } #module_16896903067153.cr-clusters-items-wrapper.cr-clusters-limit, .cr-meta-inner { max-width: 1200px; } #module_16896903067153 .cr-clusters-container.cr-customers-header-sub { max-width: 1200px; margin: 0 auto; } #module_16896903067153 .cr-clusters-container { display: flex; align-items: center; } #module_16896903067153 .cr-clusters-header { margin-bottom: 20px; display: flex; align-items: baseline; } #module_16896903067153 .cr-clusters-header h1 { letter-spacing: -2.04px; max-width: 620px; margin-right: 20px; margin-bottom: 0px; font-family: Montserrat, Inter, Arial, sans-serif !important; font-weight: 600; line-height: 1.2; } #module_16896903067153 .cr-customers-header-sub .cr-clusters-header h1 { max-width: 980px; } #module_16896903067153 .cr-customers-header-sub .cr-clusters-limit-width-headline.cr-clusters-header h1 { max-width: 700px; } #module_16896903067153.cr-clusters-limit .cr-customers-header-sub .cr-clusters-introtext { max-width: 950px; } #module_16896903067153:not(.cr-clusters-limit) .cr-customers-header-sub .cr-clusters-introtext { max-width: 100%; } #module_16896903067153 .cr-clusters-image { flex: 3; } #module_16896903067153 .cr-clusters-image img { height: auto; } #module_16896903067153 .cr-clusters-introtext, #module_16896903067153 .cr-clusters-introtext p, #module_16896903067153 .cr-clusters-introtext span { color: rgba(255, 255, 255, 1.0); font-size: 21px; margin-right: 100px; } #module_16896903067153 .cr-clusters-introtext { max-width: 680px; } #module_16896903067153 .cr-clusters-left { padding-top: 60px; flex: 3; } #module_16896903067153 .cr-header-section { display: block; font-size: 20px; font-weight: 600; color: #19C0EA; } #module_16896903067153 .cr-clusters-arrow { align-self: flex-end; } #module_16896903067153 .cr-clusters-arrow svg { max-width: 40px; height: auto; } .cr-landingpage-header { margin-bottom: 78px; } .cr-landingpage-header .dnd-column { padding: 0; } .cr-header-meta-bar { background: rgb(8, 29, 36); opacity: 1; padding: 20px 20px; position: absolute; bottom: -146px; left: 0; right: 0; margin-left: -20px; margin-right: -20px; } .cr-header-meta-bar > div > div { display: flex; font-family: Inter; font-weight: 600; font-size: 16px; line-height: 20px; letter-spacing: 0px; color: #FFFFFF; opacity: 1; } .cr-meta-inner { display: flex; flex-direction: row; align-items: center; justify-content: flex-start; margin: 0 auto; } .cr-meta-item { display: flex; align-items: center; margin-right: 30px; } .cr-meta-item img { margin-right: 10px; } .cr-header-speaker-image img { border-radius: 50%; max-width: 80px !important; } .cr-header-speaker-name { letter-spacing: -0.56px; color: #FFFFFF; font-size: 18px; line-height: 24px; font-weight: bold; font-family: Inter; text-align: center; margin-bottom: 2px; } .cr-header-speakers { display: flex; flex-direction: row; margin-top: 80px; } .cr-header-speakers-item:last-child { margin-left: 50px; } .cr-header-speaker-title { letter-spacing: -0.36px; color: #e3b15b; font-size: 16px; line-height: 20px; font-family: Inter; font-weight: 500; text-align: center; } .cr-header-speaker-image { text-align: center; } .cr-header-multipurpose { position: relative; } /*@media all and (min-width: 1200px) { .cr-header-speaker-image img { max-width: 100% !important; } }*/ @media all and (max-width: 1200px) { } @media all and (max-width: 980px) { #module_16896903067153 .cr-clusters-container { flex-direction: column; } #module_16896903067153 .cr-clusters-introtext { font-size: 18px; } #module_16896903067153 .cr-clusters-header h1 { width: auto; max-width: 100%; } #module_16896903067153 .cr-clusters-container { align-items: flex-start; } } @media all and (max-width: 767px) { #module_16896903067153 .cr-clusters-introtext { margin-right: 0; } .cr-header-meta-bar > div > div { flex-direction: column; text-align: center; font-size: 14px; } .cr-meta-item { margin-right: 10px; } .cr-header-speakers { margin-top: 40px; } } </style> <div class="cr-clusters-container cr-customers-header-sub"> <div class="cr-clusters-left"> <span class="cr-header-section">Product > Data models</span> <div class="cr-clusters-header "> <h1 style="color: rgba(255, 255, 255, 1.0);">Full-text Data</h1> </div> <div class="cr-clusters-introtext"> <p>CrateDB efficiently indexes, stores, and retrieves high volumes of unstructured, semi-structured, and structured data, enabling advanced and fast searches across diverse data types, including full-text data.</p> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-3 dnd_area-row-1-padding dnd-section"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell cell_17014231453083-padding dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-4 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_17014231453085" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="horizontal-code-tab line-numbers"> <div class="tab tab-head"> <div class="heading-content"> <h2 style="font-size: 36px;">Full-text search with SQL</h2> <p style="font-size: 18px;">Hyper-fast. Queries in milliseconds.</p> </div> <button class="tablinks module_17014231453085-codetabl" onclick="openCodeTabmodule_17014231453085(event, 'module_17014231453085-Codetab1')" id="module_17014231453085-defaultOpen"> <svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 69.969 56.814" width="20" height="17"> <g id="subheader" transform="translate(96.312 88.344) rotate(180)"> <g id="back" transform="translate(32 34.358)"> <path id="arrow_tip" data-name="Path 42" d="M0,36.174H36.174V0" transform="translate(51.158 25.579) rotate(135)" fill="none" stroke="#18b8e7" stroke-width="8"></path> <line id="arrow_line" data-name="Line 1" x2="63.051" transform="translate(1.261 25.579)" fill="none" stroke="#18b8e7" stroke-linejoin="round" stroke-width="8"></line> </g> </g> </svg> Defining a composite FULLTEXT INDEX with ANALYZER</button> <button class="tablinks module_17014231453085-codetabl" onclick="openCodeTabmodule_17014231453085(event, 'module_17014231453085-Codetab2')"> <svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 69.969 56.814" width="20" height="17"> <g id="subheader" transform="translate(96.312 88.344) rotate(180)"> <g id="back" transform="translate(32 34.358)"> <path id="arrow_tip" data-name="Path 42" d="M0,36.174H36.174V0" transform="translate(51.158 25.579) rotate(135)" fill="none" stroke="#18b8e7" stroke-width="8"></path> <line id="arrow_line" data-name="Line 1" x2="63.051" transform="translate(1.261 25.579)" fill="none" stroke="#18b8e7" stroke-linejoin="round" stroke-width="8"></line> </g> </g> </svg> Full-text search with increased relevance of a column</button> <button class="tablinks module_17014231453085-codetabl" onclick="openCodeTabmodule_17014231453085(event, 'module_17014231453085-Codetab3')"> <svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 69.969 56.814" width="20" height="17"> <g id="subheader" transform="translate(96.312 88.344) rotate(180)"> <g id="back" transform="translate(32 34.358)"> <path id="arrow_tip" data-name="Path 42" d="M0,36.174H36.174V0" transform="translate(51.158 25.579) rotate(135)" fill="none" stroke="#18b8e7" stroke-width="8"></path> <line id="arrow_line" data-name="Line 1" x2="63.051" transform="translate(1.261 25.579)" fill="none" stroke="#18b8e7" stroke-linejoin="round" stroke-width="8"></line> </g> </g> </svg> Full-text search with boosting factors</button> <button class="tablinks module_17014231453085-codetabl" onclick="openCodeTabmodule_17014231453085(event, 'module_17014231453085-Codetab4')"> <svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 69.969 56.814" width="20" height="17"> <g id="subheader" transform="translate(96.312 88.344) rotate(180)"> <g id="back" transform="translate(32 34.358)"> <path id="arrow_tip" data-name="Path 42" d="M0,36.174H36.174V0" transform="translate(51.158 25.579) rotate(135)" fill="none" stroke="#18b8e7" stroke-width="8"></path> <line id="arrow_line" data-name="Line 1" x2="63.051" transform="translate(1.261 25.579)" fill="none" stroke="#18b8e7" stroke-linejoin="round" stroke-width="8"></line> </g> </g> </svg> Search of matching phrases and score filtering</button> <button class="tablinks module_17014231453085-codetabl" onclick="openCodeTabmodule_17014231453085(event, 'module_17014231453085-Codetab5')"> <svg xmlns="http://www.w3.org/2000/svg" viewbox="0 0 69.969 56.814" width="20" height="17"> <g id="subheader" transform="translate(96.312 88.344) rotate(180)"> <g id="back" transform="translate(32 34.358)"> <path id="arrow_tip" data-name="Path 42" d="M0,36.174H36.174V0" transform="translate(51.158 25.579) rotate(135)" fill="none" stroke="#18b8e7" stroke-width="8"></path> <line id="arrow_line" data-name="Line 1" x2="63.051" transform="translate(1.261 25.579)" fill="none" stroke="#18b8e7" stroke-linejoin="round" stroke-width="8"></line> </g> </g> </svg> Fuzzy Search</button> </div> <div class="tab tab-body"> <div id="module_17014231453085-Codetab1" class="tabcontent module_17014231453085-codetabc"> <div class="tab-container"> <div class="tab-pane show active module_17014231453085-pane-number1" role="tabpanel" id="module_17014231453085-Statement1"> <pre class="language-sql line-numbers no-whitespace-normalization" data-start="1"> <code class="language-sql no-whitespace-normalization"><pre><code> /* The table stores data about netflix movies and series. The composite fulltext * index is defined on two columns with the analyzer based on English language. */ CREATE TABLE "netflix_catalog" ( "show_id" TEXT PRIMARY KEY, "type" TEXT, "title" TEXT, "director" TEXT, "cast" ARRAY(TEXT), "country" TEXT, "date_added" TIMESTAMP, "release_year" TEXT, "rating" TEXT, "duration" TEXT, "listed_in" ARRAY(TEXT), "description" TEXT, INDEX title_director_description_ft using FULLTEXT (title, director, description) WITH (analyzer = 'english') ); </code></pre> </code> </pre> </div> <div class="tab-pane module_17014231453085-pane-number1" role="tabpanel" aria-labelledby="cr-la-1-tab" id="module_17014231453085-Result1"> <pre class="language-sql line-numbers no-whitespace-normalization"> <code class="language-sql no-whitespace-normalization"> </code> </pre> </div> <div class="tab-pills statement-result"> <button class="tab-pill module_17014231453085-pill-number1 active" onclick="openPillmodule_170142314530851(event, 'module_17014231453085-Statement1')">Statement</button> </div> </div> </div> <script> function openPillmodule_170142314530851(evt1, module_17014231453085) { var i, tabcontentmodule_17014231453085, tablinksmodule_17014231453085; tabcontentmodule_17014231453085 = document.getElementsByClassName("module_17014231453085-pane-number1"); for (i = 0; i < tabcontentmodule_17014231453085.length; i++) { tabcontentmodule_17014231453085[i].style.display = "none"; } tablinksmodule_17014231453085 = document.getElementsByClassName("module_17014231453085-pill-number1"); for (i = 0; i < tablinksmodule_17014231453085.length; i++) { tablinksmodule_17014231453085[i].className = tablinksmodule_17014231453085[i].className.replace(" active", ""); } document.getElementById(module_17014231453085).style.display = "block"; evt1.currentTarget.className += " active"; } function openCodeTabmodule_17014231453085(evt1, module_17014231453085) { var i, tabcontentmodule_17014231453085, tablinksmodule_17014231453085; tabcontentmodule_17014231453085 = document.getElementsByClassName("module_17014231453085-codetabc"); for (i = 0; i < tabcontentmodule_17014231453085.length; i++) { tabcontentmodule_17014231453085[i].style.display = "none"; } tablinksmodule_17014231453085 = document.getElementsByClassName("module_17014231453085-codetabl"); for (i = 0; i < tablinksmodule_17014231453085.length; i++) { tablinksmodule_17014231453085[i].className = tablinksmodule_17014231453085[i].className.replace(" active", ""); } document.getElementById(module_17014231453085).style.display = "block"; evt1.currentTarget.className += " active"; } document.getElementById("module_17014231453085-defaultOpen").click(); </script> <div id="module_17014231453085-Codetab2" class="tabcontent module_17014231453085-codetabc"> <div class="tab-container"> <div class="tab-pane show active module_17014231453085-pane-number2" role="tabpanel" id="module_17014231453085-Statement2"> <pre class="language-sql line-numbers no-whitespace-normalization" data-start="1"> <code class="language-sql no-whitespace-normalization"><pre><code> /* The query retuns data from the "netflix_catalog" table, specifically searching * for movies where the 'title', 'director', or 'description' fields best match the * term 'Friday', with a higher emphasis on matches in the title, and orders the results * by their relevance score in descending order. */ SELECT show_id, title, director, country, release_year, rating, _score FROM "netflix_catalog" WHERE MATCH(title_director_description_ft, 'title^2 Friday') USING best_fields AND type='Movie' ORDER BY _score DESC; </code></pre> </code> </pre> </div> <div class="tab-pane module_17014231453085-pane-number2" role="tabpanel" aria-labelledby="cr-la-1-tab" id="module_17014231453085-Result2"> <pre class="language- line-numbers no-whitespace-normalization"> <code class="language- no-whitespace-normalization"><pre class="language-sql line-numbers"><code> +---------+------------------------------------+-------------------+----------------------+--------------+--------+-----------+ | show_id | title | director | country | release_year | rating | _score | +---------+------------------------------------+-------------------+----------------------+--------------+--------+-----------+ | s1674 | Black Friday | Anurag Kashyap | India | 2004 | TV-MA | 5.6455536 | | s6805 | Friday the 13th | Marcus Nispel | United States | 2009 | R | 3.226806 | | s1038 | Tuesdays & Fridays | Taranveer Singh | India | 2021 | TV-14 | 3.1089375 | | s7494 | Monster High: Friday Night Frights | Dustin McKenzie | United States | 2013 | TV-Y7 | 3.0620003 | | s3226 | Little Singham: Mahabali | Prakash Satam | NULL | 2019 | TV-Y7 | 3.002901 | | s8233 | The Bye Bye Man | Stacy Title | United States, China | 2017 | PG-13 | 2.9638999 | | s8225 | The Brawler | Ken Kushner | United States | 2019 | TV-MA | 2.8108454 | +---------+------------------------------------+-------------------+----------------------+--------------+--------+-----------+</code></pre> </code> </pre> </div> <div class="tab-pills statement-result"> <button class="tab-pill module_17014231453085-pill-number2 active" onclick="openPillmodule_170142314530852(event, 'module_17014231453085-Statement2')">Statement</button> <button class="tab-pill module_17014231453085-pill-number2" onclick="openPillmodule_170142314530852(event, 'module_17014231453085-Result2')">Result</button> </div> </div> </div> <script> function openPillmodule_170142314530852(evt2, module_17014231453085) { var i, tabcontentmodule_17014231453085, tablinksmodule_17014231453085; tabcontentmodule_17014231453085 = document.getElementsByClassName("module_17014231453085-pane-number2"); for (i = 0; i < tabcontentmodule_17014231453085.length; i++) { tabcontentmodule_17014231453085[i].style.display = "none"; } tablinksmodule_17014231453085 = document.getElementsByClassName("module_17014231453085-pill-number2"); for (i = 0; i < tablinksmodule_17014231453085.length; i++) { tablinksmodule_17014231453085[i].className = tablinksmodule_17014231453085[i].className.replace(" active", ""); } document.getElementById(module_17014231453085).style.display = "block"; evt2.currentTarget.className += " active"; } function openCodeTabmodule_17014231453085(evt2, module_17014231453085) { var i, tabcontentmodule_17014231453085, tablinksmodule_17014231453085; tabcontentmodule_17014231453085 = document.getElementsByClassName("module_17014231453085-codetabc"); for (i = 0; i < tabcontentmodule_17014231453085.length; i++) { tabcontentmodule_17014231453085[i].style.display = "none"; } tablinksmodule_17014231453085 = document.getElementsByClassName("module_17014231453085-codetabl"); for (i = 0; i < tablinksmodule_17014231453085.length; i++) { tablinksmodule_17014231453085[i].className = tablinksmodule_17014231453085[i].className.replace(" active", ""); } document.getElementById(module_17014231453085).style.display = "block"; evt2.currentTarget.className += " active"; } document.getElementById("module_17014231453085-defaultOpen").click(); </script> <div id="module_17014231453085-Codetab3" class="tabcontent module_17014231453085-codetabc"> <div class="tab-container"> <div class="tab-pane show active module_17014231453085-pane-number3" role="tabpanel" id="module_17014231453085-Statement3"> <pre class="language-sql line-numbers no-whitespace-normalization" data-start="1"> <code class="language-sql no-whitespace-normalization"><pre><code> /* This query searches for records where the combined fields of title, director, and * description match the phrase 'mission impossible', with a different weights given to * title and description. The results are ordered by their relevance score in desc order. */ SELECT show_id, type, title, director, country, rating, description, _score FROM "netflix_catalog" WHERE MATCH((title_director_description_ft, title 1.5, description 1), 'mission impossible') ORDER BY _score DESC; </code></pre> </code> </pre> </div> <div class="tab-pane module_17014231453085-pane-number3" role="tabpanel" aria-labelledby="cr-la-1-tab" id="module_17014231453085-Result3"> <pre class="language- line-numbers no-whitespace-normalization"> <code class="language- no-whitespace-normalization"><pre class="language-yaml"><code class="language-yaml"> +---------+----------+------------------------+--------------------+---------------------------------+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+ | show_id | type | title | director | country | rating | description | _score | +---------+----------+------------------------+--------------------+---------------------------------+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+ | s1000 | Movie | Stowaway | Joe Penna | Germany, United States | TV-MA | A three-person crew on a mission to Mars faces an impossible choice when an unplanned passenger jeopardizes the lives of everyone on board. | 5.0469 | | s1768 | Movie | The Impossible | J.A. Bayona | Spain, Thailand, United States | PG-13 | Tracking one family's harrowing experiences, this gripping drama depicts the chaos generated by the massive 2004 tsunami in Southeast Asia. | 3.1496503 | | s7873 | TV Show | Rishta.com | NULL | India | TV-14 | Partners at an Indian matrimonial agency face endlessly challenging and often impossible demands as they help clients make the perfect match. | 3.131972 | | s3242 | TV Show | Nailed It! Holiday! | NULL | United States | TV-PG | It's the "Nailed It!" holiday special you've been waiting for, with missing ingredients, impossible asks and desserts that look delightfully sad. | 3.1265335 | | s1032 | Movie | Into the Beat | Stefan Westerwelle | Germany | TV-14 | A teen ballerina discovers hip-hop by chance and is faced with an impossible choice: Does she follow her parents' footsteps... or her newfound passion? | 2.9678147 | | s1583 | Movie | Triple 9 | John Hillcoat | United States | R | A group of dirty Atlanta cops blackmailed by the Russian mob plan a seemingly impossible heist that sets off an explosive chain reaction of violence. | 2.9678147 | | s848 | TV Show | Mad for Each Other | NULL | NULL | TV-MA | Bothered to realize they are next-door neighbors and share a psychiatrist, a man and a woman find it's impossible to stay out of each other's way. | 2.9385366 | +---------+----------+------------------------+--------------------+---------------------------------+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+ </code></pre> </code> </pre> </div> <div class="tab-pills statement-result"> <button class="tab-pill module_17014231453085-pill-number3 active" onclick="openPillmodule_170142314530853(event, 'module_17014231453085-Statement3')">Statement</button> <button class="tab-pill module_17014231453085-pill-number3" onclick="openPillmodule_170142314530853(event, 'module_17014231453085-Result3')">Result</button> </div> </div> </div> <script> function openPillmodule_170142314530853(evt3, module_17014231453085) { var i, tabcontentmodule_17014231453085, tablinksmodule_17014231453085; tabcontentmodule_17014231453085 = document.getElementsByClassName("module_17014231453085-pane-number3"); for (i = 0; i < tabcontentmodule_17014231453085.length; i++) { tabcontentmodule_17014231453085[i].style.display = "none"; } tablinksmodule_17014231453085 = document.getElementsByClassName("module_17014231453085-pill-number3"); for (i = 0; i < tablinksmodule_17014231453085.length; i++) { tablinksmodule_17014231453085[i].className = tablinksmodule_17014231453085[i].className.replace(" active", ""); } document.getElementById(module_17014231453085).style.display = "block"; evt3.currentTarget.className += " active"; } function openCodeTabmodule_17014231453085(evt3, module_17014231453085) { var i, tabcontentmodule_17014231453085, tablinksmodule_17014231453085; tabcontentmodule_17014231453085 = document.getElementsByClassName("module_17014231453085-codetabc"); for (i = 0; i < tabcontentmodule_17014231453085.length; i++) { tabcontentmodule_17014231453085[i].style.display = "none"; } tablinksmodule_17014231453085 = document.getElementsByClassName("module_17014231453085-codetabl"); for (i = 0; i < tablinksmodule_17014231453085.length; i++) { tablinksmodule_17014231453085[i].className = tablinksmodule_17014231453085[i].className.replace(" active", ""); } document.getElementById(module_17014231453085).style.display = "block"; evt3.currentTarget.className += " active"; } document.getElementById("module_17014231453085-defaultOpen").click(); </script> <div id="module_17014231453085-Codetab4" class="tabcontent module_17014231453085-codetabc"> <div class="tab-container"> <div class="tab-pane show active module_17014231453085-pane-number4" role="tabpanel" id="module_17014231453085-Statement4"> <pre class="language-sql line-numbers no-whitespace-normalization" data-start="1"> <code class="language-sql no-whitespace-normalization"><pre><code> /* The query searches records where the combined title, director, and description * fields phrase-prefix match 'award winning' with a relevance score of at least 10, * and orders the results by their relevance score in descending order. */ SELECT show_id, type, title, country, rating, duration, _score FROM "netflix_catalog" WHERE MATCH(title_director_description_ft, 'award winning') USING phrase_prefix AND _score >= 10 ORDER BY _score DESC; </code></pre> </code> </pre> </div> <div class="tab-pane module_17014231453085-pane-number4" role="tabpanel" aria-labelledby="cr-la-1-tab" id="module_17014231453085-Result4"> <pre class="language- line-numbers no-whitespace-normalization"> <code class="language- no-whitespace-normalization"><pre class="line-numbers"><code> +---------+----------+-----------------------------------------+-----------------+--------+------------+-----------+ | show_id | type | title | country | rating | duration | _score | | ------- | -------- | ----------------------------------------| --------------- | ------ | ---------- | --------- | | s2423 | TV Show | Queer Eye | United States | TV-14 | 5 Seasons | 56.835224 | | s5930 | Movie | Print the Legend | United States | TV-14 | 100 min | 56.835224 | | s849 | TV Show | Master of None | United States | TV-MA | 3 Seasons | 54.720444 | | s7369 | TV Show | Mad Men | United States | TV-14 | 7 Seasons | 53.722008 | | s4556 | Movie | The Meaning of Monty Python | United Kingdom | TV-MA | 60 min | 51.933487 | | s6342 | TV Show | Blue Planet II | United Kingdom | TV-G | 1 Season | 51.933487 | | s4162 | Movie | Surga Yang Tak Dirindukan 2 | Indonesia | TV-14 | 119 min | 50.937637 | | s5186 | TV Show | Alias Grace | Canada | TV-MA | 1 Season | 41.05056 | | s4184 | TV Show | The World's Most Extraordinary Homes | United Kingdom | TV-G | 3 Seasons | 39.506954 | | s6111 | Movie | Alejandro Sanz: What I Was Is What I Am | Spain | TV-MA | 102 min | 38.77893 | +---------+----------+-----------------------------------------+-----------------+--------+------------+-----------+ </code></pre> </code> </pre> </div> <div class="tab-pills statement-result"> <button class="tab-pill module_17014231453085-pill-number4 active" onclick="openPillmodule_170142314530854(event, 'module_17014231453085-Statement4')">Statement</button> <button class="tab-pill module_17014231453085-pill-number4" onclick="openPillmodule_170142314530854(event, 'module_17014231453085-Result4')">Result</button> </div> </div> </div> <script> function openPillmodule_170142314530854(evt4, module_17014231453085) { var i, tabcontentmodule_17014231453085, tablinksmodule_17014231453085; tabcontentmodule_17014231453085 = document.getElementsByClassName("module_17014231453085-pane-number4"); for (i = 0; i < tabcontentmodule_17014231453085.length; i++) { tabcontentmodule_17014231453085[i].style.display = "none"; } tablinksmodule_17014231453085 = document.getElementsByClassName("module_17014231453085-pill-number4"); for (i = 0; i < tablinksmodule_17014231453085.length; i++) { tablinksmodule_17014231453085[i].className = tablinksmodule_17014231453085[i].className.replace(" active", ""); } document.getElementById(module_17014231453085).style.display = "block"; evt4.currentTarget.className += " active"; } function openCodeTabmodule_17014231453085(evt4, module_17014231453085) { var i, tabcontentmodule_17014231453085, tablinksmodule_17014231453085; tabcontentmodule_17014231453085 = document.getElementsByClassName("module_17014231453085-codetabc"); for (i = 0; i < tabcontentmodule_17014231453085.length; i++) { tabcontentmodule_17014231453085[i].style.display = "none"; } tablinksmodule_17014231453085 = document.getElementsByClassName("module_17014231453085-codetabl"); for (i = 0; i < tablinksmodule_17014231453085.length; i++) { tablinksmodule_17014231453085[i].className = tablinksmodule_17014231453085[i].className.replace(" active", ""); } document.getElementById(module_17014231453085).style.display = "block"; evt4.currentTarget.className += " active"; } document.getElementById("module_17014231453085-defaultOpen").click(); </script> <div id="module_17014231453085-Codetab5" class="tabcontent module_17014231453085-codetabc"> <div class="tab-container"> <div class="tab-pane show active module_17014231453085-pane-number5" role="tabpanel" id="module_17014231453085-Statement5"> <pre class="language-sql line-numbers no-whitespace-normalization" data-start="1"> <code class="language-sql no-whitespace-normalization"><pre><code> /* This query uses the composite index to match the term 'scence fction' * (with a likely typo in 'science fiction'), allowing for some fuzziness in matching, * using the English analyzer, requiring at least one term to match. */ SELECT show_id, title, country, description, _score FROM "netflix_catalog" WHERE MATCH(title_director_description_ft, 'scence fction') USING best_fields WITH ( fuzziness=1, analyzer='english', minimum_should_match=1, operator='or' ) ORDER BY _score DESC; </code></pre> </code> </pre> </div> <div class="tab-pane module_17014231453085-pane-number5" role="tabpanel" aria-labelledby="cr-la-1-tab" id="module_17014231453085-Result5"> <pre class="language- line-numbers no-whitespace-normalization"> <code class="language- no-whitespace-normalization"><pre class="language-sql line-numbers"><code class="language-sql"> +---------+---------------------------------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+ | show_id | title | country | description | _score | +---------+---------------------------------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+ | s1604 | Alien Worlds | United Kingdom | Applying the laws of life on Earth to the rest of the galaxy, this series blends science fact and fiction to imagine alien life on other planets. | 4.052918 | | s2589 | Oh Yuck | Canada | Using a concoction of cartoons, comedy and live action, Dr. Yuck and his eccentric lab mates investigate the science behind the planet's ickiest things. | 3.8219523 | | s7848 | Red vs. Blue | United States | This parody of first-person shooter games, military life and science-fiction films centers on a civil war fought in the middle of a desolate canyon. | 3.8219523 | | s3054 | Border Security: America's Front Line | Canada | This reality series chronicles the behind-the-scenes action as U.S. Customs and Border Protection agents safeguard the nation's crossings and ports. | 3.5455647 | | s5870 | Turbo FAST | United States | Join Turbo and his posse, the Fast Action Stunt Team. Filled with comedy, action and fun, this series amps it up to the extreme. | 2.695207 | | s3574 | Our Planet - Behind The Scenes | United Kingdom | Years spent recording footage of creatures from every corner of the globe is bound to produce a bit of drama. Here's a behind-the-scenes look. | 2.5541513 | | s8016 | Sid the Science Kid | United States | Armed with a healthy sense of humor and the help of his teacher, friends and family, curious kid Sid tackles questions youngsters have about science. | 2.5541513 | | s4917 | Bill Nye: Science Guy | United States | The dynamic, bow-tied host behind the young adult science show faces climate-change skeptics as he demonstrates the importance of scientific evidence. | 2.49332 | +---------+---------------------------------------+----------------+----------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+ </code></pre> </code> </pre> </div> <div class="tab-pills statement-result"> <button class="tab-pill module_17014231453085-pill-number5 active" onclick="openPillmodule_170142314530855(event, 'module_17014231453085-Statement5')">Statement</button> <button class="tab-pill module_17014231453085-pill-number5" onclick="openPillmodule_170142314530855(event, 'module_17014231453085-Result5')">Result</button> </div> </div> </div> <script> function openPillmodule_170142314530855(evt5, module_17014231453085) { var i, tabcontentmodule_17014231453085, tablinksmodule_17014231453085; tabcontentmodule_17014231453085 = document.getElementsByClassName("module_17014231453085-pane-number5"); for (i = 0; i < tabcontentmodule_17014231453085.length; i++) { tabcontentmodule_17014231453085[i].style.display = "none"; } tablinksmodule_17014231453085 = document.getElementsByClassName("module_17014231453085-pill-number5"); for (i = 0; i < tablinksmodule_17014231453085.length; i++) { tablinksmodule_17014231453085[i].className = tablinksmodule_17014231453085[i].className.replace(" active", ""); } document.getElementById(module_17014231453085).style.display = "block"; evt5.currentTarget.className += " active"; } function openCodeTabmodule_17014231453085(evt5, module_17014231453085) { var i, tabcontentmodule_17014231453085, tablinksmodule_17014231453085; tabcontentmodule_17014231453085 = document.getElementsByClassName("module_17014231453085-codetabc"); for (i = 0; i < tabcontentmodule_17014231453085.length; i++) { tabcontentmodule_17014231453085[i].style.display = "none"; } tablinksmodule_17014231453085 = document.getElementsByClassName("module_17014231453085-codetabl"); for (i = 0; i < tablinksmodule_17014231453085.length; i++) { tablinksmodule_17014231453085[i].className = tablinksmodule_17014231453085[i].className.replace(" active", ""); } document.getElementById(module_17014231453085).style.display = "block"; evt5.currentTarget.className += " active"; } document.getElementById("module_17014231453085-defaultOpen").click(); </script> </div> </div></div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-5 dnd_area-row-2-background-layers dnd_area-row-2-padding dnd_area-row-2-background-color dnd-section"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-6 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_widget_1689690959169" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="cr-featuresbox-items-wrapper" id="widget_1689690959169"> <style> #widget_1689690959169.cr-featuresbox-items-wrapper { /*max-width: 1760px;*/ margin-bottom: 40px; } #widget_1689690959169 .cr-featuresbox-container { background: #fff; margin: 30px auto 20px; position: relative; padding: 30px 40px 30px 40px; box-shadow: 0px 8px 22px #0000001C; border: 1px solid #FFFFFF1C; overflow: hidden; transition: box-shadow 0.3s ease-in-out; } #widget_1689690959169 .cr-featuresbox-headline { padding-right: 30px; } #widget_1689690959169 .cr-featuresbox-headline h3 { font-size: 28px; font-weight: bold; letter-spacing: -0.64px; margin-top: 0; margin-bottom: 16px; } #widget_1689690959169 .cr-featuresbox-icon img { max-width: 24px !important; position: absolute; /*right: 20px;*/ right: 10px; /*bottom: -24px;*/ top: 10px; opacity: .2; } #widget_1689690959169 .cr-featuresbox-link { position: absolute; top: 0; right: 0; bottom: 0; left: 0; display: block; z-index: 9; display: flex; justify-content: space-between; align-items: center; } #widget_1689690959169 .cr-featuresbox-link svg { max-width: 30px; height: auto; margin-right: 24px; position: absolute; right: 0px; z-index: -1; } #widget_1689690959169 .cr-featuresbox-link a, #widget_1689690959169 .cr-featuresbox-link a:visited { width: 100%; height: 100%; display: block; text-decoration: none; } #widget_1689690959169 .cr-featuresbox-link a:hover, #widget_1689690959169 .cr-featuresbox-link a:active { text-decoration: none; } #widget_1689690959169 .cr-featuresbox-text { font-size: 16px; padding-right: 120px; } #widget_1689690959169 .cr-featuresbox-readmore { text-align: right; margin-top: 40px; } #widget_1689690959169 .cr-featuresbox-readmore svg { max-width: 22px; height: auto; margin-left: 5px; } #widget_1689690959169 .cr-featuresbox-container p:last-child { margin-bottom: 0; } #widget_1689690959169 .cr-featuresbox-readmore a { font-size: 18px; color: #19C0EA; text-decoration: none; font-weight: bold; display: flex; justify-content: flex-end; align-items: center; } #widget_1689690959169 .cr-featuresbox-readmore { text-align: center !important; } #widget_1689690959169 .cr-featuresbox-readmore a { display: inline-block !important; } @media all and (max-width: 767px) { #widget_1689690959169 .cr-featuresbox-container { padding: 20px 30px 20px 30px; } #widget_1689690959169 .cr-featuresbox-text { padding-right: 0px; } #widget_1689690959169 .cr-featuresbox-link { align-items: flex-start; } #widget_1689690959169 .cr-featuresbox-headline { padding-right: 0px; } #widget_1689690959169 .cr-featuresbox-link svg { margin-top: 24px; } #widget_1689690959169 .cr-featuresbox-headline h3 { font-size: 22px; padding-right: 30px; } } </style> <div class="cr-featuresbox-container "> <div class="cr-featuresbox-headline"> <h3>Full-text search and real-time indexing</h3> </div> <div class="cr-featuresbox-text"> <p>Perform quick and accurate searches across various data types, including <a href="/product/features/full-text-search" rel="noopener">text</a>, <a href="/solutions/json-database" rel="noopener">documents</a>, and other unstructured data with robust <a href="/product/features/full-text-search" rel="noopener">full-text search capabilities</a> and <a href="/product/features/indexing-columnar-storage-aggregations" rel="noopener">real-time indexing</a>. CrateDB's fully distributed query engine is built on top of <a href="https://lucene.apache.org/" rel="noopener">Apache Lucene®. </a>To use full-text search, a full-text index with an analyzer must be created when setting up the column, allowing the text to be broken down into searchable tokens. Once this is done, full-text search queries can be run based on the index.</p> </div> <div class="cr-featuresbox-icon"> <img src="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png" alt="cr-quote-image" loading="" width="512" height="512" srcset="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=256&height=256&name=cr-quote-image.png 256w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png 512w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=768&height=768&name=cr-quote-image.png 768w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1024&height=1024&name=cr-quote-image.png 1024w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1280&height=1280&name=cr-quote-image.png 1280w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1536&height=1536&name=cr-quote-image.png 1536w" sizes="(max-width: 512px) 100vw, 512px"> </div> </div> <div class="cr-featuresbox-container "> <div class="cr-featuresbox-headline"> <h3>Support for complex querying</h3> </div> <div class="cr-featuresbox-text"> <p>Perform complex search queries effortlessly using CrateDB's support for advanced techniques, including Boolean logic, wildcard searches, phrase searches, proximity searches, and fuzzy search capabilities. Experience precise and versatile querying options that accommodate variations, ensuring accurate results across diverse search requirements.</p> </div> <div class="cr-featuresbox-icon"> <img src="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png" alt="cr-quote-image" loading="" width="512" height="512" srcset="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=256&height=256&name=cr-quote-image.png 256w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png 512w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=768&height=768&name=cr-quote-image.png 768w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1024&height=1024&name=cr-quote-image.png 1024w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1280&height=1280&name=cr-quote-image.png 1280w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1536&height=1536&name=cr-quote-image.png 1536w" sizes="(max-width: 512px) 100vw, 512px"> </div> </div> <div class="cr-featuresbox-container "> <div class="cr-featuresbox-headline"> <h3>Scalable, high-performance, and distributed search engine</h3> </div> <div class="cr-featuresbox-text"> <p>Scale your search operations effortlessly with CrateDB's <a href="/product/features/query-performance" rel="noopener">high-performance</a> and <a href="/product/features/speed-and-scalability" rel="noopener">scalable architecture</a>, ensuring <a href="/product/features/indexing-columnar-storage-aggregations" rel="noopener">rapid indexing</a> and retrieval of search results even when dealing with high volumes of data. Its <a href="/product/features/shared-nothing-architecture" rel="noopener">distributed shared-nothing architecture</a> enables executing <a href="/product/features/full-text-search" rel="noopener">distributed full-text searches</a> efficiently across diverse datasets and horizontal scaling to accommodate growing search requirements. </p> </div> <div class="cr-featuresbox-icon"> <img src="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png" alt="cr-quote-image" loading="lazy" width="512" height="512" style="max-width: 100%; height: auto;" srcset="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=256&height=256&name=cr-quote-image.png 256w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png 512w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=768&height=768&name=cr-quote-image.png 768w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1024&height=1024&name=cr-quote-image.png 1024w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1280&height=1280&name=cr-quote-image.png 1280w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1536&height=1536&name=cr-quote-image.png 1536w" sizes="(max-width: 512px) 100vw, 512px"> </div> </div> <div class="cr-featuresbox-container "> <div class="cr-featuresbox-headline"> <h3>Real-time analytics and data ingestion</h3> </div> <div class="cr-featuresbox-text"> <p>Utilize <a href="/solutions/real-time-analytics-database" rel="noopener">real-time data ingestion and analysis</a>, enabling continuous updates and immediate availability of new data in search results.</p> </div> <div class="cr-featuresbox-icon"> <img src="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png" alt="cr-quote-image" loading="lazy" width="512" height="512" style="max-width: 100%; height: auto;" srcset="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=256&height=256&name=cr-quote-image.png 256w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png 512w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=768&height=768&name=cr-quote-image.png 768w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1024&height=1024&name=cr-quote-image.png 1024w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1280&height=1280&name=cr-quote-image.png 1280w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1536&height=1536&name=cr-quote-image.png 1536w" sizes="(max-width: 512px) 100vw, 512px"> </div> </div> <div class="cr-featuresbox-container "> <div class="cr-featuresbox-headline"> <h3>High availability and fault tolerance</h3> </div> <div class="cr-featuresbox-text"> <p>Ensure<a href="/product/features/high-availability" rel="noopener"> high availability</a> of search functionalities with a <a href="/product/features/fault-tolerance" rel="noopener">fault-tolerant design</a>. CrateDB’s built-in mechanisms for <a href="/product/features/data-replication" rel="noopener">automatic failover and replication</a> prevent downtime and ensure uninterrupted search operations.</p> </div> <div class="cr-featuresbox-icon"> <img src="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png" alt="cr-quote-image" loading="lazy" width="512" height="512" style="max-width: 100%; height: auto;" srcset="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=256&height=256&name=cr-quote-image.png 256w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png 512w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=768&height=768&name=cr-quote-image.png 768w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1024&height=1024&name=cr-quote-image.png 1024w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1280&height=1280&name=cr-quote-image.png 1280w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1536&height=1536&name=cr-quote-image.png 1536w" sizes="(max-width: 512px) 100vw, 512px"> </div> </div> <div class="cr-featuresbox-container "> <div class="cr-featuresbox-headline"> <h3>Easy and seamless integration</h3> </div> <div class="cr-featuresbox-text"> <p>Integrate with various programming languages, frameworks, and tools with <a href="/product/features/native-sql" rel="noopener">native SQL</a> and the <a href="/product/features/postgresql-wire-protocol" rel="noopener">PostgreSQL Wire Protocol</a>. Seamlessly integrate CrateDB with various analytical tools, merging search capabilities with analytical processing for comprehensive insights into search results and data patterns. Customize and expand search functionalities using CrateDB's extensible plugin ecosystem, integrating additional modules or third-party plugins as per specific search requirements.<br><br><a href="/integrations" rel="noopener">View a sample list of integrations ></a></p> </div> <div class="cr-featuresbox-icon"> <img src="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png" alt="cr-quote-image" loading="lazy" width="512" height="512" style="max-width: 100%; height: auto;" srcset="https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=256&height=256&name=cr-quote-image.png 256w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=512&height=512&name=cr-quote-image.png 512w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=768&height=768&name=cr-quote-image.png 768w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1024&height=1024&name=cr-quote-image.png 1024w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1280&height=1280&name=cr-quote-image.png 1280w, https://cratedb.com/hs-fs/hubfs/cr-quote-image.png?width=1536&height=1536&name=cr-quote-image.png 1536w" sizes="(max-width: 512px) 100vw, 512px"> </div> </div> <div class="cr-featuresbox-readmore"> <a class="hs-button" href="https://cratedb.com/database"> Learn more about the database </a> </div> </div></div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-7 dnd-section dnd_area-row-3-padding dnd_area-row-3-vertical-alignment"> <div class="row-fluid "> <div class="span6 widget-span widget-type-cell dnd-column cell_16965990352872-vertical-alignment" style="" data-widget-type="cell" data-x="0" data-w="6"> <div class="row-fluid-wrapper row-depth-1 row-number-8 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_16965990352875" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module widget-type-rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="advanced-richtext body_text_regular"> <span id="hs_cos_wrapper_module_16965990352875_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="rich_text"><h3>CrateDB: A database or a search engine? Both!</h3> <p>Learn from Marija Selaković, Developer Advocate at CrateDB, how to get all the benefits of traditional databases while utilizing the scalability and efficiency of a distributed search engine.</p></span> </div></div> </div> </div> </div> </div> <div class="span6 widget-span widget-type-cell cell_16965990352873-padding dnd-column cell_16965990352873-vertical-alignment" style="" data-widget-type="cell" data-x="6" data-w="6"> <div class="row-fluid-wrapper row-depth-1 row-number-9 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_16965990352877" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"> <div class="oembed_container " id="oembed_container-module_16965990352877"> <button class="oembed_custom-thumbnail" style="background-image:url(https://cratedb.com/hubfs/WeAreDevelopers-Marija.png)"> <span class="oembed-info">Video player - WeAreDevelopers World Congress. CrateDB: A Database or a Search Engine? Both! - Click to play video</span> <div class="oembed_custom-thumbnail_icon"> <svg viewbox="0 0 135.39 149.4"><path d="M371.2,398.69l-127.79,71c-1.47.83-2.74.93-3.8.28a3.69,3.69,0,0,1-1.59-3.46V324.88a3.73,3.73,0,0,1,1.59-3.47,3.66,3.66,0,0,1,3.8.29l127.79,71c1.47.84,2.21,1.82,2.21,3S372.67,397.85,371.2,398.69Z" transform="translate(-238.02 -321)"></path></svg> </div> </button> <div class="iframe_wrapper" data-embed-response-html="<iframe width="200" height="113" src="https://www.youtube.com/embed/_ADCQ7OuJ1w?feature=oembed" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" allowfullscreen title="CrateDB: A Database or a Search Engine? Both!"></iframe>" data-embed-response-width="200" data-embed-response-height="113" data-embed-url="https://youtu.be/_ADCQ7OuJ1w" data-max-height="339" data-max-width="600"> </div> </div> </div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-10 dnd-section dnd_area-row-4-padding dnd_area-row-4-vertical-alignment"> <div class="row-fluid "> <div class="span6 widget-span widget-type-cell cell_1717416204772-vertical-alignment dnd-column" style="" data-widget-type="cell" data-x="0" data-w="6"> <div class="row-fluid-wrapper row-depth-1 row-number-11 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_17174162025917" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"> <div class="hs-video-widget" data-hsv-embed-id="04165b8b-f1cc-4d17-839d-28ccf18006c7"> <div class="hs-video-container" style="max-width: 600px; margin: 0 auto;"> <div class="hs-video-wrapper" style="position: relative; height: 0; padding-bottom: 56.33%"> <iframe data-hsv-src="https://play.hubspotvideo.com/v/19927462/id/140979442490?play_button_color=19c0ea" referrerpolicy="origin" sandbox="allow-forms allow-scripts allow-same-origin allow-popups" allow="autoplay; fullscreen;" style="position: absolute !important; width: 100% !important; height: 100% !important; left: 0; top: 0; border: 0 none; pointer-events: initial" title="HubSpot Video" loading="lazy" data-hsv-id="140979442490" data-hsv-play-button-color="19c0ea" data-hsv-width="600" data-hsv-height="338" data-hsv-full-width="false"></iframe> </div> </div> </div> </div> </div> </div> </div> </div> <div class="span6 widget-span widget-type-cell cell_17174162025912-vertical-alignment dnd-column" style="" data-widget-type="cell" data-x="6" data-w="6"> <div class="row-fluid-wrapper row-depth-1 row-number-12 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_17174162025915" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module widget-type-rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="advanced-richtext body_text_regular"> <span id="hs_cos_wrapper_module_17174162025915_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="rich_text"><h3>CrateDB workshop</h3> <p>Learn how from Karyn Azevedo, Solution Engineer at CrateDB, how to modeling you data in CrateDB.<br><br><em>Timestamp:  25:43–39:27</em></p></span> </div></div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-13 dnd-section dnd_area-row-5-background-layers dnd_area-row-5-padding dnd_area-row-5-background-color"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-14 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_16958837752255" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="cr-getstarted-items-wrapper" id="module_16958837752255"> <style> #module_16958837752255.cr-getstarted-items-wrapper { /*max-width: 1760px;*/ margin: 0 auto; } #module_16958837752255 .cr-getstarted-header { margin-bottom: 32px; display: flex; align-items: center; margin-right: 20px; } #module_16958837752255 .cr-getstarted-item { margin-right: 20px; } #module_16958837752255 .cr-getstarted-items { display: flex; flex-direction: row; } #module_16958837752255 .cr-getstarted-header h2 { letter-spacing: -2.04px; color: #0A2327; margin-right: 30px; margin-bottom: 0; font-family: Montserrat, Inter, Arial, sans-serif !important; font-weight: 600; } #module_16958837752255 .cr-getstarted-header svg { height: 50px; width: auto; } #module_16958837752255 .cr-getstarted-container.cr-gestarted-inline { display: flex; align-items: center; /*justify-content: space-between;*/ } #module_16958837752255 .cr-gestarted-inline .cr-getstarted-header, #module_16958837752255 .cr-gestarted-inline .cr-getstarted-header h2 { margin-bottom: 0px; } @media all and (max-width: 767px) { #module_16958837752255 .cr-getstarted-container.cr-gestarted-inline { display: block; } #module_16958837752255 .cr-gestarted-inline .cr-getstarted-header { margin-bottom: 20px; } #module_16958837752255 .cr-gestarted-inline .cr-getstarted-header h2 { margin-bottom: 12px; } #module_16958837752255 .cr-getstarted-header svg { height: 30px; margin-bottom: 12px; } } </style> <div class="cr-getstarted-container cr-gestarted-inline"> <div class="cr-getstarted-header"> <h2>Curious to learn more?</h2> </div> <div class="cr-getstarted-items"> <div class="cr-getstarted-item"> <div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="178354041242"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLLJ2fYtuisS6upchjYnFUMioD42cAqgEegnt3kQGe4xeqtdi9DMaB7GxLBxBHrHrv6GBnKYkmXvVXiK7LF%2FpfRtylwh%2FTzzkRzROz050BPrfs%2FLahkmb74ko3Zk70ABDL0Z0vwh6dpz6t6ouKwE8THbfIPF8qvzEKvkU05rTB4vSQ%3D%3D&portalId=19927462" target="_blank" rel="noopener" class="hs-inline-web-interactive-178354041242 hs-button " data-hubspot-cta-id="178354041242"> Start free </a> </div> </div> <div class="cr-getstarted-item"> <div class="hs-web-interactive-inline" style="" data-hubspot-wrapper-cta-id="178354187893"> <a href="https://cta-service-cms2.hubspot.com/web-interactives/public/v1/track/click?encryptedPayload=AVxigLJGHG2p3DrfPDYxmBgP02fw4GVz%2BC0HVp9F%2FgZN6UbFZ%2Bx%2FGYCTkGtSsxZ8E8C5nuQ8Ee9Qx2JQgimQGTvHqWBbr5U4SPElO01wmFIO75Kdqb5bcm5xvp0HAEA1J1FvLtGc9nk8ZyvG%2FT3tnPx5qX%2Fv4fqu81EU6o5BnBEmdw%3D%3D&portalId=19927462" target="_blank" rel="noopener" class="hs-inline-web-interactive-178354187893 hs-button " data-hubspot-cta-id="178354187893"> Contact us </a> </div> </div> </div> </div> </div></div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-15 dnd_area-row-6-padding dnd-section"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-16 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_16982270852587" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><style> #module_16982270852587 h2.cr-headline { font-size: 30px; letter-spacing: -1.7px; margin-right: 20px; margin-bottom: 40px; font-family: Montserrat, Inter, Arial, sans-serif !important; font-weight: 600; line-height: 1.3; } h3.cr-subheadline { font-style: normal; font-weight: 400; font-size: 20px; line-height: 1.3; color: #000; margin-top: 4px; margin-bottom: 0; } @media all and (max-width: 767px) { #module_16982270852587 h2.cr-headline { font-size: 20px; margin-bottom: 20px; } h3.cr-subheadline { font-size: 18px; } } </style> <h2 id="module_16982270852587" class="cr-headline" style="">Other resources on full-text search</h2> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-17 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_16982270852588" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><style> #module_16982270852588{ } #module_16982270852588 h1 { color: ; } </style> <div class="cr-relatedcontent" id="module_16982270852588"> <div class="content-wrapper"> <div class="cr-relatedcontent-cards"> <div class="cr-relatedcontent-slider-slide"> <div class="cr-relatedcontent-slider-tag"> <h3>Documentation</h3> </div> <div class="cr-relatedcontent-slider-headline"> <h3> <a href="/docs/crate/reference/en/latest/general/ddl/fulltext-indices.html"> Fulltext indices</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_module_16982270852588_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="content"></div> </div> </div> </div> <div class="cr-relatedcontent-slider-slide"> <div class="cr-relatedcontent-slider-tag"> <h3>Documentation</h3> </div> <div class="cr-relatedcontent-slider-headline"> <h3> <a href="/docs/crate/reference/en/latest/general/dql/fulltext.html"> Fulltext search</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_module_16982270852588_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="content"></div> </div> </div> </div> <div class="cr-relatedcontent-slider-slide"> <div class="cr-relatedcontent-slider-tag"> <h3>Blog</h3> </div> <div class="cr-relatedcontent-slider-headline"> <h3> <a href="https://cratedb.com/blog/indexing-and-storage-in-cratedb" target="_blank" rel="noopener"> Indexing and Storage</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_module_16982270852588_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="content"></div> </div> </div> </div> <div class="cr-relatedcontent-slider-slide"> <div class="cr-relatedcontent-slider-tag"> <h3>Blog</h3> </div> <div class="cr-relatedcontent-slider-headline"> <h3> <a href="https://cratedb.com/blog/handling-dynamic-objects-in-cratedb"> Handling Dynamic Objects in CrateDB</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_module_16982270852588_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="content"></div> </div> </div> </div> <div class="cr-relatedcontent-slider-slide"> <div class="cr-relatedcontent-slider-tag"> <h3>Workshop</h3> </div> <div class="cr-relatedcontent-slider-headline"> <h3> <a href="https://youtu.be/bD_gJX7F9g8?feature=shared"> Modeling Data in CrateDB</a> </h3> <div class="cr-relatedcontent-slider-content"> <div id="hs_cos_wrapper_module_16982270852588_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="content"></div> </div> </div> </div> </div> </div> </div></div> </div> </div> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-18 dnd_area-row-7-background-color dnd_area-row-7-background-layers dnd-section dnd_area-row-7-padding"> <div class="row-fluid "> <div class="span12 widget-span widget-type-cell dnd-column" style="" data-widget-type="cell" data-x="0" data-w="12"> <div class="row-fluid-wrapper row-depth-1 row-number-19 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_17218108157376" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><style> #module_17218108157376 h2.cr-headline { font-size: 30px; letter-spacing: -1.7px; margin-right: 20px; margin-bottom: 40px; font-family: Montserrat, Inter, Arial, sans-serif !important; font-weight: 600; line-height: 1.3; } h3.cr-subheadline { font-style: normal; font-weight: 400; font-size: 20px; line-height: 1.3; color: #000; margin-top: 4px; margin-bottom: 0; } @media all and (max-width: 767px) { #module_17218108157376 h2.cr-headline { font-size: 20px; margin-bottom: 20px; } h3.cr-subheadline { font-size: 18px; } } </style> <h2 id="module_17218108157376" class="cr-headline" style="">FAQ</h2> </div> </div> </div> </div> <div class="row-fluid-wrapper row-depth-1 row-number-20 dnd-row"> <div class="row-fluid "> <div class="span12 widget-span widget-type-custom_widget dnd-module" style="" data-widget-type="custom_widget" data-x="0" data-w="12"> <div id="hs_cos_wrapper_module_17218108157377" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><div class="hs-accordion hs-accordion-regular cr-accordion " itemscope itemtype="https://schema.org/FAQPage"> <div class="hs-accordion__item " aria-expanded="" itemscope itemprop="mainEntity" itemtype="https://schema.org/Question"> <button type="button" itemprop="name"> What is full-text search in a database? <span class="hs-accordion__item-icon"></span> </button> <main role="region" itemscope itemprop="acceptedAnswer" itemtype="https://schema.org/Answer"> <div class="hs-accordion__item-content" itemprop="text"> <p>Full-text search indexes the entire textual content of documents, articles, or records, making all text fields searchable. This allows users to perform comprehensive searches across large volumes of unstructured or semi-structured text. CrateDB enhances this functionality with its <a href="/product/features/query-performance" rel="noopener">high-performance</a>, <a href="/product/features/speed-and-scalability" rel="noopener">scalable architecture</a>, ensuring <a href="/product/features/indexing-columnar-storage-aggregations" rel="noopener">rapid indexing</a> and efficient retrieval even with substantial data volumes. </p> </div> </main> </div> <div class="hs-accordion__item " aria-expanded="" itemscope itemprop="mainEntity" itemtype="https://schema.org/Question"> <button type="button" itemprop="name"> What the different full-text search techniques? <span class="hs-accordion__item-icon"></span> </button> <main role="region" itemscope itemprop="acceptedAnswer" itemtype="https://schema.org/Answer"> <div class="hs-accordion__item-content" itemprop="text"> <p>Full-text search techniques include boolean logic, wildcard searches, phrase searches, proximity searches, and fuzzy searches, which enhance the depth and accuracy of search results. CrateDB leverages these capabilities to provide robust full-text search functionality with <a href="/product/features/indexing-columnar-storage-aggregations" rel="noopener">real-time indexing</a> and <a href="/product/features/query-performance" rel="noopener">efficient query performance</a>.</p> </div> </main> </div> <div class="hs-accordion__item " aria-expanded="" itemscope itemprop="mainEntity" itemtype="https://schema.org/Question"> <button type="button" itemprop="name"> Which database is best for full-text search? <span class="hs-accordion__item-icon"></span> </button> <main role="region" itemscope itemprop="acceptedAnswer" itemtype="https://schema.org/Answer"> <div class="hs-accordion__item-content" itemprop="text"> <p>Full-text search databases allow users to search for words throughout the entire text body of documents, enhancing research depth and precision. Examples of databases optimized for full-text search include CrateDB, MongoDB, Elasticsearch, and PostgreSQL. CrateDB's distributed shared-nothing architecture is built on top of Apache Lucene and excels in performing efficient distributed full-text searches across diverse datasets, ensuring <a href="/product/features/speed-and-scalability" rel="noopener">scalability</a> to meet growing search demands.</p> </div> </main> </div> </div></div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> <input type="hidden" name="breadcrumb" value=""> </main> <div data-global-resource-path="sf2-crate/templates/partials/footer-landify.html"> <footer class="footer" id="cr-footer"> <div class="footer-overlay-color" style="background-color: transparent;"> <div class="footer__container content-wrapper footer_firstrow"> <div class="row-fluid"> <div class="span12"> <div class="row-fluid footer-widget"> <div class="span3 footer-widget-content"> <div class="footer_logo"> <img src="https://cratedb.com/hubfs/19927462/CrateDB-logo-blue-white.svg" class="hs-image-widget" loading="lazy" style="width:154px;border-width:0px;border:0px;" alt="CrateDB Logo" title="White CrateDB Logo" width="154" height="22"> </div> <div class="footer__social"> <div id="hs_cos_wrapper_footer_social" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><style> .social-links { -webkit-box-align: center; -ms-flex-align: center; align-items: center; display: -webkit-box; display: -ms-flexbox; display: flex; -ms-flex-wrap: wrap; flex-wrap: wrap; -webkit-box-pack: center; -ms-flex-pack: center; justify-content: center; } .social-links__icon { background-color: #494A52; border-radius: 50%; display: -webkit-inline-box; display: -ms-inline-flexbox; display: inline-flex; height: 40px; margin: 0 5px; position: relative; width: 40px; } .social-links__icon:hover, .social-links__icon:focus { background-color: #21222A; } .social-links__icon:active { background-color: #71727A; } .social-links__icon svg { fill: #FFF; height: 15px; left: 50%; position: absolute; top: 50%; -webkit-transform: translate(-50%, -50%); -ms-transform: translate(-50%, -50%); transform: translate(-50%, -50%); width: auto; } .social-links__icon:hover svg, .social-links__icon:focus svg, .social-links__icon:active svg { fill: #FFF; } /* Overrides 2021 -j */ .social-links__icon { height: 25px; width: 25px; margin: 0 8px; } </style> <div class="social-links"> <a class="social-links__link nav-link" href="https://twitter.com/cratedb" target="_blank" rel="noopener"> <span id="hs_cos_wrapper_footer_social_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_icon social-links__icon" style="" data-hs-cos-general-type="widget" data-hs-cos-type="icon"><svg version="1.0" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 512 512" aria-labelledby="X Twitter1" role="img"><title id="X Twitter1">Follow us on Twitter</title><g id="X Twitter1_layer"><path d="M389.2 48h70.6L305.6 224.2 487 464H345L233.7 318.6 106.5 464H35.8L200.7 275.5 26.8 48H172.4L272.9 180.9 389.2 48zM364.4 421.8h39.1L151.1 88h-42L364.4 421.8z" /></g></svg></span> <span class="injected hidden">Follow us on Twitter</span> </a> <a class="social-links__link nav-link" href="https://www.linkedin.com/company/crateio/" target="_blank" rel="noopener"> <span id="hs_cos_wrapper_footer_social__2" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_icon social-links__icon" style="" data-hs-cos-general-type="widget" data-hs-cos-type="icon"><svg version="1.0" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 448 512" aria-labelledby="LinkedIn In2" role="img"><title id="LinkedIn In2">Follow us on GitHub</title><g id="LinkedIn In2_layer"><path d="M100.28 448H7.4V148.9h92.88zM53.79 108.1C24.09 108.1 0 83.5 0 53.8a53.79 53.79 0 0 1 107.58 0c0 29.7-24.1 54.3-53.79 54.3zM447.9 448h-92.68V302.4c0-34.7-.7-79.2-48.29-79.2-48.29 0-55.69 37.7-55.69 76.7V448h-92.78V148.9h89.08v40.8h1.3c12.4-23.5 42.69-48.3 87.88-48.3 94 0 111.28 61.9 111.28 142.3V448z" /></g></svg></span> <span class="injected hidden">Follow us on GitHub</span> </a> <a class="social-links__link nav-link" href="https://www.youtube.com/@CrateDB" target="_blank" rel="noopener"> <span id="hs_cos_wrapper_footer_social__3" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_icon social-links__icon" style="" data-hs-cos-general-type="widget" data-hs-cos-type="icon"><svg version="1.0" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 576 512" aria-labelledby="YouTube3" role="img"><title id="YouTube3">Follow us on YouTube</title><g id="YouTube3_layer"><path d="M549.655 124.083c-6.281-23.65-24.787-42.276-48.284-48.597C458.781 64 288 64 288 64S117.22 64 74.629 75.486c-23.497 6.322-42.003 24.947-48.284 48.597-11.412 42.867-11.412 132.305-11.412 132.305s0 89.438 11.412 132.305c6.281 23.65 24.787 41.5 48.284 47.821C117.22 448 288 448 288 448s170.78 0 213.371-11.486c23.497-6.321 42.003-24.171 48.284-47.821 11.412-42.867 11.412-132.305 11.412-132.305s0-89.438-11.412-132.305zm-317.51 213.508V175.185l142.739 81.205-142.739 81.201z" /></g></svg></span> <span class="injected hidden">Follow us on YouTube</span> </a> <a class="social-links__link nav-link" href="https://github.com/crate/crate" target="_blank" rel="noopener"> <span id="hs_cos_wrapper_footer_social__4" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_icon social-links__icon" style="" data-hs-cos-general-type="widget" data-hs-cos-type="icon"><svg version="1.0" xmlns="http://www.w3.org/2000/svg" viewbox="0 0 496 512" aria-labelledby="GitHub4" role="img"><title id="GitHub4">Follow us on GitHub</title><g id="GitHub4_layer"><path d="M165.9 397.4c0 2-2.3 3.6-5.2 3.6-3.3.3-5.6-1.3-5.6-3.6 0-2 2.3-3.6 5.2-3.6 3-.3 5.6 1.3 5.6 3.6zm-31.1-4.5c-.7 2 1.3 4.3 4.3 4.9 2.6 1 5.6 0 6.2-2s-1.3-4.3-4.3-5.2c-2.6-.7-5.5.3-6.2 2.3zm44.2-1.7c-2.9.7-4.9 2.6-4.6 4.9.3 2 2.9 3.3 5.9 2.6 2.9-.7 4.9-2.6 4.6-4.6-.3-1.9-3-3.2-5.9-2.9zM244.8 8C106.1 8 0 113.3 0 252c0 110.9 69.8 205.8 169.5 239.2 12.8 2.3 17.3-5.6 17.3-12.1 0-6.2-.3-40.4-.3-61.4 0 0-70 15-84.7-29.8 0 0-11.4-29.1-27.8-36.6 0 0-22.9-15.7 1.6-15.4 0 0 24.9 2 38.6 25.8 21.9 38.6 58.6 27.5 72.9 20.9 2.3-16 8.8-27.1 16-33.7-55.9-6.2-112.3-14.3-112.3-110.5 0-27.5 7.6-41.3 23.6-58.9-2.6-6.5-11.1-33.3 2.6-67.9 20.9-6.5 69 27 69 27 20-5.6 41.5-8.5 62.8-8.5s42.8 2.9 62.8 8.5c0 0 48.1-33.6 69-27 13.7 34.7 5.2 61.4 2.6 67.9 16 17.7 25.8 31.5 25.8 58.9 0 96.5-58.9 104.2-114.8 110.5 9.2 7.9 17 22.9 17 46.4 0 33.7-.3 75.4-.3 83.6 0 6.5 4.6 14.4 17.3 12.1C428.2 457.8 496 362.9 496 252 496 113.3 383.5 8 244.8 8zM97.2 352.9c-1.3 1-1 3.3.7 5.2 1.6 1.6 3.9 2.3 5.2 1 1.3-1 1-3.3-.7-5.2-1.6-1.6-3.9-2.3-5.2-1zm-10.8-8.1c-.7 1.3.3 2.9 2.3 3.9 1.6 1 3.6.7 4.3-.7.7-1.3-.3-2.9-2.3-3.9-2-.6-3.6-.3-4.3.7zm32.4 35.6c-1.6 1.3-1 4.3 1.3 6.2 2.3 2.3 5.2 2.6 6.5 1 1.3-1.3.7-4.3-1.3-6.2-2.2-2.3-5.2-2.6-6.5-1zm-11.4-14.7c-1.6 1-1.6 3.6 0 5.9 1.6 2.3 4.3 3.3 5.6 2.3 1.6-1.3 1.6-3.9 0-6.2-1.4-2.3-4-3.3-5.6-2z" /></g></svg></span> <span class="injected hidden">Follow us on GitHub</span> </a> </div></div> </div> </div> <div id="hs_cos_wrapper_module_16142721378942" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"> <div class="span3 footer-widget-content"> <h3 class="footer-menu-title"> Company </h3> <div id="hs_cos_wrapper_module_16142721378942_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="footer_menu_1.footer_menu"><ul> <li><a class="nav-link" href="https://cratedb.com/company/leadership" rel="noopener">Leadership</a></li> <li><a class="nav-link" href="https://cratedb.com/company/team" rel="noopener">Team</a></li> <li><a class="nav-link" href="https://cratedb.com/company/investors" rel="noopener">Investors</a></li> <li><a class="nav-link" href="https://cratedb.com/company/career" rel="noopener">Career</a></li> <li><a class="nav-link" href="https://cratedb.com/event" rel="noopener">Events</a></li> <li><a class="nav-link" href="https://cratedb.com/press" rel="noopener">Newsroom</a></li> <li><a class="nav-link" href="https://cratedb.com/company/media-kit" rel="noopener">Media kit</a></li> </ul></div> </div> <div class="span3 footer-widget-content"> <h3 class="footer-menu-title"> Ecosystem </h3> <div id="hs_cos_wrapper_module_16142721378942_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="footer_menu_2.footer_menu"><ul> <li><a class="nav-link" href="https://cratedb.com/partners" rel="noopener">Partners</a></li> <li><a class="nav-link" href="https://cratedb.com/product/editions/startups" rel="noopener">Startups</a></li> <li><a class="nav-link" href="https://cratedb.com/integrations" rel="noopener">Integrations</a></li> </ul></div> </div> <div class="span3 footer-widget-content"> <h3 class="footer-menu-title"> Contact </h3> <div id="hs_cos_wrapper_module_16142721378942_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_inline_rich_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="inline_rich_text" data-hs-cos-field="footer_menu_3.footer_menu"><ul> <li><a class="nav-link" href="https://cratedb.com/contact" rel="noopener">Contact us</a></li> <li><a class="nav-link" href="https://cratedb.com/contact/offices" rel="noopener">Offices</a></li> <li><a class="nav-link" href="https://cratedb.com/database/security#contact" rel="noopener">Security</a></li> <li><a class="nav-link" href="https://cratedb.com/support" rel="noopener">Support</a></li> </ul></div> </div> </div> </div> </div> </div> </div> </div> <div class="footer-second-row-overlay" style="background-color: transparent;"> <div class="footer__container content-wrapper footer_copyright"> <div class="footer__copyright"> <div id="hs_cos_wrapper_footer_copyright_text" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_module widget-type-text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="module"><span id="hs_cos_wrapper_footer_copyright_text_" class="hs_cos_wrapper hs_cos_wrapper_widget hs_cos_wrapper_type_text" style="" data-hs-cos-general-type="widget" data-hs-cos-type="text">© 2024 CrateDB. All rights reserved.</span></div> </div> <div class="hs_cos_wrapper_widget"> <ul> <li> | </li> <li><a href="/legal" class="nav-link">Legal</a> | </li> <li><a href="/legal/privacy-policy" class="nav-link">Privacy Policy</a> | </li> <li><a href="/legal/imprint" class="nav-link">Imprint</a></li> </ul> </div> </div> </div> </footer> </div> </div>  <script defer src="/hs/hsstatic/content-cwv-embed/static-1.1293/embed.js"></script> <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/template_assets/52694035002/1710167292109/sf2-crate/js/main.min.js"></script> <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/template_assets/103135878028/1676853638526/sf2-crate/js/prism-core.min.js"></script> <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/template_assets/103135878026/1676853638465/sf2-crate/js/prism-autoloader.min.js"></script> <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/template_assets/53645044755/1688038947921/sf2-crate/js/prism.min.js"></script> <script> var hsVars = hsVars || {}; hsVars['language'] = 'en'; </script> <script src="/hs/hsstatic/cos-i18n/static-1.53/bundles/project.js"></script> <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/52694764069/1701097527096/module_52694764069_menu-section.min.js"></script> <script src="https://cdn2.hubspot.net/hub/-1/hub_generated/module_assets/-35056501883/1732641105613/module_-35056501883_Video.min.js"></script>  <script async data-hs-portal-id="19927462" data-hs-ignore="true" data-cookieconsent="ignore" data-hs-page-id="147538685531" src="https://static.hsappstatic.net/video-embed/ex/loader.js"></script>  <script defer src="https://js.hubspot.com/web-interactives-embed.js" type="text/javascript" id="hubspot-web-interactives-loader" data-loader="hs-previewer" data-hsjs-portal="19927462" data-hsjs-env="prod" data-hsjs-hublet="na1"></script>  <script src="https://cratedb.com/hs-fs/hub/19927462/hub_generated/module_assets/91968152433/1731315228445/module_91968152433_Accordion_22.min.js"></script>  <script type="text/javascript"> var _hsq = _hsq || []; _hsq.push(["setContentType", "standard-page"]); _hsq.push(["setCanonicalUrl", "https:\/\/cratedb.com\/data-model\/full-text"]); _hsq.push(["setPageId", "147538685531"]); _hsq.push(["setContentMetadata", { "contentPageId": 147538685531, "legacyPageId": "147538685531", "contentFolderId": null, "contentGroupId": null, "abTestId": null, "languageVariantId": 147538685531, "languageCode": "en", }]); </script> <script type="text/javascript" id="hs-script-loader" async defer src="/hs/scriptloader/19927462.js"></script>  <script type="text/javascript"> var hsVars = { render_id: "3011e3a9-79ef-4aac-ac4e-098874c947aa", ticks: 1732645736266, page_id: 147538685531, content_group_id: 0, portal_id: 19927462, app_hs_base_url: "https://app.hubspot.com", cp_hs_base_url: "https://cp.hubspot.com", language: "en", analytics_page_type: "standard-page", scp_content_type: "", analytics_page_id: "147538685531", category_id: 1, folder_id: 0, is_hubspot_user: false } </script> <script defer src="/hs/hsstatic/HubspotToolsMenu/static-1.354/js/index.js"></script> <script type="text/javascript"> // Log the analytics category consent status of the current visitor to the console var _hsp = window._hsp = window._hsp || []; // analytics _hsp.push(['addPrivacyConsentListener', function(consent) { if (consent.categories.analytics == true) { //console.log("analytics cookies enabled"); /* clarity */ (function(c,l,a,r,i,t,y){ c[a]=c[a]||function(){(c[a].q=c[a].q||[]).push(arguments)}; t=l.createElement(r);t.async=1;t.src="https://www.clarity.ms/tag/"+i; y=l.getElementsByTagName(r)[0];y.parentNode.insertBefore(t,y); })(window, document, "clarity", "script", "dyojgmowl8"); } }]); // advertisement _hsp.push(['addPrivacyConsentListener', function(consent) { if (consent.categories.advertisement == true) { //console.log("advertisement cookies enabled"); //Google Tag Manager set ad_storage window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} // Update Tagmanager to grant consent for Ads trigger gtag('consent', 'update', { 'ad_user_data': 'granted', 'ad_personalization': 'granted', 'ad_storage': 'granted', 'analytics_storage': 'granted' }); //End Google Tag Manager } }]); // functionality _hsp.push(['addPrivacyConsentListener', function(consent) { if (consent.categories.functionality == true) { //console.log("functionality cookies enabled"); } }]); </script> </body></html>

CINXE.COM

Open Source Full-text Search Engine Database