Fully managed cloud. 30-day FREE full featured trial. Start Now
cancel
Showing results for 
Search instead for 
Did you mean: 

Using Exasol for real-time data serving via a web app?

kutny
Padawan

Hi,

we've developed a web application that serves many visualizations and data analyses to the end-users. We calculate all the data in a spark-powered data lake and push them to ClickHouse to be able to aggregate (count, sum, avg, median, ...) and present that data in real-time via our web application.

Our web app is used by 20 - 40 concurrent users. Data size 100 - 200 GB (compressed). Millions of rows, thousands of columns (very wide tables).

Can Exasol successfully replace ClickHouse in this use-case?

Thanks

2 REPLIES 2

exa-Aleksandr
Team Exasol
Team Exasol

Hi @kutny ,

Exasol definitely fits the listed requirements.

Default and recommended limits for active sessions and columns per table are 100 and 10000 accordingly.

mwellbro
Xpert

If memory serves right, @nikolayssokolov  , you might say a word or two about this ?
I might also confuse something here so bear me if I´m off mark here 😉