返回首页

gbase数据、南大通用产品文档:GBase8s

更新日期:2024年09月11日

Date string index out of bounds during date format parsing to build Date object
发生此错误是因为 DBDATE 或 GL_DATE 要求的日期字符串格式与您定义的实际日期字
符串表示形式之间不存在一对一的对应关系。例如,如果将GL_DATE 设置为 %b %D %y,
而指定了字符串 Oct,则 GL_DATE 所需的格式与实际日期字符串之间存在明显的不匹配。

要修复此问题,请修改 DBDATE 或 GL_DATE 设置的日期字符串表示形式,以便指定的日
期格式与所需的日期字符串表示形式一一对应。

High-Performance Scalability
GBase 8a MPP Cluster can expand its computing and storage capacity by adding
server nodes, supporting clusters with hundreds or thousands of nodes, and the
expansion process can be flexibly monitored and managed with features such as
monitoring, pausing, resuming, and canceling. The system supports online
expansion, with linear performance improvement, without interrupting the current
system operation, and supports adding multiple nodes at once. It also supports
flexible expansion at different levels such as instance-level, database-level, and
table-level.

GBase 8a MPP Cluster Technical White Paper
- 16 -
General Data Technology Co., Ltd.
GBase 8a MPP Cluster has high-performance scaling capabilities:
1)
Online dynamic expansion of cluster nodes;
2)
Each node can process 100TB of effective data while providing both
computing and storage capabilities;
3)
Execution
scheduling
nodes
and
data
computing
nodes
can
be
independently scaled as needed.
Figure 3-5. GBase 8a MPP ClusterExpansion Technology Diagram.
The last "Execution and Scheduling Node" and "Data Storage and Computation
Node" in the above figure are newly expanded nodes based on the original nodes.
The scheduling nodes or storage and computation nodes can be expanded. Because
GBase 8a MPP Cluster adopts a high-performance single-node MPP architecture, it
can ensure smooth expansion and linear performance growth during cluster
expansion, as shown in the following figure:

GBase 8a MPP Cluster Technical White Paper
General Data Technology Co., Ltd.
- 17 -
Figure 3-6. GBase 8a MPP Cluster high-performance and high-scalability diagram.

函数说明
返回天数N 对应的DATE 值。
示例
示例1
“734309”对应的DATE 为“2010-06-21”。
gbase> SELECT FROM_DAYS(734309) FROM t;
+-------------------+
| FROM_DAYS(734309) |
+-------------------+
| 2010-06-21 |
+-------------------+
1 row in set