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
1
vote
1 answer

Timescale: ERROR: tried calling catalog_get when extension isn't loaded

I'm using Timescale and today I faced on a problem: I`m creating a simple table with any of bellow ways: 1- > create table if not exists "NewTable" as (select * from "OldTable"); SELECT 6 2- create table "NewTable" ("eventTime" timestamptz, name…
kian jalali
  • 51
  • 6
1
vote
1 answer

TimeScaleDB - Time bucket query slow with indexes and different variations of chunk size - have i done something wrong?

I've recently been playing around with TimeScaleDB however I am a little confused and need some pointers as to why my query is running slowly or to verify if that is the typical performance of a timescaledb query. The dataset I am using is market…
Lakhvir
  • 31
  • 1
  • 8
1
vote
1 answer

Select statement in Hypertable in Java

I am using hypertable in java program (I know it should be used in C++). I want to use SELECT sql query in java program. But I am unable to select. The Result is coming as null. Please advice whether we can use SQL hypertable statement in Java…
GBS
  • 11
  • 3
1
vote
0 answers

TimescaleDB to handle complex join

I'm using Postgres 11 with timescaleDB in a LINUX machine(16 cores and 32 RAM). I have following 2 tables and only one is the time column. usersTransations (time timestamp without time zone, userId String, locationID string) location (locationID…
AYD
  • 21
  • 3
1
vote
1 answer

How to optimize insert speed to hypertable?

I have a table (Postgresql 9.6) like this CREATE TABLE m_trade ( "alias" Character Varying( 32 ), "ts" Bigint NOT NULL, "side" Character( 1 ), "price" Double Precision, "qty" Bigint ); with 50 000 000 rows. After creating…
Islam Isgandarov
  • 11
  • 6
1
vote
2 answers

suggestion needed for storage system for an crawler

I am planning to write a web crawler in c++ which crawls N number of pages daily. The main problem is that I am getting confusing with storage system . So I need a distributed db which efficient to store my crawled datas. Can anyone suggest me db…
raagavan
  • 951
  • 3
  • 12
  • 16
1
vote
1 answer

c++ hello world program in hypertable

i couldn't find an simple hello world program that inserts data into hypertable database ... and for retrieving too....can any one explain with an simple example??
raagavan
  • 951
  • 3
  • 12
  • 16
1
vote
3 answers

hypertable example in c++

where i can find an sample code for hypertable or else can any one post an sample for hypertable with c++
newb
  • 41
  • 5
1
vote
1 answer

How do you select just the row key in Hypertable's hql?

I have a table in hypertable where the row key is a user id. I wanted to select just the row key itself, but I get parse errors for: select ROW from users where ROW='1000' limit 5; Error: Hypertable::Exception: Table= twitter/users , Column…
edibleEnergy
  • 1,739
  • 1
  • 13
  • 15
1
vote
0 answers

Avoid namenode format to preserve data

I have only one machine running namenode, and datanode. The machine got rebooted. Now the namenode is not coming up due to improper shutdown. the log says that namenode is not formatted. How do I bring it back? I have a lot of data stored in it…
Majoris
  • 2,963
  • 6
  • 47
  • 81
1
vote
1 answer

Hypertable Memory Overflow at startup

I've been testing on Hypertable recently since attracted by its a-priori ability to handle huge amounts of time-series data. My version is 0.9.7.5, and I inserted about one million "rows" that each have about 1000 columns labeled date_time:"date"…
Nicko
  • 13
  • 4
1
vote
2 answers

Cache systems - Hypertable vs Memcached

I want to implement a cache system for our application, we've started integrating with Memcached. Recently I started hearing of Hypertable, and saw some great benchmarks done with that.. However, I couldn't find good comparison between the two. Just…
Aviad Ben Dov
  • 6,351
  • 2
  • 34
  • 45
1
vote
1 answer

How can one connect to remote hypertable in python

I'm trying to connect to a hypertable master machine, hypertable is deployed via mesos, When I copy hypertable.cfg file from master machine to some arbitrary machine, after running start-thriftbroker.sh, all I get is about ten lines of "Waiting for…
Sassan
  • 2,187
  • 2
  • 24
  • 43
1
vote
2 answers

Hypertable database design

Could someone point me to post/pdf/explan here where I can learn more about hypertable database design, I have searched all over google but nothing useful comes up Main problem I have is how do I store data that you "cant" represent as key value.…
Dave
  • 11
  • 3
1
vote
3 answers

C# Library for working with HyperTable

I am searching for a connector/library that will allow me to connect to Hypertable DB. I've installed Hypertable on my windows machine, but I don't know how to connect to it. I'm using ASP.NET 4.5 C# in Visual Studio. I tried this…
Liron Harel
  • 10,819
  • 26
  • 118
  • 217
1 2
3
4 5 6