[ https://issues.apache.org/jira/browse/DRILL-7732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dave Challis updated DRILL-7732: -------------------------------- Attachment: drill.log > Group by on Parquet field causing: SYSTEM ERROR: CompileException > ----------------------------------------------------------------- > > Key: DRILL-7732 > URL: https://issues.apache.org/jira/browse/DRILL-7732 > Project: Apache Drill > Issue Type: Bug > Affects Versions: 1.17.0 > Environment: AWS Linux instance, 64Gb RAM. > Reporter: Dave Challis > Priority: Major > Attachments: drill.log, portfolio.parquet > > > When executing the following query in Drill (via the web UI): > {noformat} > SELECT P.portfolio_id > FROM dfs.`/data/portfolio.parquet` AS P > GROUP BY P.portfolio_id > {noformat} > the query fails with the following error message: > {noformat} > org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: > CompileException: Line 61, Column 30: "value" is neither a method, a field, > nor a member class of "org.apache.drill.exec.vector.UntypedNullHolder" > Fragment 0:0 Please, refer to logs for more information. > [Error Id: be0b9712-c9c6-4733-9d17-5c370d5dfce0 on e531a6492cf4:31010] > {noformat} > > The schema for the Parquet file in question is: > {noformat} > $ parquet-tool schema portfolio.parquet > message parquet_go_root { > required int32 portfolio_id (UINT_32) = 0; > required binary name (UTF8) = 0; > optional binary meta (UTF8) = 0; > } > {noformat} > The contents of the file is a single row: > {noformat} > $ parquet-tools cat portfolio.parquet > portfolio_id = 0 > name = Bose Corporation > meta = null > {noformat} > I've attached this file to this ticket. -- This message was sent by Atlassian Jira (v8.3.4#803005)