1、init hawq 前

1: 在 hawq-site.xml 文件里添加

<property>
    <name>hawq_s3_url</name>
    <value>cos.wh.yun.ccbcos.com/hyq-tdh-1255000115/hawqtest/任意字符串</value>
    <description>URL for accessing S3.</description>
</property>

<property>
    <name>hawq_s3_config</name>
    <value>/path/credentials</value>
    <description>The absolute path to the S3 configuration file.</description>
</property>

2：init hawq (这样会自动创建 filespace 和 tablespace)

2、init hawq 后

1：在 hawq-site.xml 文件里添加

<property>
    <name>hawq_s3_url</name>
    <value>none</value>
    <description>URL for accessing S3.</description>
</property>

<property>
    <name>hawq_s3_config</name>
    <value>/PATH/credentials</value>
    <description>The absolute path to the S3 configuration file.</description>
</property>

2: 重启 hawq
3：然后手动创建 filespace 和 tablespcae

psql -c "create filespace s3_system  on S3('cos.wh.yun.ccbcos.com/hyq-tdh-1255000115/hawqtest/任意字符串代表folder名');"                                                                  
psql -c "create tablespace s3_default filespace s3_system;"