[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: How to read from Cassandra using Apache Flink?

You are creating an entirely new sink for each fetch, which includes setting up a connection to cassandra. It is not surprising that this is slow. The cassandra input format was written for reading large amounts of data, not synchronous single row fetches.
You can try using the datastax driver (or some other library) directly. You should be able to re-use large portions of the CassandraInputFormat.
Note that you're also leaking the connection as you aren't closing the InputFormat. 

On 05.06.2018 12:02, HarshithBolar wrote:

My flink program should do a Cassandra look up for each input record and
based on the results, should do some further processing.

But I'm currently stuck at reading data from Cassandra. This is the code
snippet I've come up with so far.


ClusterBuilder secureCassandraSinkClusterBuilder = new ClusterBuilder() {
         @Override
         protected Cluster buildCluster(Cluster.Builder builder) {
             return
builder.addContactPoints(props.getCassandraClusterUrlAll().split(","))
                     .withPort(props.getCassandraPort())
                     .withAuthProvider(new DseGSSAPIAuthProvider("HTTP"))
                     .withQueryOptions(new
QueryOptions().setConsistencyLevel(ConsistencyLevel.LOCAL_QUORUM))
                    .build();
        }
    };
    for (int i=1; i<5; i++) {
        CassandraInputFormat<Tuple2&lt;String, String>>
cassandraInputFormat =
                new CassandraInputFormat<>("select * from test where
id=hello" + i, >secureCassandraSinkClusterBuilder);
        cassandraInputFormat.configure(null);
        cassandraInputFormat.open(null);
        Tuple2<String, String> out = new Tuple8<>();
        cassandraInputFormat.nextRecord(out);
        System.out.println(out);
    }

But the issue with this is, it takes nearly 10 seconds for each look up, in
other words, this for loop takes 50 seconds to execute.

How do I speed up this operation? Alternatively, is there any other way of
looking up Cassandra in Flink?





--
Sent from: http://apache-flink-user-mailing-list-archive.2336050.n4.nabble.com/