使用Jerry这篇文章《在Google Cloud platform上的Kubernetes集群部署HANA Express》里介绍的方法在Google Cloud Platform的Kubernetes cluster上安装SAP HANA Express.
文中介绍了一个yaml文件,里面声明了容器镜像文件store/saplabs/hanaexpress:2.00.033.00.20180925.2.
安装完成后,在启动的pod里有两个容器,分别运行着SQLPad和HANA Express.
SQLPad是一个基于Nodejs开发的直接在浏览器运行SQL查询并对结果进行可视化展示工具。SQLPad支持的数据库非常多,比如:MySQL, Postgres, SQL Server, Vertica, Crate, Presto等。
使用kubectl get services拿到sqlpad的external IP:
在浏览器里输入刚才获得的IP地址,后面加上默认的3000端口,打开sqlpad的web控制台:
注册一个帐户并登录:
选择admin-Connections:
新建一个数据库连接:
database driver从下拉菜单里选择SAP HANA:
回到Google Cloud Platform的cloud shell,使用kubectl get services获得hxe-connect的external IP:
把这个地址填到数据库创建向导里:
创建一个名为quotes的collection并插入一些数据:
create collection quotes;
insert into quotes values ( { "FROM" : 'HOMER', "TO" : 'BART', "QUOTE" : 'I want to share something with you: The three little sentences that will get you through life. Number 1: Cover for me. Number 2: Oh, good idea, Boss! Number 3: It wai like that when I got here.', "MOES_BAR" : 'Point( -86.880306 36.508361 )', "QUOTE_ID" : 1 });
insert into quotes values ( { "EPISODE" : 'GRADE SCHOOL CONFIDENTIAL', "FROM" : 'HOMER', "QUOTE" : 'Wait a minute. Bart''s teacher is named Krabappel? Oh, I''ve been calling her Crandall. Why did not anyone tell me? Ohhh, I have been making an idiot out of myself!', "QUOTE_ID" : 2, "MOES_BAR" : 'Point( 2.161018 41.392641 )' });
insert into quotes values ( { "FROM" : 'HOMER', "QUOTE" : 'Oh no! What have I done? I smashed open my little boy''s piggy bank, and for what? A few measly cents, not even enough to buy one beer. Weit a minute, lemme count and make sure…not even close.', "MOES_BAR" : 'Point( -122.400690 37.784366 )', "QUOTE_ID" : 3 });
注意这个生成的sql collection并不是数据库表,而是一种document store(noSQL),实际上只是键值对-key value pair.
下面的SQL语句执行的操作是把document store里的值取出进行分析,将分析结果存放到新创建的column table里:
--Create a columnar table with a text fuzzy search index
create column table quote_analysis
(
id integer,
homer_quote text FAST PREPROCESS ON FUZZY SEARCH INDEX ON,
lon_lat nvarchar(200)
);
-- Copy the quotes form the JSON store to the relational table
insert into quote_analysis
with doc_store as (select quote_id, quote from quotes)
select doc_store.quote_id as id, doc_store.quote as homer_quote, 'Point( 2.151255 41.354159 )'
from doc_store;
相关推荐
本文档为用户提供了SAP HANA Client和Studio的安装步骤
SAP HANA Cockpit安装指导手册 SAP HANA Cockpit安装指导手册 官方下载拿过来的哦
SAP HANA Developer Quick Start Guide For SAP HANA XS Classic Model SAP HANA Platform 2.0 SPS 00 Document Version: 1.0 – 2016-11-30 from: ...
SAPHANA是一款革命性的产品,开创了大数据内存计算的先河。本书详细讲述SAPHANA平台的各种技术以及在SAPHANA平台上的软件开发过程。主要内容包括:SAPHANA的各个特性;SAPHANAStudio;属性视图;分析视图;图形化...
java连接saphana的jdbc驱动,驱动类:com.sap.db.jdbc.Driver,连接URL:jdbc:sap://${ip}:${port}/${example}?reconnect=true
SAP HANA SR(System Replication)配置手册、 SAP HANA数据库HA配置、 SAP HANA 管理维护、 官方手册,详细讲解SAP HANA SR的配置。
华为 SAP HANA一体机 集群安装指南(RH5885H&RH8100 V3+5500 V3+SLES12SP1)02.pdf
SAP HANA运维工具 自动化脚本 备份工具 SAP HANA运维工具 自动化脚本 备份工具
sap hana studio SAP HANA 数据库连接工具 及安装方式
HXEDownloadManager_win.EXE WINDOWS版本 sap HANA express 下载工具
SAP的hana操作手册用于 内容比较繁琐请大家仔细查看内容
Manager(SUM)并使用该软件安装,迁移和配置SAP系统 Provisioning Manager(SWPM),SYSTEM用户是必需的,并且需要在升级,安装,迁移或预配置期间临时重新激活。 如何进行验证在系统视图用户中,检查USER_...
SAP HANA studio window版本2.4.126
SAP HANA 数据库 2.8.22 含 ODBC
SAP HANA Training Materials SAP HANA Training Materials SAP HANA Training Materials
SAP HANA_STUDIO 安装包,有需要的朋友可以下载
SAP HANA SELECT语法(带参数) SAP HANA SELECT语法(带参数)
SAP HANA Developer Guide For SAP HANA Web Workbench PUBLIC SAP HANA Platform 2.0 SPS 03 Document Version: 1.1 – 2018-10-31 from: ...
SAP HANA 中调试存储过程 SAP HANA 中调试存储过程 SAP HANA 中调试存储过程