All
Articles 173,163Blog Posts 163,816Tech Tutorials 46,199Research Papers 33,857News 21,839
⚡ AI Lessons
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Loading JSON Data Files in GBase 8a
Starting from version 9.5.3.28, GBase 8a supports loading JSON files directly into tables. By...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
GBase 8a initcap: Capitalizing the First Letter of Every Word
The initcap function in GBase 8a capitalizes the first letter of each word in a string and converts...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Exporting Fixed‑Length Data Files in GBase 8a
Fixed‑length (or "positional") exports eliminate the need for field delimiters, which is especially...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
GBase 8a Pivot: Turning Rows into Columns
GBase 8a provides the pivot function for data pivoting — converting multiple rows into columns. This...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
GBase 8a unpivot Function: Turning Columns into Rows
unpivot is the counterpart of the pivot function in GBase 8a. It transforms multiple columns into...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Using LAST_VALUE in GBase 8a for OLAP Analysis
LAST_VALUE is a window function in GBase 8a that returns the last value in an ordered window,...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Using FIRST_VALUE in GBase 8a for OLAP Analysis
FIRST_VALUE is a window function in GBase 8a that returns the first value in an ordered window. It...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Configuring HDFS as Storage for GCDW Physical Deployment
The latest GCDW (GBase Cloud Data Warehouse) supports HDFS as its underlying storage layer,...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
GBase 8a Percentile Functions: percentile_cont and percentile_disc
GBase 8a supports two percentile functions — percentile_cont (continuous, with linear interpolation)...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Loading Data with Different Date Formats in GBase 8a — Per‑Column Control
When importing data into GBase 8a, you often encounter CSV files where different date columns follow...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
Database Industry Trends and Technical Observations
Database Industry Trends and Technical Observations Overview In a recent GBASE...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
1mo ago
How GBase 8a Handles Masked Columns in WHERE, GROUP BY, and Projections
GBase 8a supports data masking to protect sensitive information. But when a masked column appears in...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
Deep Dive into GBase 8a MPP Distributed Query Execution
How does a SQL statement travel through a GBase 8a cluster — from parsing and plan generation to...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
2mo ago
GBase 8a Data Skew Detection and Optimization in Practice
In a gbase database cluster, many slow queries are not caused by poorly written SQL, but by...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
GBase 8a Large Table Join Optimization: From Execution Path to Practical Tuning
In a gbase database, large table joins often become the performance bottleneck in reporting,...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
GBase 8a OLAP Window Functions in Practice: Ranking, Running Totals, MoM, and Ratio Analysis
GBase 8a fully supports OLAP window functions, making it a powerful gbase database for analytical...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
GBase 8c Audit and Log Governance: Don't Wait Until Disks Are Full
The logging, slow SQL tracking, and auditing features of GBase 8c can backfire when not managed...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
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...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
GBase 8a Resource Management in Practice: From Workload Grouping to Concurrency Control
Performance jitter in a gbase database MPP cluster often isn't caused by a single slow SQL statement....
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
2mo ago
How Character Sets, Collations, and String Comparisons Cause Subtle Data Drift in GBase 8a
Many "the results look wrong" problems in a gbase database don't come from incorrect imports or bad...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3mo ago
How GBase 8a Rough Index Works: Block‑Level Pruning for 10x Faster Queries
The Rough Index is a lightweight, built‑in indexing mechanism of GBase 8a's columnar storage engine....
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3mo ago
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...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3mo ago
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...
Dev.to · Michael
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3mo ago
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...
DeepCamp AI