[ https://issues.apache.org/jira/browse/DRILL-7237?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16833958#comment-16833958 ]
ASF GitHub Bot commented on DRILL-7237: --------------------------------------- vvysotskyi commented on pull request #1782: DRILL-7237: Fix single_value aggregate function for variable length types URL: https://github.com/apache/drill/pull/1782 - Added implementations of single_value for complex data types ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org > IllegalStateException in aggregation function 'single_value' when there is a > varchar datatype in the subquery results > --------------------------------------------------------------------------------------------------------------------- > > Key: DRILL-7237 > URL: https://issues.apache.org/jira/browse/DRILL-7237 > Project: Apache Drill > Issue Type: Bug > Affects Versions: 1.14.0, 1.15.0 > Reporter: Denys Ordynskiy > Assignee: Volodymyr Vysotskyi > Priority: Major > Fix For: 1.17.0 > > Attachments: drillbit.log > > > *Description:* > The following issue can be reproduced on the EBF for the > [DRILL-7050|https://issues.apache.org/jira/browse/DRILL-7050]. > _For the query with > 1 row in subquery results where the data type of these > results *is not varchar*:_ > {noformat} > SELECT > e.full_name, > ( > SELECT > ine.employee_id > FROM > cp.`employee.json` ine > WHERE > ine.position_id = e.position_id > ) as empl_id > FROM > cp.`employee.json` e > LIMIT 20 > {noformat} > _We have the following correct and informative error:_ > {noformat} > Query Failed: An Error Occurred > org.apache.drill.common.exceptions.UserRemoteException: FUNCTION ERROR: Input > for single_value function has more than one row Fragment 0:0 [Error Id: > b770098f-b1c7-4647-9f41-9e986a0e47b7 on maprhost:31010] > {noformat} > _But when in the result set of the subquery we have *a varchar data type*:_ > {noformat} > SELECT > e.full_name, > ( > SELECT > ine.first_name > FROM > cp.`employee.json` ine > WHERE > ine.position_id = e.position_id > ) as empl_id > FROM > cp.`employee.json` e > LIMIT 20 > {noformat} > *Actual result:* > _Drill throws the following error:_ > {noformat} > org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: > IllegalStateException: Workspace variable 'value' in aggregation function > 'single_value' is not allowed to have variable length type. Fragment 0:0 > Please, refer to logs for more information. [Error Id: > 32325ba9-d2b3-4216-acf6-8e80dfe4a56a on maprhost:31010] > {noformat} > Log file is in the attachment "drillbit.log" > *Expected result:* > Drill should return the same informative error to any of a data types in the > subquery result set. -- This message was sent by Atlassian JIRA (v7.6.3#76005)