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

As schema api already supports undrop_database operation

https://github.com/datafuselabs/databend/blob/main/common/meta/api/src/schema_api_impl.rs#L268

undrop database statement can be implemented now.

• the syntax:

UNDROP DATABASE <name>

• the "sementics"
  undrop the dropped table ... : -), e.g.

  create database test;
  create table test.tbl (a int

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.
PR apache/arrow-datafusion#2521 adds OFFSET to the logical plan. We should implement a physical plan for it.

Describe the solution you'd like
Implement OFFSET physical plan.

Describe alternatives you've considered
None

Additional context
None

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