Hi,
I Import a .csv file through logstash and want to display it using kibana .
Kibana version 4.5.4
My kibana source file is look like below
message:
2017-02-24,15:30:02,101k/min,101k/min,100k/min,67k/min,67k/min,67k/min
@version:
1
@timestamp:
February 25th 2017, 19:01:22.826
path:
/root/Sheet.csv
host:
xxx.xxx.com
Date:
February 24th 2017, 05:30:00.000
Time:
15:30:02
1 min Msg /sec US-East:
101k/min
1 min Msg /sec US-West:
101k/min
15 min Msg /sec US-East:
100k/min
15 min Msg /sec US-West:
67k/min
5 min Msg /sec US-East:
67k/min
5 min Msg /sec US-West:
67k/min
_id:
AVp1eAH5GQ13ZJHOkAwW
_type:
logs
_index:
testdata
_score:
1
message:
2017-02-25,00:30:01,101k/min,101k/min,102k/min,48k/min,48k/min,49k/min
@version:
1
@timestamp:
February 25th 2017, 19:01:22.829
path:
/root/Sheet.csv
host:
xxxx.xxx.com
Date:
February 25th 2017, 05:30:00.000
Time:
00:30:01
1 min Msg /sec US-East:
101k/min
1 min Msg /sec US-West:
101k/min
15 min Msg /sec US-East:
102k/min
15 min Msg /sec US-West:
48k/min
5 min Msg /sec US-East:
48k/min
5 min Msg /sec US-West:
49k/min
_id:
AVp1eAH5GQ13ZJHOkAwf
_type:
logs
_index:
testdata
_score:
1
I am facing problem When I try to visualize my data ,I don't want count or sum ,I want to display data in y axis 1 min Msg /sec US-East and in x axis date or timestamp . But in y-axis there no such field are coming to display data as it's in csv .
Below is mine logstash conf. file for visualize csv file .
input {
file {
path => "/root/Sheet.csv"
type => "csv"
start_position => "beginning"
}
}
filter {
csv {
separator => ","
columns => ["Date","Time","1 min Msg /sec US-East","5 min Msg /sec US-East","15 min Msg /sec US-East","1 min Msg /sec US-West","5 min Msg /sec US-West","15 min Msg /sec US-West"]
}
}
output {
elasticsearch {
action => "index"
hosts => "localhost:9200"
index => "testdata"
workers => 1
}
stdout {}
}
