You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "James Turton (Jira)" <ji...@apache.org> on 2022/02/25 12:49:00 UTC

[jira] [Updated] (DRILL-8146) SAS reader fails to read the majority of sas files

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

James Turton updated DRILL-8146:
--------------------------------
    Fix Version/s:     (was: 1.20.0)

> SAS reader fails to read the majority of sas files
> --------------------------------------------------
>
>                 Key: DRILL-8146
>                 URL: https://issues.apache.org/jira/browse/DRILL-8146
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - Text &amp; CSV
>            Reporter: pseudomo
>            Priority: Major
>              Labels: pull-request-available
>
> SAS reader fails to read the majority of real world sas files.
> The reader throws NPEs if:
>  * SAS file has 0 rows
>  * Date column value is null
>  * The type of value is Number
>  * Long and Double are mixed together in one column (for some reason if the fractional part of any number is zero, it will be converted to Long by parso library)
> Schema inference issue:
>  * Any Date values converted to LocalDate but actually SAS supports DateTime (timestamps). The problem is that time will be dropped
>  



--
This message was sent by Atlassian Jira
(v8.20.1#820001)