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

HyperTable - Why we can't use the * in Select Clause?

Ok I have some trouble getting through HyperTable Going through the docs and other stuff I am still not very confident at why I can't use the SELECT * FROM TABLE WHERE.... I am allowed only to do SELECT COL_NAME FROM TABLE WHERE COL_NAME =…
user349026
0
votes
1 answer

Any visualization tools for HyperTable namespaces?

Are there any visualisation tools to hypertable namespaces? Comming from the RDBMS world used to viewing table data and entries, are there any well know tools that can provide a 'table-like' view of keyspaces? GUI based would be great!
user349026
0
votes
1 answer

Questions for the cloud experts - OpenStack Hypertable?

Just trying to wrap my brain around open source cloud. 1) Is OpenStack running on OS like Ubuntu or is Ubuntu running on OpenStack? 2) Running OpenStack - do you get something like Hypertable(BigTable open source)? 3) How is this OpenStack hosted -…
Chris G.
  • 23,930
  • 48
  • 177
  • 302
0
votes
0 answers

create distributed hypertable - could not find hash function for type json

CREATE TABLE conditions ( time TIMESTAMPTZ NOT NULL, temperature DOUBLE PRECISION NULL, humidity DOUBLE PRECISION NULL, log json not null ); Query 1 ERROR: ERROR: could not find hash function for type json Creating a…
김현석
  • 1
0
votes
1 answer

Postgres grouping by range

I have data looking like this What I am trying to achieve is data for historgram that would count values into specific ranges. For category A value range 1-100 and for category B value range 0-125 where value for category C = 5. The problem I have…
Kylo
  • 109
  • 8
0
votes
2 answers

TimeScaleDB continuous aggregate refresh policy end offset is not working as expected

I am new to TimeScaleDB, I have created a continuous aggregate view as CREATE MATERIALIZED VIEW minute_data WITH (timescaledb.continuous) AS SELECT time_bucket('1 min', time_stamp) as bucket, thing_key, avg(pulse_l) as avg_pulse_l, …
Swapnil
  • 15
  • 4
0
votes
2 answers

How do I use AVG() with GROUP BY in time_bucket_gapfill() in TimeScaleDB, PostgreSQL?

I'm using TimescaleDB in my PostgreSQL and I have the following two Tables: windows_log | windows_log_id | timestamp | computer_id | log_count | ------------------------------------------------------------------ | 1 |…
TheStranger
  • 1,387
  • 1
  • 13
  • 35
0
votes
0 answers

Improve query performance by running ANALYZE?

PostgreSQL version: 12.4 TimescaleDB version: 1.7.4 Hi, I have a table in which data is distributed in multiple chunks based on time only i.e. created hypertables for one day. I am trying to improve the performance of SELECT query. To achieve that…
Satish Kumar
  • 63
  • 6
0
votes
1 answer

Custom Indexes on TimeScaleDB Hypertable

I'm using a TimeScaleDB and PostgreSQL to manage timeseries data. When optimizing the table is it recommended to rely purely on TimeScaleDB hypertable or should I also add indexes independently the same way I would do when not using a…
PiotrWolkowski
  • 8,408
  • 6
  • 48
  • 68
0
votes
3 answers

High Performance Database Opinion

I'm developing software using a MySql database and Hibernate to access it. The problem I am having is when I look for 1 keyword I am using 40 000 queries already and the application that I am developing should be able to process multiple keywords.…
Rob Hufschmitt
  • 409
  • 3
  • 12
  • 19
0
votes
2 answers

hypertable library linking problem

i have installed hypertable in /opt/hypertable/current/ and i run an example program from hypertable... #include #include #include #include #include #include…
raagavan
  • 951
  • 3
  • 12
  • 16
0
votes
1 answer

how to build c++ thrift library for hypertable

i am new to hypertable and i need to know how can i build an c++ client library to integrate hypertable in my cpp program
bbroy
  • 1
0
votes
2 answers

How to connect Drupal 7 with Hypertable?

According to http://drupal.org/node/443540: Field storage modules could be written to store field data in a variety of ways including HyperTable, Amazon S3 or CouchDB but I have no idea how to do
nasgor jancuk
  • 11
  • 3
0
votes
1 answer

Hypertable Query Language

I am trying to play around with Hypertable on my windows pc's command prompt. I am able to create a table and insert the values CREATE TABLE fruits (color, energy, vitamins); INSERT INTO fruits VALUES ("apple", "color", "red"), ("apple", "energy",…
LSY.E
  • 5
  • 7
0
votes
0 answers

Error with example in Hypertable

i have a code in Java languaje and I'm using a example of Hypertable but i have a error. The code is: import java.util.List; import java.util.ArrayList; import java.util.Map; import java.util.HashMap; import org.hypertable.thrift.*; import…
ZedGe
  • 1
  • 1
1 2 3
4
5 6