CREATE CATALOG

    Description

    该语句用于创建外部数据目录（catalog）

    语法：

    可以通过 CREATE RESOURCE 创建，目前支持三种 Resource，分别连接三种外部数据源：

    • hms：Hive MetaStore
    • es：Elasticsearch
    • jdbc：数据库访问的标准接口(JDBC), 当前支持 MySQL 和 PostgreSQL

    1.2.0 以后的版本推荐通过 resource 创建 catalog，多个使用场景可以复用相同的 resource。

    1. CREATE RESOURCE catalog_resource PROPERTIES (
    2.     'type'='hms|es|jdbc',
    3.     ...
    4. );
    6. // 在 PROERPTIES 中指定的配置，将会覆盖 Resource 中的配置。
    7. CREATE CATALOG catalog_name WITH RESOURCE catalog_resource PROPERTIES(
    8.     'key' = 'value'
    9. )

    通过 properties 创建 catalog

    1.2.0 版本通过 properties 创建 catalog。

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

    Example

    1. 新建数据目录 hive

      1. -- 1.2.0+ 版本
      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;
      7. -- 1.2.0 版本
      8. CREATE CATALOG es PROPERTIES (
      9.     "type"="es",
      10.     "hosts"="http://127.0.0.1:9200"
      11. );

    3. 新建数据目录 jdbc mysql

      2. CREATE RESOURCE mysql_resource PROPERTIES (
      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 版本
      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.     "jdbc_url" = "jdbc:clickhouse://127.0.0.1:8123/demo",
      6.     "driver_url" = "file:///path/to/clickhouse-jdbc-0.3.2-patch11-all.jar",
      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. -- 方式一
      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. -- 方式二，注意有jdbc前缀
      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",

    CREATE, CATALOG

    Best Practice