You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@flink.apache.org by Alberto Ramón <a....@gmail.com> on 2016/10/18 09:28:35 UTC
Queryable state using JDBC
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
Re: Queryable state using JDBC
Posted by Till Rohrmann <tr...@apache.org>.
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 <a....@gmail.com>
wrote:
> I don't have acess or link don't work :(
>
> 2016-10-18 16:15 GMT+02:00 Till Rohrmann <tr...@apache.org>:
>
>> 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 <a.ramonportoles@gmail.com
>> > 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 <tr...@apache.org>:
>>>
>>>> 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 <
>>>> a.ramonportoles@gmail.com> 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
>>>>>
>>>>
>>>>
>>>
>>
>
Re: Queryable state using JDBC
Posted by Alberto Ramón <a....@gmail.com>.
I don't have acess or link don't work :(
2016-10-18 16:15 GMT+02:00 Till Rohrmann <tr...@apache.org>:
> 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 <a....@gmail.com>
> 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 <tr...@apache.org>:
>>
>>> 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 <
>>> a.ramonportoles@gmail.com> 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
>>>>
>>>
>>>
>>
>
Re: Queryable state using JDBC
Posted by Till Rohrmann <tr...@apache.org>.
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 <a....@gmail.com>
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 <tr...@apache.org>:
>
>> 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 <
>> a.ramonportoles@gmail.com> 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
>>>
>>
>>
>
Re: Queryable state using JDBC
Posted by Alberto Ramón <a....@gmail.com>.
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 <tr...@apache.org>:
> 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 <a.ramonportoles@gmail.com
> > 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
>>
>
>
Re: Queryable state using JDBC
Posted by Till Rohrmann <tr...@apache.org>.
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 <a....@gmail.com>
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
>