官术网_书友最值得收藏!

Partial inserts

You are not, of course, required to provide values for all columns—other than primary key columns—when inserting a row. If, for instance, we decide to allow users to register without providing an email, we may issue this perfectly valid query:

    INSERT INTO "users"
("username", "encrypted_password")
VALUES (
'bob',
0x10920941a69549d33aaee6116ed1f47e19b8e713
);

In the preceding query, we only insert values for the username and encrypted_password fields; the row will have no value in the email field.

Do empty columns take up space?
Only columns with values take up storage space in Cassandra. This is in contrast to relational databases, in which every row has space allocated for every column, whether or not that column has a value. So, there's little downside to defining columns in Cassandra that you expect to rarely populate; they'll only take up space where they have values. For a full reference on the INSERT statement in CQL, consult the DataStax CQL documentation at http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/insert_r.html.

We haven't explored all of the possibilities for INSERT statements yet, but we'll cover many of them in future chapters.

主站蜘蛛池模板: 苍山县| 黄石市| 会昌县| 叶城县| 子洲县| 赫章县| 秭归县| 绥化市| 阿拉尔市| 荣昌县| 铁岭市| 怀远县| 怀仁县| 德庆县| 青浦区| 婺源县| 大方县| 永德县| 如皋市| 商洛市| 友谊县| 永丰县| 南阳市| 来凤县| 青龙| 启东市| 崇义县| 揭西县| 龙川县| 安陆市| 南和县| 新竹市| 镇远县| 唐河县| 内丘县| 察隅县| 涿鹿县| 德昌县| 凤庆县| 温州市| 夏河县|