You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Rakesh (JIRA)" <ji...@apache.org> on 2017/05/01 19:19:04 UTC
[jira] [Comment Edited] (DRILL-5454) REPEATED_COUNT throws error
when used in where clause
[ https://issues.apache.org/jira/browse/DRILL-5454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15991332#comment-15991332 ]
Rakesh edited comment on DRILL-5454 at 5/1/17 7:18 PM:
-------------------------------------------------------
Yes, it's string type for all elements (For the one use case I have) (i.e. when the element is created it is of the form ("x1", "x2", ...). I have also edited my JIRA with a note to explain the same.
was (Author: rakeshmalpani):
Yes, it's string type for all elements (For the one use case I have) (i.e. when the element is created it is of the form ("x1", "x2", ...)
> REPEATED_COUNT throws error when used in where clause
> -----------------------------------------------------
>
> Key: DRILL-5454
> URL: https://issues.apache.org/jira/browse/DRILL-5454
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Rakesh
>
> I have a parquet file with an array column, when I use the function 'REPEATED_COUNT' in select column it works fine, but when used in where clause I get an error:
> org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: SchemaChangeException: Failure while trying to materialize incoming schema. Errors: Error in expression at index 2. Error: Missing function implementation: [repeated_count(INT-OPTIONAL)]. Full expression: null.. Fragment 1:4 [Error Id: 1a9b034c-949a-4faa-9185-55d40e4851e7 on uswxapcsd043.ussdnve.baml.com:31010] (org.apache.drill.exec.exception.SchemaChangeException) Failure while trying to materialize incoming schema. Errors: Error in expression at index 2. Error: Missing function implementation: [repeated_count(INT-OPTIONAL)]. Full expression: null..
> Note: The query is reading data from a parquet file. This file was generated using a CTAS expression from a CSV file, and the array column was generated using CONVERT_FROM(colName, 'JSON'). The column has the string in the correct format (["x1", "x2"]). Also the count comes out correct when I use the REPEATED_COUNT(arrayCol) in select column, it's just failing in the where clause
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)