Hi Pierre, I have been looking postGreSQL's dump utility. Trafodion has some of that functionality today but not all. We could implement missing data dump features using HBase's exportsnapshot functionality. Do you think a JIRA is in order? If you could provide information about what you had in mind, I can create the JIRA.
Thanks Suresh On Wed, Mar 8, 2017 at 8:26 AM, Eric Owhadi <[email protected]> wrote: > Hello Pierre, > Did you look at the ddl.txt file? In Suresh example, this is where you > should see the "script file". > To replay it, using sqlci, just "OBEY ddl.txt" > Does that make sense? > Eric > > -----Original Message----- > From: Pierre Smits [mailto:[email protected]] > Sent: Wednesday, March 8, 2017 4:22 AM > To: [email protected] > Subject: Re: Dumping a schema > > Hi Suresh, all, > > What I am looking for, and which I think will help adoption of our > product, is an equivalent to the PostgreSQL pq_dump (see [1]) or the MySQL > mysqldump funcitons, and the subsequent import functions. > > While testing at PURGEDATA function within the sqlci in my OFBiz-Trafodion > PoC environment I didn't see any output. The SHOWDLL function delivered me > a set of create statements for a table (including those for associated > indexes) > > But I did not see how to export this to a script file. > > [1] https://www.postgresql.org/docs/9.1/static/app-pgdump.html > > Best regards, > > Pierre Smits > > ORRTIZ.COM <http://www.orrtiz.com> > OFBiz based solutions & services > > OFBiz Extensions Marketplace > http://oem.ofbizci.net/oci-2/ > > On Tue, Mar 7, 2017 at 6:06 PM, Suresh Subbiah <[email protected] > > > wrote: > > > Hi Pierre, > > > > I think PURGEDATA will do the first three steps, while loading new > > data will have to be done as usual. Now PURGEDATA is for a single > > table at a time, so it have to be repeated for every table. > > > > For example > > > > PURGEDATA <table-name> ; > > LOAD INTO <table-name> SELECT * FROM <source-table-name> ; // > > <source-table-name> can refer to HBase or Hive table // other load > > statements can be used if source data in text files. > > > > Trafodion also has a DROP SCHEMA <schema-name> CASCADE statemet, that > > will drop all tables and indexes in a schema. But steps two to four > > would have to be done separately. > > > > SHOWDDL <table-name> ; > > on each table in the schema can be done before the DROP SCHEMA > > cascade. The resulting log file can then be obeyed to recreate > > tables/indexes and set permissions. > > > > For example > > > > log ddl.txt ; > > SHOWDDL <table1> ; > > SHOWDDL <table2> ; > > .... > > log ; > > DROP SCHEMA <schema-name> CASCADE ; > > > > CREATE SCHEMA <schema-name> ; > > OBEY ddl.txt ; > > LOAD INTO <table1> .... ; > > LOAD INTO <table2> .... ; > > > > Thank you > > Suresh > > > > On Tue, Mar 7, 2017 at 7:47 AM, Pierre Smits <[email protected]> > > wrote: > > > > > Hi all, > > > > > > Is there in Trafodion an equivalent for dumping a schema, that > > > consist > > of: > > > > > > - dropping the table(s) on exist, > > > - creating the table(s) and index(es), > > > - setting the permissions, > > > - loading the data > > > > > > Best regards, > > > > > > Pierre Smits > > > > > > ORRTIZ.COM <http://www.orrtiz.com> > > > OFBiz based solutions & services > > > > > > OFBiz Extensions Marketplace > > > http://oem.ofbizci.net/oci-2/ > > > > > >
