...
| 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 3.5.0
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
----------------------------------------------------------------
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> |