ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From amgad <amgad.madk...@outlook.com>
Subject IgniteRDD SQL query stalled or extremly slow on large input argument
Date Wed, 14 Jun 2017 17:53:07 GMT
I have a query that stalls/hangs over large argument inputs. The same code
works well on smaller SQL argument input. The code is as follows: 

*subEntries = dataRDD.sql("SELECT v.id,v.sub,v.obj FROM VPRow v JOIN
table(id bigint = ?) i ON v.id = i.id",new Object[]
LOG.debug("Reading : "+subEntries.count());
Please note that the Ignite documentation mentions that the input argument
can be of any size - "Here you can provide object array (Object[]) of any
length as a parameter". The parameter passed to the query in the stalling
case was of size *23641 of long values*. 

My spring configuration file is as follows:

*<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"

    <bean id="ignite.cfg"
        <property name="cacheConfiguration">
                    <property name="name" value="dataRDD"/>
                    <property name="cacheMode" value="PARTITIONED"/>
                    <property name="indexedTypes">
                    <property name="backups" value="0"/>
        <property name="discoverySpi">
                <property name="ipFinder">
                        <property name="addresses">
The VPRow class is defined as follows

*public class VPRow implements Serializable {

    private long id;
    private String sub;
    private String obj;

    public VPRow(long id,String sub, String obj) {
        this.id = id;
        this.sub = sub;
        this.obj = obj;

View this message in context: http://apache-ignite-users.70518.x6.nabble.com/IgniteRDD-SQL-query-stalled-or-extremly-slow-on-large-input-argument-tp13711.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

View raw message