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 <msegel_had...@hotmail.com>于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 <zjf...@gmail.com> wrote:
>
>
> Can you access the hive in cli to verify hive works properly
>
> Michael Segel <msegel_had...@hotmail.com>于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 <msegel_had...@hotmail.com>
>> 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 <zjf...@gmail.com> 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 <msegel_had...@hotmail.com>于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
>>>
>>>
>>
>>
>
