Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [bigtable]

Bigtable is a wide-column NoSQL data storage system designed and built by Google.

0
votes
0answers
42 views

How to get hit (number of possible results of a query) from a table with more than 100 million records in Postgres

We have a table X in postgres v11, where it has 5 columns like A B C D E. We all columns are indexed and there are all integer values. We have around, 100 milion records, but soon will turn into 800 ...
0
votes
0answers
13 views

How can I complete a full export and import of Google BigTable

!/bin/bash BigTable_ExportTest.sh Edited original source script with new bucket and jar file. This script will backup BigTable Data Table by table and store it into a destination location as ...
0
votes
0answers
33 views

add index and change int data type to bigint in mysql 5.7 with 1.3 billion records the fastest way

how do i do this without downtime? or at least minimal downtime (3hrs max) Is there any way to tweak my.cnf config to at least make this process of indexing and change data type faster? Below is the ...
0
votes
1answer
362 views

Validate data between two large tables

I have this scenario. Data files are transferred from multiple stores (transactions) to the head office as they happen. For each store the table in question is pretty big in size. At the head office, ...
3
votes
1answer
335 views

Replacing an aggregation system of statistics

We currently have a database under MySQL, storing aggregated statistics in different tables (recent hours, hours, days, months). The tables are updated by workers running at different rates depending ...
10
votes
1answer
2k views

Why can't we perform joins in a distributed database like Bigtable?

From this answer to "What database does Google use?": Bigtable is not a relational database. It does not support joins nor does it support rich SQL-like queries. Is this obvious? I do not ...
12
votes
1answer
259 views

What are the performance implications of polymodels versus normal BigTable models in google app engine?

What produces the best performance in regular google app engine use, a polymodel or a normal "BigTable" model? The polymodel, effectively, creates a column in the parent table called "class" which ...