Description

    This statement is used to create an external catalog

    Syntax:

    can be created from CREATE RESOURCE, current supports：

    • hms：Hive MetaStore
    • es：Elasticsearch
    • jdbc: Standard interface for database access (JDBC), currently supports MySQL and PostgreSQL

    Create catalog through resource

    1. CREATE RESOURCE catalog_resource PROPERTIES (
    2.     'type'='hms|es|jdbc',
    3.     ...
    4. );
    5. CREATE CATALOG catalog_name WITH RESOURCE catalog_resource PROPERTIES (
    6.     'key' = 'value'
    7. );

    Create catalog through properties

    Version 1.2.0 creates a catalog through properties.

    1. CREATE CATALOG catalog_name PROPERTIES (
    2.     'type'='hms|es|jdbc',
    3.     ...
    4. );

    Example

    1. Create catalog hive

    2. Create catalog es

      1. -- 1.2.0+ Version
      2. CREATE RESOURCE es_resource PROPERTIES (
      3.     "type"="es",
      4.     "hosts"="http://127.0.0.1:9200"
      5. );
      6. CREATE CATALOG es WITH RESOURCE es_resource;
      8. -- 1.2.0 Version
      9.     "type"="es",
      10.     "hosts"="http://127.0.0.1:9200"
      11. );
      1. -- 1.2.0+ Version
      3.     "type"="jdbc",
      4.     "user"="root",
      5.     "password"="123456",
      6.     "jdbc_url" = "jdbc:mysql://127.0.0.1:3316/doris_test?useSSL=false",
      7.     "driver_url" = "https://doris-community-test-1308700295.cos.ap-hongkong.myqcloud.com/jdbc_driver/mysql-connector-java-8.0.25.jar",
      8.     "driver_class" = "com.mysql.cj.jdbc.Driver"
      9. );
      10. CREATE CATALOG jdbc WITH RESOURCE msyql_resource;
      12. -- 1.2.0 Version
      13. CREATE CATALOG jdbc PROPERTIES (
      14.     "type"="jdbc",
      15.     "jdbc.user"="root",
      16.     "jdbc.password"="123456",
      17.     "jdbc.jdbc_url" = "jdbc:mysql://127.0.0.1:3316/doris_test?useSSL=false",
      18.     "jdbc.driver_url" = "https://doris-community-test-1308700295.cos.ap-hongkong.myqcloud.com/jdbc_driver/mysql-connector-java-8.0.25.jar",
      19.     "jdbc.driver_class" = "com.mysql.cj.jdbc.Driver"
      20. );

      postgresql

      clickhouse

      1. -- 1.2.0+ Version
      2. CREATE RESOURCE clickhouse_resource PROPERTIES (
      3.     "type"="jdbc",
      4.     "user"="default",
      5.     "password"="123456",
      6.     "jdbc_url" = "jdbc:clickhouse://127.0.0.1:8123/demo",
      7.     "driver_class" = "com.clickhouse.jdbc.ClickHouseDriver"
      9. CREATE CATALOG jdbc WITH RESOURCE clickhouse_resource;
      11. -- 1.2.0 Version
      12. CREATE CATALOG jdbc PROPERTIES (
      13.     "type"="jdbc",
      14.     "jdbc.jdbc_url" = "jdbc:clickhouse://127.0.0.1:8123/demo",
      15.     ...
      16. )

      oracle

      1. -- The first way
      2. CREATE RESOURCE oracle_resource PROPERTIES (
      3.     "type"="jdbc",
      4.     "user"="doris",
      5.     "password"="123456",
      6.     "jdbc_url" = "jdbc:oracle:thin:@127.0.0.1:1521:helowin",
      7.     "driver_url" = "file:/path/to/ojdbc6.jar",
      8.     "driver_class" = "oracle.jdbc.driver.OracleDriver"
      9. );
      10. CREATE CATALOG jdbc WITH RESOURCE oracle_resource;
      12. -- The second way, note: keys have 'jdbc' prefix in front.
      13. CREATE CATALOG jdbc PROPERTIES (
      14.     "type"="jdbc",
      15.     "jdbc.user"="doris",
      16.     "jdbc.password"="123456",
      17.     "jdbc.jdbc_url" = "jdbc:oracle:thin:@127.0.0.1:1521:helowin",
      18.     "jdbc.driver_url" = "file:/path/to/ojdbc6.jar",
      20. );

      SQLServer

    Best Practice