CREATE REPOSITORY

    1. CREATE REPOSITORY `bos_repo`
    2. WITH BROKER `bos_broker`
    3. ON LOCATION "bos://palo_backup"
    4. PROPERTIES
    5. (
    6. "bos_endpoint" ="http://gz.bcebos.com",
    7. "bos_accesskey" = "bos_accesskey",
    8. "bos_secret_accesskey"="bos_accesskey"
    9. );
    10. CREATE READ ONLY REPOSITORY `bos_repo`
    11. WITH BROKER `bos_broker`
    12. PROPERTIES
    13. (
    14. "bos_endpoint" ="http://gz.bcebos.com",
    15. "bos_accesskey" = "bos_accesskey",
    16. "bos_secret_accesskey"="bos_secret_accesskey"
    17. );
    18. 3. Create a warehouse named hdfs_repo, which relies on Baidu HDFS broker "hdfs_broker", and the data root directory is: hdfs://hadoop-name-node:54310/path/to/repo./
    19. CREATE REPOSITORY `hdfs_repo`
    20. WITH BROKER `hdfs_broker`
    21. ON LOCATION "hdfs://hadoop-name-node:54310/path/to/repo/"
    22. (
    23. "password" = "password"
    24. );
    25. 4. 创建名为 s3_repo 的仓库, 直接链接云存储, 而不通过broker.
    26. CREATE REPOSITORY `s3_repo`
    27. WITH S3
    28. ON LOCATION "s3://s3-repo"
    29. PROPERTIES
    30. (
    31. "AWS_ENDPOINT" = "http://s3-REGION.amazonaws.com",
    32. "AWS_ACCESS_KEY" = "AWS_ACCESS_KEY",
    33. "AWS_SECRET_KEY"="AWS_SECRET_KEY",