You are the first person to add a new system SPJ for an official release.
For new installations, the new SPJ will be added automatically.
For existing installations, running : "initialize trafodion, update libmgr"
will add new SPJ's and keep existing SPJ'S the same.
There needs to be a way when the new version of code is installed, is to
somehow call: "initialize trafodion, update libmgr". If we have a metadata
change then this can be added. But if we don't change the metadata version
then something needs to be designed. Currently there are various ways of
doing this and we should standardize on some mechanism.
For example, adding HBase namespaces was added to initialize trafodion code.
Adding tenant metadata was a change to the installation scripts.
Roberta
-----Original Message-----
From: Eric Owhadi [mailto:[email protected]]
Sent: Thursday, June 15, 2017 4:05 PM
To: [email protected]
Subject: RE: initialize trafodion?
Cool, Thanks Dave,
Eric
-----Original Message-----
From: Dave Birdsall [mailto:[email protected]]
Sent: Thursday, June 15, 2017 5:59 PM
To: [email protected]
Subject: RE: initialize trafodion?
There are a variety of "initialize trafodion" variants, designed to upgrade
just one or another thing.
You can see the variety of syntax by looking at the parser
(parser/SqlParser.y). The implementations are in the sqlcomp directory.
-----Original Message-----
From: Eric Owhadi [mailto:[email protected]]
Sent: Thursday, June 15, 2017 3:54 PM
To: [email protected]
Subject: initialize trafodion?
Hi Trafodioneers,
I am studying how to create system SPJ.
I see in the code an set of instructions:
// To add a new procedure:
// update export/lib/lib_mgmt.jar to include code for the new procedure
// add a define representing the procedures below
// add a static const QString representing the create procedure text
// add a new entry in allLibmgrRoutineInfo
// perform initialize trafodion, upgrade library management
// recommend that new procedures are added in alphabetic order
// At this time there is no support to drop or change the signature of an //
existing procedure. Since customers may be using the procedures, it is //
recommended that they not be dropped or changed - instead add new ones // to
handle the required change.
I am not sure how "initialize trafodion" work, since I have always used it only
at first install. I thought that this would wipe existing data, since it
initializes metadata, right?
So there must be a mode that would just register the new system SPJ without
really re-initializing the metadata?
Eric
