Hi Russell, CDH 5.1 is HBase 0.98. You'll need Phoenix 4.x -- the 3.x line is for HBase 0.94 series.
-n On Mon, Aug 18, 2014 at 11:55 AM, Russell Jurney <[email protected]> wrote: > I added hbase-server.jar and it fixed that error. Now I get: > > java.lang.NoSuchMethodError: > org.apache.hadoop.hbase.client.Delete.addDeleteMarker(Lorg/apache/hadoop/hbase/KeyValue;)Lorg/apache/hadoop/hbase/client/Delete; > > at > org.apache.phoenix.hbase.index.util.KeyValueBuilder.deleteQuietly(KeyValueBuilder.java:61) > > at > org.apache.phoenix.schema.PTableImpl$PRowImpl.setValue(PTableImpl.java:621) > > at > org.apache.phoenix.execute.MutationState.addRowMutations(MutationState.java:176) > > at > org.apache.phoenix.execute.MutationState.access$200(MutationState.java:70) > > at org.apache.phoenix.execute.MutationState$2.init(MutationState.java:239) > > at > org.apache.phoenix.execute.MutationState$2.<init>(MutationState.java:236) > > at > org.apache.phoenix.execute.MutationState.toMutations(MutationState.java:234) > > at > org.apache.phoenix.execute.MutationState.toMutations(MutationState.java:224) > > at > org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1106) > > at > org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:422) > > at > org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:183) > > at > org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:226) > > at > org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:908) > > at > org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1351) > > at > org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:131) > > at > org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:112) > > at sqlline.SqlLine$DatabaseConnection.connect(SqlLine.java:4650) > > at sqlline.SqlLine$DatabaseConnection.getConnection(SqlLine.java:4701) > > at sqlline.SqlLine$Commands.connect(SqlLine.java:3942) > > at sqlline.SqlLine$Commands.connect(SqlLine.java:3851) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > at java.lang.reflect.Method.invoke(Method.java:606) > > at sqlline.SqlLine$ReflectiveCommandHandler.execute(SqlLine.java:2810) > > at sqlline.SqlLine.dispatch(SqlLine.java:817) > > at sqlline.SqlLine.initArgs(SqlLine.java:633) > > at sqlline.SqlLine.begin(SqlLine.java:680) > > at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441) > > at sqlline.SqlLine.main(SqlLine.java:424) > > at com.hivedata.phoenix.PhoenixSqlline.main(PhoenixSqlline.java:16) > > sqlline version 1.1.2 > ᐧ > > > On Mon, Aug 18, 2014 at 10:58 AM, Russell Jurney <[email protected] > > wrote: > >> I run SQLLine, configured to work with CDH 5.1, via the following command: >> >> java -cp >>> lib/*:target/uber-phoenix-debug-1.0-SNAPSHOT.jar:target/phoenix-debug-1.0-SNAPSHOT.jar >>> com.hivedata.phoenix.PhoenixSqlline -u jdbc:phoenix:cluster1-srv2 -n none >>> -p none --color=true --fastConnect=true --silent=false --verbose=true >>> --isolation=TRANSACTION_READ_COMMITTED -d >>> org.apache.phoenix.jdbc.PhoenixDriver >>> >> >> And I get the error below. I'm not sure what to do, plz help :) >> >> >> Setting property: [isolation, TRANSACTION_READ_COMMITTED] >>>> >>>> issuing: !connect jdbc:phoenix:cluster1-srv2 none none >>>> org.apache.phoenix.jdbc.PhoenixDriver >>>> >>>> Connecting to jdbc:phoenix:cluster1-srv2 >>>> java.lang.NoClassDefFoundError: >>>> org/apache/hadoop/hbase/regionserver/ConstantSizeRegionSplitPolicy >>>> at java.lang.ClassLoader.defineClass1(Native Method) >>>> at java.lang.ClassLoader.defineClass(ClassLoader.java:800) >>>> at >>>> java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) >>>> at java.net.URLClassLoader.defineClass(URLClassLoader.java:449) >>>> at java.net.URLClassLoader.access$100(URLClassLoader.java:71) >>>> at java.net.URLClassLoader$1.run(URLClassLoader.java:361) >>>> at java.net.URLClassLoader$1.run(URLClassLoader.java:355) >>>> at java.security.AccessController.doPrivileged(Native Method) >>>> at java.net.URLClassLoader.findClass(URLClassLoader.java:354) >>>> at java.lang.ClassLoader.loadClass(ClassLoader.java:425) >>>> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) >>>> at java.lang.ClassLoader.loadClass(ClassLoader.java:358) >>>> at >>>> org.apache.phoenix.query.QueryConstants.<clinit>(QueryConstants.java:154) >>>> at >>>> org.apache.phoenix.util.SchemaUtil.getNameAsBytes(SchemaUtil.java:238) >>>> at >>>> org.apache.phoenix.util.SchemaUtil.getTableNameAsBytes(SchemaUtil.java:229) >>>> at >>>> org.apache.phoenix.util.SchemaUtil.getTableNameAsBytes(SchemaUtil.java:225) >>>> at >>>> org.apache.phoenix.query.ConnectionQueryServicesImpl.<clinit>(ConnectionQueryServicesImpl.java:162) >>>> at >>>> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:121) >>>> at >>>> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:112) >>>> at sqlline.SqlLine$DatabaseConnection.connect(SqlLine.java:4650) >>>> at sqlline.SqlLine$DatabaseConnection.getConnection(SqlLine.java:4701) >>>> at sqlline.SqlLine$Commands.connect(SqlLine.java:3942) >>>> at sqlline.SqlLine$Commands.connect(SqlLine.java:3851) >>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>> at >>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) >>>> at >>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>>> at java.lang.reflect.Method.invoke(Method.java:606) >>>> at sqlline.SqlLine$ReflectiveCommandHandler.execute(SqlLine.java:2810) >>>> at sqlline.SqlLine.dispatch(SqlLine.java:817) >>>> at sqlline.SqlLine.initArgs(SqlLine.java:633) >>>> at sqlline.SqlLine.begin(SqlLine.java:680) >>>> at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441) >>>> at sqlline.SqlLine.main(SqlLine.java:424) >>>> at com.hivedata.phoenix.PhoenixSqlline.main(PhoenixSqlline.java:16) >>>> Caused by: java.lang.ClassNotFoundException: >>>> org.apache.hadoop.hbase.regionserver.ConstantSizeRegionSplitPolicy >>>> at java.net.URLClassLoader$1.run(URLClassLoader.java:366) >>>> at java.net.URLClassLoader$1.run(URLClassLoader.java:355) >>>> at java.security.AccessController.doPrivileged(Native Method) >>>> at java.net.URLClassLoader.findClass(URLClassLoader.java:354) >>>> at java.lang.ClassLoader.loadClass(ClassLoader.java:425) >>>> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) >>>> at java.lang.ClassLoader.loadClass(ClassLoader.java:358) >>>> ... 34 more >>>> sqlline version 1.1.2 >>>> -- >>>> Russell Jurney twitter.com/rjurney [email protected] >>>> datasyndrome.com >>>> >>>> ᐧ >> > > > > -- > Russell Jurney twitter.com/rjurney [email protected] datasyndrome. > com >
