What exactly are good examples of column-oriented DBMSs?

Can there be any difference in querying (do both use SQL?)? Performance? Data modeling?

When and why must I personally use one within the other?

Here you decide to go: Column-Oriented DBMS