drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matthias Liebig (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (DRILL-4140) csv extractHeader: fails on multiple empty columns
Date Thu, 14 Jan 2016 16:57:39 GMT

     [ https://issues.apache.org/jira/browse/DRILL-4140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Matthias Liebig closed DRILL-4140.
----------------------------------
       Resolution: Fixed
    Fix Version/s: 1.4.0

Fixed in 1.4.0. Probably a duplicate of DRILL-4145 (different error msg, but fix seems to
address the same issue).

> csv extractHeader: fails on multiple empty columns
> --------------------------------------------------
>
>                 Key: DRILL-4140
>                 URL: https://issues.apache.org/jira/browse/DRILL-4140
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - Text & CSV
>    Affects Versions: 1.3.0
>         Environment: Linux (RHEL 7.1)
>            Reporter: Matthias Liebig
>            Priority: Minor
>             Fix For: 1.4.0
>
>
> When the extractHeader feature is enabled and several columns in a row are empty, an
exception occurs.
> {code:title=csv_with_header.csvh|borderStyle=solid}
> name,num1,num2,num3
> hello,1,2,3
> hello,,,
> hello,1,2,3
> hello,1,2,3
> {code}
> {code:java}
> SELECT * FROM dfs.`/tmp/csv_with_header.csvh`;
> java.lang.NegativeArraySizeException
>         at org.apache.drill.exec.vector.VarCharVector$Accessor.get(VarCharVector.java:450)
>         at org.apache.drill.exec.vector.accessor.VarCharAccessor.getBytes(VarCharAccessor.java:125)
>         at org.apache.drill.exec.vector.accessor.VarCharAccessor.getString(VarCharAccessor.java:146)
>         at org.apache.drill.exec.vector.accessor.VarCharAccessor.getObject(VarCharAccessor.java:136)
>         at org.apache.drill.exec.vector.accessor.VarCharAccessor.getObject(VarCharAccessor.java:94)
>         at org.apache.drill.exec.vector.accessor.BoundCheckingAccessor.getObject(BoundCheckingAccessor.java:148)
>         at org.apache.drill.jdbc.impl.TypeConvertingSqlAccessor.getObject(TypeConvertingSqlAccessor.java:795)
>         at org.apache.drill.jdbc.impl.AvaticaDrillSqlAccessor.getObject(AvaticaDrillSqlAccessor.java:179)
>         at net.hydromatic.avatica.AvaticaResultSet.getObject(AvaticaResultSet.java:351)
>         at org.apache.drill.jdbc.impl.DrillResultSetImpl.getObject(DrillResultSetImpl.java:401)
>         at sqlline.Rows$Row.<init>(Rows.java:157)
>         at sqlline.IncrementalRows.hasNext(IncrementalRows.java:63)
>         at sqlline.TableOutputFormat$ResizingRowsProvider.next(TableOutputFormat.java:87)
>         at sqlline.TableOutputFormat.print(TableOutputFormat.java:118)
>         at sqlline.SqlLine.print(SqlLine.java:1593)
>         at sqlline.Commands.execute(Commands.java:852)
>         at sqlline.Commands.sql(Commands.java:751)
>         at sqlline.SqlLine.dispatch(SqlLine.java:746)
>         at sqlline.SqlLine.begin(SqlLine.java:621)
>         at sqlline.SqlLine.start(SqlLine.java:375)
>         at sqlline.SqlLine.main(SqlLine.java:268)
> {code}
> As a workaround an empty column can be added to each line (inluding the header).



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message