greenplum是基于超大型DW或OLAP数据库的集群型解决方案,它是基于postgresql开发的;你要是有postgresql数据库的底子,进阶greenplum自是如飞冲天。
greenplum和
mysql或者诸多的大型软件一般,也是采用2条脚走路,一为商业版本,二为开源版本。
greenplum开源版本
其官方手册 https://greenplum.org/documentation/
其下载介质地址 https://github.com/greenplum-db/gpdb/releases
greenplum商业版本(注:下载介质必须要付费,官方手册可以在线或离线看)
其官方手册 http://gpdb.docs.pivotal.io/570/main/index.html
其下载介质地址 https://network.pivotal.io/products/pivotal-gpdb/
greenplum商业版本与开源版本的差异
可在企业版的官方手册之 pivotal greenplum 具体版本 release notes
difference compared to open source green plum database
Pivotal Greenplum 5.x includes all of the functionality in the open source Greenplum Database project and adds:
? Product packaging and installation script.
? Support for QuickLZ compression. QuickLZ compression is not provided in the open source version of
Greenplum Database due to licensing restrictions.
? Support for managing Greenplum Database using Pivotal Greenplum Command Center.
? Support for monitoring and managing queries with Pivotal Greenplum Workload Manager.
? Support for full text search and text analysis using Pivotal GPText.
? Spark Connector and Gemfire Connector
? Data Direct ODBC/JDBC Drivers
由上可见,企业版和开源版功能是差不多,不过前者,就是服务更多,功能更全。
建议在生产环境中,可以采用混用策略,即企业版和开源版并用。减少或压缩运维及采购成本。