Hi Qifan, The HBaseClient should be in one of the following jars:
trafodion-sql-2.2.0.jar trafodion-sql-apache1_0_2-2.2.0.jar trafodion-sql-hdp2_3-2.2.0.jar I see the following in my env: $ jar -tf trafodion-sql-2.1.0.jar | grep HBase org/trafodion/sql/HBaseClient.class org/trafodion/sql/HBaseClient$ChangeFlags.class If a 'jar -tf' on the above jars do not show an HBaseClient class, then most likely there is some build issue. Thanks, -Narendra -----Original Message----- From: Qifan Chen [mailto:[email protected]] Sent: Friday, August 26, 2016 8:38 AM To: dev <[email protected]> Subject: Re: Getting class not found error on latest Trafodion Hi, I experienced the similar problem with EsgynDB2.2 today. It looks like the HBaseClient class is not present in any of the jar files built, and trafodion-sql-cdh-2.1.0.jar is not there. I reinstalled the local hadoop, rebuilt everything, sqgen, sqstart. Also ran ilh_traf_restart. Just wonder if trafodion-sql-cdh-2.1.0.jar should be built for the latest esgynDB2.2? Thanks --Qifan [qfc@adev04 scripts]$ sqlci EsgynDB Advanced Conversational Interface 2.2.0 Copyright (c) 2015-2016 Esgyn Corporation >>initialize trafodion; *** ERROR[1398] Error 706 occured while accessing the hbase subsystem. Fix that error and make sure hbase is up and running. Error Details: java.lang.NoClassDefFoundError: org/trafodion/sql/HBaseClient . --- SQL operation failed with errors. [qfc@adev04 lib]$ sh t hbase-trx-apache1_0_2-2.2.0.jar hbase-trx-apache1_1_2-2.2.0.jar hbase-trx-cdh5_4-2.2.0.jar hbase-trx-cdh5_5-2.2.0.jar hbase-trx-hdp2_3-2.2.0.jar jdbcT2.jar jdbcT4-2.2.0.jar jdbcT4.jar lib_mgmt.jar sqmanvers.jar trafodion-dtm-2.2.0.jar trafodion-dtm-apache1_0_2-2.2.0.jar trafodion-dtm-hdp2_3-2.2.0.jar trafodion-sql-2.2.0.jar trafodion-sql-apache1_0_2-2.2.0.jar trafodion-sql-hdp2_3-2.2.0.jar trafodion-utility-2.2.0.jar [qfc@adev04 lib]$ cat t for i in `ls *.jar` do echo $i jar tf $i | grep -i HBaseClient done [qfc@adev04 lib]$ ls *jar hbase-trx-apache1_0_2-2.2.0.jar sqmanvers.jar hbase-trx-apache1_1_2-2.2.0.jar trafodion-dtm-2.2.0.jar hbase-trx-cdh5_4-2.2.0.jar trafodion-dtm-apache1_0_2-2.2.0.jar hbase-trx-cdh5_5-2.2.0.jar trafodion-dtm-hdp2_3-2.2.0.jar hbase-trx-hdp2_3-2.2.0.jar trafodion-sql-2.2.0.jar jdbcT2.jar trafodion-sql-apache1_0_2-2.2.0.jar jdbcT4-2.2.0.jar trafodion-sql-hdp2_3-2.2.0.jar jdbcT4.jar trafodion-utility-2.2.0.jar lib_mgmt.jar On Wed, Aug 24, 2016 at 2:57 PM, Anoop Sharma <[email protected]> wrote: > It is usually a good idea to run the script ilh_traf_restart after a > rebase or these kind of changes. > It internally does some hbase/zookeeper cleanup, resqgen and sqstarts. > > This script was added by Narendra a while back. > > anoop > > -----Original Message----- > From: Dave Birdsall [mailto:[email protected]] > Sent: Wednesday, August 24, 2016 1:54 PM > To: [email protected] > Subject: RE: Getting class not found error on latest Trafodion > > Hi Narendra, > > Indeed! That was my problem. > > A recent check-in renamed the SQL and DTM Jar files. Of course the ". > ./env.sh" picks up the new name. But my ms.env file had the old. > > Removing etc/ms.env, then doing an sqgen, then starting again from a > new shell solved the problem. > > Many thanks! > > Dave > > -----Original Message----- > From: Narendra Goyal [mailto:[email protected]] > Sent: Wednesday, August 24, 2016 1:35 PM > To: [email protected] > Subject: RE: Getting class not found error on latest Trafodion > > Another suggestion base on what I have encountered in the past. > > Please check the CLASSPATH in $MY_SQROOT/etc/ms.env - looking for the > trafodion-sql JAR. Is it 'exactly' the same name as the one that is in > $MY_SQROOT/export/lib? > > If it does not match then you might want to re-sqgen. You could also > simply modify ms.env so that the name matches. > > - stop the Trafodion env > - restart the shell > - delete $MY_SQROOT/etc/ms.env > - sqgen > - restart Trafodion > > > Thanks, > -Narendra > > -----Original Message----- > From: Dave Birdsall [mailto:[email protected]] > Sent: Wednesday, August 24, 2016 1:20 PM > To: [email protected] > Subject: RE: Getting class not found error on latest Trafodion > > Hi Narendra, > > Here's what I get: > > [birdsall@edev05 incubator-trafodion]$ cp_search /HBaseClient.class > /mnt2/birdsall/incubator-trafodion/core/sqf/export/lib/ > trafodion-sql-cdh-2.1.0.jar: > org/trafodion/sql/HBaseClient.class > [birdsall@edev05 incubator-trafodion]$ jar tf > /mnt2/birdsall/incubator-trafodion/core/sqf/export/lib/ > trafodion-sql-cdh-2.1.0.jar > | grep HBaseClient > org/trafodion/sql/HBaseClient$ChangeFlags.class > org/trafodion/sql/HBaseClient.class > [birdsall@edev05 incubator-trafodion]$ > > Thanks, > > Dave > > -----Original Message----- > From: Narendra Goyal [mailto:[email protected]] > Sent: Wednesday, August 24, 2016 1:19 PM > To: [email protected] > Subject: RE: Getting class not found error on latest Trafodion > > Hi Dave, > > Could you please try: > > cp_search /HBaseClient.class > > It will tell us the JAR name where the class can be found. > > If it does not find the class in the JAR, please double check in the > JAR as > follows: > > jar tf > /mnt2/birdsall/incubator-trafodion/core/sqf/export/lib/ > trafodion-sql-cdh-2.1.0.jar > | grep HBaseClient > > If it is still not there then there may be some issue with the build > of the trafodion sql JAR. > > Thanks, > -Narendra > > > -----Original Message----- > From: Dave Birdsall [mailto:[email protected]] > Sent: Wednesday, August 24, 2016 12:54 PM > To: [email protected] > Subject: Getting class not found error on latest Trafodion > > Hi, > > > > Today I set up a new branch on latest Trafodion to do some development > work. > > > > I made some code changes to some C++ modules, did a make clean + a > make all. > > > > I then bring up the instance. When I try to bring up sqlci, I get the > following: > > > > [birdsall@edev05 incubator-trafodion]$ sqlci > > Apache Trafodion Conversational Interface 2.1.0 > > Copyright (c) 2015-2016 Apache Software Foundation > > >>get tables; > > > > *** ERROR[1398] Error 706 occured while accessing the hbase subsystem. > Fix that error and make sure hbase is up and running. Error Details: > > java.lang.NoClassDefFoundError: org/trafodion/sql/HBaseClient > > . > > > > *** ERROR[8822] The statement was not prepared. > > >> > > > > I checked my $CLASSPATH: It does have > /mnt2/birdsall/incubator-trafodion/core/sqf/export/lib/ > trafodion-sql-cdh-2.1.0.jar > in it. > > > > Any ideas? > > > > Thanks, > > > > Dave > -- Regards, --Qifan
