Re: [D] Problem restoring Greenplum backups on CloudberryDB [cloudberry]

2024-11-28 Thread via GitHub
GitHub user svnZA added a comment to the discussion: Problem restoring Greenplum backups on CloudberryDB I noticed the following on the roadmap "Migration tool to help users migrate from Greenplum to Cloudberry Database." But surely there has been a number of people moving from GP to Cloudber

Re: [D] Problem restoring Greenplum backups on CloudberryDB [cloudberry]

2024-11-28 Thread via GitHub
GitHub user my-ship-it added a comment to the discussion: Problem restoring Greenplum backups on CloudberryDB Hmm... you can go to Slack for more help, where there are many enthusiastic people GitHub link: https://github.com/apache/cloudberry/discussions/737#discussioncomment-11403437

Re: [D] Problem restoring Greenplum backups on CloudberryDB [cloudberry]

2024-11-28 Thread via GitHub
GitHub user svnZA added a comment to the discussion: Problem restoring Greenplum backups on CloudberryDB Thank you, much appreciated. GitHub link: https://github.com/apache/cloudberry/discussions/737#discussioncomment-11404083 This is an automatically sent email for dev@cloudberry.apach

Re: [D] Problem restoring Greenplum backups on CloudberryDB [cloudberry]

2024-11-28 Thread via GitHub
GitHub user jianlirong added a comment to the discussion: Problem restoring Greenplum backups on CloudberryDB Actually, there indeed is an open-sourced migration tool: https://github.com/HashDataInc/cbcopy You can have a try. Thanks, Lirong svnZA ***@***.***> 于2024年11月28日周四 16:45写道: > I n

Re: [D] Problem restoring Greenplum backups on CloudberryDB [cloudberry]

2024-11-28 Thread via GitHub
GitHub user my-ship-it added a comment to the discussion: Problem restoring Greenplum backups on CloudberryDB Hi @svnZA, did you use gpbackup to backup Greenplum 6.17.1 provided by Cloudberry? GitHub link: https://github.com/apache/cloudberry/discussions/737#discussioncomment-11403276

Re: [D] Problem restoring Greenplum backups on CloudberryDB [cloudberry]

2024-11-28 Thread via GitHub
GitHub user svnZA added a comment to the discussion: Problem restoring Greenplum backups on CloudberryDB Good morning, Yes, that is what I used. gpbackup version 1.20.4 gpbackup --dbname "cdrfw" --compression-level 9 --metadata-only --verbose --backup-dir /backup/gpbackups GitHub link: ht

Re: [D] Problem restoring Greenplum backups on CloudberryDB [cloudberry]

2024-11-28 Thread via GitHub
GitHub user my-ship-it added a comment to the discussion: Problem restoring Greenplum backups on CloudberryDB You can go to Slack for more help, where there are many enthusiastic people GitHub link: https://github.com/apache/cloudberry/discussions/737#discussioncomment-11403444 This is

Re: [D] Problem restoring Greenplum backups on CloudberryDB [cloudberry]

2024-11-28 Thread via GitHub
GitHub user my-ship-it deleted a comment on the discussion: Problem restoring Greenplum backups on CloudberryDB Hmm... you can go to Slack for more help, where there are many enthusiastic people GitHub link: https://github.com/apache/cloudberry/discussions/737#discussioncomment-11403437 ---

Re: [D] Cloudberry Database Roadmap 2024 [cloudberry]

2024-11-29 Thread via GitHub
GitHub user Xedonedron added a comment to the discussion: Cloudberry Database Roadmap 2024 `Cloudberry Database Manager` Does this reference from Greenplum Command Center with more powerful feature like querying or administration things? GitHub link: https://github.com/apache/cloudberry/disc

Re: [D] Problem restoring Greenplum backups on CloudberryDB [cloudberry]

2024-11-29 Thread via GitHub
GitHub user xanadu-dev added a comment to the discussion: Problem restoring Greenplum backups on CloudberryDB > Good morning, > > Firstly, I want to express my gratitude for the fantastic work you’re doing, > it's truly appreciated. > > We are in the process of transitioning from Greenplum 6

Re: [D] [Ideas] Enable pgrx in Cloudberry [cloudberry]

2024-12-01 Thread via GitHub
GitHub user yihong0618 added a comment to the discussion: [Ideas] Enable pgrx in Cloudberry Its not quick hard for doing this, only add both big-endian vs little-endian for pgrx side is OK. And its already done on gpdb side before~ GitHub link: https://github.com/apache/cloudberry/discussion

Re: [D] [Proposal] ORCA: remove the CJobQueue [cloudberry]

2024-12-02 Thread via GitHub
GitHub user my-ship-it added a comment to the discussion: [Proposal] ORCA: remove the CJobQueue Please paste pictures in English so other engineers could participant, thanks! GitHub link: https://github.com/apache/cloudberry/discussions/743#discussioncomment-11435257 This is an automati

Re: [D] Cloudberry Database Roadmap 2024 [cloudberry]

2024-12-01 Thread via GitHub
GitHub user my-ship-it added a comment to the discussion: Cloudberry Database Roadmap 2024 > `Cloudberry Database Manager` Does this reference from Greenplum Command > Center with more powerful feature like querying or administration things? Yes, it is. GitHub link: https://github.com/apach

Re: [D] Problem restoring Greenplum backups on CloudberryDB [cloudberry]

2024-12-01 Thread via GitHub
GitHub user my-ship-it added a comment to the discussion: Problem restoring Greenplum backups on CloudberryDB > > Good morning, > > Firstly, I want to express my gratitude for the fantastic work you’re > > doing, it's truly appreciated. > > We are in the process of transitioning from Greenplum

Re: [D] Problem restoring Greenplum backups on CloudberryDB [cloudberry]

2024-12-01 Thread via GitHub
GitHub user my-ship-it added a comment to the discussion: Problem restoring Greenplum backups on CloudberryDB Generally speaking, gpbackup is mainly used for database backup, not for upgrading, because different versions may have potential data compatibility issues. If upgrading is needed, it

Re: [D] [Ideas] Enable pgrx in Cloudberry [cloudberry]

2024-12-01 Thread via GitHub
GitHub user tuhaihe added a comment to the discussion: [Ideas] Enable pgrx in Cloudberry For better context, I would like to share 2 links related to this topic for your information: - https://github.com/pgcentralfoundation/pgrx/issues/1179 - https://github.com/pgcentralfoundation/pgrx/issues

Re: [D] [Proposal] ORCA: remove the CJobQueue [cloudberry]

2024-12-02 Thread via GitHub
GitHub user jiaqizho edited a discussion: [Proposal] ORCA: remove the CJobQueue ### Proposers jiaqizho ### Proposal Status Under Discussion ### Abstract About CJobQueue **As I understand it, `CJobQueue` is used to prevent do the same `Cjob`**. In CJob.h:L51 desc: ``` //

Re: [D] [Proposal] ORCA: remove the CJobQueue [cloudberry]

2024-12-02 Thread via GitHub
GitHub user jiaqizho added a comment to the discussion: [Proposal] ORCA: remove the CJobQueue updated GitHub link: https://github.com/apache/cloudberry/discussions/743#discussioncomment-11436852 This is an automatically sent email for dev@cloudberry.apache.org. To unsubscribe, please se

Re: [D] Are there any plans to further develop GPORCA to support all query performance optimizations? [cloudberry]

2024-11-26 Thread via GitHub
GitHub user KrasnovidKE added a comment to the discussion: Are there any plans to further develop GPORCA to support all query performance optimizations? Hi @avamingli @my-ship-it Great news! :) Thank you for your detailed answers. GitHub link: https://github.com/apache/cloudberry/discussio

Re: [D] Are there any plans to further develop GPORCA to support all query performance optimizations? [cloudberry]

2024-11-25 Thread via GitHub
GitHub user my-ship-it added a comment to the discussion: Are there any plans to further develop GPORCA to support all query performance optimizations? Hi @KrasnovidKE In fact, we plan to enable those features you mentioned in GPORCA in our roadmap. In the long term, we plan to narrow the diff

Re: [D] Are there any plans to further develop GPORCA to support all query performance optimizations? [cloudberry]

2024-11-25 Thread via GitHub
GitHub user avamingli added a comment to the discussion: Are there any plans to further develop GPORCA to support all query performance optimizations? > However, this legacy optimizer produces extremely complex and generally poor > plans for large queries compared to GPORCA. Max and I previo

Re: [D] [Ideas] Enable pgrx in Cloudberry [cloudberry]

2024-12-02 Thread via GitHub
GitHub user roseduan added a comment to the discussion: [Ideas] Enable pgrx in Cloudberry Work in progress: https://github.com/cloudberry-contrib/pgrx GitHub link: https://github.com/apache/cloudberry/discussions/732#discussioncomment-11443296 This is an automatically sent email for dev

Re: [D] Are there any plans to further develop GPORCA to support all query performance optimizations? [cloudberry]

2024-12-03 Thread via GitHub
GitHub user KrasnovidKE closed a discussion: Are there any plans to further develop GPORCA to support all query performance optimizations? The query performance optimizations listed below (taken from the documentation at https://cloudberry.apache.org/docs/performance/) work exclusively for the

Re: [D] Cloudberry Database Roadmap 2024 [cloudberry]

2024-12-03 Thread via GitHub
GitHub user adar604 added a comment to the discussion: Cloudberry Database Roadmap 2024 Cart GitHub link: https://github.com/apache/cloudberry/discussions/369#discussioncomment-11448825 This is an automatically sent email for dev@cloudberry.apache.org. To unsubscribe, please send an em

Re: [D] Cloudberry Database Roadmap 2024 [cloudberry]

2024-12-03 Thread via GitHub
GitHub user tuhaihe added a comment to the discussion: Cloudberry Database Roadmap 2024 Hi everyone, since Cloudberry has joined the ASF Incubator, the new roadmap for Cloudberry is now up for discussion. We welcome your feedback: https://lists.apache.org/thread/wo1lsly8h7q8c4sxrwpw73ylbnzrcw

Re: [D] Enable answer query using Materialized View for external table. [cloudberry]

2024-12-03 Thread via GitHub
GitHub user adar604 added a comment to the discussion: Enable answer query using Materialized View for external table. > GitHub link: https://github.com/apache/cloudberry/discussions/693#discussioncomment-11448973 This is an automatically sent email for dev@cloudberry.apache.org. T

Re: [D] Enable answer query using Materialized View for external table. [cloudberry]

2024-12-03 Thread via GitHub
GitHub user adar604 edited a comment on the discussion: Enable answer query using Materialized View for external table. Adar604 GitHub link: https://github.com/apache/cloudberry/discussions/693#discussioncomment-11448973 This is an automatically sent email for dev@cloudberry.apache.org.

Re: [D] Enable answer query using Materialized View for external table. [cloudberry]

2024-12-03 Thread via GitHub
GitHub user adar604 added a comment to the discussion: Enable answer query using Materialized View for external table. ⁹ŕ GitHub link: https://github.com/apache/cloudberry/discussions/693#discussioncomment-11448982 This is an automatically sent email for dev@cloudberry.apache.org. To un

Re: [D] [Proposal] ORCA: remove the CJobQueue [cloudberry]

2024-12-05 Thread via GitHub
GitHub user my-ship-it added a comment to the discussion: [Proposal] ORCA: remove the CJobQueue As far as I know, it is possible that ORCA's design is based on the DXL structure. DXL supports DAG format, but the plan in PG is a tree structure, so the queue size is 1? GitHub link: https://gi

Re: [D] Enable answer query using Materialized View for external table. [cloudberry]

2024-12-04 Thread via GitHub
GitHub user avamingli added a comment to the discussion: Enable answer query using Materialized View for external table. Implemented by #702 GitHub link: https://github.com/apache/cloudberry/discussions/693#discussioncomment-11458877 This is an automatically sent email for dev@cloudber

Re: [D] Enable answer query using Materialized View for external table. [cloudberry]

2024-12-04 Thread via GitHub
GitHub user my-ship-it closed a discussion: Enable answer query using Materialized View for external table. ### Description Currently, for inner table, planner knows to use MV to speed up query, for example: ``` create table tbl_heap(c1 int, c2 int); insert into tbl_heap select generate_ser

Re: [D] [Feature] Dynamic Tables [cloudberry]

2024-12-04 Thread via GitHub
GitHub user avamingli added a comment to the discussion: [Feature] Dynamic Tables > I think we can leverage the combination of these techniques, including > materialized views for external tables, dynamic tables (auto refreshing > materialized views) and AQUMV to solve the problem often raise

Re: [D] [Feature] Dynamic Tables [cloudberry]

2024-12-04 Thread via GitHub
GitHub user avamingli edited a comment on the discussion: [Feature] Dynamic Tables > I think we can leverage the combination of these techniques, including > materialized views for external tables, dynamic tables (auto refreshing > materialized views) and AQUMV to solve the problem often rais

Re: [D] [Feature] Dynamic Tables [cloudberry]

2024-12-04 Thread via GitHub
GitHub user avamingli edited a comment on the discussion: [Feature] Dynamic Tables > I think we can leverage the combination of these techniques, including > materialized views for external tables, dynamic tables (auto refreshing > materialized views) and AQUMV to solve the problem often rais

Re: [D] [Feature] Dynamic Tables [cloudberry]

2024-12-06 Thread via GitHub
GitHub user avamingli edited a comment on the discussion: [Feature] Dynamic Tables I have been coding some functions, here are design details: ## DDL: Provide a base table ```sql CREATE TABLE t1(a int, b int, c int) distributed by (b); INSERT INTO t1 SELECT i, i + 1, i + 2 FROM GENERATE_SERI

Re: [D] Sync up behavior on how partition maintenance works between Greenplum 6/7 and Cloudberry [cloudberry]

2024-12-09 Thread via GitHub
GitHub user yjhjstz added a comment to the discussion: Sync up behavior on how partition maintenance works between Greenplum 6/7 and Cloudberry https://github.com/apache/cloudberry/blob/main/deploy/docker/Dockerfile docker.artifactory.hashdata.xyz/docker/cbdb:devel-devtoolset-10-cbdb-docker-ub

Re: [D] Sync up behavior on how partition maintenance works between Greenplum 6/7 and Cloudberry [cloudberry]

2024-12-09 Thread via GitHub
GitHub user edespino added a comment to the discussion: Sync up behavior on how partition maintenance works between Greenplum 6/7 and Cloudberry @yjhjstz As far as the Apache Cloudberry project is concerned, if they are needed, these resources should be reworked to use the DockerHub Apache Cl

Re: [D] Sync up behavior on how partition maintenance works between Greenplum 6/7 and Cloudberry [cloudberry]

2024-12-08 Thread via GitHub
GitHub user yjhjstz added a comment to the discussion: Sync up behavior on how partition maintenance works between Greenplum 6/7 and Cloudberry @tuhaihe maybe we need a pipeline to sync docker sandbox image ? GitHub link: https://github.com/apache/cloudberry/discussions/691#discussioncomment-

Re: [D] Sync up behavior on how partition maintenance works between Greenplum 6/7 and Cloudberry [cloudberry]

2024-12-08 Thread via GitHub
GitHub user my-ship-it added a comment to the discussion: Sync up behavior on how partition maintenance works between Greenplum 6/7 and Cloudberry > I've opened a [PR](https://github.com/cloudberrydb/cloudberrydb/pull/695) to > track this issue. The child partition table should inherits access

Re: [D] Sync up behavior on how partition maintenance works between Greenplum 6/7 and Cloudberry [cloudberry]

2024-12-09 Thread via GitHub
GitHub user tuhaihe added a comment to the discussion: Sync up behavior on how partition maintenance works between Greenplum 6/7 and Cloudberry I'm uncertain about this, but I would like to involve @edespino. GitHub link: https://github.com/apache/cloudberry/discussions/691#discussioncomment-

Re: [D] [Feature] Dynamic Tables [cloudberry]

2024-12-08 Thread via GitHub
GitHub user avamingli closed a discussion: [Feature] Dynamic Tables ### Description Snowflake has a special table called Dynamic Tables: https://docs.snowflake.com/en/user-guide/dynamic-tables-intro The Dynamic Tables is much like Materialized View but in Snowflake, Materialized View is not e

Re: [D] Sync up behavior on how partition maintenance works between Greenplum 6/7 and Cloudberry [cloudberry]

2024-12-09 Thread via GitHub
GitHub user edespino added a comment to the discussion: Sync up behavior on how partition maintenance works between Greenplum 6/7 and Cloudberry @yjhjstz I am not sure what you mean by _"maybe we need a pipeline to sync docker sandbox image ?"_ GitHub link: https://github.com/apache/cloudber

Re: [D] Looking for guideline on Support model for Migration of Greenlplum to Cloudberry [cloudberry]

2024-12-07 Thread via GitHub
GitHub user 2shar-p added a comment to the discussion: Looking for guideline on Support model for Migration of Greenlplum to Cloudberry Danish Hussain... Welcome to the Apache Cloudberry Community! As you join the Apache Cloudberry community, it’s important to understand the distinction bet

Re: [D] Looking for guideline on Support model for Migration of Greenlplum to Cloudberry [cloudberry]

2024-12-07 Thread via GitHub
GitHub user 2shar-p edited a comment on the discussion: Looking for guideline on Support model for Migration of Greenlplum to Cloudberry Danish Hussain... Welcome to the Apache Cloudberry Community! As you join the Apache Cloudberry project, it’s important to understand the distinctions betw

Re: [D] Cloudberry Database Roadmap 2024 [cloudberry]

2024-12-25 Thread via GitHub
GitHub user tuhaihe edited a discussion: Cloudberry Database Roadmap 2024 This roadmap outlines the key milestones and focuses on the Cloudberry Database project in 2024. It aims to enhance functionality to strengthen further the Cloudberry Database's position as the next-gen unified open-sour

Re: [D] Cloudberry Database Roadmap 2024 [cloudberry]

2024-12-25 Thread via GitHub
GitHub user tuhaihe edited a discussion: Cloudberry Database Roadmap 2024 > [!note] > Hi everyone, since Cloudberry has joined the ASF Incubator, the new roadmap > for Cloudberry is now up for discussion. We welcome your feedback: > https://lists.apache.org/thread/wo1lsly8h7q8c4sxrwpw73ylbnzrc

Re: [D] [Ideas] periodic Coverity scan [cloudberry]

2025-01-05 Thread via GitHub
GitHub user my-ship-it added a comment to the discussion: [Ideas] periodic Coverity scan Thanks @chipitsine, please submit a GHA workflow, which is good for product quality. Feel free to submit PR to fix warnings, or file issues about warnings. GitHub link: https://github.com/apache/cloudber

Re: [D] Supporting Partitioned Tables in AQUMV(Answer Query Using Materialized Views) [cloudberry]

2024-12-25 Thread via GitHub
GitHub user avamingli added a comment to the discussion: Supporting Partitioned Tables in AQUMV(Answer Query Using Materialized Views) Sure, will invest time to explore this. GitHub link: https://github.com/apache/cloudberry/discussions/780#discussioncomment-11667143 This is an automati

Re: [D] [Ideas] Should we support ON CONFLICT to include the distribution keys? [cloudberry]

2025-02-04 Thread via GitHub
GitHub user my-ship-it edited a discussion: [Ideas] Should we support ON CONFLICT to include the distribution keys? ### Description Hackers, Currently, when the ON CONFLICT statement involves distributed keys, an error occurs, as shown below: ``` postgres=# create table tbl(v1 int, v2 int,

Re: [D] [Ideas] Should we support ON CONFLICT when updating the distribution keys? [cloudberry]

2025-02-04 Thread via GitHub
GitHub user my-ship-it edited a discussion: [Ideas] Should we support ON CONFLICT when updating the distribution keys? ### Description Hackers, Currently, when the ON CONFLICT statement involves distributed keys, an error occurs, as shown below: ``` postgres=# create table tbl(v1 int, v2 in

Re: [D] [Ideas] Should we support ON CONFLICT when updating the distribution keys? [cloudberry]

2025-02-04 Thread via GitHub
GitHub user my-ship-it edited a discussion: [Ideas] Should we support ON CONFLICT when updating the distribution keys? ### Description Hackers, Currently, when the ON CONFLICT statement involves distributed keys, an error occurs, as shown below: ``` postgres=# create table tbl(v1 int, v2 in

Re: [D] [Ideas] Should we support ON CONFLICT when updating the distribution keys? [cloudberry]

2025-02-05 Thread via GitHub
GitHub user my-ship-it edited a discussion: [Ideas] Should we support ON CONFLICT when updating the distribution keys? ### Description Hackers, Currently, when the ON CONFLICT statement involves distributed keys, an error occurs, as shown below: ``` postgres=# create table tbl(v1 int, v2 in

Re: [D] [Ideas] Improve Version Information for Source Builds [cloudberry]

2025-02-09 Thread via GitHub
GitHub user tuhaihe added a comment to the discussion: [Ideas] Improve Version Information for Source Builds > Is there a bug for versioning scripts? Why it is always 1.0.0 for Cloudberry > Database. How about follow format below for debug/release? I guess there is no mechanism to detect the

Re: [D] [Ideas] Improve Version Information for Source Builds [cloudberry]

2025-02-09 Thread via GitHub
GitHub user my-ship-it added a comment to the discussion: [Ideas] Improve Version Information for Source Builds There is a script called https://github.com/apache/cloudberry/blob/main/getversion to do this. @edespino Could you please double check with it, thanks. GitHub link: https://github

Re: [D] Shall we use Golang to manage the cluster? [cloudberry]

2025-02-10 Thread via GitHub
GitHub user avamingli added a comment to the discussion: Shall we use Golang to manage the cluster? Given the feedback, we skip the commits which use Golang as cluster management tool for now. GitHub link: https://github.com/apache/cloudberry/discussions/889#discussioncomment-12122083

Re: [D] [Ideas] Improve Version Information for Source Builds [cloudberry]

2025-02-12 Thread via GitHub
GitHub user tuhaihe added a comment to the discussion: [Ideas] Improve Version Information for Source Builds Hey, I found we need to change the string `[1.0.0]` in this file for each release, like `[2.0.0-Aplha]`, `[2.0.0-Beta]`: https://github.com/apache/cloudberry/blob/dd5aa2092f8a7b073ca6c

Re: [D] [Ideas] Improve Version Information for Source Builds [cloudberry]

2025-02-12 Thread via GitHub
GitHub user tuhaihe added a comment to the discussion: [Ideas] Improve Version Information for Source Builds I can help create one PR to fix this. GitHub link: https://github.com/apache/cloudberry/discussions/909#discussioncomment-12169109 This is an automatically sent email for dev@clo

Re: [D] [Ideas] use zizmor to static analysis the GitHub Actions files and fix them [cloudberry]

2025-01-31 Thread via GitHub
GitHub user yihong0618 closed a discussion: [Ideas] use zizmor to static analysis the GitHub Actions files and fix them ### Description As more and more attackers using GitHub Actions to steal the token or attack other users such as Mining Scripts zizmor: https://woodruffw.github.io/zizmor/

Re: [D] [Proposal] Support Incremental View Maintenance (IVM) in Cloudberry Database [cloudberry]

2024-12-11 Thread via GitHub
GitHub user yjhjstz added a comment to the discussion: [Proposal] Support Incremental View Maintenance (IVM) in Cloudberry Database finished by pr: https://github.com/apache/cloudberry/pull/280 GitHub link: https://github.com/apache/cloudberry/discussions/36#discussioncomment-11539111 T

Re: [D] Fail to create table with partition description with MAXVALUE [cloudberry]

2024-12-17 Thread via GitHub
GitHub user avamingli added a comment to the discussion: Fail to create table with partition description with MAXVALUE Hi, @xinhuitian At first glance, it appears to be a bug. The syntax you're using seems to be specific to Greenplum rather than standard PostgreSQL grammar for defining a pa

Re: [D] Fail to create table with partition description with MAXVALUE [cloudberry]

2024-12-17 Thread via GitHub
GitHub user xinhuitian edited a discussion: Fail to create table with partition description with MAXVALUE Hello, I'm currently testing cb with the bootcamp 000-cbdb-sandbox docker file. When I run a query similar as the below one: ``` gpadmin=# CREATE TABLE test_partition ( name character v

Re: [D] Fail to create table with partition description with MAXVALUE [cloudberry]

2024-12-17 Thread via GitHub
GitHub user xinhuitian edited a discussion: Fail to create table with partition description with MAXVALUE Hello, I'm currently testing cb with the bootcamp 000-cbdb-sandbox docker file. When I run a query similar as the below one: ``` gpadmin=# CREATE TABLE test_partition ( name character v

Re: [D] Fail to create table with partition description with MAXVALUE [cloudberry]

2024-12-17 Thread via GitHub
GitHub user xinhuitian added a comment to the discussion: Fail to create table with partition description with MAXVALUE Ok, I will create one GitHub link: https://github.com/apache/cloudberry/discussions/791#discussioncomment-11600219 This is an automatically sent email for dev@cloudbe

Re: [D] Fail to create table with partition description with MAXVALUE [cloudberry]

2024-12-17 Thread via GitHub
GitHub user tuhaihe added a comment to the discussion: Fail to create table with partition description with MAXVALUE Thanks! Just one trick FYI: you can create one issue directly from the discussion. https://github.com/user-attachments/assets/b06f9c2e-43ea-424a-80ee-e8de998170ce"; /> Git

Re: [D] Fail to create table with partition description with MAXVALUE [cloudberry]

2024-12-17 Thread via GitHub
GitHub user xinhuitian added a comment to the discussion: Fail to create table with partition description with MAXVALUE https://github.com/apache/cloudberry/issues/795 Created GitHub link: https://github.com/apache/cloudberry/discussions/791#discussioncomment-11600438 This is an automat

Re: [D] Fail to create table with partition description with MAXVALUE [cloudberry]

2024-12-17 Thread via GitHub
GitHub user xinhuitian closed a discussion: Fail to create table with partition description with MAXVALUE Hello, I'm currently testing cb with the bootcamp 000-cbdb-sandbox docker file. When I run a query similar as the below one: ``` gpadmin=# CREATE TABLE test_partition ( name character v

Re: [D] Fail to create table with partition description with MAXVALUE [cloudberry]

2024-12-17 Thread via GitHub
GitHub user avamingli closed the discussion with a comment: Fail to create table with partition description with MAXVALUE Close as issue created. GitHub link: https://github.com/apache/cloudberry/discussions/791#discussioncomment-11600622 This is an automatically sent email for dev@clou

Re: [D] Supporting Partitioned Tables in AQUMV(Answer Query Using Materialized Views) [cloudberry]

2024-12-13 Thread via GitHub
GitHub user avamingli edited a discussion: Supporting Partitioned Tables in AQUMV(Answer Query Using Materialized Views) ### Description Partitioned tables are essential for optimizing query performance in OLAP environments. They allow for more efficient data management and retrieval by divi

Re: [D] Supporting Partitioned Tables in AQUMV(Answer Query Using Materialized Views) [cloudberry]

2024-12-13 Thread via GitHub
GitHub user avamingli edited a discussion: Supporting Partitioned Tables in AQUMV(Answer Query Using Materialized Views) ### Description Partitioned tables are essential for optimizing query performance in OLAP environments. They allow for more efficient data management and retrieval by divi

Re: [D] Supporting Partitioned Tables in AQUMV(Answer Query Using Materialized Views) [cloudberry]

2024-12-13 Thread via GitHub
GitHub user avamingli edited a discussion: Supporting Partitioned Tables in AQUMV(Answer Query Using Materialized Views) ### Description Partitioned tables are essential for optimizing query performance in OLAP environments. They allow for more efficient data management and retrieval by divi

Re: [D] [Ideas] Optimize SQL: select distinct count(a) from t1; [cloudberry]

2024-12-03 Thread via GitHub
GitHub user avamingli closed a discussion: [Ideas] Optimize SQL: select distinct count(a) from t1; ### Description User has a auto-generated SQL by 3rd-party like: ```sql select DISTINCT count(distinct a) form t1; ``` However, for such query: Aggregate SQL without Group by, there is one row

Re: [D] [Ideas] Optimize SQL: select distinct count(a) from t1; [cloudberry]

2024-12-03 Thread via GitHub
GitHub user avamingli closed the discussion with a comment: [Ideas] Optimize SQL: select distinct count(a) from t1; Implemented by #685 . GitHub link: https://github.com/apache/cloudberry/discussions/677#discussioncomment-11456468 This is an automatically sent email for dev@cloudberry.a

Re: [D] [Ideas] use zizmor to static analysis the GitHub Actions files and fix them [cloudberry]

2025-01-08 Thread via GitHub
GitHub user edespino added a comment to the discussion: [Ideas] use zizmor to static analysis the GitHub Actions files and fix them @yihong0618 Hey buddy. I am very much interested in this tool. Let me take a look and get back to you. GitHub link: https://github.com/apache/cloudberry/discuss

Re: [D] [Proposal] Cherry-pick commits from Greenplum to Cloudberry Database [cloudberry]

2025-01-20 Thread via GitHub
GitHub user tuhaihe edited a discussion: [Proposal] Cherry-pick commits from Greenplum to Cloudberry Database ### Proposers Max Yang (@my-ship-it) Dianjin Wang (@tuhaihe) ### Proposal Status In Progress ### Abstract This proposal aims to make the process of cherry-picking commits from Gree

Re: [D] Shall we use Golang to manage the cluster? [cloudberry]

2025-01-24 Thread via GitHub
GitHub user yihong0618 added a comment to the discussion: Shall we use Golang to manage the cluster? and if so I really do not see any difference between a company closed open source project from this so now, will not response any more GitHub link: https://github.com/apache/cloudberry/discus

Re: [D] [Ideas] https://github.com/microsoft/documentdb [cloudberry]

2025-01-24 Thread via GitHub
GitHub user yihong0618 closed a discussion: [Ideas] https://github.com/microsoft/documentdb ### Description microsoft just opensource this tool, seems another tool amazing tool for pg for everything, maybe it can support in cloudberry ### Use case/motivation _No response_ ### Related iss

Re: [D] Shall we use Golang to manage the cluster? [cloudberry]

2025-01-23 Thread via GitHub
GitHub user wkvolkman added a comment to the discussion: Shall we use Golang to manage the cluster? I would vote no. I've had to go in an modify the code a couple of times in an running cluster to get segment recovery to work. Being able to make required changes and not have to have a full

Re: [D] Shall we use Golang to manage the cluster? [cloudberry]

2025-01-23 Thread via GitHub
GitHub user hyongtao-db added a comment to the discussion: Shall we use Golang to manage the cluster? HAHAHA, laugh die. If you want to start `go install` suddenly when starting gpdb, please feel free to cherry-pick these commits. GitHub link: https://github.com/apache/cloudberry/discussio

Re: [D] [Ideas] https://github.com/microsoft/documentdb [cloudberry]

2025-01-23 Thread via GitHub
GitHub user reshke edited a comment on the discussion: [Ideas] https://github.com/microsoft/documentdb It appears that FerretDB[1] is resolving this issue by proxying docDB to postgres (and thus, CBDB). What else ought to be done? [1] https://blog.ferretdb.io/ferretdb-releases-v2-faster-more

Re: [D] Shall we use Golang to manage the cluster? [cloudberry]

2025-01-23 Thread via GitHub
GitHub user yihong0618 added a comment to the discussion: Shall we use Golang to manage the cluster? its kind of Indian kpi project IMO I do not see much benefit GitHub link: https://github.com/apache/cloudberry/discussions/889#discussioncomment-11935580 This is an automatically sent e

Re: [D] [Ideas] https://github.com/microsoft/documentdb [cloudberry]

2025-01-23 Thread via GitHub
GitHub user reshke added a comment to the discussion: [Ideas] https://github.com/microsoft/documentdb It appears that FerretDB[1] is resolving this issue by proxying docDB to postgres (and thus, CBDB). What ought to be done? [1] https://blog.ferretdb.io/ferretdb-releases-v2-faster-more-compa

Re: [D] Shall we use Golang to manage the cluster? [cloudberry]

2025-01-24 Thread via GitHub
GitHub user yihong0618 deleted a comment on the discussion: Shall we use Golang to manage the cluster? its kind of Indian kpi project IMO I do not see much benefit GitHub link: https://github.com/apache/cloudberry/discussions/889#discussioncomment-11935580 This is an automatically sent

[D] [Ideas] https://github.com/microsoft/documentdb [cloudberry]

2025-01-23 Thread via GitHub
GitHub user yihong0618 created a discussion: [Ideas] https://github.com/microsoft/documentdb ### Description microsoft just opensource this tool, seems another tool amazing tool for pg for everything, maybe it can support in cloudberry ### Use case/motivation _No response_ ### Related is

Re: [D] Shall we use Golang to manage the cluster? [cloudberry]

2025-01-23 Thread via GitHub
GitHub user yjhjstz added a comment to the discussion: Shall we use Golang to manage the cluster? since gpdb not opensource anymore , so golang dependent components also closed. ```sql import ( "context" "reflect" "strings" "testing" "github.com/greenplum

Re: [D] Shall we use Golang to manage the cluster? [cloudberry]

2025-01-24 Thread via GitHub
GitHub user yihong0618 edited a comment on the discussion: Shall we use Golang to manage the cluster? and if so I really do not see any difference between a company closed open source project from this for now, will not response any more GitHub link: https://github.com/apache/cloudberry/disc

Re: [D] Shall we use Golang to manage the cluster? [cloudberry]

2025-01-24 Thread via GitHub
GitHub user yihong0618 added a comment to the discussion: Shall we use Golang to manage the cluster? I just to be honest, not sure when political correctness needs to get in the way of honesty GitHub link: https://github.com/apache/cloudberry/discussions/889#discussioncomment-11941602

Re: [D] [Ideas] use zizmor to static analysis the GitHub Actions files and fix them [cloudberry]

2025-01-03 Thread via GitHub
GitHub user yihong0618 edited a discussion: [Ideas] use zizmor to static analysis the GitHub Actions files and fix them ### Description As more and more attackers using GitHub Actions to steal the token or attack other users such as Mining Scripts zizmor: https://woodruffw.github.io/zizmor/

Re: [D] Supporting Partitioned Tables in AQUMV(Answer Query Using Materialized Views) [cloudberry]

2024-12-24 Thread via GitHub
GitHub user avamingli added a comment to the discussion: Supporting Partitioned Tables in AQUMV(Answer Query Using Materialized Views) > 1. Data Status Maintenance for Partitioned Tables: Done the first part: #786 GitHub link: https://github.com/apache/cloudberry/discussions/780#discussionc

Re: [D] Supporting Partitioned Tables in AQUMV(Answer Query Using Materialized Views) [cloudberry]

2024-12-25 Thread via GitHub
GitHub user jianlirong added a comment to the discussion: Supporting Partitioned Tables in AQUMV(Answer Query Using Materialized Views) WoW, this is a very dreamy feature. I'd like to add a specific scenario that we need to pay close attention to when implementing this feature. It's a real-wo

Re: [D] [Ideas] periodic Coverity scan [cloudberry]

2025-01-07 Thread via GitHub
GitHub user chipitsine added a comment to the discussion: [Ideas] periodic Coverity scan here we go https://github.com/apache/cloudberry/pull/849 GitHub link: https://github.com/apache/cloudberry/discussions/842#discussioncomment-11768573 This is an automatically sent email for dev@clou

Re: [D] Connect Cloudberry with ETL and BI tools. [cloudberry]

2025-02-12 Thread via GitHub
GitHub user tuhaihe added a comment to the discussion: Connect Cloudberry with ETL and BI tools. Good question. Thanks for asking! Now we're planning to ping the related projects to see how to support Cloudberry in the future. For now, you can use Postgre or Greenplum Driver to connect to Cl

Re: [D] [Ideas] Improve Version Information for Source Builds [cloudberry]

2025-02-08 Thread via GitHub
GitHub user my-ship-it edited a comment on the discussion: [Ideas] Improve Version Information for Source Builds Is there a bug for versioning scripts? Why it is always 1.0.0 for Cloudberry Database. How about follow format below for debug/release? ``` PostgreSQL 14.4 (Cloudberry Database 1.5

Re: [D] [Ideas] Improve Version Information for Source Builds [cloudberry]

2025-02-08 Thread via GitHub
GitHub user my-ship-it added a comment to the discussion: [Ideas] Improve Version Information for Source Builds Is there a bug for versioning scripts? Why it is always 1.0.0 for Cloudberry Database. How about following format for debug/release? ``` PostgreSQL 14.4 (Cloudberry Database 1.5.2+4

Re: [D] Cloudberry Deployment [cloudberry]

2025-02-16 Thread via GitHub
GitHub user RyanWei added a comment to the discussion: Cloudberry Deployment For Segment configuration please refer to: https://cloudberry.apache.org/docs/cbdb-op-software-hardware. And with 100GB of data, 2 coordinators + 2 segments should be good enough to start. GitHub link: https://githu

Re: [D] Cloudberry Deployment [cloudberry]

2025-02-16 Thread via GitHub
GitHub user SeihaHoy added a comment to the discussion: Cloudberry Deployment Thank you very much! Have a great day! GitHub link: https://github.com/apache/cloudberry/discussions/932#discussioncomment-12219791 This is an automatically sent email for dev@cloudberry.apache.org. To unsubscr

Re: [D] Cloudberry Deployment [cloudberry]

2025-02-16 Thread via GitHub
GitHub user SeihaHoy added a comment to the discussion: Cloudberry Deployment Thanks a lot! I am new into the server configurations. Based on the document we also need ETCD and FTS for availability. May you explain if it is necessary and what would the requirements be for those two. Thanks! G

Re: [D] Cloudberry Deployment [cloudberry]

2025-02-16 Thread via GitHub
GitHub user RyanWei added a comment to the discussion: Cloudberry Deployment Actually, ETCD and FTS are only needed when you want to perform auto coordinators failovers, which is not necessary at this stage. You can just ignore those 2 for the time being. GitHub link: https://github.com/apac

Re: [D] cbcopy freeze in the middle [cloudberry]

2025-03-19 Thread via GitHub
GitHub user robertmu added a comment to the discussion: cbcopy freeze in the middle Based on the command you shared, it seems that specifying --dest-host=127.0.0.1 (localhost) may be causing communication failures between the helper processes. Here's what might be happening: 1. cbcopy works b

Re: [D] [enhancement] Some future work for runtime filter pushdown [cloudberry]

2025-04-05 Thread via GitHub
GitHub user zhangyue-hashdata closed a discussion: [enhancement] Some future work for runtime filter pushdown ### Description Here some future work for runtime filter pushdown: 1. support singlenode or utility mode; 2. support null value filter; 3. support Motion, SharedScan as

Re: [D] [Ideas] Remove Bundled Python Packages in Cloudberry Main Repo [cloudberry]

2025-04-07 Thread via GitHub
GitHub user avamingli added a comment to the discussion: [Ideas] Remove Bundled Python Packages in Cloudberry Main Repo > Would it be possible to remove these bundled source packages and instead > install them via package managers like `pip` during the build or test process, It doesn’t seem l

  1   2   3   4   >