[
https://issues.apache.org/jira/browse/DRILL-1937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14317458#comment-14317458
]
Aman Sinha commented on DRILL-1937:
-----------------------------------
Since you will throw an error even if the subquery returns 1 value (e.g with
LIMIT 1), it is better to say: "Non-scalar subquery used in an expression."
Also, the unit tests should test for the derived unsupported exceptions.
> Disable internal function SINGLE_VALUE()
> -----------------------------------------
>
> 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, DRILL-1937.2.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)
