On Thu, Jul 18, 2013 at 8:12 AM, Tony Anecito <adanecito@yahoo.com> wrote: 
As I work more with CQL and CLI as some other posting I have seen regarding usage I am thinking that CLI for keyspace and Column Family setup and maintenance is best
 while CQL for queries/inserts ect is best. Mainly I am thinking this because of better control over the schema using CLI.

The question is not really CQL vs CLI, it's COMPACT STORAGE vs. (NON-COMPACT) CQL storage. Picking one or the other strongly informs whether you want to also use Thrift or CQL (respectively) as an interface.