[ANNOUNCE] Apache Phoenix 4.13.1 released
The Apache Phoenix team is pleased to announce the immediate availability of the 4.13.1 release. Apache Phoenix enables SQL-based OLTP and operational analytics for Apache Hadoop using Apache HBase as its backing store and providing integration with other projects in the Apache ecosystem such as Spark, Hive, Pig, Flume, and MapReduce. This releases is compatible with HBase 0.98, 1.1, 1.2 and 1.3. Highlights of the release include: * Support again for HBase 1.1 and 1.2 due to community ask * Inclusion of required server-side jars for new COLLATION_KEY function [1] Source and binary downloads are available here [2]. Note that in the future, releases will be done separately for each branches by dedicated release managers. I'll send out an email on this soon. Thanks, James (on behalf of the Apache Phoenix team) [1] https://issues.apache.org/jira/browse/PHOENIX-4384 [2] http://phoenix.apache.org/download.html
Re: Problem With QueryServer In SQL Line Thin Client.
Hi Josh, Here's the full stacktrace from PQS, I think its saying the PQS at localhost has an error. python sqlline-thin.py bigdata-namenode:8765 Failed to extract serialization from hbase-site.xml, defaulting to PROTOBUF. Setting property: [incremental, false] Setting property: [isolation, TRANSACTION_READ_COMMITTED] issuing: !connect jdbc:phoenix:thin:url=http://bigdata-namenode:8765;serialization=PROTOBUF none none org.apache.phoenix.queryserver.client.Driver Connecting to jdbc:phoenix:thin:url=http://bigdata-namenode:8765;serialization=PROTOBUF SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/home/saque/hadoopec/phoenix/apache-phoenix-4.12.0-HBase-1.2-bin/phoenix-4.12.0-HBase-1.2-thin-client.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/home/saque/hadoopec/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. AvaticaClientRuntimeException: Remote driver error: RuntimeException: java.sql.SQLException: No suitable driver found for localhost -> SQLException: No suitable driver found for localhost. Error -1 (0) null java.lang.RuntimeException: java.sql.SQLException: No suitable driver found for localhost at org.apache.calcite.avatica.jdbc.JdbcMeta.openConnection(JdbcMeta.java:621) at org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:285) at org.apache.calcite.avatica.remote.Service$OpenConnectionRequest.accept(Service.java:1771) at org.apache.calcite.avatica.remote.Service$OpenConnectionRequest.accept(Service.java:1751) at org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:94) at org.apache.calcite.avatica.remote.ProtobufHandler.apply(ProtobufHandler.java:46) at org.apache.calcite.avatica.server.AvaticaProtobufHandler.handle(AvaticaProtobufHandler.java:127) at org.apache.phoenix.shaded.org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52) at org.apache.phoenix.shaded.org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97) at org.apache.phoenix.shaded.org.eclipse.jetty.server.Server.handle(Server.java:499) at org.apache.phoenix.shaded.org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311) at org.apache.phoenix.shaded.org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257) at org.apache.phoenix.shaded.org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544) at org.apache.phoenix.shaded.org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635) at org.apache.phoenix.shaded.org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLException: No suitable driver found for localhost at java.sql.DriverManager.getConnection(DriverManager.java:689) at java.sql.DriverManager.getConnection(DriverManager.java:208) at org.apache.calcite.avatica.jdbc.JdbcMeta.openConnection(JdbcMeta.java:618) ... 15 more at org.apache.calcite.avatica.remote.Service$ErrorResponse.toException(Service.java:2476) at org.apache.calcite.avatica.remote.RemoteProtobufService._apply(RemoteProtobufService.java:63) at org.apache.calcite.avatica.remote.ProtobufService.apply(ProtobufService.java:81) at org.apache.calcite.avatica.remote.Driver.connect(Driver.java:176) at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157) at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203) at sqlline.Commands.connect(Commands.java:1064) at sqlline.Commands.connect(Commands.java:996) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38) at sqlline.SqlLine.dispatch(SqlLine.java:809) at sqlline.SqlLine.initArgs(SqlLine.java:588) at sqlline.SqlLine.begin(SqlLine.java:661) at sqlline.SqlLine.start(SqlLine.java:398) at sqlline.SqlLine.main(SqlLine.java:291) at org.apache.phoenix.queryserver.client.SqllineWrapper.main(SqllineWrapper.java:93) sqlline version 1.2.0 0: jdbc:phoenix:thin:url=http://bigdata-namen> !quit AvaticaClientRuntimeException: Remote driver error: RuntimeException: java.sql.SQLException: No suitable driver found for localhost -> SQLException: No suitable driver found for localhost. Error -1 (0) null java.lang.RuntimeException: java.sql.SQLException: No suitable driver found for localhost at org.apache.calcite.avatica.jdbc.JdbcMeta.openConnection(JdbcMeta.java:621) at org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:285) at org.apache.calcite.avatica.remote.Service$OpenConnectionRequest.accept(Service.java:1771) at
Re: Problem With QueryServer In SQL Line Thin Client.
I can't seem to track down that error message to any specific line of code. Do you have a stacktrace in the PQS log? I'm not sure the the message is implying that "localhost" is being interpreted as a class name or if it's saying the PQS at localhost had an error. The more details you can provide, the better. On 12/7/17 12:55 AM, Vaghawan Ojha wrote: Hi, I'm facing a weird problem with queryserver. When I start the queryserver, the log says that the service is listening in the port 8765, everything looks fine. But when I try to use the queryserver, the error like this prompts up. n$ python sqlline-thin.py localhost:8765 Failed to extract serialization from hbase-site.xml, defaulting to PROTOBUF. Setting property: [incremental, false] Setting property: [isolation, TRANSACTION_READ_COMMITTED] issuing: !connect jdbc:phoenix:thin:url=http://localhost:8765;serialization=PROTOBUF none none org.apache.phoenix.queryserver.client.Driver Connecting to jdbc:phoenix:thin:url=http://localhost:8765;serialization=PROTOBUF SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/home/saque/hadoopec/phoenix/apache-phoenix-4.12.0-HBase-1.2-bin/phoenix-4.12.0-HBase-1.2-thin-client.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/home/saque/hadoopec/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. AvaticaClientRuntimeException: Remote driver error: RuntimeException: java.sql.SQLException: No suitable driver found for localhost -> SQLException: No suitable driver found for localhost. Error -1 (0) null java.lang.RuntimeException: java.sql.SQLException: No suitable driver found for localhost The same queryserver was running before the server was restarted. This happens all the time, when I restart the server. The hadoop classpath and hbase classpath are there. The sqlline with zookeper port works fine. When I do: python sqlline.py localhost:2181. It works. However when I do python sqlline-thin.py localhost:8765, it throws such errors. Any help would be great, I'm using apache-phoenix-4.12.0-HBase-1.2 . Thanks in advance Vaghawan