Support Forums : DataStax

DataStax Support Forums » DataStax Enterprise

Composit columns for Name field

(4 posts) (2 voices)

Started 10 months ago by akhil.bansal
Latest reply from xedin
This topic is not a support question

Tags:

akhil.bansal
Member

Hi, I have a column family for storing customer details. Column Family will have CustomerCode as key and below mentioned fields

email address
Name
First Name
last name
Suffix

Address
House#
Street
City
State
Country.

where name should be the combined values of Suffix, First Name ,last name
and address should be the combined value of House#, Street, City, State and Country

Does composite columns be used in this situations ?

Can you please guide with the syntax for creating this column family where we have two composite columns and each has different number of columns ?

Posted 10 months ago #
xedin
Member

Yes, you can use composites in this case, you will need to have CompositeType(UTF8Type, UTF8Type, UTF8Type) which would handle the Suffix, first/last name and CompositeType(Int32Type, UTF8Type, UTF8Type, Int32Type, UTF8Type) for house/street/city/state and country.

CLI syntax:

create column family cf with key_validation_class=UTF8Type and comparator=AsciiType and column_metadata=[{column_name:name, validation_class:'CompositeType(UTF8Type, UTF8Type, UTF8Type)'}, {column_name:address, validation_class:'CompositeType(Int32Type, UTF8Type, UTF8Type, Int32Type, UTF8Type)'}];

But it also depends and how do you want to query the data, if you would query only specific columns (e.g. first name) you can go with secondary indices instead of composites.

Posted 10 months ago #
akhil.bansal
Member

Thanks xedin this is what i was looking for.

1. How does it differs from storing the individual columns at column family level as compared to composite column ?

2. Does composite column offer any advantage in column retrieval over the data retrieval from individual columns ?

3. How specifying CompositeType for a column is different from specifying a composite for the column family (comparator)? I have seen lots of syntax on net for composite column where CompositeType is specified for comparator instead of Validate_class for column. And all the articles were for composite columns only.

Posted 10 months ago #
xedin
Member

I suggest you to take a look at this http://www.datastax.com/dev/blog/introduction-to-composite-columns-part-1 , which has detailed description of the problem and answers to all 3 of your questions.

Posted 10 months ago #

RSS feed for this topic

Reply

You must log in to post.