Unable to perform sql select on logstash index

Hi @hemanth22,
You just need to escape the index name because - is a reserved character (the minus sign):

GET _xpack/sql?format=txt
{
  "query": "select * \"from logstash-2015.05.18\""
}