


                The Views of Cassandra
                
                
                1) the DBA view
                    is looking at install, performance, tuning, etc
                    use NodeTool
                  
                2) the Data Modeler
                    is looking at the tables/columns/keys etc
                    defines the KeySpace rules and the Table rules
                    including the Primary Key which gives us the
                    Partition key and Clustering Columns  
                    
                3) the Developer
                    is looking at queries/updates etc
                    use CQL 
                    in CQL a SELECT w/o a WHERE is "search the World"
                    a SELECT w/ a WHERE MUST use the Partition Key!!!
                    in CQL I CANNOT use a column in the WHERE clause that is NOT a key column
                    and I MUST use the part of the Primary Key from 
                    LEFT to RIGHT I CANNOT skip a part
                    for this:
                     PRIMARY KEY ((state), city, last_name, first_name))
                     
                     I can do:
                     where state =
                     where state = and city =
                     where state = and city = and last_name = 
                     
                     I CANNOT do
                     where state = and last_name = (skipping city)
                     
                     
                    
                    
