Also do you know where I can find oozie.sql used for ooziedb.sh script?
ooziedb.sh create <OPTIONS> : create Oozie DB schema
-run Confirm the DB schema
creation/upgrade
-sqlfile <arg> Generate SQL script instead
creating/upgrading the DB
schema
I guess you need to do ooziedb.sh create -sqlfile <sqlfile> to get the sql
file created.
Regards,
Rohini
On Thu, Jan 3, 2013 at 1:08 PM, jun aoki <[email protected]> wrote:
> Hi Virag/Mona, thank you for clarifying.
>
> One last question; It looks like the database schema is created openjpa
> through from the java classes.
> (I thought oozie.sql is bundled in oozie when I saw Get started doc)
> Could we also remove "-sqlfile oozie.sql" from ooziedb.sh example since new
> users would have no idea where the sql file is?
>
>
> (i also appending what I replied back mistakenly only Mona previously)
> -------- What replied to Mona in my previous--------
>
> Hi Mona, thank you for responding.
> So as I thought more after getting your comment, I found there are multiple
> ways to setup oozie.
>
> For haddoplib and libext, you can use either one way
> 1. bin/oozie-setup.sh -hadoop (specify a path to hadoop you use)
> 2. OR , use hadooplibs
>
> For EXT-JS
> 1. Store extjs under libext
> 2. OR use oozie-setup.sh --extjs {path to extjs)
>
> For db creation,
> 1. run ooziedb.sh
> 2. OR set oozie.service.JPAService.create.db.schema
>
> Let me know if I get it right.
>
> Probably we can still refer mkdistro.sh ?
>
> Also do you know where I can find oozie.sql used for ooziedb.sh script?
>
>
>
>
> On Thu, Jan 3, 2013 at 12:27 PM, Virag Kothari <[email protected]>
> wrote:
>
> > Hi Jun,
> >
> > Thanks for taking a look at the quick start. Responses online
> >
> > 1. it does not tell how to build oozie (mkdistro.sh)
> >
> >
> > Yes. I think we should make this as part of QuickStart. Currently, its at
> > http://oozie.apache.org/docs/3.3.0/ENG_Building.html. In quick start, we
> > should provide a link to this page and I think it will be a good idea to
> > specify bin/mkdistro.sh for building oozie in Quickstart.
> >
> > 2. Users do not have to do anything with hadooplibs tar.gz ?
> > 3. Users do not have to create libext folder?
> >
> > This two steps are required for injecting the required hadoop jars in
> > Oozie's WEB-INF/lib. This can be done in a separate way by parameterizing
> > the oozie-setup.sh (as in your github link). But libext is the
> recommended
> > way.
> >
> > 4) at least a few properties should be modified in oozie-site.xml?
> > (See my understanding here
> > https://github.com/jaoki/oozie-playground#oozie-setup)
> >
> > The whitelist and hadoop-configuration settings in oozie-site are not
> > mandatory. If bin/ooziedb.sh is used, then setting
> > 'oozie.service.JPAService.create.db.schema' to true is not required.
> >
> > 5. bin/ooziedb.sh does not have to be called manually?
> >
> >
> > Answered above.
> >
> > Thanks,
> > Virag
> >
> >
> >
> > On 1/3/13 11:00 AM, "jun aoki" <[email protected]> wrote:
> >
> > >http://oozie.apache.org/docs/3.3.0/DG_QuickStart.html
> > >
> > >seems a bit out-dated by following reasons;
> > >
> > >1. it does not tell how to build oozie (mkdistro.sh)
> > >2. Users do not have to do anything with hadooplibs tar.gz ?
> > >3. Users do not have to create libext folder?
> > >4. at least a few properties should be modified in oozie-site.xml?
> > > (See my understanding here
> > >https://github.com/jaoki/oozie-playground#oozie-setup)
> > >5. bin/ooziedb.sh does not have to be called manually?
> > >
> > >if anybody is interested, I can make a ticket and submit a patch. Let me
> > >know.
> >
> >
>
