drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-7237) IllegalStateException in aggregation function 'single_value' when there is a varchar datatype in the subquery results
Date Mon, 06 May 2019 16:09:00 GMT

    [ 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:
users@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)

Mime
View raw message