Can janusgraph support the ClickHouse?

[ggservice007]

I love janusgraph and ClickHouse.

ClickHouse/ClickHouse#4001

We can together make it.

So nice.

[porunov]

@ggservice007 as far as I know, right now JanusGraph doesn't support ClickHouse as a storage backend. I believe it is possible to add support for ClickHouse but for this we need someone who is an expert in both JanusGraph and ClickHouse and is willing to contribute to JanusGraph. If you wish to contribute to JanusGraph by adding a new supported backend to it then JanusGraph community can help you with it.
You can ask development questions in the JanusGraph developers group: https://groups.google.com/forum/#!forum/janusgraph-dev

[ggservice007]

@porunov
So nice.
I will try it.

[blinkov]

Briefly browsed around source/docs and it sounds like JanusGraph uses those backends just for read/write queries for specific keys. If that's right there's not much sense to add ClickHouse to that backends list, because it's optimized for batch writes and analytical retrieval queries (with aggregation, joins, sorts, etc.) which is completely different workload.

[ggservice007]

@porunov

Thanks a lot.

Maybe we can write a new store format for the ClickHouse.

[ggservice007]

@porunov
Any idea about that "Briefly browsed around source/docs and it sounds like JanusGraph uses those backends just for read/write queries for specific keys. "

[porunov]

@ggservice007 I am not familiar with ClickHouse and don't know if it is wise to use it as a storage backend. All I know is that it is a column-oriented database management system. If so, then it is possible to use it as a storage backend. But to understand if you should use it as a storage backend you need to dig into ClickHouse.

[blinkov]

@porunov what kind of queries are typically issued to those backends?

[porunov]

@blinkov I didn't research yet how JanusGraph proceed queries to the storage backend. I know what kind of queries go into index backends (cursor is used to retrieve search data in batches. Search queries are not key specific). I assume that there are not only queries for specific keys when working with storage backends.
You can ask this question JanusGraph community here:
https://groups.google.com/forum/#!forum/janusgraph-users
Possibly someone can give you an answer