You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2015/06/05 03:19:38 UTC
[jira] [Updated] (DRILL-3256) Error message can be improved when
query fails due to an invalid position in ORDER BY clause
[ https://issues.apache.org/jira/browse/DRILL-3256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Abhishek Girish updated DRILL-3256:
-----------------------------------
Description:
Error message from Drill:
{code:sql}
> select s_city, s_store_sk, sum(s_number_employees) from store group by s_city, s_store_sk ORDER BY 40 limit 10;
Error: PARSE ERROR: From line 1, column 101 to line 1, column 102: Ordinal out of range
[Error Id: 0458fba1-afd6-48cf-89ba-1e4c107d2426 on abhi8.qa.lab:31010] (state=,code=0)
{code}
Error message from Postgres:
{code:sql}
# select s_city, s_store_sk, avg(s_number_employees) from store group by s_city, s_store_sk order by 5,6 limit 10;
ERROR: ORDER BY position 5 is not in select list
LINE 1: ...) from store group by s_city, s_store_sk order by 5,6 limit ...
^
{code}
was:
Error message from Drill:
{code:sql}
> select s_city, s_store_sk, sum(s_number_employees) from store group by s_city, s_store_sk ORDER BY 40 limit 10;
Error: PARSE ERROR: From line 1, column 101 to line 1, column 102: Ordinal out of range
[Error Id: 0458fba1-afd6-48cf-89ba-1e4c107d2426 on abhi8.qa.lab:31010] (state=,code=0)
{code}
Error message from Postgres:
{code:sql}
# select s_city, s_store_sk, avg(s_number_employees) from store group by s_city, s_store_sk order by 5,6 limit 10;
ERROR: *ORDER BY position 5 is not in select list*
LINE 1: ...) from store group by s_city, s_store_sk order by 5,6 limit ...
^
{code}
> Error message can be improved when query fails due to an invalid position in ORDER BY clause
> --------------------------------------------------------------------------------------------
>
> Key: DRILL-3256
> URL: https://issues.apache.org/jira/browse/DRILL-3256
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Affects Versions: 1.1.0
> Reporter: Abhishek Girish
> Assignee: Jinfeng Ni
> Priority: Minor
>
> Error message from Drill:
> {code:sql}
> > select s_city, s_store_sk, sum(s_number_employees) from store group by s_city, s_store_sk ORDER BY 40 limit 10;
> Error: PARSE ERROR: From line 1, column 101 to line 1, column 102: Ordinal out of range
> [Error Id: 0458fba1-afd6-48cf-89ba-1e4c107d2426 on abhi8.qa.lab:31010] (state=,code=0)
> {code}
> Error message from Postgres:
> {code:sql}
> # select s_city, s_store_sk, avg(s_number_employees) from store group by s_city, s_store_sk order by 5,6 limit 10;
> ERROR: ORDER BY position 5 is not in select list
> LINE 1: ...) from store group by s_city, s_store_sk order by 5,6 limit ...
> ^
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)