SAP HANA 导入导出(SAP HANA Export & Import)

SAP HANA 导入导出(SAP HANA Export & Import)

导入(Import):从平面文件中导入数据

Import语法：

IMPORT FROM [<file_type>] <file_path> [INTO <table_name>] [WITH <import_from_option_list>]

<file_type> ::= CSV FILE | CONTROL FILE

<file_path> ::= '<character>...'

<table_name> ::= [<schema_name>.]<identifier>

<import_from_option_list> ::= <import_from_option> | <import_from_option_list> <import_from_option>

<import_from_option> :: = THREADS <number_of_threads> | BATCH <number_of_records_of_each_commit> | TABLE LOCK | NO TYPE CHECK | SKIP FIRST <number_of_rows_to_skip> ROW | COLUMN LIST IN FIRST ROW | COLUMN LIST ( <column_name_list> ) | RECORD DELIMITED BY '<string_for_record_delimiter>' | FIELD DELIMITED BY '<string_for_field_delimiter>' | OPTIONALLY ENCLOSED BY '<character_for_optional_enclosure>' | DATE FORMAT '<string_for_date_format>' | TIME FORMAT '<string_for_time_format>' | TIMESTAMP FORMAT '<string_for_timestamp_format>' |

第一步：创建测试表area

create column table area (  id varchar(3) primary key,area varchar(20) );

select * from system.ftp_server

IMPORT FROM '/dropbox/Blag/Area.ctl';

Area.ctl 文件内容：

import data into table P1526659201.area 
 from 'Area.csv'
 record delimited by '\n' 
 fields delimited by ','
 optionally enclosed by '"'
 error log 'Area.err'