DuckDB provides us with a bunch of list concatenation functions that do exactly the same thing; concatenate two lists. Actually, they’re all synonyms and so they can all be used interchangeably. There’s also a more general concatenation function that can also be used on lists.
So this article presents five functions that we can use to concatenate lists.
Continue readingIn DuckDB, the LEAST() function returns the smallest value from a list of expressions. The function works across various data types and provides flexible comparison capabilities for data analysis tasks.
In this article, we’ll explore DuckDB’s LEAST() function with some simple examples.
DuckDB offers a variety of date functions, one of which is the extract() function. This function is designed to retrieve a specific date part from a date or timestamp value, and it can also be applied to intervals.
In this article, we’ll take a closer look at the extract() function and provide some straightforward examples to illustrate how it works.
DuckDB’s SAMPLE clause is a handy feature that allows us to work with a random subset of our data. This is particularly useful when dealing with large datasets where processing the entire dataset might be time-consuming or unnecessary for exploratory data analysis, testing queries, or creating representative samples.
When we use this clause, we can specify the absolute number of rows to return, or a percentage of rows. We also have an option of sampling method to use.
Continue readingThe range() function is a handy utility in DuckDB that enables us to generate sequences of numbers or timestamps. We specify the starting point, the end point, and the step to use for each value in the range.
In this article, we’ll take a look at DuckDB’s range() function, along with some basic examples.
The generate_subscripts() function in DuckDB creates a series of index values for accessing elements in an array. It can help us iterate through array indices when we need to work with array elements.
Here’s a quick look at DuckDB’s generate_subscripts() function, along with examples.
DuckDB is an in-process SQL OLAP database management system designed for analytical workloads. Among its various aggregate functions is the product() function, which calculates the product of a set of numeric values.
In this article, we’ll explore how the product() function works with some basic examples.
If you’ve ever used the strptime() function to create a timestamp in DuckDB, you may be aware that it will return an error if it can’t construct the timestamp from the format string/s provided.
While such an error could be useful in some situations, it could also be annoying in others.
Fortunately, DuckDB also provides the try_strptime() function, which will suppress any error that we might ordinarily get in such cases. This function returns null instead of an error.
In DuckDB, the generate_series() function is a powerful tool for generating sequences of values, which can be very useful for data analysis, testing, and creating sample datasets. This function enables us to easily create series of numbers, dates, and timestamps with minimal code.
In DuckDB, bool_and() is an aggregate function that returns true if every input value is true, otherwise it returns false.
Here are some basic examples that demonstrate how it works.
Continue reading