see conf/schema-sample.txt it's a script that can be passed to the cli (has an example there) and you can also paste the text into the cli if you want to.
The cli has a bunch of online help as well. Hope that helps. ----------------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 11 May 2011, at 13:55, Jim the Standing Bear wrote: > Hi Praveen, > >> The import only works on fresh system >> and imports from cassandra.yaml file. > > Thanks for this information. What do you mean by a fresh system? A > system that was just installed, configured, and launched, with no any > other user-defined keyspaces? So in other words, I can only add one > user-defined keyspace into cassandra using cassandra.yaml; and for all > other keyspaces that I may wish to add in the future, I have to do it > programmatically? > > I think I am still stuck in the RDBMS world... because with RDBMS, I > can certainly create SQL scripts to add as many new databases as I > wish. This is better than embedding the data definition SQL in > program logic. > > -- Jim