search

NabheetCloud / MyLearnings

My Learnings and Experiments
0 stars 0 forks source link

SAP HANA Express edition #7

Open NabheetCloud opened 6 years ago

NabheetCloud commented 6 years ago

Handy Commands sudo su - hxeadm - login to instance HDB info - Detail about HDB services https://hxehost:53075/watt/index.html - Webide https://hxehost:51042/sap/hana/cockpit/landscape/index.html# SAP HANA cockpit

NabheetCloud commented 6 years ago

Association rule end to end

CREATE SCHEMA PA_DATA;

CREATE TABLE PA_DATA.CUSTOMERS_REFERENCES ( USERID INT, COUNTRY VARCHAR(20), SITE VARCHAR(3), IDPROV INT, ORDERS_COUNT INT, PRIMARY KEY (USERID) ); CREATE TABLE PA_DATA.CUSTOMERS_TRANSACTIONS ( USERID INT, ITEMPURCHASED VARCHAR(20), DATE_PUTINCADDY TIMESTAMP, QUANTITY VARCHAR(5), TRANSACTIONID INT, PRIMARY KEY (TRANSACTIONID) ); CREATE TABLE PA_DATA.WEBSITE_REFERENCES ( SESSIONID INT, PRIMARY KEY (SESSIONID) ); CREATE TABLE PA_DATA.WEBSITE_TRANSACTIONS ( SESSIONID INT, PAGE VARCHAR(50), TRANSACTIONID INT, IPADDRESS VARCHAR(15), VISITE_TIME TIMESTAMP, PRIMARY KEY (TRANSACTIONID) );

NabheetCloud commented 6 years ago

Install SAP APL all this has to be done as SUDO /usr/sap/HXE/home/bin ./HXEDownloadManager_linux.bin linuxx86_64 installer apl.tgz extract the files

NabheetCloud commented 6 years ago

Check if AFL is installed SELECT FROM "SYS"."AFL_AREAS" WHERE AREA_NAME = 'AFLPAL'; SELECT FROM "SYS"."AFL_PACKAGES" WHERE AREA_NAME = 'AFLPAL'; SELECT * FROM "SYS"."AFL_FUNCTIONS" WHERE AREA_NAME = 'AFLPAL';

NabheetCloud commented 6 years ago

Check if script server is active, The Script Server is an auxiliary service that is required to execute Application Function Libraries ( AFL ).

SELECT SERVICE_NAME, PORT, ACTIVE_STATUS FROM SYS.M_SERVICES ORDER BY 1

if not then run this on systemdb ALTER DATABASE HXE ADD 'scriptserver';