11.15.1 Preparatory tasks
Complete the following preparatory tasks.
- Organization of this subsection
(1) Preparing the CSV files
Perform the following:
-
The CSV files need to satisfy any of the following conditions. Confirm that the CSV files satisfy the condition.
-
Uncompressed CSV files
-
CSV files compressed in GZIP format by using the OS's gzip command
-
CSV files that were exported by the adbexport command and compressed in GZIP format
-
-
Confirm that the data format of the CSV files observes the rules. For details about the rules for the data format of CSV files, see Rules for CSV files under Rules under ADB_CSVREAD function in System-defined functions in Constituent Elements in the manual HADB SQL Reference. If the data format of a CSV file is invalid, an error will occur during data retrieval processing.
-
Store the CSV files in the file system of the server machine on which the HADB server is running.
-
Make sure that the absolute path name of a CSV file consists of no more than 510 bytes.
(2) Granting the read privilege for the CSV files and their directory
Grant the following privileges to the HADB administrator so that the HADB server can open the CSV files:
-
Read privilege for the CSV files
-
Read and execute privileges for the directory storing the CSV files