Queryable state using JDBC

[Alberto Ramón]

Hello

I'm investigating about Flink + Calcite, StreamSQL, Queryable State

Is possible connect to Kylin using SQL Client via JDBC ?

(I always see API examples)

BR

[Till Rohrmann]

Hi Alberto,

have you checked out Flink's JDBCInputFormat? As far as I can tell, Kylin has support for JDBC and, thus, you should be able to read from it with this input format.

Cheers,

Till

On Tue, Oct 18, 2016 at 11:28 AM, Alberto Ramón <[hidden email]> wrote:

Hello

I'm investigating about Flink + Calcite, StreamSQL, Queryable State

Is possible connect to Kylin using SQL Client via JDBC ?

(I always see API examples)

BR

[Alberto Ramón]

Hi  :)

SQL Client ---> JDBC  ---> Flink (queryable state)

(I don't read from Flink a JDBC Source)

I want the opposite: See Flink as "realtime database" from my SQL Client ... for example: Tableau ---> Flink states

2016-10-18 14:52 GMT+02:00 Till Rohrmann <[hidden email]>:

Hi Alberto,

have you checked out Flink's JDBCInputFormat? As far as I can tell, Kylin has support for JDBC and, thus, you should be able to read from it with this input format.

Cheers,

Till

On Tue, Oct 18, 2016 at 11:28 AM, Alberto Ramón <[hidden email]> wrote:

Hello

I'm investigating about Flink + Calcite, StreamSQL, Queryable State

Is possible connect to Kylin using SQL Client via JDBC ?

(I always see API examples)

BR

[Till Rohrmann]

Oh now I understand. Sorry for my confusion. Flink does not offer a JDBC interface to query its state. The only way to do that is to use Flink's proprietary interface. Since this feature is highly experimental there is not a lot of documentation out there. I can recommend you this github repo [1] where you can see an example of how to access Flink state.

[1] https://github.com/dataArtisans/queryable-state-demo

Cheers,

Till

On Tue, Oct 18, 2016 at 3:22 PM, Alberto Ramón <[hidden email]> wrote:

Hi  :)

SQL Client ---> JDBC  ---> Flink (queryable state)

(I don't read from Flink a JDBC Source)

I want the opposite: See Flink as "realtime database" from my SQL Client ... for example: Tableau ---> Flink states

2016-10-18 14:52 GMT+02:00 Till Rohrmann <[hidden email]>:

Hi Alberto,

have you checked out Flink's JDBCInputFormat? As far as I can tell, Kylin has support for JDBC and, thus, you should be able to read from it with this input format.

Cheers,

Till

On Tue, Oct 18, 2016 at 11:28 AM, Alberto Ramón <[hidden email]> wrote:

Hello

I'm investigating about Flink + Calcite, StreamSQL, Queryable State

Is possible connect to Kylin using SQL Client via JDBC ?

(I always see API examples)

BR

[Alberto Ramón]

I don't have acess  or link don't work     :(

2016-10-18 16:15 GMT+02:00 Till Rohrmann <[hidden email]>:

Oh now I understand. Sorry for my confusion. Flink does not offer a JDBC interface to query its state. The only way to do that is to use Flink's proprietary interface. Since this feature is highly experimental there is not a lot of documentation out there. I can recommend you this github repo [1] where you can see an example of how to access Flink state.

[1] https://github.com/dataArtisans/queryable-state-demo

Cheers,

Till

On Tue, Oct 18, 2016 at 3:22 PM, Alberto Ramón <[hidden email]> wrote:

Hi  :)

SQL Client ---> JDBC  ---> Flink (queryable state)

(I don't read from Flink a JDBC Source)

I want the opposite: See Flink as "realtime database" from my SQL Client ... for example: Tableau ---> Flink states

2016-10-18 14:52 GMT+02:00 Till Rohrmann <[hidden email]>:

Hi Alberto,

have you checked out Flink's JDBCInputFormat? As far as I can tell, Kylin has support for JDBC and, thus, you should be able to read from it with this input format.

Cheers,

Till

On Tue, Oct 18, 2016 at 11:28 AM, Alberto Ramón <[hidden email]> wrote:

Hello

I'm investigating about Flink + Calcite, StreamSQL, Queryable State

Is possible connect to Kylin using SQL Client via JDBC ?

(I always see API examples)

BR

[Till Rohrmann]

Sorry, this seems to be a private repository. Then you could take a look at QueryableStateITCase in the Flink code base.

Cheers,

Till

On Tue, Oct 18, 2016 at 4:33 PM, Alberto Ramón <[hidden email]> wrote:

I don't have acess  or link don't work     :(

2016-10-18 16:15 GMT+02:00 Till Rohrmann <[hidden email]>:

Oh now I understand. Sorry for my confusion. Flink does not offer a JDBC interface to query its state. The only way to do that is to use Flink's proprietary interface. Since this feature is highly experimental there is not a lot of documentation out there. I can recommend you this github repo [1] where you can see an example of how to access Flink state.

[1] https://github.com/dataArtisans/queryable-state-demo

Cheers,

Till

On Tue, Oct 18, 2016 at 3:22 PM, Alberto Ramón <[hidden email]> wrote:

Hi  :)

SQL Client ---> JDBC  ---> Flink (queryable state)

(I don't read from Flink a JDBC Source)

I want the opposite: See Flink as "realtime database" from my SQL Client ... for example: Tableau ---> Flink states

2016-10-18 14:52 GMT+02:00 Till Rohrmann <[hidden email]>:

Hi Alberto,

have you checked out Flink's JDBCInputFormat? As far as I can tell, Kylin has support for JDBC and, thus, you should be able to read from it with this input format.

Cheers,

Till

On Tue, Oct 18, 2016 at 11:28 AM, Alberto Ramón <[hidden email]> wrote:

Hello

I'm investigating about Flink + Calcite, StreamSQL, Queryable State

Is possible connect to Kylin using SQL Client via JDBC ?

(I always see API examples)

BR