Fixing "Can't get distribution attribute of table" in GBase 8a
When a gbase database cluster experiences an unclean shutdown — a sudden power loss or kernel panic — some metadata that was still in memory may nev…
Latest News
⚑ Report a ProblemTech news from the best sources
All topics
- игры
AI
Gear
News
Tech
agents
ai
api
architecture
automation
beginners
career
database
devops
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
testing
tutorial
typescript
webdev
GBase 8a 9.5.3 New Feature: Event‑Based Data Node Replacement (eventMode)
Starting from certain builds of GBase 8a 9.5.3, a new event‑driven method for replacing failed data nodes is available. Unlike the traditional redis…
GBase 8a Performance Anomaly Case Study: How a Single Parameter Change Sparked a Chain Reaction
One seemingly innocent parameter adjustment — increasing group_concat_max_len to accommodate a business requirement — caused a cascade of performanc…
GBase 8a Table Design and Modeling: Choosing Data Types, Partitions, Distribution Keys, and Replicated Tables
In a distributed analytical gbase database , many performance issues are baked in at the table design stage. Data types, partitioning, distribution…
GBase 8a Operations in Practice: Load Monitoring, Audit Logs, and Memory Tuning
This guide covers three core areas of daily GBase 8a operations: tracking data loads and collecting error details, configuring audit logs and analys…
What Drags Down Throughput in GBase 8a Bulk Loading — and Where to Look First
When loading large volumes into a gbase database cluster, stability matters far more than a single peak throughput number. The same 500 GB data set…
GBase 8a Security Hardening: Permissions, Password Policies, SSL Encryption, and Audit Logs
This guide provides a complete security hardening checklist for a gbase database cluster, covering user privileges, password policies, SSL encryptio…
GBase 8c Distributed Cluster Operations: Troubleshooting Common Failures with Hands‑On Fixes
Node crashes, connection storms, shard anomalies, and resource overloads are the most frequent disruptions in a gbase database cluster. This guide d…
GBase 8a Data Migration: Standardizing Export, Load, and Verification
When moving data between GBase 8a clusters, stability trumps speed. Failures often stem not from the commands themselves but from inconsistent forma…
GBase 8c Object Dependency Checks Before Schema Changes
The real challenge in a gbase database schema change isn't writing the DDL — it's uncovering every object that depends on the table before you hit “…
GBase 8c DDL Change Risks: Object Dependencies and Troubleshooting
DDL changes in a gbase database often fail not because of syntax errors, but because of hidden object dependencies, long-running transactions, lock…
How NULL Values Skew Comparisons, Aggregations, and Deduplication in GBase 8a
NULL in a gbase database doesn't behave like an ordinary value, nor is it simply a blank. It affects comparisons, deduplication, aggregations, and c…
GBase 8a Slow SQL Diagnosis: 6 Real‑World Cases from Symptom to Fix
Six real slow‑query scenarios with complete trace: data skew, wrong execution plans, oversized intermediate results, and functions that disable part…
Debugging Slow SQL in GBase 8a: How Execution Plans, Distribution Keys, and Parallelism Go Off the Rails Together
A slow query in a gbase database MPP cluster is rarely just a matter of sloppy SQL. More often, it's the combined effect of data distribution, execu…
GBase 8a Backup and Restore Guide: Full and Incremental Backups with gbackup
GBase 8a stores massive analytical datasets across many nodes. If hardware fails, someone drops a table, or an upgrade goes wrong, a solid backup st…
When GBase 8a Execution Plans Go Wrong: Mastering Statistics Management
A simple SQL suddenly triggers a full table scan, or a JOIN order looks completely off. Most of the time, the culprit is stale statistics misleading…
How to Audit Only Critical Operations Like DROP TABLE in GBase 8a
GBase 8a’s audit log can capture virtually every SQL operation. To keep logs lean and focused on security, you can configure a policy that records o…
How GBase 8a Resource Plans Bind to Time Schedules
Resource plans in GBase 8a (e.g., plan_day , plan_night ) are not directly bound to time and do not support cron expressions . Their automated switc…
Why a Failed Rebalance Returns to STARTING Instead of CANCELED in GBase 8a
When a rebalance operation fails on a table that is in RUNNING state, GBase 8a moves the table back to STARTING — not to CANCELED . This behavior re…
Inner vs Outer Joins: The Two Fundamental Join Types in SQL
SQL joins fall into two fundamental categories — inner joins and outer joins — while LEFT , RIGHT , and FULL joins are subclasses of the outer join.…
IFNULL vs NULLIF in GBase 8a: Why They Are Not Interchangeable
Both IFNULL and NULLIF accept two arguments, but they perform opposite operations. Knowing the difference is key to avoiding subtle data errors. Fun…
Get Real Row Counts in GBase 8s Without UPDATE STATISTICS
The nrows column in systables is only updated when you run UPDATE STATISTICS , so it often shows 0 even right after bulk inserts. If you need the re…
Interval Partitioning in GBase 8s: Automatic Extension and Lifecycle Management
Interval partitioning automatically creates new partitions when data exceeds the defined range, eliminating the need to manually add partitions. GBa…
Optimizing GBase 8s JDBC with IFX_AUTOFREE
The JDBC driver for GBase 8s provides IFX_AUTOFREE , a parameter that cuts an extra network round trip when closing statements. If your application…
GBase 8a QUALIFY Clause: Filtering Window Functions the Smart Way
When you use window functions in SQL, you can't filter their results directly in a WHERE or HAVING clause — that's a well‑known limitation across ma…
Expanding a GBase 8a Cluster: Adding a GNode in Practice
As data grows, you'll likely need to add nodes to your existing GBase 8a MPP cluster without downtime. This hands‑on guide walks through the full pr…
GBase 8s: How DELIMIDENT Controls Case Sensitivity
By default, identifiers in GBase 8s are case‑insensitive: uppercase letters are silently treated as lowercase. Setting the environment variable DELI…
End-to-End: Hadoop Deployment and Data Loading into GBase 8a
This post walks through setting up a distributed Hadoop cluster from scratch and loading data from HDFS into GBase 8a, GBASE's China-domestically de…
GBase 8c High Availability with VIP: A Step-by-Step Verification Guide
This walkthrough demonstrates how to deploy a GBase 8c primary‑standby cluster with a virtual IP (VIP) and verify automatic failover. GBase 8c is a…