Re: Problem With QueryServer In SQL Line Thin Client.

2017-12-11 Thread Josh Elser 

Weird, but glad you got it figured out.

PQS pulls the (thick) PhoenixDriver from the phoenix-client.jar you have 
in your Phoenix installation. Perhaps you had accidentally moved the jar 
aside and restarted PQS leaving PQS running without that jar? Hard to 
say, but that's my only guess.


On 12/8/17 7:18 AM, Vaghawan Ojha wrote:

Hi Josh,

I fixed it by specifying the host where the query server was running 
while doing python queryserver.py stop.


Something like this: python queryserver.py stop localhost:8765

And again started normally, it started working.

Thanks a lot.
Vaghawan

On Fri, Dec 8, 2017 at 7:38 AM, Vaghawan Ojha > wrote:


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

Re: Problem With QueryServer In SQL Line Thin Client.

2017-12-08 Thread Vaghawan Ojha 
Hi Josh,

I fixed it by specifying the host where the query server was running while
doing python queryserver.py stop.

Something like this: python queryserver.py stop localhost:8765

And again started normally, it started working.

Thanks a lot.
Vaghawan

On Fri, Dec 8, 2017 at 7:38 AM, Vaghawan Ojha  wrote:

> 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:

Re: Problem With QueryServer In SQL Line Thin Client.

2017-12-07 Thread Vaghawan Ojha 
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.

2017-12-07 Thread Josh Elser 

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

Problem With QueryServer In SQL Line Thin Client.

2017-12-06 Thread Vaghawan Ojha 
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