...
| Code Block |
|---|
|
LOAD DATA INFILE 'sample/quickstart/load_sample.csv' INTO TABLE load_sample AUTO HEADUSE;
|
Check input data
| Code Block |
|---|
SELECT * FROM load_sample; |
Using the sample file, you can do the following.
| 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
Load Data
133
[mach@localhost ~]$ machsql
================================================================ = Machbase Client Query Utility Release Version =
Machbase Client Query Utility
Release Version 3.5.0 Copyright 2014, Machbase Inc. or its subsidiaries. All Rights
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).
Elapsed time: 0.344
mach> DESC load_sample;
----------------------------------------------------------------NAME TYPE LENGTH
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
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.
Elapsed time: 0.000
mach> |