Original Sql query:
SELECT dnsnb.value,
dnsnb.id
FROM DnsNetBiosAssetGroupData dnsnb
JOIN TABLE (value VARCHAR = ? ) temp
ON dnsnb.value = temp.value
WHERE dnsnb.subscriptionId = ?
AND dnsnb.assetGroupId = ?
AND dnsnb.assetTypeInd = ?
temp table list has around 1_00_000 values.
I also tried changing the indexes as follows. But it did not work.
public class DnsNetBiosAssetGroupData implements
Data<DefaultDataAffinityKey>,UpdatableData<DefaultDataAffinityKey> {
@QuerySqlField
private long id;
@QuerySqlField(orderedGroups = {@QuerySqlField.Group(name =
"dns_nb_asset_group_data_idx1", order = 1)})
private long assetGroupId;
@QuerySqlField(orderedGroups = {@QuerySqlField.Group(name =
"dns_nb_asset_group_data_idx1", order = 2)})
private int assetTypeInd;
private int partitionId;
@QuerySqlField
private long subscriptionId;
@QuerySqlField
private long updatedDate;
//@QuerySqlField (index = true)
@QuerySqlField(orderedGroups = {@QuerySqlField.Group(name =
"dns_nb_asset_group_data_idx1", order = 3)})
private String value;
Thanks,
Prasad
On Tue, Aug 21, 2018 at 7:35 PM ilya.kasnacheev <[email protected]>
wrote:
> Hello!
>
> Can you please show the original query that you are running?
>
> Regards,
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
