Skip to content

Lao Zizhu's home

Domestic GBase Database Usage Experience

  • Homepage
  • Core Index
  • Drive
  • Self-check for faults

Day: January 12, 2021

南大通用GBase 8a V95版本支持多列Hash的最大列数量

Posted on 2021年1月12日2022年9月9日 by laozizhu

南大通用GBase 8a数据库集群,从V95版本开始,支持多列hash,用于改善数据倾斜问题。理论上其最大数量和列数量相同的2000个,但由于源数据表table_distribution里hash_column列最大长度是4096,实际列数会小于理论值。

南大通用GBase 8a 模糊查询和正则函数regexp_replace、regexp_like

Posted on 2021年1月12日2023年2月15日 by laozizhu

本文介绍在GBase 8a数据库集群里,和正则有关的功能和函数,包括like、REGEXP、RLIKE关键字,以及regexp_like、regexp_replace、regexp_instr、regexp_substr等函数。

南大通用GBase 8a V9版本虚拟集群(Virtual Cluster 简称VC)安装、创建和使用

Posted on 2021年1月12日2023年12月6日 by laozizhu

本文介绍GBase 8a数据库集群V95版本,虚拟集群(Virtual Cluster 简称VC)的安装,创建和使用。

南大通用GBase 8a V9通过tpc-ds测试

Posted on 2021年1月12日 by laozizhu

南大通用GBase 8a V9,在2020年12月23日,通过tpc-ds测试。采用的H3C UniServer R4900 G3服务器。

南大通用GBase 8a截取字符串函数substr、substring、MID介绍和样例

Posted on 2021年1月12日2021年7月15日 by laozizhu

本文介绍GBase 8a数据库集群里,用于截取字符串的函数substr,substring、MID的语法和样例,同时也对相关的函数做介绍,以便实现截取指定位置,指定长度的字符串。

Skip to footer
January 2021
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Dec   Feb »

Tags

Event FoundationDB GBase8c GCDW Cloud Data Warehouse gcware gdom ipv6 JDBC kafka Kerberos Linux ODBC Online Analytical Processing performance_schema Python SSL TiDB User-Defined Function V95 Product Information Metadata Full-text index Memory Function Partition Loading Upgrade Multi-instance Stored procedure Learning Log Safety Install Container Password Export Expand Log Date Port Node Replacement Tuning Timeout Operations and maintenance monitoring 锁 Interview questions

Categories

  • GBase8a Operations Case Study Analysis
  • GBase News
  • GBase8a for Everyday Use
  • GBase8a Configuration Parameters
  • GBase8a Development Interface
  • GBase8a Common Questions
  • GBase8a Error Handling
  • Odds and ends
  • Other databases
  • ClickHouse

Archives

  • June 2026
  • May 2026
  • March 2026
  • February 2026
  • January 2026
  • June 2025
  • April 2025
  • March 2025
  • February 2025
  • January 2025
  • December 2024
  • November 2024
  • October 2024
  • September 2024
  • June 2024
  • May 2024
  • March 2024
  • February 2024
  • January 2024
  • December 2023
  • November 2023
  • October 2023
  • September 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020

Friendship link

Nanda Generational Official Website
GBase 8a Official Community
Lao Zizhu's Column (CSDN)
GBase 8s Development and Management

Tianjin ICP prepared No. 17003092
Tianjin Public Network Security Preparation No. 12010202000888

Site Map

Back to Top

Proudly powered by WordPress | Theme: Yocto by Humble Themes.
English
Chinese