Create Log Table
The log data to be input is a file in the following csv format.
Check each field value of log data and create a table. You can create it in machsql using 'CREATE TABLE' syntax.
Alternatively, you can create a table creation script file and run machsql on the OS command line.
Log Data Insert
Since the log data is a csv format file, you can load it using csvimport.
The first field in the log file is the date, which specifies the option to enter this value into the _arrival_time column.
Log Data Retrieval
Check the data in machsql.
Create and View Index
Create a keyword index for the eventlog column of varchar type in the generated sample_table column and search for text.
Time Series Data Retrieval
Machbase provides a convenient syntax for querying time series data. Learn how to query fast data using DURATION.
Internet Address Type Data Retrieval
Machbase provides data types for Internet addresses and can be conveniently searched.