Skip to content

1.3.5 no longer accepts newline as space? #80

@daledude

Description

@daledude

We just upgraded to 1.3.5 from 1.2 (i think). We have queries with \n in them that used to work but now fail with:

SQLFeatureNotSupportedException[Unsupported query

Using the web interface to test it seems that I must have a space before the \n (doesn't work after) but only up until after the FROM clause. The query I used to test is below. There is a space before the new line on the SELECT and FROM lines but every line after does not have a space at the end and the query succeeds. Take away the space at the end of any of the SELECT and FROM lines will produce the error. Use mouse to highlight the query and you will see the spaces at the end of the lines.

SELECT 
MAX(statPorts) as maxPorts, MIN(statPorts) as minPorts, AVG(statPorts) as avgPorts, MAX(statCPS) as maxCps, MIN(statCPS) as minCps, AVG(statCPS) as avgCps
FROM data-2015.08.22 
where
datadate between '2015-08-22 00:00:00-0000' and '2015-08-22 23:59:59-0000'
and portNum in (8493)
GROUP BY date_histogram(field='datadate','interval'='hour')

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions