Skip to main content

Vertica as reporting tool (not for analytics)?

  • January 6, 2016
  • 1 reply
  • 6 views
KMehta

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 ?

 

    1 reply

    eli_revach
    Forum|alt.badge.img+2
    • eli_revach
    • Participating Frequently
    • January 7, 2016

    Hi ,

    You do not mention what  type of  problem you have   , I guess its  query performances  . Its hard to answer such question without real use case and sample query   , also the DML comment is not clear .

    Thinks you can consider :

    But as general statement , Vertica is  not ideal  for query’s that return very large result set  

     

     

    Thanks

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement