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

this step will mod many files, but do not need review carefully

Solution

Step 4: (674 files, 6730 lines (with Step 1, Step 2 and Step 3))

1. Set below rules' severity to error in Checkstyle
   a. Array Type Style
   b.

Use case:

Get the total duration over many events. Something like select sum(age(ended, started)) from myevents or select sum(ended - started) from myevents - depending on crate/crate#12479

See https://github.com/crate/crate/blob/dc3ce297b1597d482949a2e57479890feb3adbf4/server/src/main/java/io/crate/execution/engine/aggregation/impl/SumAggregation.java#L67

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.

Describe the bug
We have a hard-coded distinct = false parameter in ballista/rust/core/src/serde/physical_plan/mod.rs.

Ok(create_aggregate_expr(
    &aggr_function.into(),
    false, // <-- hard-coded "distinct"
    input_phy_expr.as_slice(),
    &physical_schema,
    name.to_string(),
)?)

To Reproduce
Try running a COUNT(DISTINCT expr) in Ballista

**E

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

Is there an existing issue for the same feature request?

• I have checked the existing issues.

Is your feature request related to a problem?

Showcase SQL requires support of this function.


SELECT c.workorder_no,d.nuc_id, e.station_name,a.action_time, a.action_detail,
	CASE
				WHEN FIND_IN_SET('U360CEN', SUBSTRING( d.nuc_id, 1, 7 ) ) THEN 'UCL360C'
				WHE

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