Weird error in trying set up a hive interpreter.

classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

Weird error in trying set up a hive interpreter.

Michael Segel
I’m trying to set up a hive interpreter for Zeppelin 0.7.2
(I compiled from source. )

I got the following error, but not sure where I’m picking up a reference to Java 1.6.

Error setting properties for interpreter 'jdbc.hive': Could not find artifact jdk.tools:jdk.tools:jar:1.6 at specified path /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.144-0.b01.el7_4.x86_64/jre/../lib/tools.jar


Any suggestions?

Thx

Reply | Threaded
Open this post in threaded view
|

Re: Weird error in trying set up a hive interpreter.

Jeff Zhang

It is hard to tell without the full log. Could you paste the log ? And what dependency do you specify for your hive interpreter ? 

Michael Segel <[hidden email]>于2017年10月23日周一 上午11:08写道:
I’m trying to set up a hive interpreter for Zeppelin 0.7.2
(I compiled from source. )

I got the following error, but not sure where I’m picking up a reference to Java 1.6.

Error setting properties for interpreter 'jdbc.hive': Could not find artifact jdk.tools:jdk.tools:jar:1.6 at specified path /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.144-0.b01.el7_4.x86_64/jre/../lib/tools.jar


Any suggestions?

Thx

Reply | Threaded
Open this post in threaded view
|

Re: Weird error in trying set up a hive interpreter.

Michael Segel
Hi Jeff, 

The error occurred after I tried to save the interpreter… 
In a pop-up I saw :

Error setting properties for interpreter 'jdbc.hive': Could not find artifact jdk.tools:jdk.tools:jar:1.6 at specified path /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.144-0.b01.el7_4.x86_64/jre/../lib/tools.jar


I’ll check the logs and see what the say. 

My first thought was that there’s an old reference to Java 1.6 in a config file that I didn’t update , or was changed when I compiled version 0.7.2

Thx 

-Mike

On Oct 22, 2017, at 10:14 PM, Jeff Zhang <[hidden email]> wrote:


It is hard to tell without the full log. Could you paste the log ? And what dependency do you specify for your hive interpreter ? 

Michael Segel <[hidden email]>于2017年10月23日周一 上午11:08写道:
I’m trying to set up a hive interpreter for Zeppelin 0.7.2
(I compiled from source. )

I got the following error, but not sure where I’m picking up a reference to Java 1.6.

Error setting properties for interpreter 'jdbc.hive': Could not find artifact jdk.tools:jdk.tools:jar:1.6 at specified path /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.144-0.b01.el7_4.x86_64/jre/../lib/tools.jar


Any suggestions?

Thx


Reply | Threaded
Open this post in threaded view
|

Re: Weird error in trying set up a hive interpreter.

Michael Segel
In the zeppelin-interpreter log… 
ERROR [2017-10-23 00:00:03,759] ({BoneCP-pool-watch-thread} PoolWatchThread.java[fillConnections]:118) - Error in trying to obtain a connection. Retrying in 7000ms
java.sql.SQLException: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.setReadOnly(Unknown Source)
        at com.jolbox.bonecp.ConnectionHandle.setReadOnly(ConnectionHandle.java:1324)
        at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:262)
        at com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:115)

The log file rolled, and it looks like this was the start… 
ERROR [2017-10-22 00:00:00,012] ({BoneCP-pool-watch-thread} PoolWatchThread.java[fillConnections]:118) - Error in trying to obtain a connection. Retrying in 7000ms
java.sql.SQLException: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.setReadOnly(Unknown Source)
        at com.jolbox.bonecp.ConnectionHandle.setReadOnly(ConnectionHandle.java:1324)
        at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:262)
        at com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:115)
        at com.jolbox.bonecp.PoolWatchThread.run(PoolWatchThread.java:82)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)


Thx 

-Mike

On Oct 23, 2017, at 6:42 AM, Michael Segel <[hidden email]> wrote:

Hi Jeff, 

The error occurred after I tried to save the interpreter… 
In a pop-up I saw :

Error setting properties for interpreter 'jdbc.hive': Could not find artifact jdk.tools:jdk.tools:jar:1.6 at specified path /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.144-0.b01.el7_4.x86_64/jre/../lib/tools.jar


I’ll check the logs and see what the say. 

My first thought was that there’s an old reference to Java 1.6 in a config file that I didn’t update , or was changed when I compiled version 0.7.2

Thx 

-Mike

On Oct 22, 2017, at 10:14 PM, Jeff Zhang <[hidden email]> wrote:


It is hard to tell without the full log. Could you paste the log ? And what dependency do you specify for your hive interpreter ? 

Michael Segel <[hidden email]>于2017年10月23日周一 上午11:08写道:
I’m trying to set up a hive interpreter for Zeppelin 0.7.2
(I compiled from source. )

I got the following error, but not sure where I’m picking up a reference to Java 1.6.

Error setting properties for interpreter 'jdbc.hive': Could not find artifact jdk.tools:jdk.tools:jar:1.6 at specified path /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.144-0.b01.el7_4.x86_64/jre/../lib/tools.jar


Any suggestions?

Thx



Reply | Threaded
Open this post in threaded view
|

Re: Weird error in trying set up a hive interpreter.

Jeff Zhang

Can you access the hive in cli to verify hive works properly 

Michael Segel <[hidden email]>于2017年10月23日周一 下午7:49写道:
In the zeppelin-interpreter log… 
ERROR [2017-10-23 00:00:03,759] ({BoneCP-pool-watch-thread} PoolWatchThread.java[fillConnections]:118) - Error in trying to obtain a connection. Retrying in 7000ms
java.sql.SQLException: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.setReadOnly(Unknown Source)
        at com.jolbox.bonecp.ConnectionHandle.setReadOnly(ConnectionHandle.java:1324)
        at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:262)
        at com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:115)

The log file rolled, and it looks like this was the start… 
ERROR [2017-10-22 00:00:00,012] ({BoneCP-pool-watch-thread} PoolWatchThread.java[fillConnections]:118) - Error in trying to obtain a connection. Retrying in 7000ms
java.sql.SQLException: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.setReadOnly(Unknown Source)
        at com.jolbox.bonecp.ConnectionHandle.setReadOnly(ConnectionHandle.java:1324)
        at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:262)
        at com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:115)
        at com.jolbox.bonecp.PoolWatchThread.run(PoolWatchThread.java:82)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)


Thx 

-Mike

On Oct 23, 2017, at 6:42 AM, Michael Segel <[hidden email]> wrote:

Hi Jeff, 

The error occurred after I tried to save the interpreter… 
In a pop-up I saw :

Error setting properties for interpreter 'jdbc.hive': Could not find artifact jdk.tools:jdk.tools:jar:1.6 at specified path /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.144-0.b01.el7_4.x86_64/jre/../lib/tools.jar


I’ll check the logs and see what the say. 

My first thought was that there’s an old reference to Java 1.6 in a config file that I didn’t update , or was changed when I compiled version 0.7.2

Thx 

-Mike

On Oct 22, 2017, at 10:14 PM, Jeff Zhang <[hidden email]> wrote:


It is hard to tell without the full log. Could you paste the log ? And what dependency do you specify for your hive interpreter ? 

Michael Segel <[hidden email]>于2017年10月23日周一 上午11:08写道:
I’m trying to set up a hive interpreter for Zeppelin 0.7.2
(I compiled from source. )

I got the following error, but not sure where I’m picking up a reference to Java 1.6.

Error setting properties for interpreter 'jdbc.hive': Could not find artifact jdk.tools:jdk.tools:jar:1.6 at specified path /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.144-0.b01.el7_4.x86_64/jre/../lib/tools.jar


Any suggestions?

Thx



Reply | Threaded
Open this post in threaded view
|

Re: Weird error in trying set up a hive interpreter.

Michael Segel
Hi, 

You were right. Hive wasn’t up and running. 

I’ve re-installed MapR, created the interpreter… but then ran in to a curious issue….

If I created a new note and made hive my default interpreter. I could run Hive commands. 
But… if I took a spark note and then tried to run %hive … within the note in a new paragraph… it fails. 
What am I missing? 

The error says that it doesn’t recognize the interpreter and I even restarted the hive interpreter from within the note… 


Thx

-Mike

On Oct 23, 2017, at 7:41 AM, Jeff Zhang <[hidden email]> wrote:


Can you access the hive in cli to verify hive works properly 

Michael Segel <[hidden email]>于2017年10月23日周一 下午7:49写道:
In the zeppelin-interpreter log… 
ERROR [2017-10-23 00:00:03,759] ({BoneCP-pool-watch-thread} PoolWatchThread.java[fillConnections]:118) - Error in trying to obtain a connection. Retrying in 7000ms
java.sql.SQLException: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.setReadOnly(Unknown Source)
        at com.jolbox.bonecp.ConnectionHandle.setReadOnly(ConnectionHandle.java:1324)
        at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:262)
        at com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:115)

The log file rolled, and it looks like this was the start… 
ERROR [2017-10-22 00:00:00,012] ({BoneCP-pool-watch-thread} PoolWatchThread.java[fillConnections]:118) - Error in trying to obtain a connection. Retrying in 7000ms
java.sql.SQLException: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.setReadOnly(Unknown Source)
        at com.jolbox.bonecp.ConnectionHandle.setReadOnly(ConnectionHandle.java:1324)
        at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:262)
        at com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:115)
        at com.jolbox.bonecp.PoolWatchThread.run(PoolWatchThread.java:82)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)


Thx 

-Mike

On Oct 23, 2017, at 6:42 AM, Michael Segel <[hidden email]> wrote:

Hi Jeff, 

The error occurred after I tried to save the interpreter… 
In a pop-up I saw :

Error setting properties for interpreter 'jdbc.hive': Could not find artifact jdk.tools:jdk.tools:jar:1.6 at specified path /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.144-0.b01.el7_4.x86_64/jre/../lib/tools.jar


I’ll check the logs and see what the say. 

My first thought was that there’s an old reference to Java 1.6 in a config file that I didn’t update , or was changed when I compiled version 0.7.2

Thx 

-Mike

On Oct 22, 2017, at 10:14 PM, Jeff Zhang <[hidden email]> wrote:


It is hard to tell without the full log. Could you paste the log ? And what dependency do you specify for your hive interpreter ? 

Michael Segel <[hidden email]>于2017年10月23日周一 上午11:08写道:
I’m trying to set up a hive interpreter for Zeppelin 0.7.2
(I compiled from source. )

I got the following error, but not sure where I’m picking up a reference to Java 1.6.

Error setting properties for interpreter 'jdbc.hive': Could not find artifact jdk.tools:jdk.tools:jar:1.6 at specified path /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.144-0.b01.el7_4.x86_64/jre/../lib/tools.jar


Any suggestions?

Thx




Reply | Threaded
Open this post in threaded view
|

Re: Weird error in trying set up a hive interpreter.

Jeff Zhang

What do you mean spark note ? There's no concept of spark note.

Could you give more details of your problem ? Maybe screenshot is helpful.



Michael Segel <[hidden email]>于2017年10月26日周四 上午12:07写道:
Hi, 

You were right. Hive wasn’t up and running. 

I’ve re-installed MapR, created the interpreter… but then ran in to a curious issue….

If I created a new note and made hive my default interpreter. I could run Hive commands. 
But… if I took a spark note and then tried to run %hive … within the note in a new paragraph… it fails. 
What am I missing? 

The error says that it doesn’t recognize the interpreter and I even restarted the hive interpreter from within the note… 


Thx

-Mike

On Oct 23, 2017, at 7:41 AM, Jeff Zhang <[hidden email]> wrote:


Can you access the hive in cli to verify hive works properly 

Michael Segel <[hidden email]>于2017年10月23日周一 下午7:49写道:
In the zeppelin-interpreter log… 
ERROR [2017-10-23 00:00:03,759] ({BoneCP-pool-watch-thread} PoolWatchThread.java[fillConnections]:118) - Error in trying to obtain a connection. Retrying in 7000ms
java.sql.SQLException: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.setReadOnly(Unknown Source)
        at com.jolbox.bonecp.ConnectionHandle.setReadOnly(ConnectionHandle.java:1324)
        at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:262)
        at com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:115)

The log file rolled, and it looks like this was the start… 
ERROR [2017-10-22 00:00:00,012] ({BoneCP-pool-watch-thread} PoolWatchThread.java[fillConnections]:118) - Error in trying to obtain a connection. Retrying in 7000ms
java.sql.SQLException: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.setReadOnly(Unknown Source)
        at com.jolbox.bonecp.ConnectionHandle.setReadOnly(ConnectionHandle.java:1324)
        at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:262)
        at com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:115)
        at com.jolbox.bonecp.PoolWatchThread.run(PoolWatchThread.java:82)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)


Thx 

-Mike

On Oct 23, 2017, at 6:42 AM, Michael Segel <[hidden email]> wrote:

Hi Jeff, 

The error occurred after I tried to save the interpreter… 
In a pop-up I saw :

Error setting properties for interpreter 'jdbc.hive': Could not find artifact jdk.tools:jdk.tools:jar:1.6 at specified path /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.144-0.b01.el7_4.x86_64/jre/../lib/tools.jar


I’ll check the logs and see what the say. 

My first thought was that there’s an old reference to Java 1.6 in a config file that I didn’t update , or was changed when I compiled version 0.7.2

Thx 

-Mike

On Oct 22, 2017, at 10:14 PM, Jeff Zhang <[hidden email]> wrote:


It is hard to tell without the full log. Could you paste the log ? And what dependency do you specify for your hive interpreter ? 

Michael Segel <[hidden email]>于2017年10月23日周一 上午11:08写道:
I’m trying to set up a hive interpreter for Zeppelin 0.7.2
(I compiled from source. )

I got the following error, but not sure where I’m picking up a reference to Java 1.6.

Error setting properties for interpreter 'jdbc.hive': Could not find artifact jdk.tools:jdk.tools:jar:1.6 at specified path /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.144-0.b01.el7_4.x86_64/jre/../lib/tools.jar


Any suggestions?

Thx




Reply | Threaded
Open this post in threaded view
|

Re: Weird error in trying set up a hive interpreter.

Michael Segel
Notebook with Spark as the default interpreter? 

Sorry, not sure how to describe it… 

So… I can create a new note with hive as the default  interpreter… everything is ok. 

Ok, that’s weird… now it works. 

I just created a spark notebook and then did %hive and then Show databaes;

That worked…. 


On Oct 25, 2017, at 6:08 PM, Jeff Zhang <[hidden email]> wrote:


What do you mean spark note ? There's no concept of spark note.

Could you give more details of your problem ? Maybe screenshot is helpful.



Michael Segel <[hidden email]>于2017年10月26日周四 上午12:07写道:
Hi, 

You were right. Hive wasn’t up and running. 

I’ve re-installed MapR, created the interpreter… but then ran in to a curious issue….

If I created a new note and made hive my default interpreter. I could run Hive commands. 
But… if I took a spark note and then tried to run %hive … within the note in a new paragraph… it fails. 
What am I missing? 

The error says that it doesn’t recognize the interpreter and I even restarted the hive interpreter from within the note… 


Thx

-Mike

On Oct 23, 2017, at 7:41 AM, Jeff Zhang <[hidden email]> wrote:


Can you access the hive in cli to verify hive works properly 

Michael Segel <[hidden email]>于2017年10月23日周一 下午7:49写道:
In the zeppelin-interpreter log… 
ERROR [2017-10-23 00:00:03,759] ({BoneCP-pool-watch-thread} PoolWatchThread.java[fillConnections]:118) - Error in trying to obtain a connection. Retrying in 7000ms
java.sql.SQLException: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.setReadOnly(Unknown Source)
        at com.jolbox.bonecp.ConnectionHandle.setReadOnly(ConnectionHandle.java:1324)
        at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:262)
        at com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:115)

The log file rolled, and it looks like this was the start… 
ERROR [2017-10-22 00:00:00,012] ({BoneCP-pool-watch-thread} PoolWatchThread.java[fillConnections]:118) - Error in trying to obtain a connection. Retrying in 7000ms
java.sql.SQLException: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
        at org.apache.derby.impl.jdbc.EmbedConnection.setReadOnly(Unknown Source)
        at com.jolbox.bonecp.ConnectionHandle.setReadOnly(ConnectionHandle.java:1324)
        at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:262)
        at com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:115)
        at com.jolbox.bonecp.PoolWatchThread.run(PoolWatchThread.java:82)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
        at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)


Thx 

-Mike

On Oct 23, 2017, at 6:42 AM, Michael Segel <[hidden email]> wrote:

Hi Jeff, 

The error occurred after I tried to save the interpreter… 
In a pop-up I saw :

Error setting properties for interpreter 'jdbc.hive': Could not find artifact jdk.tools:jdk.tools:jar:1.6 at specified path /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.144-0.b01.el7_4.x86_64/jre/../lib/tools.jar


I’ll check the logs and see what the say. 

My first thought was that there’s an old reference to Java 1.6 in a config file that I didn’t update , or was changed when I compiled version 0.7.2

Thx 

-Mike

On Oct 22, 2017, at 10:14 PM, Jeff Zhang <[hidden email]> wrote:


It is hard to tell without the full log. Could you paste the log ? And what dependency do you specify for your hive interpreter ? 

Michael Segel <[hidden email]>于2017年10月23日周一 上午11:08写道:
I’m trying to set up a hive interpreter for Zeppelin 0.7.2
(I compiled from source. )

I got the following error, but not sure where I’m picking up a reference to Java 1.6.

Error setting properties for interpreter 'jdbc.hive': Could not find artifact jdk.tools:jdk.tools:jar:1.6 at specified path /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.144-0.b01.el7_4.x86_64/jre/../lib/tools.jar


Any suggestions?

Thx