Print

Print


Hi, 

FYI, some ClickHouse expert are playing with our S15 benchmark (first node for now) 
https://clickhouse.yandex/ 

Regards 


De: "Vadim Tkachenko" <[log in to unmask]> 
À: "Bart Scheers" <[log in to unmask]> 
Cc: "Fritz Mueller" <[log in to unmask]>, "Fabrice Jammes" <[log in to unmask]> 
Envoyé: Lundi 4 Décembre 2017 16:39:39 
Objet: Re: Re LSST Queries 

Bart, 
Thanks a lot! 

Fabrice, Fritz , 

would you make it possible to share the simulated data with the team that experts in ClickHouse? 
We also would be able to assist with ClickHouse questions if you have any. 

Thanks in advance, 
Vadim 


On Mon, Dec 4, 2017 at 5:54 AM, Bart Scheers < [ mailto:[log in to unmask] | [log in to unmask] ] > wrote: 


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 | 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 [ tel:%2B1-919-249-7483 | +1-919-249-7483 ] 







-- 
Vadim Tkachenko, CTO, Percona 
Phone +1-919-249-7483 


########################################################################
Use REPLY-ALL to reply to list

To unsubscribe from the QSERV-L list, click the following link:
https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1