...
...
...
데이터 불러오기
| 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> |