Buckets:
| <meta charset="utf-8" /><meta name="hf:doc:metadata" content="{"title":"Perform SQL operations","local":"perform-sql-operations","sections":[],"depth":1}"> | |
| <link href="/docs/hub/pr_2437/en/_app/immutable/assets/0.e3b0c442.css" rel="modulepreload"> | |
| <link rel="modulepreload" href="/docs/hub/pr_2437/en/_app/immutable/entry/start.5e3ed1fd.js"> | |
| <link rel="modulepreload" href="/docs/hub/pr_2437/en/_app/immutable/chunks/scheduler.258d2a4d.js"> | |
| <link rel="modulepreload" href="/docs/hub/pr_2437/en/_app/immutable/chunks/singletons.2d0c91e1.js"> | |
| <link rel="modulepreload" href="/docs/hub/pr_2437/en/_app/immutable/chunks/index.c8b82093.js"> | |
| <link rel="modulepreload" href="/docs/hub/pr_2437/en/_app/immutable/chunks/paths.d360121b.js"> | |
| <link rel="modulepreload" href="/docs/hub/pr_2437/en/_app/immutable/entry/app.93e7704b.js"> | |
| <link rel="modulepreload" href="/docs/hub/pr_2437/en/_app/immutable/chunks/preload-helper.a4507a26.js"> | |
| <link rel="modulepreload" href="/docs/hub/pr_2437/en/_app/immutable/chunks/index.421344fd.js"> | |
| <link rel="modulepreload" href="/docs/hub/pr_2437/en/_app/immutable/nodes/0.bedbef6e.js"> | |
| <link rel="modulepreload" href="/docs/hub/pr_2437/en/_app/immutable/chunks/each.e59479a4.js"> | |
| <link rel="modulepreload" href="/docs/hub/pr_2437/en/_app/immutable/nodes/38.760d23a3.js"> | |
| <link rel="modulepreload" href="/docs/hub/pr_2437/en/_app/immutable/chunks/CopyLLMTxtMenu.9c2a67a1.js"> | |
| <link rel="modulepreload" href="/docs/hub/pr_2437/en/_app/immutable/chunks/MermaidChart.svelte_svelte_type_style_lang.9bb92958.js"> | |
| <link rel="modulepreload" href="/docs/hub/pr_2437/en/_app/immutable/chunks/CodeBlock.619ec4e3.js"><!-- HEAD_svelte-u9bgzb_START --><meta name="hf:doc:metadata" content="{"title":"Perform SQL operations","local":"perform-sql-operations","sections":[],"depth":1}"><!-- HEAD_svelte-u9bgzb_END --> <p></p> <div class="items-center shrink-0 min-w-[100px] max-sm:min-w-[50px] justify-end ml-auto flex" style="float: right; margin-left: 10px; display: inline-flex; position: relative; z-index: 10;"><div class="inline-flex rounded-md max-sm:rounded-sm"><button class="inline-flex items-center gap-1 h-7 max-sm:h-7 px-2 max-sm:px-1.5 text-sm font-medium text-gray-800 border border-r-0 rounded-l-md max-sm:rounded-l-sm border-gray-200 bg-white hover:shadow-inner dark:border-gray-850 dark:bg-gray-950 dark:text-gray-200 dark:hover:bg-gray-800" aria-live="polite"><span class="inline-flex items-center justify-center rounded-md p-0.5 max-sm:p-0 hover:text-gray-800 dark:hover:text-gray-200"><svg class="sm:size-3.5 size-3" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" fill="currentColor" focusable="false" role="img" width="1em" height="1em" preserveAspectRatio="xMidYMid meet" viewBox="0 0 32 32"><path d="M28,10V28H10V10H28m0-2H10a2,2,0,0,0-2,2V28a2,2,0,0,0,2,2H28a2,2,0,0,0,2-2V10a2,2,0,0,0-2-2Z" transform="translate(0)"></path><path d="M4,18H2V4A2,2,0,0,1,4,2H18V4H4Z" transform="translate(0)"></path><rect fill="none" width="32" height="32"></rect></svg></span> <span>Copy page</span></button> <button class="inline-flex items-center justify-center w-6 max-sm:w-5 h-7 max-sm:h-7 disabled:pointer-events-none text-sm text-gray-500 hover:text-gray-700 dark:hover:text-white rounded-r-md max-sm:rounded-r-sm border border-l transition border-gray-200 bg-white hover:shadow-inner dark:border-gray-850 dark:bg-gray-950 dark:text-gray-200 dark:hover:bg-gray-800" aria-haspopup="menu" aria-expanded="false" aria-label="Open copy menu"><svg class="transition-transform text-gray-400 overflow-visible sm:size-3.5 size-3 rotate-0" width="1em" height="1em" viewBox="0 0 12 7" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M1 1L6 6L11 1" stroke="currentColor"></path></svg></button></div> </div> <h1 class="relative group"><a id="perform-sql-operations" class="header-link block pr-1.5 text-lg no-hover:hidden with-hover:absolute with-hover:p-1.5 with-hover:opacity-0 with-hover:group-hover:opacity-100 with-hover:right-full" href="#perform-sql-operations"><span><svg class="" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" aria-hidden="true" role="img" width="1em" height="1em" preserveAspectRatio="xMidYMid meet" viewBox="0 0 256 256"><path d="M167.594 88.393a8.001 8.001 0 0 1 0 11.314l-67.882 67.882a8 8 0 1 1-11.314-11.315l67.882-67.881a8.003 8.003 0 0 1 11.314 0zm-28.287 84.86l-28.284 28.284a40 40 0 0 1-56.567-56.567l28.284-28.284a8 8 0 0 0-11.315-11.315l-28.284 28.284a56 56 0 0 0 79.196 79.197l28.285-28.285a8 8 0 1 0-11.315-11.314zM212.852 43.14a56.002 56.002 0 0 0-79.196 0l-28.284 28.284a8 8 0 1 0 11.314 11.314l28.284-28.284a40 40 0 0 1 56.568 56.567l-28.285 28.285a8 8 0 0 0 11.315 11.314l28.284-28.284a56.065 56.065 0 0 0 0-79.196z" fill="currentColor"></path></svg></span></a> <span>Perform SQL operations</span></h1> <p data-svelte-h="svelte-gxx94w">Performing SQL operations with DuckDB opens up a world of possibilities for querying datasets efficiently. Let’s dive into some examples showcasing the power of DuckDB functions.</p> <p data-svelte-h="svelte-xr19vp">For our demonstration, we’ll explore a fascinating dataset. The <a href="https://huggingface.co/datasets/cais/mmlu" rel="nofollow">MMLU</a> dataset is a multitask test containing multiple-choice questions spanning various knowledge domains.</p> <p data-svelte-h="svelte-w5gipb">To preview the dataset, let’s select a sample of 3 rows:</p> <div class="code-block relative "><div class="absolute top-2.5 right-4"><button class="inline-flex items-center relative text-sm focus:text-green-500 cursor-pointer focus:outline-none transition duration-200 ease-in-out opacity-0 mx-0.5 text-gray-600 " title="code excerpt" type="button"><svg class="" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" fill="currentColor" focusable="false" role="img" width="1em" height="1em" preserveAspectRatio="xMidYMid meet" viewBox="0 0 32 32"><path d="M28,10V28H10V10H28m0-2H10a2,2,0,0,0-2,2V28a2,2,0,0,0,2,2H28a2,2,0,0,0,2-2V10a2,2,0,0,0-2-2Z" transform="translate(0)"></path><path d="M4,18H2V4A2,2,0,0,1,4,2H18V4H4Z" transform="translate(0)"></path><rect fill="none" width="32" height="32"></rect></svg> <div class="absolute pointer-events-none transition-opacity bg-black text-white py-1 px-2 leading-tight rounded font-normal shadow left-1/2 top-full transform -translate-x-1/2 translate-y-2 opacity-0"><div class="absolute bottom-full left-1/2 transform -translate-x-1/2 w-0 h-0 border-black border-4 border-t-0" style="border-left-color: transparent; border-right-color: transparent; "></div> Copied</div></button></div> <pre class=""><!-- HTML_TAG_START -->FROM <span class="hljs-string">'hf://datasets/cais/mmlu/all/test-*.parquet'</span> USING SAMPLE 3; | |
| ┌──────────────────────┬──────────────────────┬──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┬────────┐ | |
| │ question │ subject │ choices │ answer │ | |
| │ varchar │ varchar │ varchar[] │ int64 │ | |
| ├──────────────────────┼──────────────────────┼──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┼────────┤ | |
| │ The model of light… │ conceptual_physics │ [wave model, particle model, Both of these, Neither of these] │ 1 │ | |
| │ A person <span class="hljs-built_in">who</span> is lo… │ professional_psych… │ [his/her life scripts., his/her own feelings, attitudes, and beliefs., the emotional reactions and behaviors of the people he/she is interacting with.… │ 1 │ | |
| │ The thermic effect… │ nutrition │ [is substantially higher <span class="hljs-keyword">for</span> carbohydrate than <span class="hljs-keyword">for</span> protein, is accompanied by a slight decrease <span class="hljs-keyword">in</span> body core temperature., is partly related to sympat… │ 2 │ | |
| └──────────────────────┴──────────────────────┴──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┴────────┘ | |
| <!-- HTML_TAG_END --></pre></div> <p data-svelte-h="svelte-8gg3w3">This command retrieves a random sample of 3 rows from the dataset for us to examine.</p> <p data-svelte-h="svelte-80ut5">Let’s start by examining the schema of our dataset. The following table outlines the structure of our dataset:</p> <div class="code-block relative "><div class="absolute top-2.5 right-4"><button class="inline-flex items-center relative text-sm focus:text-green-500 cursor-pointer focus:outline-none transition duration-200 ease-in-out opacity-0 mx-0.5 text-gray-600 " title="code excerpt" type="button"><svg class="" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" fill="currentColor" focusable="false" role="img" width="1em" height="1em" preserveAspectRatio="xMidYMid meet" viewBox="0 0 32 32"><path d="M28,10V28H10V10H28m0-2H10a2,2,0,0,0-2,2V28a2,2,0,0,0,2,2H28a2,2,0,0,0,2-2V10a2,2,0,0,0-2-2Z" transform="translate(0)"></path><path d="M4,18H2V4A2,2,0,0,1,4,2H18V4H4Z" transform="translate(0)"></path><rect fill="none" width="32" height="32"></rect></svg> <div class="absolute pointer-events-none transition-opacity bg-black text-white py-1 px-2 leading-tight rounded font-normal shadow left-1/2 top-full transform -translate-x-1/2 translate-y-2 opacity-0"><div class="absolute bottom-full left-1/2 transform -translate-x-1/2 w-0 h-0 border-black border-4 border-t-0" style="border-left-color: transparent; border-right-color: transparent; "></div> Copied</div></button></div> <pre class=""><!-- HTML_TAG_START -->DESCRIBE FROM <span class="hljs-string">'hf://datasets/cais/mmlu/all/test-*.parquet'</span> USING SAMPLE 3; | |
| ┌─────────────┬─────────────┬─────────┬─────────┬─────────┬─────────┐ | |
| │ column_name │ column_type │ null │ key │ default │ extra │ | |
| │ varchar │ varchar │ varchar │ varchar │ varchar │ varchar │ | |
| ├─────────────┼─────────────┼─────────┼─────────┼─────────┼─────────┤ | |
| │ question │ VARCHAR │ YES │ │ │ │ | |
| │ subject │ VARCHAR │ YES │ │ │ │ | |
| │ choices │ VARCHAR[] │ YES │ │ │ │ | |
| │ answer │ BIGINT │ YES │ │ │ │ | |
| └─────────────┴─────────────┴─────────┴─────────┴─────────┴─────────┘ | |
| <!-- HTML_TAG_END --></pre></div> <p data-svelte-h="svelte-1abo7a1">Next, let’s analyze if there are any duplicated records in our dataset:</p> <div class="code-block relative "><div class="absolute top-2.5 right-4"><button class="inline-flex items-center relative text-sm focus:text-green-500 cursor-pointer focus:outline-none transition duration-200 ease-in-out opacity-0 mx-0.5 text-gray-600 " title="code excerpt" type="button"><svg class="" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" fill="currentColor" focusable="false" role="img" width="1em" height="1em" preserveAspectRatio="xMidYMid meet" viewBox="0 0 32 32"><path d="M28,10V28H10V10H28m0-2H10a2,2,0,0,0-2,2V28a2,2,0,0,0,2,2H28a2,2,0,0,0,2-2V10a2,2,0,0,0-2-2Z" transform="translate(0)"></path><path d="M4,18H2V4A2,2,0,0,1,4,2H18V4H4Z" transform="translate(0)"></path><rect fill="none" width="32" height="32"></rect></svg> <div class="absolute pointer-events-none transition-opacity bg-black text-white py-1 px-2 leading-tight rounded font-normal shadow left-1/2 top-full transform -translate-x-1/2 translate-y-2 opacity-0"><div class="absolute bottom-full left-1/2 transform -translate-x-1/2 w-0 h-0 border-black border-4 border-t-0" style="border-left-color: transparent; border-right-color: transparent; "></div> Copied</div></button></div> <pre class=""><!-- HTML_TAG_START -->SELECT *, | |
| COUNT(*) AS counts | |
| FROM <span class="hljs-string">'hf://datasets/cais/mmlu/all/test-*.parquet'</span> | |
| GROUP BY ALL | |
| HAVING counts > 2; | |
| ┌──────────┬─────────┬───────────┬────────┬────────┐ | |
| │ question │ subject │ choices │ answer │ counts │ | |
| │ varchar │ varchar │ varchar[] │ int64 │ int64 │ | |
| ├──────────┴─────────┴───────────┴────────┴────────┤ | |
| │ 0 rows │ | |
| └──────────────────────────────────────────────────┘ | |
| <!-- HTML_TAG_END --></pre></div> <p data-svelte-h="svelte-1t2fkie">Fortunately, our dataset doesn’t contain any duplicate records.</p> <p data-svelte-h="svelte-pt369e">Let’s see the proportion of questions based on the subject in a bar representation:</p> <div class="code-block relative "><div class="absolute top-2.5 right-4"><button class="inline-flex items-center relative text-sm focus:text-green-500 cursor-pointer focus:outline-none transition duration-200 ease-in-out opacity-0 mx-0.5 text-gray-600 " title="code excerpt" type="button"><svg class="" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" fill="currentColor" focusable="false" role="img" width="1em" height="1em" preserveAspectRatio="xMidYMid meet" viewBox="0 0 32 32"><path d="M28,10V28H10V10H28m0-2H10a2,2,0,0,0-2,2V28a2,2,0,0,0,2,2H28a2,2,0,0,0,2-2V10a2,2,0,0,0-2-2Z" transform="translate(0)"></path><path d="M4,18H2V4A2,2,0,0,1,4,2H18V4H4Z" transform="translate(0)"></path><rect fill="none" width="32" height="32"></rect></svg> <div class="absolute pointer-events-none transition-opacity bg-black text-white py-1 px-2 leading-tight rounded font-normal shadow left-1/2 top-full transform -translate-x-1/2 translate-y-2 opacity-0"><div class="absolute bottom-full left-1/2 transform -translate-x-1/2 w-0 h-0 border-black border-4 border-t-0" style="border-left-color: transparent; border-right-color: transparent; "></div> Copied</div></button></div> <pre class=""><!-- HTML_TAG_START -->SELECT | |
| subject, | |
| COUNT(*) AS counts, | |
| BAR(COUNT(*), 0, (SELECT COUNT(*) FROM <span class="hljs-string">'hf://datasets/cais/mmlu/all/test-*.parquet'</span>)) AS percentage | |
| FROM | |
| <span class="hljs-string">'hf://datasets/cais/mmlu/all/test-*.parquet'</span> | |
| GROUP BY | |
| subject | |
| ORDER BY | |
| counts DESC; | |
| ┌──────────────────────────────┬────────┬────────────────────────────────────────────────────────────────────────────────┐ | |
| │ subject │ counts │ percentage │ | |
| │ varchar │ int64 │ varchar │ | |
| ├──────────────────────────────┼────────┼────────────────────────────────────────────────────────────────────────────────┤ | |
| │ professional_law │ 1534 │ ████████▋ │ | |
| │ moral_scenarios │ 895 │ █████ │ | |
| │ miscellaneous │ 783 │ ████▍ │ | |
| │ professional_psychology │ 612 │ ███▍ │ | |
| │ high_school_psychology │ 545 │ ███ │ | |
| │ high_school_macroeconomics │ 390 │ ██▏ │ | |
| │ elementary_mathematics │ 378 │ ██▏ │ | |
| │ moral_disputes │ 346 │ █▉ │ | |
| ├──────────────────────────────┴────────┴────────────────────────────────────────────────────────────────────────────────┤ | |
| │ 57 rows (8 shown) 3 columns │ | |
| └────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘ | |
| <!-- HTML_TAG_END --></pre></div> <p data-svelte-h="svelte-18q9kdb">Now, let’s prepare a subset of the dataset containing questions related to <strong>nutrition</strong> and create a mapping of questions to correct answers. | |
| Notice that we have the column <strong>choices</strong> from which we can get the correct answer using the <strong>answer</strong> column as an index.</p> <div class="code-block relative "><div class="absolute top-2.5 right-4"><button class="inline-flex items-center relative text-sm focus:text-green-500 cursor-pointer focus:outline-none transition duration-200 ease-in-out opacity-0 mx-0.5 text-gray-600 " title="code excerpt" type="button"><svg class="" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" fill="currentColor" focusable="false" role="img" width="1em" height="1em" preserveAspectRatio="xMidYMid meet" viewBox="0 0 32 32"><path d="M28,10V28H10V10H28m0-2H10a2,2,0,0,0-2,2V28a2,2,0,0,0,2,2H28a2,2,0,0,0,2-2V10a2,2,0,0,0-2-2Z" transform="translate(0)"></path><path d="M4,18H2V4A2,2,0,0,1,4,2H18V4H4Z" transform="translate(0)"></path><rect fill="none" width="32" height="32"></rect></svg> <div class="absolute pointer-events-none transition-opacity bg-black text-white py-1 px-2 leading-tight rounded font-normal shadow left-1/2 top-full transform -translate-x-1/2 translate-y-2 opacity-0"><div class="absolute bottom-full left-1/2 transform -translate-x-1/2 w-0 h-0 border-black border-4 border-t-0" style="border-left-color: transparent; border-right-color: transparent; "></div> Copied</div></button></div> <pre class=""><!-- HTML_TAG_START -->SELECT * | |
| FROM <span class="hljs-string">'hf://datasets/cais/mmlu/all/test-*.parquet'</span> | |
| WHERE subject = <span class="hljs-string">'nutrition'</span> LIMIT 3; | |
| ┌──────────────────────┬───────────┬─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┬────────┐ | |
| │ question │ subject │ choices │ answer │ | |
| │ varchar │ varchar │ varchar[] │ int64 │ | |
| ├──────────────────────┼───────────┼─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┼────────┤ | |
| │ Which foods tend t… │ nutrition │ [Meat, Confectionary, Fruits and vegetables, Potatoes] │ 2 │ | |
| │ In <span class="hljs-built_in">which</span> one of th… │ nutrition │ [If the incidence rate of the disease falls., If survival time with the disease increases., If recovery of the disease is faster., If the population <span class="hljs-keyword">in</span> <span class="hljs-built_in">which</span> the… │ 1 │ | |
| │ Which of the follo… │ nutrition │ [The flavonoid class comprises flavonoids and isoflavonoids., The digestibility and bioavailability of isoflavones <span class="hljs-keyword">in</span> soya food products are not changed by proce… │ 0 │ | |
| └──────────────────────┴───────────┴─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┴────────┘ | |
| <!-- HTML_TAG_END --></pre></div> <div class="code-block relative "><div class="absolute top-2.5 right-4"><button class="inline-flex items-center relative text-sm focus:text-green-500 cursor-pointer focus:outline-none transition duration-200 ease-in-out opacity-0 mx-0.5 text-gray-600 " title="code excerpt" type="button"><svg class="" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" fill="currentColor" focusable="false" role="img" width="1em" height="1em" preserveAspectRatio="xMidYMid meet" viewBox="0 0 32 32"><path d="M28,10V28H10V10H28m0-2H10a2,2,0,0,0-2,2V28a2,2,0,0,0,2,2H28a2,2,0,0,0,2-2V10a2,2,0,0,0-2-2Z" transform="translate(0)"></path><path d="M4,18H2V4A2,2,0,0,1,4,2H18V4H4Z" transform="translate(0)"></path><rect fill="none" width="32" height="32"></rect></svg> <div class="absolute pointer-events-none transition-opacity bg-black text-white py-1 px-2 leading-tight rounded font-normal shadow left-1/2 top-full transform -translate-x-1/2 translate-y-2 opacity-0"><div class="absolute bottom-full left-1/2 transform -translate-x-1/2 w-0 h-0 border-black border-4 border-t-0" style="border-left-color: transparent; border-right-color: transparent; "></div> Copied</div></button></div> <pre class=""><!-- HTML_TAG_START -->SELECT question, | |
| choices[answer] AS correct_answer | |
| FROM <span class="hljs-string">'hf://datasets/cais/mmlu/all/test-*.parquet'</span> | |
| WHERE subject = <span class="hljs-string">'nutrition'</span> LIMIT 3; | |
| ┌─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┬─────────────────────────────────────────────┐ | |
| │ question │ correct_answer │ | |
| │ varchar │ varchar │ | |
| ├─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┼─────────────────────────────────────────────┤ | |
| │ Which foods tend to be consumed <span class="hljs-keyword">in</span> lower quantities <span class="hljs-keyword">in</span> Wales and Scotland (as of 2020)?\n │ Confectionary │ | |
| │ In <span class="hljs-built_in">which</span> one of the following circumstances will the prevalence of a disease <span class="hljs-keyword">in</span> the population increase, all <span class="hljs-keyword">else</span> being constant?\n │ If the incidence rate of the disease falls. │ | |
| │ Which of the following statements is correct?\n │ │ | |
| └─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┴─────────────────────────────────────────────┘ | |
| <!-- HTML_TAG_END --></pre></div> <p data-svelte-h="svelte-v9ewbe">To ensure data cleanliness, let’s remove any newline characters at the end of the questions and filter out any empty answers:</p> <div class="code-block relative "><div class="absolute top-2.5 right-4"><button class="inline-flex items-center relative text-sm focus:text-green-500 cursor-pointer focus:outline-none transition duration-200 ease-in-out opacity-0 mx-0.5 text-gray-600 " title="code excerpt" type="button"><svg class="" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" fill="currentColor" focusable="false" role="img" width="1em" height="1em" preserveAspectRatio="xMidYMid meet" viewBox="0 0 32 32"><path d="M28,10V28H10V10H28m0-2H10a2,2,0,0,0-2,2V28a2,2,0,0,0,2,2H28a2,2,0,0,0,2-2V10a2,2,0,0,0-2-2Z" transform="translate(0)"></path><path d="M4,18H2V4A2,2,0,0,1,4,2H18V4H4Z" transform="translate(0)"></path><rect fill="none" width="32" height="32"></rect></svg> <div class="absolute pointer-events-none transition-opacity bg-black text-white py-1 px-2 leading-tight rounded font-normal shadow left-1/2 top-full transform -translate-x-1/2 translate-y-2 opacity-0"><div class="absolute bottom-full left-1/2 transform -translate-x-1/2 w-0 h-0 border-black border-4 border-t-0" style="border-left-color: transparent; border-right-color: transparent; "></div> Copied</div></button></div> <pre class=""><!-- HTML_TAG_START -->SELECT regexp_replace(question, <span class="hljs-string">'\n'</span>, <span class="hljs-string">''</span>) AS question, | |
| choices[answer] AS correct_answer | |
| FROM <span class="hljs-string">'hf://datasets/cais/mmlu/all/test-*.parquet'</span> | |
| WHERE subject = <span class="hljs-string">'nutrition'</span> AND LENGTH(correct_answer) > 0 LIMIT 3; | |
| ┌───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┬─────────────────────────────────────────────┐ | |
| │ question │ correct_answer │ | |
| │ varchar │ varchar │ | |
| ├───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┼─────────────────────────────────────────────┤ | |
| │ Which foods tend to be consumed <span class="hljs-keyword">in</span> lower quantities <span class="hljs-keyword">in</span> Wales and Scotland (as of 2020)? │ Confectionary │ | |
| │ In <span class="hljs-built_in">which</span> one of the following circumstances will the prevalence of a disease <span class="hljs-keyword">in</span> the population increase, all <span class="hljs-keyword">else</span> being constant? │ If the incidence rate of the disease falls. │ | |
| │ Which vitamin is a major lipid-soluble antioxidant <span class="hljs-keyword">in</span> cell membranes? │ Vitamin D │ | |
| └───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┴─────────────────────────────────────────────┘ | |
| <!-- HTML_TAG_END --></pre></div> <p data-svelte-h="svelte-15xbpc4">Finally, lets highlight some of the DuckDB functions used in this section:</p> <ul data-svelte-h="svelte-1akw45a"><li><code>DESCRIBE</code>, returns the table schema.</li> <li><code>USING SAMPLE</code>, samples are used to randomly select a subset of a dataset.</li> <li><code>BAR</code>, draws a band whose width is proportional to (x - min) and equal to width characters when x = max. Width defaults to 80.</li> <li><code>string[begin:end]</code>, extracts a string using slice conventions. Missing begin or end arguments are interpreted as the beginning or end of the list respectively. Negative values are accepted.</li> <li><code>regexp_replace</code>, if the string contains the regexp pattern, replaces the matching part with replacement.</li> <li><code>LENGTH</code>, gets the number of characters in the string.</li></ul> <blockquote class="tip" data-svelte-h="svelte-1gfukj1"><p>There are plenty of useful functions available in DuckDB’s <a href="https://duckdb.org/docs/sql/functions/overview" rel="nofollow">SQL functions overview</a>. The best part is that you can use them directly on Hugging Face datasets.</p></blockquote> <a class="!text-gray-400 !no-underline text-sm flex items-center not-prose mt-4" href="https://github.com/huggingface/hub-docs/blob/main/docs/hub/datasets-duckdb-sql.md" target="_blank"><svg class="mr-1" xmlns="http://www.w3.org/2000/svg" aria-hidden="true" fill="currentColor" focusable="false" role="img" width="1em" height="1em" preserveAspectRatio="xMidYMid meet" viewBox="0 0 32 32"><path d="M31,16l-7,7l-1.41-1.41L28.17,16l-5.58-5.59L24,9l7,7z"></path><path d="M1,16l7-7l1.41,1.41L3.83,16l5.58,5.59L8,23l-7-7z"></path><path d="M12.419,25.484L17.639,6.552l1.932,0.518L14.351,26.002z"></path></svg> <span data-svelte-h="svelte-zjs2n5"><span class="underline">Update</span> on GitHub</span></a> <p></p> | |
| <script> | |
| { | |
| __sveltekit_ummgov = { | |
| assets: "/docs/hub/pr_2437/en", | |
| base: "/docs/hub/pr_2437/en", | |
| env: {} | |
| }; | |
| const element = document.currentScript.parentElement; | |
| const data = [null,null]; | |
| Promise.all([ | |
| import("/docs/hub/pr_2437/en/_app/immutable/entry/start.5e3ed1fd.js"), | |
| import("/docs/hub/pr_2437/en/_app/immutable/entry/app.93e7704b.js") | |
| ]).then(([kit, app]) => { | |
| kit.start(app, element, { | |
| node_ids: [0, 38], | |
| data, | |
| form: null, | |
| error: null | |
| }); | |
| }); | |
| } | |
| </script> | |
Xet Storage Details
- Size:
- 36 kB
- Xet hash:
- 6303810e8bcd96deff766433ae46b411da3e0308eb7e197e3e8261cf6aa8e555
·
Xet efficiently stores files, intelligently splitting them into unique chunks and accelerating uploads and downloads. More info.