Vertica as reporting tool (not for analytics)?
I know vertica is very good for Analytics but i am working on some POC to use vertica as Reporting tool only to replace SQL Server but so far results are not great.
Its column oriented storage will not help to retrive all/selected columns for the reports. Also when we need to get data near to real time we will also have isuses with DML operations on primary server.
Any thoughts/suggestions ? Anyone has used Vertica for pure reporting only ?