...
...
...
테이블 생성
| Code Block |
|---|
CREATE TABLE import_sample
(
srcip IPV4,
srcport INTEGER,
dstip IPV4,
dstport INTEGER,
protocol SHORT,
eventlog VARCHAR(1024),
eventcode SHORT,
eventsize LONG
);
|
데이터 불러오기
...
machloader 도구를 이용하여 csv 파일을 입력한다.
| Code Block |
|---|
machloader -i -t import_sample -d sample_data.csv |
입력 데이터 확인
입력 데이터를 확인한다.
| Code Block |
|---|
SELECT COUNT(*) FROM import_sample; |
샘플 예제
아래는, 실제
...
machloader 와 machsql 을 이용한 샘플 예제 과정을 나타낸 것이다.
| Code Block |
|---|
Mach> CREATE TABLE import_sample
(
srcip IPV4,
srcport INTEGER,
dstip IPV4,
dstport INTEGER,
protocol SHORT,
eventlog VARCHAR(1024),
eventcode SHORT,
eventsize LONG
);
Created successfully.
Mach> quit |
...
| Code Block |
|---|
[mach@localhost ~]$ cd $MACHBASE_HOME/sample/quickstart
[mach@localhost ~]$ ls -l sample_data.csv
-rw-r--r--- 1 mach mach 110477124 2017-02-23 15:18 sample_data.csv
[mach@localhost ~]$ machloader -i -t import_sample -d sample_data.csv
-----------------------------------------------------------------
Machbase Data Import/Export Utility.
Release Version |
...
x. |
...
x. |
...
x.official Copyright 2014, Machbase Inc. or its subsidiaries. All Rights Reserved. ----------------------------------------------------------------- NLS : US7ASCII EXECUTE MODE : IMPORT TARGET TABLE : import_sample DATA FILE : sample_data.csv IMPORT_MODE : APPEND FILED TERM : , ROW TERM : \n ENCLOSURE : " ARRIVAL_TIME : FALSE ENCODING : NONE HEADER : FALSE CREATE TABLE : FALSE Progress bar Imported records Error records 1000000 0 Import time : 0 hour 0 min 2.39 sec Load success count : 1000000 Load fail count : 0 [mach@localhost ~]$ |
...
| Code Block |
|---|
Mach> SELECT COUNT(*) FROM import_sample;
COUNT(*)
-----------------------
1000000
[1] row(s) selected.
Mach> |