You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by Ka...@ril.com on 2019/03/11 12:33:39 UTC
QueryEntities not returning all the fields available in cache - 2.6
version
Hi Igniters,
Am trying to retrieve Cache metadata i.e. its field name and data type. But facing one weird issue, the metadata is returning valid response for some caches and invalid for some. Am giving my cache configuration for reference. The cluster is up and running for some time now, and we have not altered/added any fields to any specific cache (aware about one existing issue if you alter cache then its metadata is not updated and can't be retrieved from QueryEntities). Any help or pointers on this would be appreciated :
e.g. for below cache its returning only one field i.e. associateId. However, it is supposed to return both the fields mentioned in 'fields' property below.
<bean class="org.apache.ignite.configuration.CacheConfiguration" parent="cache-template">
<property name="name" value="EntMapAssociateCache" />
<property name="cacheMode" value="PARTITIONED" />
<property name="atomicityMode" value="ATOMIC" />
<property name="backups" value="1" />
<property name="statisticsEnabled" value="true"/>
<property name="queryEntities">
<list>
<bean class="org.apache.ignite.cache.QueryEntity">
<property name="keyType" value="java.lang.String" />
<property name="valueType" value="com.digitalapi.edif.customer.model.EntMapAssociate" />
<property name="tableName" value="ENT_MAP_ASSOCIATE" />
<property name="keyFieldName" value="mappingId" />
<property name="keyFields">
<list>
<value>mappingId</value>
</list>
</property>
<property name="fields">
<map>
<entry key="associateId" value="java.lang.String" />
<entry key="mappingId" value="java.lang.String" />
</map>
</property>
<property name="aliases">
<map>
<entry key="associateId" value="ASSOCIATE_ID" />
<entry key="mappingId" value="MAPPING_ID" />
</map>
</property>
</bean>
</list>
</property>
</bean>
Thanks and Regards,
Kamlesh Joshi
"Confidentiality Warning: This message and any attachments are intended only for the use of the intended recipient(s).
are confidential and may be privileged. If you are not the intended recipient. you are hereby notified that any
review. re-transmission. conversion to hard copy. copying. circulation or other use of this message and any attachments is
strictly prohibited. If you are not the intended recipient. please notify the sender immediately by return email.
and delete this message and any attachments from your system.
Virus Warning: Although the company has taken reasonable precautions to ensure no viruses are present in this email.
The company cannot accept responsibility for any loss or damage arising from the use of this email or attachment."
Re: [External]Re: QueryEntities not returning all the fields
available in cache - 2.6 version
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
So this gives the following QueryEntity:
[QueryEntity
[keyType=com.jio.digitalapi.edif.customer.model.EntAssociatePositionKey,
valType=com.jio.digitalapi.edif.customer.model.EntAssociatePosition,
keyFieldName=null, valueFieldName=null,
fields=LinkedHashMap {associateId=java.lang.String,
jobFunction=java.lang.String, locationType=java.lang.String,
locationCode=java.lang.String, storeCode=java.lang.String,
updateddatetime=java.sql.Timestamp, updatedby=java.lang.String},
keyFields=LinkedHashSet [associateId, jobFunction],
aliases=HashMap {associateId=ASSOCIATE_ID, jobFunction=JOB_FUNCTION,
updatedby=UPDATEDBY, locationType=LOCATION_TYPE,
updateddatetime=UPDATEDDATETIME, locationCode=LOCATION_CODE,
storeCode=STORE_CODE},
idxs=LinkedList [QueryIndex [name=ENT_ASSOCIATE_POSITION_PK,
fields=LinkedHashMap {associateId=false, jobFunction=false}, type=SORTED,
inlineSize=-1]], tableName=ENT_ASSOCIATE_POSITION]]
What's amiss here?
Regards,
--
Ilya Kasnacheev
вт, 19 мар. 2019 г. в 12:32, <Ka...@ril.com>:
> Hi Ilya,
>
>
>
> Please find below config of cache with composite key:
>
>
>
> <bean class="org.apache.ignite.configuration.CacheConfiguration"
> parent="cache-template">
>
> <property name="name" value="EntAssociatePositionCache" />
>
> <property name="cacheMode" value="PARTITIONED" />
>
> <property name="atomicityMode" value="ATOMIC" />
>
> <property name="backups" value="1" />
>
> <property name="statisticsEnabled" value="false"/>
>
> <property name="queryEntities">
>
> <list>
>
> <bean class="org.apache.ignite.cache.QueryEntity">
>
> <property name="keyType"
> value="com.jio.digitalapi.edif.customer.model.EntAssociatePositionKey" />
>
> <property name="valueType"
> value="com.jio.digitalapi.edif.customer.model.EntAssociatePosition" />
>
> <property name="tableName" value="ENT_ASSOCIATE_POSITION"
> />
>
> <property name="keyFields">
>
> <list>
>
> <value>associateId</value>
>
> <value>jobFunction</value>
>
> </list>
>
> </property>
>
> <property name="fields">
>
> <map>
>
> <entry key="associateId" value="java.lang.String"
> />
>
> <entry key="jobFunction" value="java.lang.String"
> />
>
> <entry key="locationType" value="java.lang.String"
> />
>
> <entry key="locationCode" value="java.lang.String"
> />
>
> <entry key="storeCode" value="java.lang.String" />
>
> <entry key="updateddatetime"
> value="java.sql.Timestamp" />
>
> <entry key="updatedby" value="java.lang.String" />
>
> </map>
>
> </property>
>
> <property name="aliases">
>
> <map>
>
> <entry key="associateId" value="ASSOCIATE_ID" />
>
> <entry key="jobFunction" value="JOB_FUNCTION" />
>
> <entry key="locationType" value="LOCATION_TYPE" />
>
> <entry key="locationCode" value="LOCATION_CODE" />
>
> <entry key="storeCode" value="STORE_CODE" />
>
> </map>
>
> </property>
>
> <property name="indexes">
>
> <list>
>
> <bean class="org.apache.ignite.cache.QueryIndex">
>
> <property name="name"
> value="ENT_ASSOCIATE_POSITION_PK" />
>
> <property name="indexType" value="SORTED" />
>
> <property name="fields">
>
> <map>
>
> <entry key="associateId" value="false"
> />
>
> <entry key="jobFunction" value="false"
> />
>
> </map>
>
> </property>
>
> </bean>
>
> </list>
>
> </property>
>
> </bean>
>
> </list>
>
> </property>
>
> </bean>
>
>
>
> *Thanks and Regards,*
>
> *Kamlesh Joshi*
>
>
>
> *From:* Ilya Kasnacheev [mailto:ilya.kasnacheev@gmail.com]
> *Sent:* Thursday, March 14, 2019 2:53 PM
> *To:* user@ignite.apache.org
> *Subject:* Re: [External]Re: QueryEntities not returning all the fields
> available in cache - 2.6 version
>
>
>
> The e-mail below is from an external source. Please do not open
> attachments or click links from an unknown or suspicious origin.
>
> Hello!
>
>
>
> Then mappingId is not a field. It is an SQL column but it's not a field.
>
>
>
> If it happens with composite keys, please share config.
>
>
>
> Regards,
>
> --
>
> Ilya Kasnacheev
>
>
>
>
>
> чт, 14 мар. 2019 г. в 12:18, <Ka...@ril.com>:
>
> Hi,
>
>
>
> No, mappingId is not part of value object. But, even this issue is
> occurring for other cache with composite key as well.
>
>
>
> *Thanks and Regards,*
>
> *Kamlesh Joshi*
>
>
>
> *From:* Ilya Kasnacheev [mailto:ilya.kasnacheev@gmail.com]
> *Sent:* Wednesday, March 13, 2019 6:16 PM
> *To:* user@ignite.apache.org
> *Subject:* [External]Re: QueryEntities not returning all the fields
> available in cache - 2.6 version
>
>
>
> The e-mail below is from an external source. Please do not open
> attachments or click links from an unknown or suspicious origin.
>
> Hello!
>
>
>
> Do you have field mappingId in your value objects? Note that your key
> (which is java.lang.String) is a different thing that mappingId in your
> value object, since obviously you can make them diverge.
>
>
>
> Regards,
>
> --
>
> Ilya Kasnacheev
>
>
>
>
>
> пн, 11 мар. 2019 г. в 15:34, <Ka...@ril.com>:
>
> Hi Igniters,
>
>
>
> Am trying to retrieve Cache metadata i.e. its field name
> and data type. But facing one weird issue, the metadata is returning valid
> response for some caches and invalid for some. Am giving my cache
> configuration for reference. The cluster is up and running for some time
> now, and we have not altered/added any fields to any specific cache (aware
> about one existing issue if you alter cache then its metadata is not
> updated and can’t be retrieved from QueryEntities). Any help or pointers on
> this would be appreciated :
>
> e.g. for below cache its returning only one field i.e. associateId.
> However, it is supposed to return both the fields mentioned in ‘fields’
> property below.
>
>
>
> <bean class="org.apache.ignite.configuration.CacheConfiguration"
> parent="cache-template">
>
> <property name="name" value="EntMapAssociateCache" />
>
> <property name="cacheMode" value="PARTITIONED" />
>
> <property name="atomicityMode" value="ATOMIC" />
>
> <property name="backups" value="1" />
>
> <property name="statisticsEnabled" value="true"/>
>
> <property name="queryEntities">
>
> <list>
>
> <bean class="org.apache.ignite.cache.QueryEntity">
>
> <property name="keyType"
> value="java.lang.String" />
>
> <property name="valueType"
> value="com.digitalapi.edif.customer.model.EntMapAssociate" />
>
> <property name="tableName"
> value="ENT_MAP_ASSOCIATE" />
>
> <property name="keyFieldName"
> value="mappingId" />
>
> <property name="keyFields">
>
> <list>
>
>
> <value>mappingId</value>
>
> </list>
>
> </property>
>
> <property name="fields">
>
> <map>
>
> <entry
> key="associateId" value="java.lang.String" />
>
> <entry
> key="mappingId" value="java.lang.String" />
>
> </map>
>
> </property>
>
> <property name="aliases">
>
> <map>
>
> <entry
> key="associateId" value="ASSOCIATE_ID" />
>
> <entry
> key="mappingId" value="MAPPING_ID" />
>
> </map>
>
> </property>
>
> </bean>
>
> </list>
>
> </property>
>
> </bean>
>
>
>
>
>
> *Thanks and Regards,*
>
> *Kamlesh Joshi*
>
>
>
>
> "*Confidentiality Warning*: This message and any attachments are intended
> only for the use of the intended recipient(s), are confidential and may be
> privileged. If you are not the intended recipient, you are hereby notified
> that any review, re-transmission, conversion to hard copy, copying,
> circulation or other use of this message and any attachments is strictly
> prohibited. If you are not the intended recipient, please notify the sender
> immediately by return email and delete this message and any attachments
> from your system.
>
> *Virus Warning:* Although the company has taken reasonable precautions to
> ensure no viruses are present in this email. The company cannot accept
> responsibility for any loss or damage arising from the use of this email or
> attachment."
>
>
> "*Confidentiality Warning*: This message and any attachments are intended
> only for the use of the intended recipient(s), are confidential and may be
> privileged. If you are not the intended recipient, you are hereby notified
> that any review, re-transmission, conversion to hard copy, copying,
> circulation or other use of this message and any attachments is strictly
> prohibited. If you are not the intended recipient, please notify the sender
> immediately by return email and delete this message and any attachments
> from your system.
>
> *Virus Warning:* Although the company has taken reasonable precautions to
> ensure no viruses are present in this email. The company cannot accept
> responsibility for any loss or damage arising from the use of this email or
> attachment."
>
>
> "*Confidentiality Warning*: This message and any attachments are intended
> only for the use of the intended recipient(s), are confidential and may be
> privileged. If you are not the intended recipient, you are hereby notified
> that any review, re-transmission, conversion to hard copy, copying,
> circulation or other use of this message and any attachments is strictly
> prohibited. If you are not the intended recipient, please notify the sender
> immediately by return email and delete this message and any attachments
> from your system.
>
> *Virus Warning:* Although the company has taken reasonable precautions to
> ensure no viruses are present in this email. The company cannot accept
> responsibility for any loss or damage arising from the use of this email or
> attachment."
>
RE: [External]Re: QueryEntities not returning all the fields
available in cache - 2.6 version
Posted by Ka...@ril.com.
Hi Ilya,
Please find below config of cache with composite key:
<bean class="org.apache.ignite.configuration.CacheConfiguration" parent="cache-template">
<property name="name" value="EntAssociatePositionCache" />
<property name="cacheMode" value="PARTITIONED" />
<property name="atomicityMode" value="ATOMIC" />
<property name="backups" value="1" />
<property name="statisticsEnabled" value="false"/>
<property name="queryEntities">
<list>
<bean class="org.apache.ignite.cache.QueryEntity">
<property name="keyType" value="com.jio.digitalapi.edif.customer.model.EntAssociatePositionKey" />
<property name="valueType" value="com.jio.digitalapi.edif.customer.model.EntAssociatePosition" />
<property name="tableName" value="ENT_ASSOCIATE_POSITION" />
<property name="keyFields">
<list>
<value>associateId</value>
<value>jobFunction</value>
</list>
</property>
<property name="fields">
<map>
<entry key="associateId" value="java.lang.String" />
<entry key="jobFunction" value="java.lang.String" />
<entry key="locationType" value="java.lang.String" />
<entry key="locationCode" value="java.lang.String" />
<entry key="storeCode" value="java.lang.String" />
<entry key="updateddatetime" value="java.sql.Timestamp" />
<entry key="updatedby" value="java.lang.String" />
</map>
</property>
<property name="aliases">
<map>
<entry key="associateId" value="ASSOCIATE_ID" />
<entry key="jobFunction" value="JOB_FUNCTION" />
<entry key="locationType" value="LOCATION_TYPE" />
<entry key="locationCode" value="LOCATION_CODE" />
<entry key="storeCode" value="STORE_CODE" />
</map>
</property>
<property name="indexes">
<list>
<bean class="org.apache.ignite.cache.QueryIndex">
<property name="name" value="ENT_ASSOCIATE_POSITION_PK" />
<property name="indexType" value="SORTED" />
<property name="fields">
<map>
<entry key="associateId" value="false" />
<entry key="jobFunction" value="false" />
</map>
</property>
</bean>
</list>
</property>
</bean>
</list>
</property>
</bean>
Thanks and Regards,
Kamlesh Joshi
From: Ilya Kasnacheev [mailto:ilya.kasnacheev@gmail.com]
Sent: Thursday, March 14, 2019 2:53 PM
To: user@ignite.apache.org
Subject: Re: [External]Re: QueryEntities not returning all the fields available in cache - 2.6 version
The e-mail below is from an external source. Please do not open attachments or click links from an unknown or suspicious origin.
Hello!
Then mappingId is not a field. It is an SQL column but it's not a field.
If it happens with composite keys, please share config.
Regards,
--
Ilya Kasnacheev
чт, 14 мар. 2019 г. в 12:18, <Ka...@ril.com>>:
Hi,
No, mappingId is not part of value object. But, even this issue is occurring for other cache with composite key as well.
Thanks and Regards,
Kamlesh Joshi
From: Ilya Kasnacheev [mailto:ilya.kasnacheev@gmail.com<ma...@gmail.com>]
Sent: Wednesday, March 13, 2019 6:16 PM
To: user@ignite.apache.org<ma...@ignite.apache.org>
Subject: [External]Re: QueryEntities not returning all the fields available in cache - 2.6 version
The e-mail below is from an external source. Please do not open attachments or click links from an unknown or suspicious origin.
Hello!
Do you have field mappingId in your value objects? Note that your key (which is java.lang.String) is a different thing that mappingId in your value object, since obviously you can make them diverge.
Regards,
--
Ilya Kasnacheev
пн, 11 мар. 2019 г. в 15:34, <Ka...@ril.com>>:
Hi Igniters,
Am trying to retrieve Cache metadata i.e. its field name and data type. But facing one weird issue, the metadata is returning valid response for some caches and invalid for some. Am giving my cache configuration for reference. The cluster is up and running for some time now, and we have not altered/added any fields to any specific cache (aware about one existing issue if you alter cache then its metadata is not updated and can’t be retrieved from QueryEntities). Any help or pointers on this would be appreciated :
e.g. for below cache its returning only one field i.e. associateId. However, it is supposed to return both the fields mentioned in ‘fields’ property below.
<bean class="org.apache.ignite.configuration.CacheConfiguration" parent="cache-template">
<property name="name" value="EntMapAssociateCache" />
<property name="cacheMode" value="PARTITIONED" />
<property name="atomicityMode" value="ATOMIC" />
<property name="backups" value="1" />
<property name="statisticsEnabled" value="true"/>
<property name="queryEntities">
<list>
<bean class="org.apache.ignite.cache.QueryEntity">
<property name="keyType" value="java.lang.String" />
<property name="valueType" value="com.digitalapi.edif.customer.model.EntMapAssociate" />
<property name="tableName" value="ENT_MAP_ASSOCIATE" />
<property name="keyFieldName" value="mappingId" />
<property name="keyFields">
<list>
<value>mappingId</value>
</list>
</property>
<property name="fields">
<map>
<entry key="associateId" value="java.lang.String" />
<entry key="mappingId" value="java.lang.String" />
</map>
</property>
<property name="aliases">
<map>
<entry key="associateId" value="ASSOCIATE_ID" />
<entry key="mappingId" value="MAPPING_ID" />
</map>
</property>
</bean>
</list>
</property>
</bean>
Thanks and Regards,
Kamlesh Joshi
"Confidentiality Warning: This message and any attachments are intended only for the use of the intended recipient(s), are confidential and may be privileged. If you are not the intended recipient, you are hereby notified that any review, re-transmission, conversion to hard copy, copying, circulation or other use of this message and any attachments is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return email and delete this message and any attachments from your system.
Virus Warning: Although the company has taken reasonable precautions to ensure no viruses are present in this email. The company cannot accept responsibility for any loss or damage arising from the use of this email or attachment."
"Confidentiality Warning: This message and any attachments are intended only for the use of the intended recipient(s), are confidential and may be privileged. If you are not the intended recipient, you are hereby notified that any review, re-transmission, conversion to hard copy, copying, circulation or other use of this message and any attachments is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return email and delete this message and any attachments from your system.
Virus Warning: Although the company has taken reasonable precautions to ensure no viruses are present in this email. The company cannot accept responsibility for any loss or damage arising from the use of this email or attachment."
"Confidentiality Warning: This message and any attachments are intended only for the use of the intended recipient(s).
are confidential and may be privileged. If you are not the intended recipient. you are hereby notified that any
review. re-transmission. conversion to hard copy. copying. circulation or other use of this message and any attachments is
strictly prohibited. If you are not the intended recipient. please notify the sender immediately by return email.
and delete this message and any attachments from your system.
Virus Warning: Although the company has taken reasonable precautions to ensure no viruses are present in this email.
The company cannot accept responsibility for any loss or damage arising from the use of this email or attachment."
Re: [External]Re: QueryEntities not returning all the fields
available in cache - 2.6 version
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
Then mappingId is not a field. It is an SQL column but it's not a field.
If it happens with composite keys, please share config.
Regards,
--
Ilya Kasnacheev
чт, 14 мар. 2019 г. в 12:18, <Ka...@ril.com>:
> Hi,
>
>
>
> No, mappingId is not part of value object. But, even this issue is
> occurring for other cache with composite key as well.
>
>
>
> *Thanks and Regards,*
>
> *Kamlesh Joshi*
>
>
>
> *From:* Ilya Kasnacheev [mailto:ilya.kasnacheev@gmail.com]
> *Sent:* Wednesday, March 13, 2019 6:16 PM
> *To:* user@ignite.apache.org
> *Subject:* [External]Re: QueryEntities not returning all the fields
> available in cache - 2.6 version
>
>
>
> The e-mail below is from an external source. Please do not open
> attachments or click links from an unknown or suspicious origin.
>
> Hello!
>
>
>
> Do you have field mappingId in your value objects? Note that your key
> (which is java.lang.String) is a different thing that mappingId in your
> value object, since obviously you can make them diverge.
>
>
>
> Regards,
>
> --
>
> Ilya Kasnacheev
>
>
>
>
>
> пн, 11 мар. 2019 г. в 15:34, <Ka...@ril.com>:
>
> Hi Igniters,
>
>
>
> Am trying to retrieve Cache metadata i.e. its field name
> and data type. But facing one weird issue, the metadata is returning valid
> response for some caches and invalid for some. Am giving my cache
> configuration for reference. The cluster is up and running for some time
> now, and we have not altered/added any fields to any specific cache (aware
> about one existing issue if you alter cache then its metadata is not
> updated and can’t be retrieved from QueryEntities). Any help or pointers on
> this would be appreciated :
>
> e.g. for below cache its returning only one field i.e. associateId.
> However, it is supposed to return both the fields mentioned in ‘fields’
> property below.
>
>
>
> <bean class="org.apache.ignite.configuration.CacheConfiguration"
> parent="cache-template">
>
> <property name="name" value="EntMapAssociateCache" />
>
> <property name="cacheMode" value="PARTITIONED" />
>
> <property name="atomicityMode" value="ATOMIC" />
>
> <property name="backups" value="1" />
>
> <property name="statisticsEnabled" value="true"/>
>
> <property name="queryEntities">
>
> <list>
>
> <bean class="org.apache.ignite.cache.QueryEntity">
>
> <property name="keyType"
> value="java.lang.String" />
>
> <property name="valueType"
> value="com.digitalapi.edif.customer.model.EntMapAssociate" />
>
> <property name="tableName"
> value="ENT_MAP_ASSOCIATE" />
>
> <property name="keyFieldName"
> value="mappingId" />
>
> <property name="keyFields">
>
> <list>
>
>
> <value>mappingId</value>
>
> </list>
>
> </property>
>
> <property name="fields">
>
> <map>
>
> <entry
> key="associateId" value="java.lang.String" />
>
> <entry
> key="mappingId" value="java.lang.String" />
>
> </map>
>
> </property>
>
> <property name="aliases">
>
> <map>
>
> <entry
> key="associateId" value="ASSOCIATE_ID" />
>
> <entry
> key="mappingId" value="MAPPING_ID" />
>
> </map>
>
> </property>
>
> </bean>
>
> </list>
>
> </property>
>
> </bean>
>
>
>
>
>
> *Thanks and Regards,*
>
> *Kamlesh Joshi*
>
>
>
>
> "*Confidentiality Warning*: This message and any attachments are intended
> only for the use of the intended recipient(s), are confidential and may be
> privileged. If you are not the intended recipient, you are hereby notified
> that any review, re-transmission, conversion to hard copy, copying,
> circulation or other use of this message and any attachments is strictly
> prohibited. If you are not the intended recipient, please notify the sender
> immediately by return email and delete this message and any attachments
> from your system.
>
> *Virus Warning:* Although the company has taken reasonable precautions to
> ensure no viruses are present in this email. The company cannot accept
> responsibility for any loss or damage arising from the use of this email or
> attachment."
>
>
> "*Confidentiality Warning*: This message and any attachments are intended
> only for the use of the intended recipient(s), are confidential and may be
> privileged. If you are not the intended recipient, you are hereby notified
> that any review, re-transmission, conversion to hard copy, copying,
> circulation or other use of this message and any attachments is strictly
> prohibited. If you are not the intended recipient, please notify the sender
> immediately by return email and delete this message and any attachments
> from your system.
>
> *Virus Warning:* Although the company has taken reasonable precautions to
> ensure no viruses are present in this email. The company cannot accept
> responsibility for any loss or damage arising from the use of this email or
> attachment."
>
RE: [External]Re: QueryEntities not returning all the fields
available in cache - 2.6 version
Posted by Ka...@ril.com.
Hi,
No, mappingId is not part of value object. But, even this issue is occurring for other cache with composite key as well.
Thanks and Regards,
Kamlesh Joshi
From: Ilya Kasnacheev [mailto:ilya.kasnacheev@gmail.com]
Sent: Wednesday, March 13, 2019 6:16 PM
To: user@ignite.apache.org
Subject: [External]Re: QueryEntities not returning all the fields available in cache - 2.6 version
The e-mail below is from an external source. Please do not open attachments or click links from an unknown or suspicious origin.
Hello!
Do you have field mappingId in your value objects? Note that your key (which is java.lang.String) is a different thing that mappingId in your value object, since obviously you can make them diverge.
Regards,
--
Ilya Kasnacheev
пн, 11 мар. 2019 г. в 15:34, <Ka...@ril.com>>:
Hi Igniters,
Am trying to retrieve Cache metadata i.e. its field name and data type. But facing one weird issue, the metadata is returning valid response for some caches and invalid for some. Am giving my cache configuration for reference. The cluster is up and running for some time now, and we have not altered/added any fields to any specific cache (aware about one existing issue if you alter cache then its metadata is not updated and can’t be retrieved from QueryEntities). Any help or pointers on this would be appreciated :
e.g. for below cache its returning only one field i.e. associateId. However, it is supposed to return both the fields mentioned in ‘fields’ property below.
<bean class="org.apache.ignite.configuration.CacheConfiguration" parent="cache-template">
<property name="name" value="EntMapAssociateCache" />
<property name="cacheMode" value="PARTITIONED" />
<property name="atomicityMode" value="ATOMIC" />
<property name="backups" value="1" />
<property name="statisticsEnabled" value="true"/>
<property name="queryEntities">
<list>
<bean class="org.apache.ignite.cache.QueryEntity">
<property name="keyType" value="java.lang.String" />
<property name="valueType" value="com.digitalapi.edif.customer.model.EntMapAssociate" />
<property name="tableName" value="ENT_MAP_ASSOCIATE" />
<property name="keyFieldName" value="mappingId" />
<property name="keyFields">
<list>
<value>mappingId</value>
</list>
</property>
<property name="fields">
<map>
<entry key="associateId" value="java.lang.String" />
<entry key="mappingId" value="java.lang.String" />
</map>
</property>
<property name="aliases">
<map>
<entry key="associateId" value="ASSOCIATE_ID" />
<entry key="mappingId" value="MAPPING_ID" />
</map>
</property>
</bean>
</list>
</property>
</bean>
Thanks and Regards,
Kamlesh Joshi
"Confidentiality Warning: This message and any attachments are intended only for the use of the intended recipient(s), are confidential and may be privileged. If you are not the intended recipient, you are hereby notified that any review, re-transmission, conversion to hard copy, copying, circulation or other use of this message and any attachments is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return email and delete this message and any attachments from your system.
Virus Warning: Although the company has taken reasonable precautions to ensure no viruses are present in this email. The company cannot accept responsibility for any loss or damage arising from the use of this email or attachment."
"Confidentiality Warning: This message and any attachments are intended only for the use of the intended recipient(s).
are confidential and may be privileged. If you are not the intended recipient. you are hereby notified that any
review. re-transmission. conversion to hard copy. copying. circulation or other use of this message and any attachments is
strictly prohibited. If you are not the intended recipient. please notify the sender immediately by return email.
and delete this message and any attachments from your system.
Virus Warning: Although the company has taken reasonable precautions to ensure no viruses are present in this email.
The company cannot accept responsibility for any loss or damage arising from the use of this email or attachment."
Re: QueryEntities not returning all the fields available in cache -
2.6 version
Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!
Do you have field mappingId in your value objects? Note that your key
(which is java.lang.String) is a different thing that mappingId in your
value object, since obviously you can make them diverge.
Regards,
--
Ilya Kasnacheev
пн, 11 мар. 2019 г. в 15:34, <Ka...@ril.com>:
> Hi Igniters,
>
>
>
> Am trying to retrieve Cache metadata i.e. its field name
> and data type. But facing one weird issue, the metadata is returning valid
> response for some caches and invalid for some. Am giving my cache
> configuration for reference. The cluster is up and running for some time
> now, and we have not altered/added any fields to any specific cache (aware
> about one existing issue if you alter cache then its metadata is not
> updated and can’t be retrieved from QueryEntities). Any help or pointers on
> this would be appreciated :
>
> e.g. for below cache its returning only one field i.e. associateId.
> However, it is supposed to return both the fields mentioned in ‘fields’
> property below.
>
>
>
> <bean class="org.apache.ignite.configuration.CacheConfiguration"
> parent="cache-template">
>
> <property name="name" value="EntMapAssociateCache" />
>
> <property name="cacheMode" value="PARTITIONED" />
>
> <property name="atomicityMode" value="ATOMIC" />
>
> <property name="backups" value="1" />
>
> <property name="statisticsEnabled" value="true"/>
>
> <property name="queryEntities">
>
> <list>
>
> <bean class="org.apache.ignite.cache.QueryEntity">
>
> <property name="keyType"
> value="java.lang.String" />
>
> <property name="valueType"
> value="com.digitalapi.edif.customer.model.EntMapAssociate" />
>
> <property name="tableName"
> value="ENT_MAP_ASSOCIATE" />
>
> <property name="keyFieldName"
> value="mappingId" />
>
> <property name="keyFields">
>
> <list>
>
>
> <value>mappingId</value>
>
> </list>
>
> </property>
>
> <property name="fields">
>
> <map>
>
> <entry
> key="associateId" value="java.lang.String" />
>
> <entry
> key="mappingId" value="java.lang.String" />
>
> </map>
>
> </property>
>
> <property name="aliases">
>
> <map>
>
> <entry
> key="associateId" value="ASSOCIATE_ID" />
>
> <entry
> key="mappingId" value="MAPPING_ID" />
>
> </map>
>
> </property>
>
> </bean>
>
> </list>
>
> </property>
>
> </bean>
>
>
>
>
>
> *Thanks and Regards,*
>
> *Kamlesh Joshi*
>
>
>
>
> "*Confidentiality Warning*: This message and any attachments are intended
> only for the use of the intended recipient(s), are confidential and may be
> privileged. If you are not the intended recipient, you are hereby notified
> that any review, re-transmission, conversion to hard copy, copying,
> circulation or other use of this message and any attachments is strictly
> prohibited. If you are not the intended recipient, please notify the sender
> immediately by return email and delete this message and any attachments
> from your system.
>
> *Virus Warning:* Although the company has taken reasonable precautions to
> ensure no viruses are present in this email. The company cannot accept
> responsibility for any loss or damage arising from the use of this email or
> attachment."
>