sudo su - hxeadm
cd $DIR_INSTANCE/work/
wget https://github.com/mrbrogi/SAP_SFLIGHT_4_HANA/blob/f8773d1d6c38457f16d59e1476244a68ae5ff7cf/sflights... -O sflight.zip
unzip sflight.zip
/usr/sap/HXE/HDB90/work/
HXE
tenant (but you can pick whatever place you want in your database).IMPORT "SFLIGHT"."SMACOURSE",
"SFLIGHT"."STICKET",
"SFLIGHT"."SDESSERT",
"SFLIGHT"."SMEALT",
"SFLIGHT"."SCURX",
"SFLIGHT"."STRAVELAG",
"SFLIGHT"."SFLIMEAL",
"SFLIGHT"."SFLIGHT",
"SFLIGHT"."SCPLANE",
"SFLIGHT"."SNVOICE",
"SFLIGHT"."SPPLANE",
"SFLIGHT"."SMEAL",
"SFLIGHT"."SCITAIRP",
"SFLIGHT"."SCARPLAN",
"SFLIGHT"."SCARR",
"SFLIGHT"."SCOUNTER",
"SFLIGHT"."SPFLI",
"SFLIGHT"."SAIRPORT",
"SFLIGHT"."SBUSPART",
"SFLIGHT"."SAPLANE",
"SFLIGHT"."SMENU",
"SFLIGHT"."SSTARTER",
"SFLIGHT"."SCURR",
"SFLIGHT"."SGEOCITY",
"SFLIGHT"."SCUSTOM",
"SFLIGHT"."SBOOK"
FROM '/usr/sap/HXE/HDB90/work' WITH REPLACE THREADS 8;
MANDT
field as part of the key. And I checked that clean data seems to be in the client 300
.CREATE COLUMN TABLE "SFLIGHT"."SAIRPORT_C"
AS (select
"ID",
"NAME",
"TIME_ZONE"
from "SFLIGHT"."SAIRPORT"
where "MANDT" = '300');
ALTER TABLE "SFLIGHT"."SAIRPORT_C" ADD PRIMARY KEY ("ID");
_ID
key column.CREATE COLUMN TABLE "SFLIGHT"."SPFLI_C"
AS (select
concat("CARRID", "CONNID") as "_ID",
"CARRID", "CONNID",
"COUNTRYFR", "CITYFROM", "AIRPFROM",
"COUNTRYTO", "CITYTO", "AIRPTO",
"FLTIME", "DEPTIME", "ARRTIME",
"DISTANCE", "DISTID",
"FLTYPE", "PERIOD"
from "SFLIGHT"."SPFLI"
where "MANDT"=300);
ALTER TABLE "SFLIGHT"."SPFLI_C" ADD PRIMARY KEY ("_ID");
--DROP GRAPH WORKSPACE "SFLIGHT"."CONNECTIONS_C";
CREATE GRAPH WORKSPACE "SFLIGHT"."CONNECTIONS_C"
EDGE TABLE "SFLIGHT"."SPFLI_C"
SOURCE COLUMN "AIRPFROM"
TARGET COLUMN "AIRPTO"
KEY COLUMN "_ID"
VERTEX TABLE "SFLIGHT"."SAIRPORT_C"
KEY COLUMN "ID";
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
10 | |
8 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |