forked from embulk/embulk-filter-column
-
Notifications
You must be signed in to change notification settings - Fork 0
/
add_columns.yml
30 lines (30 loc) · 953 Bytes
/
add_columns.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
in:
type: file
path_prefix: example/example.csv
parser:
type: csv
charset: UTF-8
newline: CRLF
null_string: 'NULL'
skip_header_lines: 1
comment_line_marker: '#'
columns:
- {name: time, type: timestamp, format: "%Y-%m-%d"}
- {name: id, type: long}
- {name: name, type: string}
- {name: score, type: double}
- {name: json, type: json}
filters:
- type: column
default_timezone: "Asia/Tokyo"
default_timestamp_format: "%Y-%m-%d"
add_columns:
- {name: foo, type: long, default: 1}
- {name: d, type: timestamp, default: "2015-07-13"}
- {name: t, type: timestamp, default: "2015-07-13 00:00:00", timezone: "UTC", format: "%Y-%m-%d %H:%M:%S"}
- {name: copy_score, src: score}
- {name: $.json.bar, type: long, default: 1}
- {name: $.json.d, type: string, default: "2015-07-13"}
- {name: $.json.copy_foo, src: $.json.foo}
out:
type: stdout