gbase数据、南大通用产品文档：GBase8c语法

python3 pssh [OPTIONS]

函数说明
返回time 对应的秒数，范围为0～59。
示例
示例1：返回“10:05:03”对应的秒数。
gbase> SELECT SECOND('10:05:03') FROM dual;
+--------------------+
| SECOND('10:05:03') |
+--------------------+
|
3 |
+--------------------+
1 row in set

Data Loading
In GBase 8a MPP Cluster, the cluster loading function is directly integrated within
the GBase 8a MPP Cluster and does not require additional external loading tools.
The data loading has the following characteristics and advantages:
1）Highly integrated with the cluster;
2）The SQL interface is more in line with users' usage habits;
3）Supports parallel loading of a single table from multiple data sources and
supports multiple loading machines for parallel loading of a single table,
maximizing loading performance;
4）Supports pulling data from general data servers and supports multiple file
transfer protocols such as ftp/sftp/hdfs/Kafka/http/https;
5）Supports multiple data file formats, such as plain text, gzip compression,
snappy compression, and lzo compression;
6）Supports loading of plain text, fixed-length text, and loose mode;
7）Supports user-defined column separators, row separators, and date/time
formats;
8）Supports error data tracing, which can accurately locate the position of
erroneous data in the source file;
9）The loading performance can continue to improve with the expansion of the
cluster scale.

GBase 8a MPP Cluster Technical White Paper
- 22 -
General Data Technology Co., Ltd.