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

Remove uncessary this.

Most scenario, it just use in constructor.

Solution

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow thi

Summary

Category: Conditional Functions

Syntax:

COALESCE( <expr1> , <expr2> [ , ... , <exprN> ] )

Example:

SELECT COALESCE(NULL, NULL, NULL, 'databend.com', NULL, 'snow.com');

databend.com

Reference:
https://docs.snowflake.com/en/sql-reference/functions/coalesce.html

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.

Is your feature request related to a problem or challenge? Please describe what you are trying to do.
From discussion in apache/arrow-datafusion#2690 (comment)

What about only showing the projection when there is one and ommiting it when there are none.
This could remove the None/Some too:

TableScan a projection=[col1,col2]

vs

Ta

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?

Several showcase SQL requires the support of this function:


select DATE_FORMAT(b.measurement_time,'%Y-%m-%d') 

select DATE_FORMAT(FROM_UNIXTIME(tm.create_time), %Y%m%d)

Describe the feature you'd like

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