README.md in fluent-plugin-sql-2.2.0 vs README.md in fluent-plugin-sql-2.3.0
- old
+ new
@@ -42,10 +42,11 @@
<source>
@type sql
host rdb_host
+ port rdb_port
database rdb_database
adapter mysql2_or_postgresql_or_etc
username myusername
password mypassword
@@ -66,10 +67,11 @@
<table>
table table2
tag table2 # optional
update_column updated_at
time_column updated_at # optional
+ time_format %Y-%m-%d %H:%M:%S.%6N # optional
</table>
# detects all tables instead of <table> sections
#all_tables
</source>
@@ -91,9 +93,10 @@
* **tag** tag name of events (optional; default value is table name)
* **table** RDBM table name
* **update_column**: see above description
* **time_column** (optional): if this option is set, this plugin uses this column's value as the the event's time. Otherwise it uses current time.
* **primary_key** (optional): if you want to get data from the table which doesn't have primary key like PostgreSQL's View, set this parameter.
+* **time_format** (optional): if you want to specify the format of the date used in the query, useful when using alternative adapters which have restrictions on format
## Input: Limitation
You should make sure target tables have index (and/or partitions) on the *update\_column*. Otherwise SELECT causes full table scan and serious performance problem.