Skip to content

Instantly share code, notes, and snippets.

% embulk selfupdate
2016-05-14 22:38:24.502 +0900: Embulk v0.8.8
Checking the latest version...
Found new version 0.8.9.
Downloading https://dl.bintray.com/embulk/maven/embulk-0.8.9.jar ...
OpenSSL::SSL::SSLError: certificate verify failed
connect at org/jruby/ext/openssl/SSLSocket.java:215
block in connect at uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/net/http.rb:927
timeout at org/jruby/ext/timeout/Timeout.java:127
connect at uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/net/http.rb:927
% pgrep -fl xhyve
1828 /Applications/Docker.app/Contents/MacOS/com.docker.osx.xhyve.linux -watchdog fd:0
1829 /Applications/Docker.app/Contents/MacOS/com.docker.osx.xhyve.linux -watchdog fd:0
1835 /Applications/Docker.app/Contents/MacOS/com.docker.osx.xhyve.linux
1837 /Applications/Docker.app/Contents/MacOS/com.docker.xhyve -A -m 2G -c 4 -u -s 0:0,hostbridge -s 31,lpc -s 2:0,virtio-ipc,uuid=44aaef45-e8f5-40af-a79e-b5539ceacbe4,path=/var/tmp/com.docker.slirp.socket,macfile=/Users/yoshikaw/Library/Containers/com.docker.docker/Data/com.docker.driver.amd64-linux/mac.0 -s 3,virtio-blk,file:///Users/yoshikaw/Library/Containers/com.docker.docker/Data/com.docker.driver.amd64-linux/Docker.qcow2,format=qcow -s 4,virtio-9p,path=/var/tmp/com.docker.db.socket,tag=db -s 5,virtio-rnd -s 6,virtio-9p,path=/var/tmp/com.docker.port.socket,tag=port -s 7,virtio-sock,guest_cid=3,path=/var/tmp/com.docker.vsock,guest_forwards=2376;1525 -l com1,autopty=/Users/yoshikaw/Library/Containers/com.docker.docker/Data/com.docker.driver.amd64-
12/12 14:08 root@ol64 <orcl> /root 1516 # lsb_release -a
LSB Version:    :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch
Distributor ID: OracleServer
Description:    Oracle Linux Server release 6.7
Release:        6.7
Codename:       n/a
○クッキーの値
key1=aaa; key2=bbb; key3=ccc
○embulk.yml(抜粋)
- type: column
add_columns:
- {name: cookie_key1: src: cookie}
- {name: cookie_key2: src: cookie}
- {name: cookie_key3: src: cookie}
-- http://krisrice.blogspot.jp/2014/12/sql-developer-41-ea1-is-out.html
select '@|red,bold,underline This is red,bold,underline|@' "@|red Colors|@" from dual
union all
select '@|NEGATIVE_ON This is negative |@' from dual
union all
select '@|INTENSITY_FAINT This is faint |@' from dual
union all
select '@|INTENSITY_BOLD This is my bold |@' from dual
union all
select '@|ITALIC This is italic |@' from dual
# curl -s localhost:9200/accesslog_20151107,accesslog_20151125/_settings | jq
{
"accesslog_20151107": {
"settings": {
"index": {
"creation_date": "1448566370524",
"number_of_shards": "5",
"number_of_replicas": "1",
"uuid": "_c2dVWOcSKa0QpNyAbwsFg",
"version": {
Oracle Linux 7.1
# systemctl status docker-elasticsearch
docker-elasticsearch.service - Elasticsearch
Loaded: loaded (/usr/lib/systemd/system/docker-elasticsearch.service; disabled)
Active: active (running) since 金 2015-11-20 19:30:38 JST; 5 days ago
Docs: https://hub.docker.com/r/library/elasticsearch/
Main PID: 41258 (docker)
CGroup: /system.slice/docker-elasticsearch.service
# embulk preview ./test_access.yml
2015-11-11 13:37:01.020 +0900: Embulk v0.7.8
2015-11-11 13:37:01.844 +0900 [INFO] (preview): Loaded plugin embulk-filter-column (0.3.1)
2015-11-11 13:37:01.860 +0900 [INFO] (preview): Loaded plugin embulk-parser-apache-custom-log (0.3.0)
2015-11-11 13:37:01.871 +0900 [INFO] (preview): Listing local files at directory '.' filtering filename by prefix 'test_access.log'
2015-11-11 13:37:01.875 +0900 [INFO] (preview): Loading files [test_access.log]
2015-11-11 13:37:01.938 +0900 [INFO] (preview): LogFormat : %h %v %u %t "%r" %>s %b "%{Referer}i" "%{User-Agent}i" "%{Cookie}i" "%{Set-cookie}o" %D %{X_VIASSL}i
2015-11-11 13:37:01.938 +0900 [INFO] (preview): RegExp : (.*) ([^\s]*) (.*) \[([^\]]+)\] "(.*)" ([1-9]\d{2}) (-?\d+|-) "(.*)" "(.*)" "(.*)" "(.*)" (-?\d+|-) (.*)
2015-11-11 13:37:01.938 +0900 [INFO] (preview): replacement : 13
+-------------------------+
% ls -l **/*(
Completing glob qualifier
% -- device files
) -- end of qualifiers
* -- executable plain files
+ -- + command name
- -- follow symlinks toggle
. -- plain files
/ -- directories
: -- modifier
% sqlplus -S / as sysdba
set lines 9999
select open_mode from v$database;
OPEN_MODE
------------------------------------------------------------
MOUNTED
select SID, START_TIME,TOTALWORK, sofar, (sofar/totalwork) * 100 done,
sysdate + TIME_REMAINING/3600/24 end_at