Stack Overflow
Stack Overflow

Questions tagged [column-family]

A column family is a NoSQL object that contains columns of related data. It is a tuple (pair) that consists of a key-value pair, where the key is mapped to a value that is a set of columns. In analogy with relational databases, a column family is as a "table".

71 questions
2
votes
1 answer

how to add a column in hbase table without adding column family

is that possible to create a hbase table without adding column family, for instance create 'emp','personal data','professional data' personal data & professional data are the column family, i want to add fields to table without adding column…
Gowtham
  • 39
  • 1
  • 7
2
votes
3 answers

How to copy cassandra data from one cluster to another

I Have 2 cassandra clusters, on different datacenter (note that these are 2 different clusters, NOT a single cluster with multidc), and both clusters have the same keyspace and columnfamily models. I wish to copy data of columnfamily C from Cluster…
Salvia
  • 182
  • 2
  • 11
1
vote
1 answer

Is there a way to query by column family in Cassandra NoSQL?

Table Creation Attempt: CREATE TABLE users_v1 ( guid uuid PRIMARY KEY, notice text, first_name text, last_name text, obsidian text, starlight text, bids text, apps text, FAMILY f1 (first_name, last_name), FAMILY f2 (obsidian, starlight), FAMILY f3…
Ian
  • 25
  • 4
1
vote
1 answer

How to get the count of columns in each column family in HBASE

How to get the count of columns in each column family in HBASE. I have a table_name T, and columnfamily 'f' and 'm', have 10 columns each. how to count the number of columns in each column family.
khubeb
  • 21
  • 1
1
vote
1 answer

How to determine logical/physical reads and writes in cassandra?

I'am currently investigating read and writes operations on cassandra. I would like to know about the read and writes that cassandra performs on the memtable and sstable. What is the closest value of the cassandra metrics? All I found are latency…
Sebastian
  • 21
  • 5
1
vote
1 answer

Prefix search on a specific column in hbase not working in java

There is a column lets say Countries in hbase and I want to prefix on this column(this is not a row key) then I will use ColumnPrefixFilter and do something like this ColumnPrefixFilter columnPrefixFilter = new…
agrawal1084
  • 129
  • 2
  • 11
1
vote
1 answer

HBase Column family locality

there are HBase on five servers with one Table that contains one column Family and I should do some map tasks on it per each key and save the result. the main question is: to keep data locality which one is better: create new Column Family on the…
Hossein Vatani
  • 1,381
  • 14
  • 26
1
vote
0 answers

How do I choose between column-family and a document store database?

I'm working on a project, and I'm struggling to make a definitive decision on whether to use a column-family or a document store. My situation is as follows: The project I am working on is a hass.io application that will visualize certain data for…
Muggenhoofd2
  • 11
  • 1
1
vote
1 answer

Hbase multiple column families vs multiple tables

I'm developing a Hbase storage for data generated from different sources. Usually columns from the same source are more likely to be retrieved at the same time. The expected write/read ratio roughly range from 1/10 to 1/100 (depends on different…
twds
  • 333
  • 1
  • 4
  • 15
1
vote
2 answers

How to set the column family size for a Hbase table column family?

I am trying to import data from a CSV file into a HBase table. But I am running into the below shown exception during the import. Error: com.google.protobuf.InvalidProtocolBufferException: Protocol message was too large. May be malicious. Use…
AnOldSoul
  • 4,017
  • 12
  • 57
  • 118
1
vote
1 answer

How to get the range of tokens for only particular CF in cassandra by CQL?

I do want to repair a column family part by part using the command nodetool repair -st starting_token -et ending_token. As each row in column family have different range of token values,Is there any way to get the different token range possessed by…
arjun gowthaman
  • 11
  • 1
  • 3
1
vote
1 answer

How can I create a column family without defining any column in apache phoenix?

According to the description on phoenix website: Following create table DDL will create two column faimiles A and B. CREATE TABLE TEST (MYKEY VARCHAR NOT NULL PRIMARY KEY, A.COL1 VARCHAR, A.COL2 VARCHAR, B.COL3 VARCHAR) But I need to create a…
Powpow
  • 150
  • 1
  • 8
1
vote
1 answer

Disadvantages of having more columnfamily in hbase?

I have read that in hbase, I should not have more than 2-3 column families in a table. I know that to fetch entries from each column family in a row, I need to do a separate scan, but still I don't understand what will be issue if I will have more…
Harsh Sharma
  • 10,942
  • 2
  • 18
  • 29
1
vote
3 answers

Does Cassandra read the whole row when limiting the number of requested results?

I am using cassandra 2.0.6. and have this table: CREATE TABLE t ( id text, idx bigint, data bigint, PRIMARY KEY (id, idx) ) So say I got these rows: id / idx / data x 1 data1 x 2 data2 x 3 data3 .... goes on…
kostas.kougios
  • 945
  • 10
  • 21
1
vote
0 answers

unconfigured columnfamily error on consecutive execute calls (CQL)

I'm using the cassandra python driver for datastax's distro. mah codez... from cassandra.io.libevreactor import LibevConnection from cassandra.cluster import Cluster cluster = Cluster(['some ip addr']) cluster.connection_class =…
Davis Dulin
  • 629
  • 5
  • 9
1
2
3 4 5