集群上的load data 语法支持多列哈希,语法不变。
示例
建表语句:
create table x0( entry_id int, id2 int, id3 int,id4 int ) distributed by('id3','id4');
数据文件:
# cat x0.tbl
1|2|3|4|
0|0|0|0|
1|1|1|1|
2|2|2|2|
加载过程:
gbase> LOAD DATA INFILE 'sftp://gbase:gbase@192.168.105.66//opt/data/
x0.tbl' INTO TABLE x0 DATA_FORMAT 3 FIELDS TERMINATED BY
'|';
Query OK, 4 rows affected (Elapsed: 00:00:01.11)
Task 4163 finished, Loaded 4 records, Skipped 0 records
查询入库数据:
gbase> select * from x0;
+----------+------+------+------+
| entry_id | id2
| id3
| id4
|
+----------+------+------+------+
|
1 |
2 |
3 |
4 |
|
1 |
2 |
3 |
4 |
|
1 |
2 |
3 |
4 |
|
0 |
0 |
0 |
0 |
|
1 |
1 |
1 |
1 |
|
2 |
2 |
2 |
2 |
+----------+------+------+------+
6 rows in set (Elapsed: 00:00:00.03)
GBase 8a MPP Cluster 产品手册
5 数据库管理指南
文档版本953(2022-09-15)
南大通用数据技术股份有限公司
1216