[DRILL-416] Make Drill work with SELECT without FROM

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.4.0
• Fix Version/s: 1.16.0
• Assignee: Vova Vysotskyi
• Reporter: Chun Chang
• Created: 13/Mar/14 00:58
• Updated: 02/May/19 16:46
• Resolved: 03/Mar/19 13:17

Description

This works with postgres:

[root@qa-node120 ~]# sudo -u postgres psql foodmart
foodmart=# select 1+1.1;
?column?
----------
2.1
(1 row)

But does not work with Drill:

0: jdbc:drill:> select 1+1.1;
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "100f4d4c-1ee1-495e-9c2f-547aae75473d"
endpoint {
address: "qa-node118.qa.lab"
user_port: 31010
control_port: 31011
data_port: 31012
}
error_type: 0
message: "Failure while parsing sql. < SqlParseException:[ Encountered \"<EOF>\" at line 1, column 12.\nWas expecting one of:....