- 快召唤伙伴们来围观吧
- 微博 QQ QQ空间 贴吧
- 视频嵌入链接 文档嵌入链接
- 复制
- 微信扫一扫分享
- 已成功复制到剪贴板
用GreenplumPython管理和分析非关系型数据
2023年2月22日, Greenplum中文社区与示说社区合作,举办了2023年首场【Greenplum 开发和升级的相关经验分享】线上直播活动。
主讲人:VMware Greenplum 研发工程师 苏学斌
内容概览:Greenplum 数据库一般被许多企业用于管理和分析各类表格型,也就是关系型数据。而相对少为人知的是,得益于 Greenplum 强大的可扩展性,通过与 Python 结合,它也能高效地管理和分析在企业信息系统中常见的文档、图片、或视频等非关系型数据。本次演讲主要介绍如何使用即将发布的新产品——GreenplumPython,在全 Python 环境下操作 Greenplum 管理和分析非关系型数据。
展开查看详情
1 . !" GreenplumPython #$%&'()*+,- !"# VMware Greenplum $%&'( 2022.02 Confidential │ © VMware, Inc.
2 .Agenda ! "#$%&'()*+,-./01 - GreenplumPython123 - '(GreenplumPython1456789:;</0 Confidential │ © VMware, Inc. 2
3 .!"#$%&'()*+,-./0 SQLAN()*+, SQL=>?(@A/01BC@DEF(+,GDomain-Specific Language)H IJ(*KLM='(N()*+,O%PythonPOQR@H STUN()*+,@VWXA/01YBZO[\]^__`abcdeSQL+fH ghijkLl@mno$ - p*qrOstu@*KvwxyOvz{|} - ~[•€)*•‚@ƒ„…†O)*‡ˆv‰} - vŠ‹UŒ•\Ž••‘@’“OŠ‹”•–—˜™H Confidential │ © VMware, Inc. 3
4 .!"#$%&'()*+,-./0 SQLAN()*+, STš›œ•žŸO ^`aL¡)*+,¢£@APIO'€ ^‘w - '()*+,¤¥@¦Q§¨xy©ª«¬-O®%'(¯°+fª«UPDATEP} - >±n²©•€)*•‚@ƒ„…†O…‰)*‡ˆ} - >±n²©³()*+,@´µ¶¬•‚·¸Ž••‘@’“} - PP…… ¹ºœOORM»¼½…¾Tg¿@L¡À¢£APIÁ Confidential │ © VMware, Inc. 4
5 .GreenplumPython012 AORMÂÃOGreenplumPythonÄ…¾TL¡)*+,¢£@APIOiÅ(Æ-./01 IAORM»¼vÇ@=O GreenplumPython=FÈS/078ÉÊ@H GreenplumPython@ËŸÌÍ$ - iÅ(ÆÎLÏÐѬ-7ÒSÓϧԬ-OÕÖ)s~²} - …¾T×±@¤lØÙ/@‘ÚOiÅ(ÆÛ(ÜÝ@Python178/0OÌÍ9:;</0H - APIA/0ÞßDE?(@pandas1ÂÃOŠ‹œbH GreenplumPython àáU https://github.com/greenplum-db/GreenplumPython Confidential │ © VMware, Inc. 5
6 .GreenplumPython012 âã(äåå[æçèéS® ®%OêÉ ^`aë%ì@LÏÌíæçèé@ª@/0î•78$ Confidential │ © VMware, Inc. 6
7 .GreenplumPython012 âã(äåå[æçèéS® aTÒïðÏæçñò/óôõö±O ^•[î•%ì¬-$ GreenplumPython!"#$%&'Fluent API( Confidential │ © VMware, Inc. 7
8 .&'GreenplumPython03456789:;./ (Greenplum459:;</0 Greenplumã÷‚ø×±@459:;</0@‘ÚO% - •['(bytea6textÂ<ùúûîü/06ýã/0} - •[S9:;</0Rþÿ!["#¬$O%Greenplum Text•[SýãRþÿ!} - •['(UDFë9:;</0î•%&Ê'H NpGreenplumPythonO ^•[U(PythonVWXiʼn‡©³(gL×±‘ÚH Confidential │ © VMware, Inc. 8
9 .&'GreenplumPython03456789:;./ J()®$*õ+,œ@ý- ®%O ^•[(Python1*õù.UGreenplumX@+,œ@ý- Confidential │ © VMware, Inc. 9
10 .&'GreenplumPython03456789:;./ J()®$*õ+,œ@ý- Uã©[ûîü/jù.@+,O•[(byteaÂ<ù.UGreenplumXH Confidential │ © VMware, Inc. 10
11 .&'GreenplumPython03456789:;./ J()®$*õ+,œ@ý- 01OSTëGreenplumX@/0î•78O ^•[2RUDFO3U4XÛ(+5*õ1 Confidential │ © VMware, Inc. 11
12 .&'GreenplumPython03456789:;./ J()®$*õ+,œ@ý- U*õt+,œ@ý-ñ1O ^•[ë46îL778O®% - '(Greenplum Textëý-‡¶ÿ - '(48@PythonÌÎý-9:•+;O<=>?•48+,PH Confidential │ © VMware, Inc. 12
13 .&'GreenplumPython03456789:;./ '(UDF78/0@@Ÿ - ALM@PythonÙ/vÇOUDF=U/01AB•@OCIDETFc/0@àG Confidential │ © VMware, Inc. 13
14 .&'GreenplumPython03456789:;./ '(UDF78/0@@Ÿ - ALM@PythonÙ/vÇOUDF=U/01AB•@OCIDETFc/0@àG - UDF‘wHIÓhÓ¿@/078`JO'€GreenplumvK‘w78:;</0OÄ‘78 9:;</0Hg'€LMèé;N¼Q@ÐѲ€[ÕÖ - O/07PUÓÏQŸœROGreenplum‘wÎUDF¤c3•SHAÔT@Python*KUVO UDF‘Wk‡©X5±YZ/0H Confidential │ © VMware, Inc. 14
15 . !"#$Greenplum %&'() *+,-./0 Confidential │ © VMware, Inc. 15