AWS redshift->hdb pg(Greenplum), 内置函数、数据类型、字符集
背景
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