[
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)
