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.