You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Chun Chang (JIRA)" <ji...@apache.org> on 2014/05/16 13:03:25 UTC

[jira] [Updated] (DRILL-416) Make Drill work with SELECT without FROM

     [ https://issues.apache.org/jira/browse/DRILL-416?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chun Chang updated DRILL-416:
-----------------------------

    Priority: Blocker  (was: Major)

> Make Drill work with SELECT without FROM
> ----------------------------------------
>
>                 Key: DRILL-416
>                 URL: https://issues.apache.org/jira/browse/DRILL-416
>             Project: Apache Drill
>          Issue Type: Improvement
>    Affects Versions: 1.0.0-rc1
>            Reporter: Chun Chang
>            Priority: Blocker
>
> 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:....



--
This message was sent by Atlassian JIRA
(v6.2#6252)