Stack Overflow
Stack Overflow

Questions tagged [hypertable]

Hypertable is an open source database inspired by publications on the design of Google's BigTable.

Hypertable is an open source database inspired by publications on the design of Google's BigTable.

Hypertable runs on top of a distributed file system such as the Apache Hadoop DFS, GlusterFS, or the Kosmos File System (KFS). It is written almost entirely in C++.

Because Hypertable keeps data physically sorted by a primary key, it is well-suited to a broad set of applications.

Official Website

83 questions
23
votes
2 answers

bigtable vs cassandra vs simpledb vs dynamo vs couchdb vs hypertable vs riak vs hbase, what do they have in common?

Sorry if this question is somewhat subjective. I am new to 'could store', 'distributed store' or some concepts like this. I really wonder what do they have in common and want to get an overview on all of them. What do I need to prepare if I want to…
Mickey Shine
  • 12,187
  • 25
  • 96
  • 148
5
votes
2 answers

why we need hadoop for hypertable

i have written an crawler in c++ and i am looking for an distributed data store i found 2 1) hbase 2) hypertable both are the implementation of Big table and i just reviewed hypertable.. because it was implemented in c++ and..hbase is most widely…
ramya
  • 51
  • 2
3
votes
0 answers

How to insert 'n' values in hypertable using Hadoop Python?

How to insert multiple values in hypertable using Hadoop Python streaming? I am able to insert values for single column, but not more than one column. While I'm trying, I get the following exception: java.lang.RuntimeException: java.io.IOException:…
SENTHIL SARAVANAN
  • 719
  • 1
  • 12
  • 28
3
votes
1 answer

How do I create a hypertable with TimescaleDB from a table with joint Primary Key?

The question pretty much says it all. I'm trying to create a hypertable with TimescaleDB from a table with joint Primary Key: CREATE TABLE cars ( id BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY, time_bought TIMESTAMP NOT NULL, brand…
TheStranger
  • 1,387
  • 1
  • 13
  • 35
3
votes
1 answer

Update all time index in a TimescaleDB/PostgreSQL hypertable?

I am using an open-source time-series database named TimescaleDB ( based on PostgreSQL ). Assuming this table : CREATE TABLE order ( time TIMESTAMPTZ NOT NULL, product text, price DOUBLE…
A. STEFANI
  • 6,707
  • 1
  • 23
  • 48
3
votes
1 answer

Implement select for update for hypertable query language

I am asked to implement select for update in HQL in python. I haven't tried anything because I don’t have a good idea how I am going to go about it. As select for update fetches rows after we disable autocommit and there by achieve locking on…
Aladin
  • 31
  • 5
3
votes
1 answer

How to update data in hypertable

I have written some C# code to store data into hypertable database. However I don't know how to update the data. Below is what I have done: Hypertable b = new Hypertable(); b.Write("1", "value1");//this line is for writing to database b.Write("1",…
user1642888
  • 127
  • 1
  • 1
  • 8
2
votes
1 answer

Memory Requirement/Utilization for MongoDB, Riak and HyperTable (or HBase)

I've evaluated most of the NoSQL solutions and it seems that using a combination of MongoDB, Riak and HyperTable (or HBase) is the way to go. What is the minimum requirement for these databases to run comfortably? Let's say, if I deploy these…
ikevin8me
  • 4,253
  • 5
  • 44
  • 84
2
votes
1 answer

Posgresql crosstab alternative

I am looking for a crosstab alternative. I have data in Timescaledb (posgresql) hypertable in multiple rows: For example I need to calculate average of category = 1 when category 2 > 4. What I am doing at them moment is to pivot using crosstab and…
Kylo
  • 109
  • 8
2
votes
0 answers

How to reference hypertables properly using foreign key constraints in PostgreSQL?

#Error description: It's possible to create a table that has a foreign key into a hypertable provided the foreign key is defined when the table is created #To Reproduce, there are next tables: CREATE TABLE ids ( measurement_id int DEFAULT 0, …
Jean Fernandez
  • 51
  • 3
2
votes
1 answer

Timescale DB not creating hypertable

I'm following the tutorial from timescaleDB.. https://docs.timescale.com/timescaledb/latest/how-to-guides/hypertables/create/#create-a-hypertable but I cant create a hypertable.. I have successfully installed postgres and timescale. Why cant I make…
Teamunicorn
  • 45
  • 6
2
votes
1 answer

PostgreSQL - Delete duplicated records - ERROR: too many range table entries

I have a HyperTable (TimescaleDB extension) called "conferimenti" I am trying to delete about 2500 duplicated rows DELETE FROM conferimenti WHERE id IN (SELECT id FROM (SELECT id, ROW_NUMBER() OVER( PARTITION BY dataora,…
Augusto Murri
  • 183
  • 1
  • 19
2
votes
1 answer

Hypertable v. HBase and BigTable v. SQL

As Hypertable and HBase seem to be the two major open source BigTable implementations, what are the major pros and cons between these two databases? In addition, what are the major pros and cons between BigTable and SQL RDBMSes, and what significant…
Ryan Lester
  • 2,363
  • 7
  • 25
  • 38
2
votes
2 answers

Hadoop Hypercube

Hey, i am starting a hadoop based hypercube with a flexible number of dimensions. Does anybody know any existing approaches for this? I just found PigOLAPSketch, but there is no code to use it. Another approach is Zohmg from lastfm, which uses…
Torben Brodt
  • 117
  • 4
2
votes
4 answers

HBase vs Hyptertable vs Lucene

I am using an search system in lucene. By default it is not distributed, so I am thinking of moving to something like HBase or Hadoop. Do solutions like HBase or Hypertable have a built-in search capability or will I need to implement Lucene on…
mumt
  • 49
  • 2
  • 6
1
2 3 4 5 6