drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khurram Faraaz (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1937) Throw exception and give error message when Non-scalar sub-query used in an expression
Date Mon, 03 Oct 2016 10:31:20 GMT

    [ https://issues.apache.org/jira/browse/DRILL-1937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15542088#comment-15542088
] 

Khurram Faraaz commented on DRILL-1937:
---------------------------------------

Verified on Drill 1.9.0 ( do we need the reference to JIRA number in the error message ? )

{noformat}
0: jdbc:drill:schema=dfs.tmp> select n_name from dfs.`/drill/testdata/tpch-multi/nation`
where n_nationkey = (select r_regionkey from dfs.`/drill/testdata/tpch-multi/region` where
r_regionkey = 1);
Error: UNSUPPORTED_OPERATION ERROR: Non-scalar sub-query used in an expression
See Apache Drill JIRA: DRILL-1937


[Error Id: 4dfea81d-d9eb-427a-8f0e-4c8dc29ded3e on centos-01.qa.lab:31010] (state=,code=0)
{noformat}

> Throw exception and give error message when Non-scalar sub-query used in an expression
> --------------------------------------------------------------------------------------
>
>                 Key: DRILL-1937
>                 URL: https://issues.apache.org/jira/browse/DRILL-1937
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: SQL Parser
>    Affects Versions: 0.8.0
>            Reporter: Victoria Markman
>            Assignee: Aman Sinha
>             Fix For: 0.8.0
>
>         Attachments: DRILL-1937.1.patch
>
>
> {code}
> #Fri Jan 02 21:20:47 EST 2015
> git.commit.id.abbrev=b491cdb
> {code}
> It is dangerous to have an internal function be exposed to users.
> What if one day user decided to write a UDF with the same signature ?
> {code}
> 0: jdbc:drill:schema=dfs> select SINGLE_VALUE(1) from `t.json`;
> +--+
> |  |
> +--+
> +--+
> No rows selected (0.111 seconds)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message