Re: Blog of jdbc interpreter on zeppelin

Thank Jeff for sharing the article! On Mon, Jul 6, 2020 at 5:38 PM Wesley wrote: > > > Jeff Zhang wrote: > > I write a article about jdbc interpreter on zeppelin, hope it is helpful > > for you. > > > > > https://medium.com/@zjffdu/jdbc-interpret

Re: Blog of jdbc interpreter on zeppelin

Jeff Zhang wrote: I write a article about jdbc interpreter on zeppelin, hope it is helpful for you. https://medium.com/@zjffdu/jdbc-interpreter-on-zeppelin-tutorial-8a7958b8c94e Nice article. Thanks for share. regards.

Blog of jdbc interpreter on zeppelin

I write a article about jdbc interpreter on zeppelin, hope it is helpful for you. https://medium.com/@zjffdu/jdbc-interpreter-on-zeppelin-tutorial-8a7958b8c94e -- Best Regards Jeff Zhang

Re: Zeppelin with JDBC interpreter, need queryBuilder help

27;t committed though) >> >> -- >> Ruslan Dautkhanov >> >> >> On Fri, Oct 5, 2018 at 2:43 PM anirban chatterjee < >> anirban.chatter...@gmail.com> wrote: >> >>> Hi, Can one get query builder type support (intellisense capability >>

Re: Zeppelin with JDBC interpreter, need queryBuilder help

> >> Hi, Can one get query builder type support (intellisense capability >> where one gets suggestions on available tables, columns, fields etc >> contextually) with the JDBC interpreter? We are using Zeppelin with Presto, >> and would like to get suggestions of table

Re: Zeppelin with JDBC interpreter, need queryBuilder help

mail.com> wrote: > Hi, Can one get query builder type support (intellisense capability where > one gets suggestions on available tables, columns, fields etc contextually) > with the JDBC interpreter? We are using Zeppelin with Presto, and would > like to get suggestions of table'

Re: Zeppelin with JDBC interpreter, need queryBuilder help

Hi, Can one get query builder type support (intellisense capability where one gets suggestions on available tables, columns, fields etc contextually) with the JDBC interpreter? We are using Zeppelin with Presto, and would like to get suggestions of table's fields (not just keywords that one

Re: JDBC interpreter - Illegal principal name // org.apache.hadoop.security.authentication.util.KerberosName$NoMatchingRule

Dears, I figured out that I was missing jars in the zeppelin jdbc interpreter repository. I added them manually and it worked. Kind regards, 2017-04-04 14:02 GMT+02:00 Michał Kabocik : > Dears, > > I'm trying to enable %jdbc interpreter to be able to work with hive tables.

JDBC interpreter - Illegal principal name // org.apache.hadoop.security.authentication.util.KerberosName$NoMatchingRule

Dears, I'm trying to enable %jdbc interpreter to be able to work with hive tables. I'm using kerberized HDP 2.5.3 with Zeppelin 0.6.2. I also have hue which we are using for a long time. Zeppelin is connected to AD, so I log in using my CK. The same CK is used to log in to hue and it

Re: Challenges while creating interactive visualization using %jdbc interpreter - Experiments with jdbc interpreter

message in context: http://apache-zeppelin-users-incubating-mailing-list.75479.x6.nabble.com/Challenges-while-creating-interactive-visualization-using-jdbc-interpreter-Experiments-with-jdbc-intr-tp3903p4694.html Sent from the Apache Zeppelin Users (incubating) mailing list mailing list archive at Nabble.com.

JDBC Interpreter does not commit updates workaround?

Hello All! From Zeppelin Notes, is there a way to make the JDBCInterpreter commit after I run an upset command? Or somehow call the connection.commit method? I know there’s an open JIRA for this(https://issues.apache.org/jira/browse/ZEPPELIN-1645

Re: Use user id dynamically in JDBC interpreter

Hi, This feature is work in progress here https://github.com/apache/zeppelin/pull/1539 Hope we can see this feature in master, soon. Thanks, moon On Wed, Nov 2, 2016 at 1:07 PM Chen Song wrote: > Hello > > Is there a way to configure a JDBC interpreter to use the user id logged >

Use user id dynamically in JDBC interpreter

Hello Is there a way to configure a JDBC interpreter to use the user id logged in instead of a static value? Something like shown below: default.user -> jdbc_user to default.user -> ${user_id} Chen

ConcurrentModificationException when trying to create JDBC interpreter

Hi, I caught this error when trying to using JDBC to query my Hive. With the same environment setting, I was able to connect to my Hive and query tables, create tables, etc..So I think the problem is not related to my environment. I created ticket https://issues.apache.org/jira/browse/ZEPPELIN-15

zeppelin-0.6.1 - hive jdbc interpreter dependecies not loading

I added hive jdbc dependencies to the jdbc interpreter. I'm seeing these kind of errors all over in the hive interpreter log and getting a message on the interpreter UI that "Failed to collect dependencies for org.apache.hive:hive-jdbc:jar:0.14.0 (compile)"

Re: Challenges while creating interactive visualization using %jdbc interpreter - Experiments with jdbc interpreter

wse/ZEPPELIN-1363. it might be related. >> Zeppelin's interpreter abstraction allows any interpreter creates >> something like Z context. To expose Z context to user in %jdbc interpreter, >> we need proper syntax for it. i.e. %spark interpreter expose Z context as >> scala api

Re: Challenges while creating interactive visualization using %jdbc interpreter - Experiments with jdbc interpreter

I need is one input box at the top and bind the remaining > paragraphs with it > I have created an issue https://issues.apache. > org/jira/browse/ZEPPELIN-1363. it might be related. > Zeppelin's interpreter abstraction allows any interpreter creates > something like Z context.

Re: Challenges while creating interactive visualization using %jdbc interpreter - Experiments with jdbc interpreter

eates something like Z context. To expose Z context to user in %jdbc interpreter, we need proper syntax for it. i.e. %spark interpreter expose Z context as scala api. %pyspark interpreter expose Z context as python api. %jdbc interpreter expose Z context as ..? 2. Store query result into a spark data

Re: JDBC interpreter question

Hi, No, not yet. On Tuesday, 23 August 2016, MrAsanjar . wrote: > Hi all, > Does Zeppelin 0.6.0 JDBC interpreter supporters multiple queries in a > single paragraph (snippet)? > i.e. > > %jdbc(hive) > drop table table1 > drop table table2 > > > -- 이종열, Jongyoul Lee, 李宗烈 http://madeng.net

JDBC interpreter question

Hi all, Does Zeppelin 0.6.0 JDBC interpreter supporters multiple queries in a single paragraph (snippet)? i.e. %jdbc(hive) drop table table1 drop table table2

Re: JDBC Interpreter

more meaningful error message. Currently the interpreter seems to refuse any additional command - once you have tried to launch a series of semi-colon separated commands On Friday, 19 August 2016, Jongyoul Lee wrote: > Zeppelin's JDBC interpreter support single commands at once. Tha

Challenges while creating interactive visualization using %jdbc interpreter - Experiments with jdbc interpreter

. Below are couple of challenges which I faced while using %jdbc interpreter, If it seems valid enhancement I can go and create defects for them 1. *Something similar to z context in %jdbc interpreter* - I have a *input box* which takes number of days as input . I have a number of paragraph

Re: Any reason why PostgreSQL is not merged into jdbc interpreter

Thanks Lee. On Fri, Aug 19, 2016 at 12:49 PM, Jongyoul Lee wrote: > PostgreSql will be merged into next major release. > > On Thu, Aug 18, 2016 at 5:03 PM, Jeff Zhang wrote: > >> Is there anything specific for postgreSQL so that zeppelin didn't merge >> it into

Re: Any reason why PostgreSQL is not merged into jdbc interpreter

PostgreSql will be merged into next major release. On Thu, Aug 18, 2016 at 5:03 PM, Jeff Zhang wrote: > Is there anything specific for postgreSQL so that zeppelin didn't merge it > into the general jdbc interpreter ? > > -- > Best Regards > > Jeff Zhang > --

Re: JDBC Interpreter

Zeppelin's JDBC interpreter support single commands at once. That's because Zeppelin cannot handle different multiple output within a paragraph. On Fri, Aug 19, 2016 at 1:50 AM, tog wrote: > Hi > > I have installed Zeppelin so that it can connect to a HDP cluster. > > I

JDBC Interpreter

Hi I have installed Zeppelin so that it can connect to a HDP cluster. I have configured the jdbc interpreter to use HIVE - but I have a strange behavior (i.e. differences with what I get from Ambari) For example, the following *does work* with Ambari: show databases; use mydb; show tables; The

Any reason why PostgreSQL is not merged into jdbc interpreter

Is there anything specific for postgreSQL so that zeppelin didn't merge it into the general jdbc interpreter ? -- Best Regards Jeff Zhang

Re: jdbc interpreter settings [pb with HIVE]

mal hive one (+ some options) > > Cheers > Guillaume > > > On Tuesday, 16 August 2016, Vinay Shukla wrote: > >> Guillaume, >> >> Can you try this? >> >> Enable Zeppelin authentication, via Shiro config and have Kerberos setup >> for Zeppelin. Zeppe

Any reason why PostgreSQL is not merged into jdbc interpreter

Is there anything specific for postgreSQL so that zeppelin didn't merge it into the general jdbc interpreter ? -- Best Regards Jeff Zhang

Re: Zeppelin JDBC Interpreter to Apache Drill

ter to connect to Drill? > We would like to use Zeppelin reports based around Drill queries. I found > stories in Git based on adding Drill as a jdbc Interpreter but I can’t find > instructions on how to add Drill. For example: https://github.com/apache/ > zeppelin/pull/718 > >

Zeppelin JDBC Interpreter to Apache Drill

Does anyone have experience connecting Zeppelin to Apache Drill? Are there instructions I can follow to configure an Interpreter to connect to Drill? We would like to use Zeppelin reports based around Drill queries. I found stories in Git based on adding Drill as a jdbc Interpreter but I can&#

Re: Drill JDBC Interpreter: Connection Refused

ctPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) > > at > java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) > > at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) > > at java.net.Socket.connect(Socket.java:589) > >

RE: Drill JDBC Interpreter: Connection Refused

at java.net.Socket.connect(Socket.java:589) at org.apache.thrift.transport.TSocket.open(TSocket.java:182) ... 9 more From: Jongyoul Lee [mailto:jongy...@gmail.com] Sent: Thursday, July 28, 2016 3:02 AM To: users@zeppelin.apache.org Subject: Re: Drill JDBC Interpreter: Connection Re

Re: Drill JDBC Interpreter: Connection Refused

PoolExecutor.java:180) > > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293) > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > > at

RE: Drill JDBC Interpreter: Connection Refused

r.java:617) at java.lang.Thread.run(Thread.java:745) From: Jongyoul Lee [mailto:jongy...@gmail.com] Sent: Tuesday, July 12, 2016 10:53 PM To: users@zeppelin.apache.org Subject: Re: Drill JDBC Interpreter: Connection Refused Hello, It seem not to launch remote Interpreter properly. Whi

Re: Drill JDBC Interpreter: Connection Refused

Hello, It seem not to launch remote Interpreter properly. Which version are you using? I've found the error file and couldn't find the version which you are using JL On Wed, Jul 13, 2016 at 2:32 PM, Krishnaprasad A S < krishna.pra...@flytxt.com> wrote: > I tried with, > %jdbc(drill) > %drill >

Re: Drill JDBC Interpreter: Connection Refused

I tried with, %jdbc(drill) %drill %drill(jdbc) Currently I made the drill interpretor as the default one and ran the sql without using a %drill, select count(*) from `dfs`.`POC/Sample1.csv` Please find attached error log. On Wed, Jul 13, 2016 at 5:26 AM, Jongyoul Lee wrote: > Hello, > >

Re: Drill JDBC Interpreter: Connection Refused

Hello, It looks like a kind of initialization error. Could you tell me your script starting from %? And interpreter logs which is located under logs/ will help solve this error. Hope this help, JL On Wednesday, 13 July 2016, Krishnaprasad A S wrote: > hi, > I'm trying to create a drill int

Fwd: Drill JDBC Interpreter: Connection Refused

hi, I'm trying to create a drill interpreter in zeppelin. *drill.url = jdbc:drill:zk=:2181/drill/drillbits1drill.driver = org.apache.drill.jdbc.Driver* my drillbit runs on the same server as of zeppelin. Added the dependency 'apache-drill-1.7.0/jars/drill-jdbc-all-1.7.0.jar' in zeppelin ui. I'm t

Re: JDBC interpreter is not concurrent

Hi!This PR https://issues.apache.org/jira/browse/ZEPPELIN-995 helped a bit but still the JDBC interpreter is somehow different.First, it shows very weird error messages (actually, pretty standard Java error stack but they are not about SQL and I can't understand what's wrong with my quer

Re: JDBC interpreter is not concurrent

duler getScheduler() { >>> return SchedulerFactory.singleton().createOrGetParallelScheduler( >>> HiveInterpreter.class.getName() + this.hashCode(), 10); >>> } >>> >>> Thanks, >>> Prasad >>> >>> On Fri, Ju

Re: JDBC interpreter is not concurrent

shCode(), 10); >> } >> >> Thanks, >> Prasad >> >> On Fri, Jun 10, 2016 at 5:52 AM, Boris Schminke > > wrote: >> >>> Hi all, >>> when I used the Hive interpreter I could send several queries in >>> parallel. No

Re: JDBC interpreter is not concurrent

preter is merged into JDBC (which >> is very good) but I can not execute concurrent Hive queries (which is not >> so good). >> How can I run concurrent queries to Hive using JDBC interpreter now in >> Zeppelin 0.6? >> >> Regards, >> Boris >> > >

Re: JDBC interpreter is not concurrent

terpreter is merged into JDBC (which is very > good) but I can not execute concurrent Hive queries (which is not so good). > How can I run concurrent queries to Hive using JDBC interpreter now in > Zeppelin 0.6? > > Regards, > Boris >

JDBC interpreter is not concurrent

Hi all, when I used the Hive interpreter I could send several queries in parallel. Now in Zeppelin 0.6 Hive Interpreter is merged into JDBC (which is very good) but I can not execute concurrent Hive queries (which is not so good). How can I run concurrent queries to Hive using JDBC interpreter now