Tech news from the best sources
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, executi…
GBase 8a stores massive analytical datasets across many nodes. If hardware fails, someone drops a table, or an upgrade goes wrong, a solid backup stra…
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 t…
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 onl…
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 switchi…
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 reve…
SQL joins fall into two fundamental categories — inner joins and outer joins — while LEFT , RIGHT , and FULL joins are subclasses of the outer join. T…
Both IFNULL and NULLIF accept two arguments, but they perform opposite operations. Knowing the difference is key to avoiding subtle data errors. Funct…
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 real…
Interval partitioning automatically creates new partitions when data exceeds the defined range, eliminating the need to manually add partitions. GBase…
The JDBC driver for GBase 8s provides IFX_AUTOFREE , a parameter that cuts an extra network round trip when closing statements. If your application ex…
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 many…
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 proc…
By default, identifiers in GBase 8s are case‑insensitive: uppercase letters are silently treated as lowercase. Setting the environment variable DELIMI…
This post walks through setting up a distributed Hadoop cluster from scratch and loading data from HDFS into GBase 8a, GBASE's China-domestically deve…
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 Ch…