Re: Mystical SPJ error
Found it. I defined the library using .class instead of .jar. Oops. On Mon, Apr 4, 2016 at 6:22 PM, Gunnar Tapperwrote: > Hi, > > This error is driving me batty. :) > > The SPJ information: > > [centos@trafodion trafodion-spjs]$ pwd > /home/centos/trafodion-spjs > [centos@trafodion trafodion-spjs]$ javap Payroll.class > Compiled from "Payroll.java" > public class Payroll { > public Payroll(); > public static void adjustSalary(java.math.BigDecimal, double, > java.math.BigDecimal[]) throws java.sql.SQLException; > public static void employeeJob(int, java.lang.Integer[]) throws > java.sql.SQLException; > public static void projectTeam(int, java.sql.ResultSet[]) throws > java.sql.SQLException; > public static void topSalesReps(int, java.sql.ResultSet[]) throws > java.sql.SQLException; > } > > So, I add the class to Trafodion as a library. > > [centos@trafodion trafodion-spjs]$ trafci > > Welcome to Apache Trafodion Command Interface > Copyright (c) 2015 Apache Software Foundation > > Host Name/IP Address: localhost:23400 > User Name: zz > > Connected to Trafodion > > SQL>create library trafodion.persnl.payroll file > '/home/centos/trafodion-spjs/Payroll.class'; > > --- SQL operation complete. > > SQL>get libraries in schema trafodion.persnl; > > PAYROLL > > --- SQL operation complete. > > Next, I try to create a procedure but Trafodion doesn't seem to see the > Payroll class in the library file. > > SQL>CREATE PROCEDURE trafodion.persnl.adjustsalary( IN empnum NUMERIC(4) > , IN percent FLOAT > , OUT newsalary NUMERIC(8,2) > ) >EXTERNAL NAME 'Payroll.adjustSalary' >LIBRARY trafodion.persnl.payroll > +>+>+>+>+> LANGUAGE JAVA >PARAMETER STYLE JAVA >MODIFIES SQL DATA >; > +>+>+>+> > *** ERROR[11205] Java class 'Payroll' was not found in external path > '/home/centos/trafodion-spjs/Payroll.class'. [2016-04-05 00:16:46] > *** ERROR[1231] User-defined routine TRAFODION.PERSNL.ADJUSTSALARY could > not be created. [2016-04-05 00:16:46] > > SQL> > > What am I missing? > > Thanks, > > Gunnar > *If you think you can you can, if you think you can't you're right.* > -- Thanks, Gunnar *If you think you can you can, if you think you can't you're right.*
Re: installation prerequisites
Thank you Venkat. Hortonworks will be good too. I will use the Sandbox. Sent from my iPhone > On Apr 4, 2016, at 5:19 PM, Venkat Muthuswamy> wrote: > > Hi Sharu, > > If you are only looking to try out trafodion from an end-user perspective, > you can try the sandbox that Amanda created recently. > You can find the details in this March archive > http://mail-archives.apache.org/mod_mbox/incubator-trafodion-user/201603.mbox/browser > under the topic “Trafodion 1.3 Sandbox” > Note that this sandbox is based on Hortonworks 2.2 not CDH, if that will work > for you. > > Venkat > > From: Sharu Gupta [mailto:gupta.sh...@gmail.com] > Sent: Monday, April 04, 2016 12:42 PM > To: user@trafodion.incubator.apache.org > Subject: Re: installation prerequisites > > Hello, > > I want to thank everybody for their responses and I am so sorry for such a > delayed response. > > I will explain what I am trying to do. I am trying to install trafodion 1.3.0 > binaries to experiment with trafodion as an end-user. I am referring to the > steps in the provisioning guide for this purpose. > > Reading through the prerequisites and steps in the provisioning guide, I want > to install the binaries on a virtual machine (single-node environment). I > need CDH 5.3 hadoop distribution on the VM to get going. > The problem I have is that when I go to > http://www.cloudera.com/downloads/quickstart_vms/5-5.html, I only see two > options: download the VM installed with CDH 5.5 or CDH 5.4. (no option of > getting VM with CDH 5.3 or under) > > Christophe, you sent me a the link to get CDH 5.3. Would it be OK if I > install CDH 5.3 hadoop distribution on my local machine and get started. I > mean install hadoop CDH 5.3 and trafodion on my machine instead of VM. > > I am new to the hadoop world. Sorry if my questions are trivial. Thank you > for your time. > > Sharu > > > > > > > > > On Fri, Apr 1, 2016 at 4:34 PM, Christophe LeRouzo wrote: > Hi Sharu, > > If you don’t want to wait for Trafodion 2.0 release (which will support CDH > 5.5), you can still find CDH 5.3 here: > http://www.cloudera.com/downloads/cdh/5-3-0.html > > Best, > Christophe > > > From: Carol Pearson [mailto:carol.pearson...@gmail.com] > Sent: Friday, April 1, 2016 1:27 PM > To: user@trafodion.incubator.apache.org > Subject: Re: installation prerequisites > > Hi Sharu, > > First, welcome! As Eric asks, are you trying out Trafodion as an experiment, > or do you have a particular use case in mind? > > The daily build that Amanda mentions is not necessarily ready for real use - > it's a snapshot build and so might contain incomplete fixes, partial updates, > limited documentation, etc. > > The developer daily build is not recommended for general release usage > because it is a snapshot for testing purposes and so the quality expectations > are different. > > For more information on the daily build (especially if you're going to try to > install it), you can see the development list by subscribing to > dev-subscr...@apache.incubator.trafodion.org . That list goes into deep > technical details, build mechanics and more - definitely not a > general-purpose user list, as the daily build is not a general-purpose build! > > > If you're interested in trying to build Trafodion or checking out a developer > build as part of becoming more deeply involved in Trafodion, there are plenty > of people on the dev list who can help you out! > > We're in the process of putting together Trafodion release 2.0 which is the > official path for supporting Trafodion on Cloudera 5.4. I've been away at a > conference this week, so haven't seen the latest updates on release 2.0, but > it should be going to release candidate status very soon. > > Thanks and again, welcome! > > -Carol P. > > > --- > Email:carol.pearson...@gmail.com > Twitter: @CarolP222 > --- > > On Fri, Apr 1, 2016 at 12:19 PM, Sharu Gupta wrote: > Hello, > > I am a new user on your mailing list. I was reading the instructions to > download and install Trafodion. > > The instructions say that either Cloudera CDH 5.3 or CDH 5.2 are required. > However, I can only find CDH versions 5.4 or higher on > http://www.cloudera.com/downloads/quickstart_vms/5-5.html > > Will it be OK to use hadoop distribution by CDH 5.4 or higher? > > Thank you, > Sharu > >
RE: installation prerequisites
Hi Sharu, If you are only looking to try out trafodion from an end-user perspective, you can try the sandbox that Amanda created recently. You can find the details in this March archive http://mail-archives.apache.org/mod_mbox/incubator-trafodion-user/201603.mbox/browser under the topic “Trafodion 1.3 Sandbox” Note that this sandbox is based on Hortonworks 2.2 not CDH, if that will work for you. Venkat *From:* Sharu Gupta [mailto:gupta.sh...@gmail.com] *Sent:* Monday, April 04, 2016 12:42 PM *To:* user@trafodion.incubator.apache.org *Subject:* Re: installation prerequisites Hello, I want to thank everybody for their responses and I am so sorry for such a delayed response. I will explain what I am trying to do. I am trying to install trafodion 1.3.0 binaries to experiment with trafodion as an end-user. I am referring to the steps in the provisioning guide for this purpose. Reading through the prerequisites and steps in the provisioning guide, I want to install the binaries on a virtual machine (single-node environment). I need CDH 5.3 hadoop distribution on the VM to get going. The problem I have is that when I go to http://www.cloudera.com/downloads/quickstart_vms/5-5.html, I only see two options: download the VM installed with CDH 5.5 or CDH 5.4. (no option of getting VM with CDH 5.3 or under) Christophe, you sent me a the link to get CDH 5.3. Would it be OK if I install CDH 5.3 hadoop distribution on my local machine and get started. I mean install hadoop CDH 5.3 and trafodion on my machine instead of VM. I am new to the hadoop world. Sorry if my questions are trivial. Thank you for your time. Sharu On Fri, Apr 1, 2016 at 4:34 PM, Christophe LeRouzowrote: Hi Sharu, If you don’t want to wait for Trafodion 2.0 release (which will support CDH 5.5), you can still find CDH 5.3 here: http://www.cloudera.com/downloads/cdh/5-3-0.html Best, Christophe *From:* Carol Pearson [mailto:carol.pearson...@gmail.com] *Sent:* Friday, April 1, 2016 1:27 PM *To:* user@trafodion.incubator.apache.org *Subject:* Re: installation prerequisites Hi Sharu, First, welcome! As Eric asks, are you trying out Trafodion as an experiment, or do you have a particular use case in mind? The daily build that Amanda mentions is not necessarily ready for real use - it's a snapshot build and so might contain incomplete fixes, partial updates, limited documentation, etc. The developer daily build is not recommended for general release usage because it is a snapshot for testing purposes and so the quality expectations are different. For more information on the daily build (especially if you're going to try to install it), you can see the development list by subscribing to dev-subscr...@apache.incubator.trafodion.org . That list goes into deep technical details, build mechanics and more - definitely not a general-purpose user list, as the daily build is not a general-purpose build! If you're interested in trying to build Trafodion or checking out a developer build as part of becoming more deeply involved in Trafodion, there are plenty of people on the dev list who can help you out! We're in the process of putting together Trafodion release 2.0 which is the official path for supporting Trafodion on Cloudera 5.4. I've been away at a conference this week, so haven't seen the latest updates on release 2.0, but it should be going to release candidate status very soon. Thanks and again, welcome! -Carol P. --- Email:carol.pearson...@gmail.com Twitter: @CarolP222 --- On Fri, Apr 1, 2016 at 12:19 PM, Sharu Gupta wrote: Hello, I am a new user on your mailing list. I was reading the instructions to download and install Trafodion. The instructions say that either Cloudera CDH 5.3 or CDH 5.2 are required. However, I can only find CDH versions 5.4 or higher on http://www.cloudera.com/downloads/quickstart_vms/5-5.html Will it be OK to use hadoop distribution by CDH 5.4 or higher? Thank you, Sharu
Re: installation prerequisites
Thank you Carol. Sharu On Mon, Apr 4, 2016 at 3:31 PM, Carol Pearsonwrote: > Hi Sharu, > > I think you can install CDH 5.3 on a supported Linux version (RHEL or > CentOS 6.x) directly, rather than a VM. Trafodion doesn' run on Windows. > The VM and the asssocated helpers in the instructions are there to make it > easier. > > Once you've got Trafodion installed, there are various things you can do > with it - see the quickstart page at > http://trafodion.apache.org/quickstart.html and feel free to make > suggestions or contributions as you discover things that could be done > differently to make it easier! > > Again, welcome! > -Carol P > > --- > Email:carol.pearson...@gmail.com > Twitter: @CarolP222 > --- > > On Mon, Apr 4, 2016 at 12:41 PM, Sharu Gupta > wrote: > >> Hello, >> >> I want to thank everybody for their responses and I am so sorry for such >> a delayed response. >> >> I will explain what I am trying to do. I am trying to install trafodion >> 1.3.0 binaries to experiment with trafodion as an end-user. I am referring >> to the steps in the provisioning guide for this purpose. >> >> Reading through the prerequisites and steps in the provisioning guide, I >> want to install the binaries on a virtual machine (single-node >> environment). I need CDH 5.3 hadoop distribution on the VM to get going. >> The problem I have is that when I go to >> http://www.cloudera.com/downloads/quickstart_vms/5-5.html, I only see >> two options: download the VM installed with CDH 5.5 or CDH 5.4. (no option >> of getting VM with CDH 5.3 or under) >> >> Christophe, you sent me a the link to get CDH 5.3. Would it be OK if I >> install CDH 5.3 hadoop distribution on my local machine and get started. I >> mean install hadoop CDH 5.3 and trafodion on my machine instead of VM. >> >> I am new to the hadoop world. Sorry if my questions are trivial. Thank >> you for your time. >> >> Sharu >> >> >> >> >> >> >> >> >> On Fri, Apr 1, 2016 at 4:34 PM, Christophe LeRouzo >> wrote: >> >>> Hi Sharu, >>> >>> >>> >>> If you don’t want to wait for Trafodion 2.0 release (which will support >>> CDH 5.5), you can still find CDH 5.3 here: >>> http://www.cloudera.com/downloads/cdh/5-3-0.html >>> >>> >>> >>> Best, >>> >>> Christophe >>> >>> >>> >>> >>> >>> *From:* Carol Pearson [mailto:carol.pearson...@gmail.com] >>> *Sent:* Friday, April 1, 2016 1:27 PM >>> *To:* user@trafodion.incubator.apache.org >>> *Subject:* Re: installation prerequisites >>> >>> >>> >>> Hi Sharu, >>> >>> >>> >>> First, welcome! As Eric asks, are you trying out Trafodion as an >>> experiment, or do you have a particular use case in mind? >>> >>> >>> >>> The daily build that Amanda mentions is not necessarily ready for real >>> use - it's a snapshot build and so might contain incomplete fixes, partial >>> updates, limited documentation, etc. >>> >>> >>> >>> The developer daily build is not recommended for general release usage >>> because it is a snapshot for testing purposes and so the quality >>> expectations are different. >>> >>> >>> >>> For more information on the daily build (especially if you're going to >>> try to install it), you can see the development list by subscribing to >>> dev-subscr...@apache.incubator.trafodion.org . That list goes into >>> deep technical details, build mechanics and more - definitely not a >>> general-purpose user list, as the daily build is not a general-purpose >>> build! >>> >>> >>> >>> If you're interested in trying to build Trafodion or checking out a >>> developer build as part of becoming more deeply involved in Trafodion, >>> there are plenty of people on the dev list who can help you out! >>> >>> >>> >>> We're in the process of putting together Trafodion release 2.0 which is >>> the official path for supporting Trafodion on Cloudera 5.4. I've been away >>> at a conference this week, so haven't seen the latest updates on release >>> 2.0, but it should be going to release candidate status very soon. >>> >>> >>> >>> Thanks and again, welcome! >>> >>> >>> >>> -Carol P. >>> >>> >>> >>> >>> --- >>> >>> Email:carol.pearson...@gmail.com >>> >>> Twitter: @CarolP222 >>> >>> --- >>> >>> >>> >>> On Fri, Apr 1, 2016 at 12:19 PM, Sharu Gupta >>> wrote: >>> >>> Hello, >>> >>> >>> >>> I am a new user on your mailing list. I was reading the instructions to >>> download and install Trafodion. >>> >>> >>> >>> The instructions say that either Cloudera CDH 5.3 or CDH 5.2 are >>> required. However, I can only find CDH versions 5.4 or higher on >>> >>> http://www.cloudera.com/downloads/quickstart_vms/5-5.html >>> >>> >>> >>> Will it be OK to use hadoop distribution by CDH 5.4 or higher? >>> >>> >>> >>>
Re: installation prerequisites
Hi Sharu, I think you can install CDH 5.3 on a supported Linux version (RHEL or CentOS 6.x) directly, rather than a VM. Trafodion doesn' run on Windows. The VM and the asssocated helpers in the instructions are there to make it easier. Once you've got Trafodion installed, there are various things you can do with it - see the quickstart page at http://trafodion.apache.org/quickstart.html and feel free to make suggestions or contributions as you discover things that could be done differently to make it easier! Again, welcome! -Carol P --- Email:carol.pearson...@gmail.com Twitter: @CarolP222 --- On Mon, Apr 4, 2016 at 12:41 PM, Sharu Guptawrote: > Hello, > > I want to thank everybody for their responses and I am so sorry for such a > delayed response. > > I will explain what I am trying to do. I am trying to install trafodion > 1.3.0 binaries to experiment with trafodion as an end-user. I am referring > to the steps in the provisioning guide for this purpose. > > Reading through the prerequisites and steps in the provisioning guide, I > want to install the binaries on a virtual machine (single-node > environment). I need CDH 5.3 hadoop distribution on the VM to get going. > The problem I have is that when I go to > http://www.cloudera.com/downloads/quickstart_vms/5-5.html, I only see two > options: download the VM installed with CDH 5.5 or CDH 5.4. (no option of > getting VM with CDH 5.3 or under) > > Christophe, you sent me a the link to get CDH 5.3. Would it be OK if I > install CDH 5.3 hadoop distribution on my local machine and get started. I > mean install hadoop CDH 5.3 and trafodion on my machine instead of VM. > > I am new to the hadoop world. Sorry if my questions are trivial. Thank you > for your time. > > Sharu > > > > > > > > > On Fri, Apr 1, 2016 at 4:34 PM, Christophe LeRouzo wrote: > >> Hi Sharu, >> >> >> >> If you don’t want to wait for Trafodion 2.0 release (which will support >> CDH 5.5), you can still find CDH 5.3 here: >> http://www.cloudera.com/downloads/cdh/5-3-0.html >> >> >> >> Best, >> >> Christophe >> >> >> >> >> >> *From:* Carol Pearson [mailto:carol.pearson...@gmail.com] >> *Sent:* Friday, April 1, 2016 1:27 PM >> *To:* user@trafodion.incubator.apache.org >> *Subject:* Re: installation prerequisites >> >> >> >> Hi Sharu, >> >> >> >> First, welcome! As Eric asks, are you trying out Trafodion as an >> experiment, or do you have a particular use case in mind? >> >> >> >> The daily build that Amanda mentions is not necessarily ready for real >> use - it's a snapshot build and so might contain incomplete fixes, partial >> updates, limited documentation, etc. >> >> >> >> The developer daily build is not recommended for general release usage >> because it is a snapshot for testing purposes and so the quality >> expectations are different. >> >> >> >> For more information on the daily build (especially if you're going to >> try to install it), you can see the development list by subscribing to >> dev-subscr...@apache.incubator.trafodion.org . That list goes into deep >> technical details, build mechanics and more - definitely not a >> general-purpose user list, as the daily build is not a general-purpose >> build! >> >> >> >> If you're interested in trying to build Trafodion or checking out a >> developer build as part of becoming more deeply involved in Trafodion, >> there are plenty of people on the dev list who can help you out! >> >> >> >> We're in the process of putting together Trafodion release 2.0 which is >> the official path for supporting Trafodion on Cloudera 5.4. I've been away >> at a conference this week, so haven't seen the latest updates on release >> 2.0, but it should be going to release candidate status very soon. >> >> >> >> Thanks and again, welcome! >> >> >> >> -Carol P. >> >> >> >> >> --- >> >> Email:carol.pearson...@gmail.com >> >> Twitter: @CarolP222 >> >> --- >> >> >> >> On Fri, Apr 1, 2016 at 12:19 PM, Sharu Gupta >> wrote: >> >> Hello, >> >> >> >> I am a new user on your mailing list. I was reading the instructions to >> download and install Trafodion. >> >> >> >> The instructions say that either Cloudera CDH 5.3 or CDH 5.2 are >> required. However, I can only find CDH versions 5.4 or higher on >> >> http://www.cloudera.com/downloads/quickstart_vms/5-5.html >> >> >> >> Will it be OK to use hadoop distribution by CDH 5.4 or higher? >> >> >> >> Thank you, >> >> Sharu >> >> >> > >
Re: installation prerequisites
Hello, I want to thank everybody for their responses and I am so sorry for such a delayed response. I will explain what I am trying to do. I am trying to install trafodion 1.3.0 binaries to experiment with trafodion as an end-user. I am referring to the steps in the provisioning guide for this purpose. Reading through the prerequisites and steps in the provisioning guide, I want to install the binaries on a virtual machine (single-node environment). I need CDH 5.3 hadoop distribution on the VM to get going. The problem I have is that when I go to http://www.cloudera.com/downloads/quickstart_vms/5-5.html, I only see two options: download the VM installed with CDH 5.5 or CDH 5.4. (no option of getting VM with CDH 5.3 or under) Christophe, you sent me a the link to get CDH 5.3. Would it be OK if I install CDH 5.3 hadoop distribution on my local machine and get started. I mean install hadoop CDH 5.3 and trafodion on my machine instead of VM. I am new to the hadoop world. Sorry if my questions are trivial. Thank you for your time. Sharu On Fri, Apr 1, 2016 at 4:34 PM, Christophe LeRouzowrote: > Hi Sharu, > > > > If you don’t want to wait for Trafodion 2.0 release (which will support > CDH 5.5), you can still find CDH 5.3 here: > http://www.cloudera.com/downloads/cdh/5-3-0.html > > > > Best, > > Christophe > > > > > > *From:* Carol Pearson [mailto:carol.pearson...@gmail.com] > *Sent:* Friday, April 1, 2016 1:27 PM > *To:* user@trafodion.incubator.apache.org > *Subject:* Re: installation prerequisites > > > > Hi Sharu, > > > > First, welcome! As Eric asks, are you trying out Trafodion as an > experiment, or do you have a particular use case in mind? > > > > The daily build that Amanda mentions is not necessarily ready for real use > - it's a snapshot build and so might contain incomplete fixes, partial > updates, limited documentation, etc. > > > > The developer daily build is not recommended for general release usage > because it is a snapshot for testing purposes and so the quality > expectations are different. > > > > For more information on the daily build (especially if you're going to try > to install it), you can see the development list by subscribing to > dev-subscr...@apache.incubator.trafodion.org . That list goes into deep > technical details, build mechanics and more - definitely not a > general-purpose user list, as the daily build is not a general-purpose > build! > > > > If you're interested in trying to build Trafodion or checking out a > developer build as part of becoming more deeply involved in Trafodion, > there are plenty of people on the dev list who can help you out! > > > > We're in the process of putting together Trafodion release 2.0 which is > the official path for supporting Trafodion on Cloudera 5.4. I've been away > at a conference this week, so haven't seen the latest updates on release > 2.0, but it should be going to release candidate status very soon. > > > > Thanks and again, welcome! > > > > -Carol P. > > > > > --- > > Email:carol.pearson...@gmail.com > > Twitter: @CarolP222 > > --- > > > > On Fri, Apr 1, 2016 at 12:19 PM, Sharu Gupta > wrote: > > Hello, > > > > I am a new user on your mailing list. I was reading the instructions to > download and install Trafodion. > > > > The instructions say that either Cloudera CDH 5.3 or CDH 5.2 are required. > However, I can only find CDH versions 5.4 or higher on > > http://www.cloudera.com/downloads/quickstart_vms/5-5.html > > > > Will it be OK to use hadoop distribution by CDH 5.4 or higher? > > > > Thank you, > > Sharu > > >