xulovemin commented on PR #26728: URL: https://github.com/apache/doris/pull/26728#issuecomment-1840112211
> > > Hi @xulovemin Thanks for your contributor. But we need more details about this new catalog, such as column type mapping, docs and test cases. > > > > > > @morningman GaussDb is based on PostgreSQL and has undergone modifications. The calling methods and syntax are the same, including DML, DDL, and column mapping. It's similar to the example of MySQL and MariaDB, so I directly made the changes. The following is an example of my actual usage: > > CREATE CATALOG `gaussdb` PROPERTIES ( "password" = "passowrd", "driver_class" = "com.huawei.gauss200.jdbc.Driver", "only_specified_database" = "false", "driver_url" = "gsjdbc-200.jar", "lower_case_table_names" = "true", "type" = "jdbc", "user" = "user", "jdbc_url" = "jdbc:gaussdb://ip:port/db?useCursorFetch=true" ); > > show tables from gaussdb.public; > > I just made some modifications in the project and used it. I am only providing some suggestions. The implementation can be further investigated by experts. I hope to see more catalogs added with more powerful features. > > Can you provide a docker compose for GaussDb so that we can add regression test case for it? Hi @morningman `version: '3' services: gaussdb: container_name: gaussdb image: enmotech/opengauss:3.0.3 environment: GS_PASSWORD: Enmo@123 TZ: Asia/Shanghai volumes: - /gaussdb:/var/lib/opengauss ports: - 5432:5432 networks: - my_network networks: my_network: external: true` username is gaussdb -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org