背景
redshift与hdb pg 的常用函数、数据类型、字符集对应关系。

redshift
内置函数
https://docs.aws.amazon.com/redshift/latest/dg/c_SQL_functions.html

数据类型
https://docs.aws.amazon.com/redshift/latest/dg/c_Supported_data_types.html

阿里云hdb pg
oracle兼容函数
https://gpdb.docs.pivotal.io/43300/utility_guide/orafce_ref.html

内置函数
https://gpdb.docs.pivotal.io/43300/ref_guide/function-summary.html

数据类型
https://gpdb.docs.pivotal.io/43300/ref_guide/data_types.html

字符集
https://gpdb.docs.pivotal.io/43300/ref_guide/character_sets.html

HLL估值类型
https://help.aliyun.com/document_detail/56747.html

roaring bitmap类型
https://github.com/digoal/blog/blob/master/201801/20180127_01.md
转自阿里云德哥