Hi Vadim,
We ran the queries in ClickHouse as well, and will come with a report
soon that we will share.
As stated in the blog post the simulated data are generated by the LSST
DM group and comes from the French LSST group at CNRS/LIMOS. They don't
have any objections providing you with the data. But I'll have to refer
you to them tp request the same s15 1.3 TB dataset. The one we used is
named RegionOne.
I'll forward you to Fabrice Jammes (LPC, Clermont-Ferrand, France) and
Fritz Mueller (SLAC) who are in charge of the data.
Recently we had been discussing the essence of having a representative
set of LSST benchmark queries and the benefit LSST (as well as serious
database systems) could make if they run these kind of queries.
Could you keep me in the loop?
Cheers
Bart
On 11/30/2017 02:51 AM, Vadim Tkachenko wrote:
> Hello,
>
> I am Vadim Tkachenko, CTO at Percona.
> Also I am doing a lot of research work regarding ClickHouse,
> a modern columnar database.
>
> I've found this blog
> https://www.monetdb.org/blog/lsst-in-monetdb
> Where the researcher ran queries against 2TB dataset,
> but he mentioned that database should be requested from LSST team.
>
> I wonder if you would be able to provide a dataset to run a similar
> experiment
> with ClickHouse.
>
> Thanks in advance,
> Vadim
>
> --
> Vadim Tkachenko, CTO, Percona
> Phone +1-919-249-7483