Recently I did a POC with column store databases. I used Maria DB ColumnStore database storage engine and SQL server's column indexed on Azure. I had around 38 GB's of sample data to query upon. I wrote close to 45 test cases (with queries). Some of the tables had more than 100 columns.
I was surprised to see that Maria Db's execution time for queries was far better than SQL Server columnstore index. Is there any reason behind it? I was expecting better results from SQL.