You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by aashish choudhary <aa...@gmail.com> on 2020/06/04 15:57:51 UTC
Re: Calcite geode adapter query
Can we accept a feature request for querying partitioned region with
calcite geode adapter. I don't think it is fully supported. Let me know if
you have any questions.
With best regards,
Ashish
On Tue, Apr 14, 2020, 1:40 AM Stamatis Zampetakis <za...@gmail.com> wrote:
> I still don't see the log that you are mentioning.
>
> Many kind of attachments are rejected when you are sending to the dev list.
> It's better to provide hyperlinks or paste directly the relevant part to
> the body of the email.
>
> On Mon, Apr 13, 2020 at 5:17 PM aashish choudhary <
> aashish.choudhary1@gmail.com> wrote:
>
> > Full error is this in Dbeaver logs. Tried attaching the screenshot but
> mail
> > delivery got failed.
> >
> > Table 'GEODE.TABLENAME' not found in metadata catalog.
> >
> > Data type 'RecordType() MULTISET' can't be resolved by '
> > org.jkiss.dbeaver.ext.generic.model.GenericDataSource'
> >
> > With best regards,
> > Ashish
> >
> > On Mon, Apr 13, 2020, 7:23 PM Stamatis Zampetakis <za...@gmail.com>
> > wrote:
> >
> > > Hi Ashish,
> > >
> > > Unfortunately with a single line of the stacktrace we cannot understand
> > > much.
> > > We need the complete stacktrace to better see what happens.
> > >
> > > Best,
> > > Stamatis
> > >
> > > On Mon, Apr 13, 2020 at 1:24 PM aashish choudhary <
> > > aashish.choudhary1@gmail.com> wrote:
> > >
> > > > I think i have updated the error i am getting in previous email.
> > > >
> > > > "Also even simple query like select * from /PartitionedRegion name
> > limit
> > > 1
> > > > not working with calcite adapter and getting below exception on
> Dbeaver
> > > > Query execution failed
> > > > Reason:
> > > > java.lang.IndexOutofBoundsException
> > > >
> > > > Anyone tried it before or able to query data with calcite?
> > > >
> > > >
> > > > select count(*) from /PartitionedRegionname gives a count of zero
> even
> > > > though it has records but for replicated regions it gives the correct
> > > > count."
> > > >
> > > > This is a very basic functionality not sure why it is not supported.
> > > >
> > > >
> > > > With best regards,
> > > > Ashish
> > > >
> > > > On Sun, Apr 5, 2020, 8:54 PM Stamatis Zampetakis <za...@gmail.com>
> > > > wrote:
> > > >
> > > > > I have not used the adapter recently so cannot tell for sure.
> > > > >
> > > > > When you say that Calcite adapter is not working, what do you mean?
> > Is
> > > > > there an exception or the query simply does not return anything?
> > > > >
> > > > > Best,
> > > > > Stamatis
> > > > >
> > > > > On Sun, Apr 5, 2020 at 5:01 PM aashish choudhary <
> > > > > aashish.choudhary1@gmail.com> wrote:
> > > > >
> > > > > > Any inputs in the below thread? So I assume this feature is not
> > > > supported
> > > > > > with calcite geode adapter.?
> > > > > >
> > > > > > With best regards,
> > > > > > Ashish
> > > > > >
> > > > > > On Fri, Apr 3, 2020, 1:11 PM aashish choudhary <
> > > > > > aashish.choudhary1@gmail.com>
> > > > > > wrote:
> > > > > >
> > > > > > > I am able to query simple regions like below.
> > > > > > > Region<String,Object> replicated region
> > > > > > > But not this type of region with calcite adapter.
> > > > > > > Region<String,List<Object>> partitioned region
> > > > > > >
> > > > > > > For example I can run following query on geode data browser
> pulse
> > > > > without
> > > > > > > any issue.
> > > > > > > Select e.value from /PartitionedRegion name.entrySet e where
> > > > > > > e.key=keyvalue
> > > > > > > But it doesn't work with calcite adapter.
> > > > > > >
> > > > > > > Also even simple query like select * from /PartitionedRegion
> name
> > > > > limit 1
> > > > > > > not working with calcite adapter and getting below exception on
> > > > Dbeaver
> > > > > > > Query execution failed
> > > > > > > Reason:
> > > > > > > java.lang.IndexOutofBoundsException
> > > > > > >
> > > > > > > Anyone tried it before or able to query data with calcite?
> > > > > > >
> > > > > > >
> > > > > > > select count(*) from /PartitionedRegionname gives a count of
> > zero
> > > > even
> > > > > > > though it has records but for replicated regions it gives the
> > > correct
> > > > > > count.
> > > > > > >
> > > > > > > With best regards,
> > > > > > > Ashish
> > > > > > >
> > > > > > > On Fri, Apr 3, 2020, 12:40 PM Stamatis Zampetakis <
> > > zabetak@gmail.com
> > > > >
> > > > > > > wrote:
> > > > > > >
> > > > > > >> Hi Ashish,
> > > > > > >>
> > > > > > >> It would help if you can post the error that you are getting
> > when
> > > > you
> > > > > > >> attempt to query regions with ArrayLists (if there is one).
> > > > > > >>
> > > > > > >> It seems that the case with ArrayList is not well tested
> (maybe
> > > not
> > > > > > tested
> > > > > > >> at all) [1] so it does not suprise me that it fails somewhere
> > > along
> > > > > the
> > > > > > >> road.
> > > > > > >>
> > > > > > >> Best,
> > > > > > >> Stamatis
> > > > > > >>
> > > > > > >> [1]
> > > > > > >>
> > > > > > >>
> > > > > >
> > > > >
> > > >
> > >
> >
> https://github.com/apache/calcite/blob/master/geode/src/test/java/org/apache/calcite/adapter/geode/rel/GeodeAllDataTypesTest.java
> > > > > > >>
> > > > > > >> On Fri, Apr 3, 2020 at 4:47 AM aashish choudhary <
> > > > > > >> aashish.choudhary1@gmail.com> wrote:
> > > > > > >>
> > > > > > >> > +Christian
> > > > > > >> >
> > > > > > >> > With best regards,
> > > > > > >> > Ashish
> > > > > > >> >
> > > > > > >> > On Thu, Apr 2, 2020, 5:00 PM Danny Chan <
> yuzhao.cyz@gmail.com
> > >
> > > > > wrote:
> > > > > > >> >
> > > > > > >> > > I believe few people in the community are familiar with
> > geode,
> > > > > maybe
> > > > > > >> you
> > > > > > >> > > can ask the author of this module [1]
> > > > > > >> > >
> > > > > > >> > > [1] https://github.com/tzolov
> > > > > > >> > >
> > > > > > >> > > Best,
> > > > > > >> > > Danny Chan
> > > > > > >> > > 在 2020年4月2日 +0800 PM6:41,aashish choudhary <
> > > > > > >> aashish.choudhary1@gmail.com
> > > > > > >> > > >,写道:
> > > > > > >> > > > Can anyone help me with this?
> > > > > > >> > > >
> > > > > > >> > > > With best regards,
> > > > > > >> > > > Ashish
> > > > > > >> > > >
> > > > > > >> > > > On Wed, Apr 1, 2020, 7:27 PM aashish choudhary <
> > > > > > >> > > aashish.choudhary1@gmail.com>
> > > > > > >> > > > wrote:
> > > > > > >> > > >
> > > > > > >> > > > > Hi,
> > > > > > >> > > > >
> > > > > > >> > > > > I am trying to setup querying geode using calcite
> geode
> > > > > adapter.
> > > > > > >> So
> > > > > > >> > > far i
> > > > > > >> > > > > am successfully able to connect to geode cluster which
> > is
> > > > SSL
> > > > > > >> enabled
> > > > > > >> > > after
> > > > > > >> > > > > making few changes in the adapter and query data for
> > > regions
> > > > > > which
> > > > > > >> > are
> > > > > > >> > > > > having flat hierarchy.
> > > > > > >> > > > >
> > > > > > >> > > > > However I am not able to run any query for region
> having
> > > > Array
> > > > > > >> list
> > > > > > >> > as
> > > > > > >> > > > > values and String as key. I am using Dbeaver to query
> > > > > following
> > > > > > >> this
> > > > > > >> > > link.
> > > > > > >> > > > > https://youtu.be/I_iaMgqdV3Q
> > > > > > >> > > > >
> > > > > > >> > > > > Can someone help me with this?
> > > > > > >> > > > >
> > > > > > >> > > > > With geode you can query those complex region in geode
> > > Pulse
> > > > > > data
> > > > > > >> > > browser.
> > > > > > >> > > > > You can do .entrySet or .entries to run queries like
> > this.
> > > > > > >> > > > >
> > > > > > >> > > > > Also in Dbeaver in under Tables->Columns I can view
> > fields
> > > > as
> > > > > > well
> > > > > > >> > for
> > > > > > >> > > > > regions having flat hierarchy but it doesn't show
> > anything
> > > > for
> > > > > > >> > regions
> > > > > > >> > > > > storing arrays.
> > > > > > >> > > > >
> > > > > > >> > > > >
> > > > > > >> > > > > With best regards,
> > > > > > >> > > > > Ashish
> > > > > > >> > > > >
> > > > > > >> > >
> > > > > > >> >
> > > > > > >>
> > > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
Re: Calcite geode adapter query
Posted by aashish choudhary <aa...@gmail.com>.
CALCITE-4044
With best regards,
Ashish
On Thu, Jun 4, 2020, 10:53 PM Julian Hyde <jh...@apache.org> wrote:
> Sure, log a JIRA case. Describe the use case as well as you can. Maybe
> give a SQL example.
>
> Julian
>
>
> > On Jun 4, 2020, at 8:57 AM, aashish choudhary <
> aashish.choudhary1@gmail.com> wrote:
> >
> > Can we accept a feature request for querying partitioned region with
> > calcite geode adapter. I don't think it is fully supported. Let me know
> if
> > you have any questions.
> >
> > With best regards,
> > Ashish
> >
> > On Tue, Apr 14, 2020, 1:40 AM Stamatis Zampetakis <za...@gmail.com>
> wrote:
> >
> >> I still don't see the log that you are mentioning.
> >>
> >> Many kind of attachments are rejected when you are sending to the dev
> list.
> >> It's better to provide hyperlinks or paste directly the relevant part to
> >> the body of the email.
> >>
> >> On Mon, Apr 13, 2020 at 5:17 PM aashish choudhary <
> >> aashish.choudhary1@gmail.com> wrote:
> >>
> >>> Full error is this in Dbeaver logs. Tried attaching the screenshot but
> >> mail
> >>> delivery got failed.
> >>>
> >>> Table 'GEODE.TABLENAME' not found in metadata catalog.
> >>>
> >>> Data type 'RecordType() MULTISET' can't be resolved by '
> >>> org.jkiss.dbeaver.ext.generic.model.GenericDataSource'
> >>>
> >>> With best regards,
> >>> Ashish
> >>>
> >>> On Mon, Apr 13, 2020, 7:23 PM Stamatis Zampetakis <za...@gmail.com>
> >>> wrote:
> >>>
> >>>> Hi Ashish,
> >>>>
> >>>> Unfortunately with a single line of the stacktrace we cannot
> understand
> >>>> much.
> >>>> We need the complete stacktrace to better see what happens.
> >>>>
> >>>> Best,
> >>>> Stamatis
> >>>>
> >>>> On Mon, Apr 13, 2020 at 1:24 PM aashish choudhary <
> >>>> aashish.choudhary1@gmail.com> wrote:
> >>>>
> >>>>> I think i have updated the error i am getting in previous email.
> >>>>>
> >>>>> "Also even simple query like select * from /PartitionedRegion name
> >>> limit
> >>>> 1
> >>>>> not working with calcite adapter and getting below exception on
> >> Dbeaver
> >>>>> Query execution failed
> >>>>> Reason:
> >>>>> java.lang.IndexOutofBoundsException
> >>>>>
> >>>>> Anyone tried it before or able to query data with calcite?
> >>>>>
> >>>>>
> >>>>> select count(*) from /PartitionedRegionname gives a count of zero
> >> even
> >>>>> though it has records but for replicated regions it gives the correct
> >>>>> count."
> >>>>>
> >>>>> This is a very basic functionality not sure why it is not supported.
> >>>>>
> >>>>>
> >>>>> With best regards,
> >>>>> Ashish
> >>>>>
> >>>>> On Sun, Apr 5, 2020, 8:54 PM Stamatis Zampetakis <za...@gmail.com>
> >>>>> wrote:
> >>>>>
> >>>>>> I have not used the adapter recently so cannot tell for sure.
> >>>>>>
> >>>>>> When you say that Calcite adapter is not working, what do you mean?
> >>> Is
> >>>>>> there an exception or the query simply does not return anything?
> >>>>>>
> >>>>>> Best,
> >>>>>> Stamatis
> >>>>>>
> >>>>>> On Sun, Apr 5, 2020 at 5:01 PM aashish choudhary <
> >>>>>> aashish.choudhary1@gmail.com> wrote:
> >>>>>>
> >>>>>>> Any inputs in the below thread? So I assume this feature is not
> >>>>> supported
> >>>>>>> with calcite geode adapter.?
> >>>>>>>
> >>>>>>> With best regards,
> >>>>>>> Ashish
> >>>>>>>
> >>>>>>> On Fri, Apr 3, 2020, 1:11 PM aashish choudhary <
> >>>>>>> aashish.choudhary1@gmail.com>
> >>>>>>> wrote:
> >>>>>>>
> >>>>>>>> I am able to query simple regions like below.
> >>>>>>>> Region<String,Object> replicated region
> >>>>>>>> But not this type of region with calcite adapter.
> >>>>>>>> Region<String,List<Object>> partitioned region
> >>>>>>>>
> >>>>>>>> For example I can run following query on geode data browser
> >> pulse
> >>>>>> without
> >>>>>>>> any issue.
> >>>>>>>> Select e.value from /PartitionedRegion name.entrySet e where
> >>>>>>>> e.key=keyvalue
> >>>>>>>> But it doesn't work with calcite adapter.
> >>>>>>>>
> >>>>>>>> Also even simple query like select * from /PartitionedRegion
> >> name
> >>>>>> limit 1
> >>>>>>>> not working with calcite adapter and getting below exception on
> >>>>> Dbeaver
> >>>>>>>> Query execution failed
> >>>>>>>> Reason:
> >>>>>>>> java.lang.IndexOutofBoundsException
> >>>>>>>>
> >>>>>>>> Anyone tried it before or able to query data with calcite?
> >>>>>>>>
> >>>>>>>>
> >>>>>>>> select count(*) from /PartitionedRegionname gives a count of
> >>> zero
> >>>>> even
> >>>>>>>> though it has records but for replicated regions it gives the
> >>>> correct
> >>>>>>> count.
> >>>>>>>>
> >>>>>>>> With best regards,
> >>>>>>>> Ashish
> >>>>>>>>
> >>>>>>>> On Fri, Apr 3, 2020, 12:40 PM Stamatis Zampetakis <
> >>>> zabetak@gmail.com
> >>>>>>
> >>>>>>>> wrote:
> >>>>>>>>
> >>>>>>>>> Hi Ashish,
> >>>>>>>>>
> >>>>>>>>> It would help if you can post the error that you are getting
> >>> when
> >>>>> you
> >>>>>>>>> attempt to query regions with ArrayLists (if there is one).
> >>>>>>>>>
> >>>>>>>>> It seems that the case with ArrayList is not well tested
> >> (maybe
> >>>> not
> >>>>>>> tested
> >>>>>>>>> at all) [1] so it does not suprise me that it fails somewhere
> >>>> along
> >>>>>> the
> >>>>>>>>> road.
> >>>>>>>>>
> >>>>>>>>> Best,
> >>>>>>>>> Stamatis
> >>>>>>>>>
> >>>>>>>>> [1]
> >>>>>>>>>
> >>>>>>>>>
> >>>>>>>
> >>>>>>
> >>>>>
> >>>>
> >>>
> >>
> https://github.com/apache/calcite/blob/master/geode/src/test/java/org/apache/calcite/adapter/geode/rel/GeodeAllDataTypesTest.java
> >>>>>>>>>
> >>>>>>>>> On Fri, Apr 3, 2020 at 4:47 AM aashish choudhary <
> >>>>>>>>> aashish.choudhary1@gmail.com> wrote:
> >>>>>>>>>
> >>>>>>>>>> +Christian
> >>>>>>>>>>
> >>>>>>>>>> With best regards,
> >>>>>>>>>> Ashish
> >>>>>>>>>>
> >>>>>>>>>> On Thu, Apr 2, 2020, 5:00 PM Danny Chan <
> >> yuzhao.cyz@gmail.com
> >>>>
> >>>>>> wrote:
> >>>>>>>>>>
> >>>>>>>>>>> I believe few people in the community are familiar with
> >>> geode,
> >>>>>> maybe
> >>>>>>>>> you
> >>>>>>>>>>> can ask the author of this module [1]
> >>>>>>>>>>>
> >>>>>>>>>>> [1] https://github.com/tzolov
> >>>>>>>>>>>
> >>>>>>>>>>> Best,
> >>>>>>>>>>> Danny Chan
> >>>>>>>>>>> 在 2020年4月2日 +0800 PM6:41,aashish choudhary <
> >>>>>>>>> aashish.choudhary1@gmail.com
> >>>>>>>>>>>> ,写道:
> >>>>>>>>>>>> Can anyone help me with this?
> >>>>>>>>>>>>
> >>>>>>>>>>>> With best regards,
> >>>>>>>>>>>> Ashish
> >>>>>>>>>>>>
> >>>>>>>>>>>> On Wed, Apr 1, 2020, 7:27 PM aashish choudhary <
> >>>>>>>>>>> aashish.choudhary1@gmail.com>
> >>>>>>>>>>>> wrote:
> >>>>>>>>>>>>
> >>>>>>>>>>>>> Hi,
> >>>>>>>>>>>>>
> >>>>>>>>>>>>> I am trying to setup querying geode using calcite
> >> geode
> >>>>>> adapter.
> >>>>>>>>> So
> >>>>>>>>>>> far i
> >>>>>>>>>>>>> am successfully able to connect to geode cluster which
> >>> is
> >>>>> SSL
> >>>>>>>>> enabled
> >>>>>>>>>>> after
> >>>>>>>>>>>>> making few changes in the adapter and query data for
> >>>> regions
> >>>>>>> which
> >>>>>>>>>> are
> >>>>>>>>>>>>> having flat hierarchy.
> >>>>>>>>>>>>>
> >>>>>>>>>>>>> However I am not able to run any query for region
> >> having
> >>>>> Array
> >>>>>>>>> list
> >>>>>>>>>> as
> >>>>>>>>>>>>> values and String as key. I am using Dbeaver to query
> >>>>>> following
> >>>>>>>>> this
> >>>>>>>>>>> link.
> >>>>>>>>>>>>> https://youtu.be/I_iaMgqdV3Q
> >>>>>>>>>>>>>
> >>>>>>>>>>>>> Can someone help me with this?
> >>>>>>>>>>>>>
> >>>>>>>>>>>>> With geode you can query those complex region in geode
> >>>> Pulse
> >>>>>>> data
> >>>>>>>>>>> browser.
> >>>>>>>>>>>>> You can do .entrySet or .entries to run queries like
> >>> this.
> >>>>>>>>>>>>>
> >>>>>>>>>>>>> Also in Dbeaver in under Tables->Columns I can view
> >>> fields
> >>>>> as
> >>>>>>> well
> >>>>>>>>>> for
> >>>>>>>>>>>>> regions having flat hierarchy but it doesn't show
> >>> anything
> >>>>> for
> >>>>>>>>>> regions
> >>>>>>>>>>>>> storing arrays.
> >>>>>>>>>>>>>
> >>>>>>>>>>>>>
> >>>>>>>>>>>>> With best regards,
> >>>>>>>>>>>>> Ashish
> >>>>>>>>>>>>>
> >>>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>>
> >>>>>>>>
> >>>>>>>
> >>>>>>
> >>>>>
> >>>>
> >>>
> >>
>
>
Re: Calcite geode adapter query
Posted by Julian Hyde <jh...@apache.org>.
Sure, log a JIRA case. Describe the use case as well as you can. Maybe give a SQL example.
Julian
> On Jun 4, 2020, at 8:57 AM, aashish choudhary <aa...@gmail.com> wrote:
>
> Can we accept a feature request for querying partitioned region with
> calcite geode adapter. I don't think it is fully supported. Let me know if
> you have any questions.
>
> With best regards,
> Ashish
>
> On Tue, Apr 14, 2020, 1:40 AM Stamatis Zampetakis <za...@gmail.com> wrote:
>
>> I still don't see the log that you are mentioning.
>>
>> Many kind of attachments are rejected when you are sending to the dev list.
>> It's better to provide hyperlinks or paste directly the relevant part to
>> the body of the email.
>>
>> On Mon, Apr 13, 2020 at 5:17 PM aashish choudhary <
>> aashish.choudhary1@gmail.com> wrote:
>>
>>> Full error is this in Dbeaver logs. Tried attaching the screenshot but
>> mail
>>> delivery got failed.
>>>
>>> Table 'GEODE.TABLENAME' not found in metadata catalog.
>>>
>>> Data type 'RecordType() MULTISET' can't be resolved by '
>>> org.jkiss.dbeaver.ext.generic.model.GenericDataSource'
>>>
>>> With best regards,
>>> Ashish
>>>
>>> On Mon, Apr 13, 2020, 7:23 PM Stamatis Zampetakis <za...@gmail.com>
>>> wrote:
>>>
>>>> Hi Ashish,
>>>>
>>>> Unfortunately with a single line of the stacktrace we cannot understand
>>>> much.
>>>> We need the complete stacktrace to better see what happens.
>>>>
>>>> Best,
>>>> Stamatis
>>>>
>>>> On Mon, Apr 13, 2020 at 1:24 PM aashish choudhary <
>>>> aashish.choudhary1@gmail.com> wrote:
>>>>
>>>>> I think i have updated the error i am getting in previous email.
>>>>>
>>>>> "Also even simple query like select * from /PartitionedRegion name
>>> limit
>>>> 1
>>>>> not working with calcite adapter and getting below exception on
>> Dbeaver
>>>>> Query execution failed
>>>>> Reason:
>>>>> java.lang.IndexOutofBoundsException
>>>>>
>>>>> Anyone tried it before or able to query data with calcite?
>>>>>
>>>>>
>>>>> select count(*) from /PartitionedRegionname gives a count of zero
>> even
>>>>> though it has records but for replicated regions it gives the correct
>>>>> count."
>>>>>
>>>>> This is a very basic functionality not sure why it is not supported.
>>>>>
>>>>>
>>>>> With best regards,
>>>>> Ashish
>>>>>
>>>>> On Sun, Apr 5, 2020, 8:54 PM Stamatis Zampetakis <za...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> I have not used the adapter recently so cannot tell for sure.
>>>>>>
>>>>>> When you say that Calcite adapter is not working, what do you mean?
>>> Is
>>>>>> there an exception or the query simply does not return anything?
>>>>>>
>>>>>> Best,
>>>>>> Stamatis
>>>>>>
>>>>>> On Sun, Apr 5, 2020 at 5:01 PM aashish choudhary <
>>>>>> aashish.choudhary1@gmail.com> wrote:
>>>>>>
>>>>>>> Any inputs in the below thread? So I assume this feature is not
>>>>> supported
>>>>>>> with calcite geode adapter.?
>>>>>>>
>>>>>>> With best regards,
>>>>>>> Ashish
>>>>>>>
>>>>>>> On Fri, Apr 3, 2020, 1:11 PM aashish choudhary <
>>>>>>> aashish.choudhary1@gmail.com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> I am able to query simple regions like below.
>>>>>>>> Region<String,Object> replicated region
>>>>>>>> But not this type of region with calcite adapter.
>>>>>>>> Region<String,List<Object>> partitioned region
>>>>>>>>
>>>>>>>> For example I can run following query on geode data browser
>> pulse
>>>>>> without
>>>>>>>> any issue.
>>>>>>>> Select e.value from /PartitionedRegion name.entrySet e where
>>>>>>>> e.key=keyvalue
>>>>>>>> But it doesn't work with calcite adapter.
>>>>>>>>
>>>>>>>> Also even simple query like select * from /PartitionedRegion
>> name
>>>>>> limit 1
>>>>>>>> not working with calcite adapter and getting below exception on
>>>>> Dbeaver
>>>>>>>> Query execution failed
>>>>>>>> Reason:
>>>>>>>> java.lang.IndexOutofBoundsException
>>>>>>>>
>>>>>>>> Anyone tried it before or able to query data with calcite?
>>>>>>>>
>>>>>>>>
>>>>>>>> select count(*) from /PartitionedRegionname gives a count of
>>> zero
>>>>> even
>>>>>>>> though it has records but for replicated regions it gives the
>>>> correct
>>>>>>> count.
>>>>>>>>
>>>>>>>> With best regards,
>>>>>>>> Ashish
>>>>>>>>
>>>>>>>> On Fri, Apr 3, 2020, 12:40 PM Stamatis Zampetakis <
>>>> zabetak@gmail.com
>>>>>>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Hi Ashish,
>>>>>>>>>
>>>>>>>>> It would help if you can post the error that you are getting
>>> when
>>>>> you
>>>>>>>>> attempt to query regions with ArrayLists (if there is one).
>>>>>>>>>
>>>>>>>>> It seems that the case with ArrayList is not well tested
>> (maybe
>>>> not
>>>>>>> tested
>>>>>>>>> at all) [1] so it does not suprise me that it fails somewhere
>>>> along
>>>>>> the
>>>>>>>>> road.
>>>>>>>>>
>>>>>>>>> Best,
>>>>>>>>> Stamatis
>>>>>>>>>
>>>>>>>>> [1]
>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>> https://github.com/apache/calcite/blob/master/geode/src/test/java/org/apache/calcite/adapter/geode/rel/GeodeAllDataTypesTest.java
>>>>>>>>>
>>>>>>>>> On Fri, Apr 3, 2020 at 4:47 AM aashish choudhary <
>>>>>>>>> aashish.choudhary1@gmail.com> wrote:
>>>>>>>>>
>>>>>>>>>> +Christian
>>>>>>>>>>
>>>>>>>>>> With best regards,
>>>>>>>>>> Ashish
>>>>>>>>>>
>>>>>>>>>> On Thu, Apr 2, 2020, 5:00 PM Danny Chan <
>> yuzhao.cyz@gmail.com
>>>>
>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>> I believe few people in the community are familiar with
>>> geode,
>>>>>> maybe
>>>>>>>>> you
>>>>>>>>>>> can ask the author of this module [1]
>>>>>>>>>>>
>>>>>>>>>>> [1] https://github.com/tzolov
>>>>>>>>>>>
>>>>>>>>>>> Best,
>>>>>>>>>>> Danny Chan
>>>>>>>>>>> 在 2020年4月2日 +0800 PM6:41,aashish choudhary <
>>>>>>>>> aashish.choudhary1@gmail.com
>>>>>>>>>>>> ,写道:
>>>>>>>>>>>> Can anyone help me with this?
>>>>>>>>>>>>
>>>>>>>>>>>> With best regards,
>>>>>>>>>>>> Ashish
>>>>>>>>>>>>
>>>>>>>>>>>> On Wed, Apr 1, 2020, 7:27 PM aashish choudhary <
>>>>>>>>>>> aashish.choudhary1@gmail.com>
>>>>>>>>>>>> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> Hi,
>>>>>>>>>>>>>
>>>>>>>>>>>>> I am trying to setup querying geode using calcite
>> geode
>>>>>> adapter.
>>>>>>>>> So
>>>>>>>>>>> far i
>>>>>>>>>>>>> am successfully able to connect to geode cluster which
>>> is
>>>>> SSL
>>>>>>>>> enabled
>>>>>>>>>>> after
>>>>>>>>>>>>> making few changes in the adapter and query data for
>>>> regions
>>>>>>> which
>>>>>>>>>> are
>>>>>>>>>>>>> having flat hierarchy.
>>>>>>>>>>>>>
>>>>>>>>>>>>> However I am not able to run any query for region
>> having
>>>>> Array
>>>>>>>>> list
>>>>>>>>>> as
>>>>>>>>>>>>> values and String as key. I am using Dbeaver to query
>>>>>> following
>>>>>>>>> this
>>>>>>>>>>> link.
>>>>>>>>>>>>> https://youtu.be/I_iaMgqdV3Q
>>>>>>>>>>>>>
>>>>>>>>>>>>> Can someone help me with this?
>>>>>>>>>>>>>
>>>>>>>>>>>>> With geode you can query those complex region in geode
>>>> Pulse
>>>>>>> data
>>>>>>>>>>> browser.
>>>>>>>>>>>>> You can do .entrySet or .entries to run queries like
>>> this.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Also in Dbeaver in under Tables->Columns I can view
>>> fields
>>>>> as
>>>>>>> well
>>>>>>>>>> for
>>>>>>>>>>>>> regions having flat hierarchy but it doesn't show
>>> anything
>>>>> for
>>>>>>>>>> regions
>>>>>>>>>>>>> storing arrays.
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> With best regards,
>>>>>>>>>>>>> Ashish
>>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>