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
2
votes
1 answer

Is it possible to save results of a Hypertable shell query into a file?

I need some data out of my hypertable. I can inspect the data with the hypertable shell and was curios whether it is possible to pipe the result of a HQL query into a file. This would be useful for further investigations when the result set is large…
Matthias Kricke
  • 4,931
  • 4
  • 29
  • 43
2
votes
4 answers

Adding a time dimension to MySQL cells

Is there a way to keep a timestamped record of every change to every column of every row in a MySQL table? This way I would never lose any data and keep a history of the transitions. Row deletion could be just setting a "deleted" column to true, but…
agentofuser
  • 8,987
  • 11
  • 54
  • 85
2
votes
2 answers

Which nosql solution fits my application HBase OR Hypertable OR Cassandra

I have an application with 100 million of data and growing. I want to scale out before it hits the wall. I have been reading stuff about nosql technologies which can handle Big Data efficiently. My needs: There are more reads than writes.But writes…
Rahul
  • 1,403
  • 4
  • 18
  • 31
1
vote
1 answer

hypertable column name in where clause

I have application with 2 columns viz. city, category. I want to fit this in hypertable. There is also id which I would like to add as ROW. create table ads (city, category); insert into ads values ("1", "city:mumbai", "1"); insert into ads values…
Rahul
  • 1,403
  • 4
  • 18
  • 31
1
vote
1 answer

enable compression in TimeScaleDB hypertable - invalid column name

When I try and enable compression on my TimeScale DB hypertable using this query: ALTER TABLE public."Session" SET ( timescaledb.compress, timescaledb.compress_segmentby = 'AssetId' ); I get the following error: ERROR: column "assetid" does…
jim
  • 8,670
  • 15
  • 78
  • 149
1
vote
1 answer

Hypertable migration causing problem with rails 2.3.8

I am using Hypertable db with the front end of HyperRecord. There were some bugs that i fixed in it. But now migrations get stuck me. When ever i do migrate it shows the error: rake aborted! undefined method `select_rows' for…
Nazar Hussain
  • 5,102
  • 6
  • 40
  • 67
1
vote
1 answer

Unable to create distributed hypertable on Multi-node TimescaleDB setup

I am trying to create a distributed hypertable on a multi-node setup of timescaledb. I can easily create the table and then convert it to a distributed hypertable using the "create_distributed_hypertable" command. This works on the "public" schema…
diehamburg
  • 11
  • 1
1
vote
1 answer

How to increase performance of TimescaleDB?

I have installed Postgresql 12 with TimescaleDB. I have two tables in database Sensor_Data Sensor_Data_TS (Timescale Hypertable). Both the tables have same columns, same data and indexing is done on sensor_id and time in both the tables. Now when…
Hitanshu
  • 11
  • 3
1
vote
1 answer

TimescaleDB time_bucket() function giving unexpected results for arbitrary time interval

I have created a hypertable water_meter to store the sensor data It contains following data ordered by timestamp in ascending order select * from water_meter order by time_stamp; As can be seen I have data starting from 01 May 2020 if I use…
Swapnil
  • 15
  • 4
1
vote
2 answers

Is it possible to select one column based on another column without using subquery in SQL?

I'm working in a TimescaleDB in PostgreSQL. I have the following table: | id | timestamp | ---------------------------- | 1 | 2021-07-12 01:04:58 | | 2 | 2021-07-12 02:12:03 | | 3 | 2021-07-12 04:44:11 | | 4 | 2021-07-12 05:08:31…
TheStranger
  • 1,387
  • 1
  • 13
  • 35
1
vote
2 answers

Permission denied while accessing Hypertable in CGI program

I'm trying to develop a Web app in Perl using Hypertable. Sample code: #!/usr/bin/perl -w use strict; use warnings; use CGI; use CGI::Carp qw/fatalsToBrowser warningsToBrowser/; use CGI::Session ('-ip_match'); use Hypertable::ThriftClient; use…
one man army
  • 11
  • 3
1
vote
1 answer

Timescale db - multiple hyper tables on single Postgres Table

Can anyone help me with creating multiple timescale hyper tables on single Postgres table. I have a table with one value and 3 timestamp columns. I would like to create hyper table with every timestamp column.
Chandra Challagonda
  • 11
  • 2
1
vote
1 answer

Fastest nosql option for number crunching?

I had always thought that Mongo had excellent performance with it's mapreduce functionality, but am now reading that it is a slow implementation of it. So if I had to pick an alternative to benchmark against, what should it be? My software will be…
Jeremy Smith
  • 14,727
  • 19
  • 67
  • 114
1
vote
1 answer

Will i get benefits of hyper table if I have a query in which I join a hyper table with a normal (non-hyper) table in timescaledb

I have to fetch record from two tables, there is one table is hyper table another table is normal table. Hyper table primary key (a UUID, not a timestampz column) is used as foreign key in 2nd normal table. The hyper table has one to many…
Sanjeev Jha
  • 37
  • 5
1
vote
1 answer

Google Go datastore interfaces

What are your thoughts on go-pgsql and thrift4go? I'd like to use Go with either Postgres or Hypertable for a project, but I'm curious as to how mature and complete these interfaces are.
Ryan Lester
  • 2,363
  • 7
  • 25
  • 38
1
2
3 4 5 6