Re: Suggestions for Open Source FLINK SQL editor

[liu ron]

Hi Rajat,

I also think Zeppelin may be a good choice.

Best,
Ron

Guanghui Zhang  于2023年7月28日周五 20:45写道：

> Hi, Guozhen, our team also use flink as ad-hoc query engine.  Can we talk
> aboat it
>
> Guozhen Yang  于2023年7月20日周四 11:58写道：
>
>> Hi Rajat,
>>
>> We are using apache zeppelin as our entry point for submitting flink
>> ad-hoc queries (and spark jobs actually).
>>
>> It supports interactive queries, data visualization, multiple data query
>> engines, multiple auth models. You can check out other features on its
>> official website.
>>
>> But because of the inactivity of the apache zeppelin community (the last
>> stable release was a year and a half ago), we need to do a bit of custom
>> development and bug fixing on its master branch.
>>
>> On 2023/07/19 16:47:43 Rajat Ahuja wrote:
>> > Hi team,
>> >
>> > I have set up a session cluster on k8s via sql gateway.  I am looking
>> for
>> > an open source Flink sql editor that can submit sql queries on top of
>> the
>> > k8s session cluster. Any suggestions for sql editor to submit queries ?
>> >
>> >
>> > Thanks
>> >
>>
>

Re: Suggestions for Open Source FLINK SQL editor

[Guanghui Zhang]

Hi, Guozhen, our team also use flink as ad-hoc query engine.  Can we talk
aboat it

Guozhen Yang  于2023年7月20日周四 11:58写道：

> Hi Rajat,
>
> We are using apache zeppelin as our entry point for submitting flink
> ad-hoc queries (and spark jobs actually).
>
> It supports interactive queries, data visualization, multiple data query
> engines, multiple auth models. You can check out other features on its
> official website.
>
> But because of the inactivity of the apache zeppelin community (the last
> stable release was a year and a half ago), we need to do a bit of custom
> development and bug fixing on its master branch.
>
> On 2023/07/19 16:47:43 Rajat Ahuja wrote:
> > Hi team,
> >
> > I have set up a session cluster on k8s via sql gateway.  I am looking for
> > an open source Flink sql editor that can submit sql queries on top of the
> > k8s session cluster. Any suggestions for sql editor to submit queries ?
> >
> >
> > Thanks
> >
>

RE: Suggestions for Open Source FLINK SQL editor

[Jiabao Sun]

Hi Rajat,

I think Apache StreamPark(Incubating) or Apache Zeppelin is a good choice.

https://streampark.apache.org/ 
https://zeppelin.apache.org/ 


Best,
Jiabao


On 2023/07/19 16:47:43 Rajat Ahuja wrote:
> Hi team,
> 
> I have set up a session cluster on k8s via sql gateway.  I am looking for
> an open source Flink sql editor that can submit sql queries on top of the
> k8s session cluster. Any suggestions for sql editor to submit queries ?
> 
> 
> Thanks
> 

RE: Suggestions for Open Source FLINK SQL editor

[Guozhen Yang]

Hi Rajat,

We are using apache zeppelin as our entry point for submitting flink ad-hoc
queries (and spark jobs actually).

It supports interactive queries, data visualization, multiple data query
engines, multiple auth models. You can check out other features on its
official website.

But because of the inactivity of the apache zeppelin community (the last
stable release was a year and a half ago), we need to do a bit of custom
development and bug fixing on its master branch.

On 2023/07/19 16:47:43 Rajat Ahuja wrote:
> Hi team,
>
> I have set up a session cluster on k8s via sql gateway.  I am looking for
> an open source Flink sql editor that can submit sql queries on top of the
> k8s session cluster. Any suggestions for sql editor to submit queries ?
>
>
> Thanks
>

Re: Suggestions for Open Source FLINK SQL editor

[Shammon FY]

Hi Rajat,

Currently sql-gateway supports REST[1] and Hive[2] endpoints.

For Hive endpoints, you can submit sql jobs with existing Hive clients,
such as hive jdbc, apache superset and other systems.

For REST endpoints, you can use flink sql-client to submit your sql jobs.
We support jdbc-driver[3] in the next release version(1.18) and you can
submit sql jobs in all editors which support standard jdbc protocol such as
apache superset, tableau and .etc


[1]
https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/sql-gateway/rest/
[2]
https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/sql-gateway/hiveserver2/
[3]
https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/jdbcdriver/

Best,
Shammon FY

On Thu, Jul 20, 2023 at 12:48 AM Rajat Ahuja 
wrote:

> Hi team,
>
> I have set up a session cluster on k8s via sql gateway.  I am looking for
> an open source Flink sql editor that can submit sql queries on top of the
> k8s session cluster. Any suggestions for sql editor to submit queries ?
>
>
> Thanks
>

Suggestions for Open Source FLINK SQL editor

[Rajat Ahuja]

Hi team,

I have set up a session cluster on k8s via sql gateway.  I am looking for
an open source Flink sql editor that can submit sql queries on top of the
k8s session cluster. Any suggestions for sql editor to submit queries ?


Thanks