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

Add rules in checkstyle. And fix them in project.

This article (chinese 中文) can help you find problem and fix them.

• PackageDeclaration
• EmptyBlock
• EmptyForInitializerPad

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

Rename the namespace starrocks::vectorized to starrocks for codes under be/src/storage.

A section in CONTRIBUTING.md for Code Formatting would be useful for new developers to understand patterns, standards, and also prevent unnecessary commits with linter errors.

Describe the solution you'd like
A short section in CONTRIBUTING.md explaining to new devs how to format their code from the cli and as part of pre-commit

Search before asking

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

Description

Translate the README.md and README.en-US.md into English

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's [Code of Conduct](h

What type of PR is this?

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

Which issue(s) this PR fixes:

issue #2095

What this PR does / why we need it:

Add cosh() built-in function

Special notes for your reviewer:

Not Available

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

If we find distinct value statistics is very small compared with row counts, we can use RLE encoding when building RowSets.

https://github.com/risinglightdb/risinglight/blob/65372ee4da36bada718a6ab00cdba865ba554e5e/src/storage/secondary/compactor.rs#L93-L96