That's how things typically take off, not on the first attempt. Depends on what's different this time.
(Though NoSQL has outlived its usefulness as a concept IMO, it's just too loose to be useful beyond its early use for "something like CouchDB/Mongo", which this is clearly not)
How exactly is it different from No-SQL?
No schema? Check.
No consistency? Check. (eventually consistent)
Key-value store? Check. (because it's using ZooKeeper under the hood)
Promising amazing results and freeing you from the chains of the SQL? CHECK!
Everything you wrote here is false, with the exception of Rama not using SQL. Rama has strong schemas, is strongly consistent, and is not limited to key/value (PStates can be any data structure combination). Zookeeper is used only for cluster metadata and is not involved with user storage/processing in any way.
