olap

In Big Query there is a function array_concat_agg that aggregates array fields by concatenating the arrays. In Snowflake there is a flatten function that can unnest nested arrays into single array. I am looking for similar functionality in duckdb.

select flatten([[1, 2], [2, 3], [4, 5]] would return [1, 2, 2, 3, 4, 5]
I would also need a distinct option:
`select flatten(DISTINCT [[1, 2],

Search before asking

• I had searched in the issues and found no similar issues.

Description

There are many redundant Header file included.

We can remove them.

Solution

This is a good related tools--IWYU

Are you willing to submit PR?

• [ ]

Use case:
Concatenate TEXT or to TEXT castable type values using a given separator, for example concatenate address parts by comma.

SELECT concat_ws(',', '535 Mission St.', '14th floor', 'San Francisco', 'CA', '94105') AS address;
--> 535 Mission St., 14th floor, San Francisco, CA 94105

Feature description:
Add support for the `concat_ws ( sep text, val1 "any" [

Hey everyone!

mapd-core-cpu is already available on conda-forge (https://anaconda.org/conda-forge/omniscidb-cpu)

now we should add some instructions on the documentation.

at this moment it is available for linux and osx.

some additional information about the configuration:

1. for now, always install omniscidb-cpu inside a conda environment (also it is a good practice), eg:

Refactoring request

The following two APIs need to pass tablet_id and schema_hash, while these two parameters already exist in tablet_meta or meta_pb, so there is no need to pass them again.

https://github.com/StarRocks/starrocks/blob/67e71be7c536751dab789c437a501fcfeca65643/be/src/storage/tabl

TPC-DS has many queries with IN predicates where all elements are constants. It's a low-hanging fruit if we could implement an InSet function for this all constants value case.

While implementing this, we could either use a hashtable or a chain of if-elif-else, depending on the length and the type of the constants array.

Q8:

 WHERE substr(ca_zip, 1, 5) IN (
               '2412

Search before asking

• I had searched in the issues and found no similar feature requirement.

Description

Add internationalization configuration of menu. The document is located in dlink-web/src/locales//menu.ts.
增加菜单的国际化配置，文件位于 dlink-web/src/locales//menu.ts。

Use case

No response

Related issues

_No respons

https://github.com/risinglightdb/risinglight/blob/7b5bc7a1a258afd64a483990ca95f4c799482791/src/storage/secondary/version_manager.rs#L258-L263

Currently, users will need to manually call pin and unpin. If there are futures cancelled or somehow, it is possible that we fail to unpin by ourselves.

We should implement a struct called Version, and implement Drop for it. pin will return a

What type of PR is this?

• API-change
• BUG
• Improvement
• Documentation
• Feature
• Test and CI
• Code Refactoring

Which issue(s) this PR fixes:

issue #2094

What this PR does / why we need it:

Add Built-in function sinh()

Special notes for your reviewer:

Not Available

**Additional documentation (e.g. design docs, usage do