This topic describes some common scenarios that OBLOADER supports and provides the corresponding use cases.
The following table provides information about the database used in the examples.
Database information |
Example value |
|---|---|
| Cluster name | Cluster A |
| OBProxy IP address | xx.x.x.x |
| OBProxy port number | 2883 |
| Tenant name | TenantA |
| Password of a user (with at least the real-only privilege) under the sys tenant | **1*** (the password of the **u*** user in this example) |
| User account (with read/write privileges) under a business tenant | **u*** |
| Password of the user under the business tenant | **1*** |
| Schema name | USERA |
Import schema structures
Scenario description : Import all the schema information from /home/admin/LOAD-1/ to the USERA schema.
Example statement :
[admin@localhost]> ./obloader -h xx.x.x.x -P 2883 -u **u*** -p **1*** --sys-password **1*** -c ClusterA -t tenantA -D USERA --ddl --all -f /Users/admin/LOAD-1/
Import CSV data files
Scenario description : Import all the CSV data files in /home/admin/LOAD-1/ to the USERA schema.
Example statement :
[admin@localhost]> ./obloader -h xx.x.x.x -P 2883 -u **u*** -p **1*** --sys-password **1*** -c ClusterA -t tenantA -D USERA --csv --all -f /Users/admin/LOAD-1/
Import SQL data files
Scenario description : Import all the SQL data files in /home/admin/LOAD-1/ to the USERA schema.
Example statement :
[admin@localhost]> ./obloader -h xx.x.x.x -P 2883 -u **u*** -p **1*** --sys-password **1*** -c ClusterA -t tenantA -D USERA --sql --all -f /Users/admin/LOAD-1/
Full import of structures and data in limited mode
Scenario description : Import all the structures and data in /home/admin/LOAD-1/ to the USERA schema in the limited mode.
Example statement :
[admin@localhost]> ./obloader -h xx.x.x.x -P 2883 -u **u*** -p **1*** -c ClusterA -t tenantA -D USERA --ddl --sql --public-cloud --all -f /Users/admin/LOAD-1/
Import POS data files
Scenario description : Import all the data files in /home/admin to the test table in the test database. Use the control files in /home/admin to process the data and use the vertical bar (|) as the column splitter.
Example statement :
[admin@localhost]>./obloader -h xx.x.x.x -P 2881 -u test -t mysql -c xx -p **1*** -D test --table 'test' -f /home/admin --pos --column-splitter '|' --ctl-path '/home/admin'
The following example shows the rule defined in a control file:
lang=java
(
c1 position(1:5) "trim(c1)",
c2 position(7:25) "replace(trim(c2),'',' ')"
);
Import CUT data files
Scenario description : Import all the data files in /home/admin to the test table in the test database. Use the control file in /home/admin to process the data and use the string '|@|' as the column splitter.
Example statement :
[admin@localhost]>./obloader -h xx.x.x.x -P 2881 -u test -t mysql -c xx -p **1*** -D test --table 'test' -f /home/admin --cut --column-splitter '|@|' --ctl-path '/home/admin'
The following example shows the rule defined in a control file:
lang=java
(
c1 "trim(c1)",
c2 "replace(trim(c2),'',' ')"
);