' + col.title + '

' + link[0] + '

'; if (col.subsection) { html += '

' + col.subsection.title + '

' + link[0] + '

'; } html += '

'; return html; } function injectStyles() { if (document.getElementById('ch-footer-styles')) return; var style = document.createElement('style'); style.id = 'ch-footer-styles'; style.textContent = '' + '#' + FOOTER_ID + ' { box-sizing: border-box; font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, sans-serif; }' // On desktop the sidebar is fixed at 19rem wide; match #content-container's // horizontal padding (pl-[32px] / pr-[32px]) so the footer's inner edges // align with the content area used by both doc pages and the home page. + '@media (min-width: 1024px) { #' + FOOTER_ID + ' { padding-left: calc(19rem + 32px) !important; padding-right: 32px !important; } }' + '#' + FOOTER_ID + ' [data-inner] { max-width: 1280px; margin: 0 auto; }' + '#' + FOOTER_ID + ' * { box-sizing: border-box; }' + '#' + FOOTER_ID + ' a { text-decoration: none; transition: color 0.15s, border-color 0.15s; }' // Top section: sitemap + CTA side by side only at wide viewports + '#' + FOOTER_ID + ' [data-top] { display: flex; flex-direction: column; gap: 32px; padding-bottom: 48px; }' + '@media (min-width: 1400px) { #' + FOOTER_ID + ' [data-top] { flex-direction: row; gap: 40px; } }' // Sitemap grid: 2 cols default, 3 at md, 5 only when side-by-side + '#' + FOOTER_ID + ' [data-sitemap] { display: grid; grid-template-columns: repeat(2, 1fr); gap: 24px; flex: 1; min-width: 0; }' + '@media (min-width: 768px) { #' + FOOTER_ID + ' [data-sitemap] { grid-template-columns: repeat(3, 1fr); } }' + '@media (min-width: 1400px) { #' + FOOTER_ID + ' [data-sitemap] { grid-template-columns: repeat(5, 1fr); } }' // Column headings + '#' + FOOTER_ID + ' [data-sitemap] h3 { font-size: 13px; font-weight: 600; margin: 0 0 12px; }' + '#' + FOOTER_ID + ' [data-sitemap] .ch-sub-heading { margin-top: 24px; }' + '#' + FOOTER_ID + ' [data-sitemap] ul { list-style: none; margin: 0; padding: 0; display: flex; flex-direction: column; gap: 8px; }' + '#' + FOOTER_ID + ' [data-sitemap] a { font-size: 13px; }' // CTA column + '#' + FOOTER_ID + ' [data-cta] { display: flex; flex-direction: column; }' + '@media (min-width: 1400px) { #' + FOOTER_ID + ' [data-cta] { width: 300px; flex-shrink: 0; } }' + '#' + FOOTER_ID + ' [data-cta] p { font-size: 13px; line-height: 1.5; margin: 0 0 20px; }' + '#' + FOOTER_ID + ' [data-cta] form { display: flex; border-radius: 8px; overflow: hidden; margin-bottom: 16px; }' + '#' + FOOTER_ID + ' [data-cta] form input { flex: 1; background: transparent; border: none; padding: 10px 14px; font-size: 13px; outline: none; min-width: 0; }' + '#' + FOOTER_ID + ' [data-cta] form button { background: #fdff75; color: #1c1c1c; border: none; padding: 10px 20px; font-size: 13px; font-weight: 600; cursor: pointer; white-space: nowrap; }' + '#' + FOOTER_ID + ' [data-cta] form button:hover { background: #eaec6a; }' + '#' + FOOTER_ID + ' [data-cta] form button:disabled { cursor: default; opacity: 0.7; }' + '#' + FOOTER_ID + ' .ch-signup-msg { font-size: 12px; margin: 6px 0 0; }' + '#' + FOOTER_ID + ' .ch-signup-success { color: #22c55e; }' + '#' + FOOTER_ID + ' .ch-signup-error { color: #ef4444; }' + '#' + FOOTER_ID + ' [data-gh] { display: inline-flex; align-items: center; justify-content: center; gap: 8px; background: transparent; padding: 10px 20px; border-radius: 8px; font-size: 13px; font-weight: 600; width: 100%; }' + '#' + FOOTER_ID + ' [data-gh]:hover { border-color: #888 !important; }' // Bottom bar + '#' + FOOTER_ID + ' [data-divider] { margin-bottom: 24px; }' + '#' + FOOTER_ID + ' [data-bottom] { display: flex; flex-wrap: wrap; justify-content: space-between; align-items: center; gap: 12px; }' + '#' + FOOTER_ID + ' [data-bottom] a { font-size: 13px; white-space: nowrap; }' + '#' + FOOTER_ID + ' [data-legal] { display: flex; flex-wrap: wrap; gap: 16px; }' + '@media (max-width: 639px) {' + ' #' + FOOTER_ID + ' [data-bottom] { flex-direction: column; text-align: center; }' + ' #' + FOOTER_ID + ' [data-legal] { justify-content: center; }' + '}' // Light mode colors + '#' + FOOTER_ID + ' [data-sitemap] h3 { color: #111; }' + '#' + FOOTER_ID + ' [data-sitemap] a { color: #6b7280; }' + '#' + FOOTER_ID + ' [data-sitemap] a:hover { color: #111; }' + '#' + FOOTER_ID + ' [data-cta] p { color: #6b7280; }' + '#' + FOOTER_ID + ' [data-cta] form { border: 1px solid #d1d5db; }' + '#' + FOOTER_ID + ' [data-cta] form input { color: #111; }' + '#' + FOOTER_ID + ' [data-cta] form input::placeholder { color: #9ca3af; }' + '#' + FOOTER_ID + ' [data-gh] { color: #111; border: 1px solid #d1d5db; }' + '#' + FOOTER_ID + ' [data-divider] { border-top: 1px solid #e5e7eb; }' + '#' + FOOTER_ID + ' [data-copyright] { font-size: 13px; color: #6b7280; }' + '#' + FOOTER_ID + ' [data-bottom] a { color: #6b7280; }' + '#' + FOOTER_ID + ' [data-bottom] a:hover { color: #111; }' + '#' + FOOTER_ID + ' [data-logo] { margin-bottom: 16px; }' + '#' + FOOTER_ID + ' [data-logo] svg * { fill: #111; }' // Dark mode colors + '.dark #' + FOOTER_ID + ' [data-sitemap] h3 { color: #f5f5f5; }' + '.dark #' + FOOTER_ID + ' [data-sitemap] a { color: #a3a3a3; }' + '.dark #' + FOOTER_ID + ' [data-sitemap] a:hover { color: #f5f5f5; }' + '.dark #' + FOOTER_ID + ' [data-cta] p { color: #a3a3a3; }' + '.dark #' + FOOTER_ID + ' [data-cta] form { border-color: #555; }' + '.dark #' + FOOTER_ID + ' [data-cta] form input { color: #fff; }' + '.dark #' + FOOTER_ID + ' [data-cta] form input::placeholder { color: #6b7280; }' + '.dark #' + FOOTER_ID + ' [data-gh] { color: #fff; border-color: #555; }' + '.dark #' + FOOTER_ID + ' [data-divider] { border-color: #333; }' + '.dark #' + FOOTER_ID + ' [data-copyright] { color: #a3a3a3; }' + '.dark #' + FOOTER_ID + ' [data-bottom] a { color: #a3a3a3; }' + '.dark #' + FOOTER_ID + ' [data-bottom] a:hover { color: #f5f5f5; }' + '.dark #' + FOOTER_ID + ' [data-logo] svg * { fill: #fff; }'; document.head.appendChild(style); } function buildFooterHtml() { var year = new Date().getFullYear(); // Build columns HTML var columnsHtml = ''; columns.forEach(function (col) { columnsHtml += buildColumnHtml(col); }); // Build legal links HTML var legalHtml = ''; legalLinks.forEach(function (link) { legalHtml += '' + link[0] + ''; }); return '

' // Top: sitemap grid + CTA column side by side on desktop + '

' + '

' + columnsHtml + '

' + '

' + logoSvg + '

' + '

Stay informed on feature releases, product roadmap, support, and cloud offerings!

' + '' + '' + githubSvg + 'Star us on Github' + '

' + '

' // Divider + '

' // Bottom + '

' + '

' + '\u00A9 ' + year + ' ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.' + '

' + '

' + legalHtml + '

' + '

'; } var mktoScriptLoading = false; var mktoReadyQueue = []; function ensureMarketoScript(callback) { if (window.MktoForms2) { callback(); return; } mktoReadyQueue.push(callback); if (mktoScriptLoading) return; mktoScriptLoading = true; var s = document.createElement('script'); s.src = 'https://discover.clickhouse.com/js/forms2/js/forms2.min.js'; s.onload = function () { var q = mktoReadyQueue.slice(); mktoReadyQueue = []; q.forEach(function (fn) { fn(); }); }; s.onerror = function () { // Reset so a later signup can retry loading the script instead of // enqueuing callbacks that would never run. mktoScriptLoading = false; if (s.parentNode) s.parentNode.removeChild(s); var q = mktoReadyQueue.slice(); mktoReadyQueue = []; q.forEach(function (fn) { fn(new Error('script load failed')); }); }; document.head.appendChild(s); } function submitToMarketo(email, onSuccess, onError) { ensureMarketoScript(function (err) { if (err) { onError(); return; } try { var sink = document.createElement('div'); sink.style.cssText = 'position:absolute;left:-9999px;top:-9999px;width:1px;height:1px;overflow:hidden;'; document.body.appendChild(sink); window.MktoForms2.loadForm('//discover.clickhouse.com', '238-FPC-317', 1122, function (form) { form.vals({ Email: email, 'loc__c': 'docs-footer' }); form.onSuccess(function () { if (sink.parentNode) sink.parentNode.removeChild(sink); onSuccess(); return false; }); form.submit(); }); } catch (e) { onError(); } }); } function attachSignupHandler(footerEl) { var form = footerEl.querySelector('form[data-signup]'); if (!form || form._chBound) return; form._chBound = true; form.addEventListener('submit', function (e) { e.preventDefault(); var input = form.querySelector('input[type="email"]'); var btn = form.querySelector('button[type="submit"]'); var email = (input.value || '').trim(); // Clear previous messages var old = form.parentNode.querySelector('.ch-signup-msg'); if (old) old.parentNode.removeChild(old); if (!email || !/^[^\s@]+@[^\s@]+\.[^\s@]+$/.test(email)) { var errMsg = document.createElement('p'); errMsg.className = 'ch-signup-msg ch-signup-error'; errMsg.textContent = 'Please enter a valid email address.'; form.parentNode.insertBefore(errMsg, form.nextSibling); return; } btn.disabled = true; btn.textContent = 'Signing up…'; // Guard so success/error/timeout only resolve once. Marketo's loadForm // or onSuccess can silently never fire (network/server stall), so a // timeout fallback keeps the button from getting stuck on "Signing up…". var settled = false; var timeoutId = setTimeout(function () { handleError(); }, 10000); function handleSuccess() { if (settled) return; settled = true; clearTimeout(timeoutId); form.style.display = 'none'; var ok = document.createElement('p'); ok.className = 'ch-signup-msg ch-signup-success'; ok.textContent = 'Thanks for subscribing!'; form.parentNode.insertBefore(ok, form.nextSibling); } function handleError() { if (settled) return; settled = true; clearTimeout(timeoutId); btn.disabled = false; btn.textContent = 'Sign up'; var errMsg = document.createElement('p'); errMsg.className = 'ch-signup-msg ch-signup-error'; errMsg.textContent = 'Something went wrong. Please try again.'; form.parentNode.insertBefore(errMsg, form.nextSibling); } submitToMarketo(email, handleSuccess, handleError); }); } function findFooterTarget() { var contentContainer = document.getElementById('content-container'); if (!contentContainer) return null; // Walk up to the nearest block-level ancestor so the footer renders as a // full-width block below the sidebar + content row. Some intermediate // ancestors use display:contents on mobile, so keep walking until we // find a real block-level container. var ancestor = contentContainer.parentElement; while (ancestor && ancestor !== document.body) { if (getComputedStyle(ancestor).display === 'block') { return ancestor; } ancestor = ancestor.parentElement; } return contentContainer; } function ensureFooterAtEnd() { var existing = document.getElementById(FOOTER_ID); if (!existing) return false; var target = findFooterTarget(); // If the target was replaced or the footer drifted, move it to the end of the right parent. if (target && (existing.parentElement !== target || existing !== target.lastElementChild)) { target.appendChild(existing); } return true; } function injectFooter() { // Already injected — just make sure it's still positioned at the end. if (document.getElementById(FOOTER_ID)) { return ensureFooterAtEnd(); } // Find the scrollable content container var contentContainer = document.getElementById('content-container'); if (!contentContainer) return false; // Hide the existing Mintlify footer if present var mintlifyFooter = document.getElementById('footer'); if (mintlifyFooter) { mintlifyFooter.style.display = 'none'; } // Inject styles and create footer injectStyles(); var wrapper = document.createElement('footer'); wrapper.id = FOOTER_ID; wrapper.style.cssText = 'width:100%;padding:64px 24px 32px;'; wrapper.innerHTML = buildFooterHtml(); // In the Maple theme, #content-container is a flex-row, so appending // there makes the footer a horizontal sibling of the content columns. // Walk up to the nearest block-level ancestor so the footer renders as // a full-width block below the sidebar + content row. var target = findFooterTarget() || contentContainer; target.appendChild(wrapper); attachSignupHandler(wrapper); return true; } function init() { injectFooter(); var scheduled = false; var observer; function check() { scheduled = false; var existing = document.getElementById(FOOTER_ID); if (!existing) { injectFooter(); return; } var target = findFooterTarget(); if (!target) return; if (existing.parentElement === target && existing === target.lastElementChild) return; // Disconnect around our own re-append so the resulting mutation doesn't // re-fire the observer mid-React-render, which corrupts the top-nav // dropdown's SVG icons during reconciliation. observer.disconnect(); target.appendChild(existing); observer.observe(document.documentElement, { childList: true, subtree: true }); } observer = new MutationObserver(function () { if (scheduled) return; scheduled = true; requestAnimationFrame(check); }); observer.observe(document.documentElement, { childList: true, subtree: true }); } if (document.readyState === 'loading') { document.addEventListener('DOMContentLoaded', init); } else { init(); } })();

Справочная страница
Форматы данных
Справочник SQL