...
...
...
데이터 불러오기
| Code Block | ||
|---|---|---|
| ||
LOAD DATA INFILE 'sample/quickstart/load_sample.csv' INTO TABLE load_sample AUTO HEADUSE;
|
...
입력 데이터 확인
| Code Block |
|---|
SELECT * FROM load_sample; |
...
샘플 예제
샘플 파일을 이용하여, 다음과 같이 실행할 수 있다.
| Code Block |
|---|
[mach@localhost ~]$ cd $MACHBASE_HOME/sample/quickstart
[mach@localhost ~]$ ls -l load_sample.csv
-rw-r
--r--- 1 root root 2827 2017-02-23 15:01 load_sample.csv
[mach@localhost ~]$ machsql
=================================================================
Machbase Client Query Utility
Release Version |
...
x.x. |
...
x. |
...
official Copyright 2014, Machbase Inc. or its subsidiaries. All Rights Reserved ================================================================= Machbase server address (Default:127.0.0.1) : Machbase user ID (Default:SYS) Machbase User Password : MACH_CONNECT_MODE=INET, PORT=5656 Mach> |
...
LOAD DATA INFILE 'sample/quickstart/load_sample.csv' INTO TABLE load_sample AUTO HEADUSE;
50 row(s) loaded. Failed to load 0 row(s).
|
...
Mach> DESC load_sample; ---------------------------------------------------------------- NAME TYPE LENGTH ---------------------------------------------------------------- SENSOR_ID varchar 32767 EPOCH_TIME varchar 32767 E_YEAR varchar 32767 E_MONTH varchar 32767 E_DAY varchar 32767 E_HOUR varchar 32767 E_MINUTE varchar 32767 E_SECOND varchar 32767 VALUE varchar 32767 |
...
Mach> SELECT COUNT(*) FROM load_sample; COUNT(*) ----------------------- 50 [1] row(s) selected. |
...
Mach> |