12 lines
286 B
Bash
Executable File
12 lines
286 B
Bash
Executable File
#!/bin/bash
|
|
grep '|' ~/sparkdata/data/logging/log | sed 's/[ \t]*|/|/g' > clean_db
|
|
rm log_db
|
|
sqlite3 log_db <<EOF
|
|
create table log(dt,ts,ss,level,tid,tname,pid,loc,dtype,msg);
|
|
.separator |
|
|
.import clean_db log
|
|
EOF
|
|
sqlite3 log_db "select ts,tname, msg from log order by ts" > log.csv
|
|
|
|
|