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

Posted to dev@drill.apache.org by "pseudomo (Jira)" <ji...@apache.org> on 2022/02/22 21:39:00 UTC

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

pseudomo created DRILL-8146:
-------------------------------

             Summary: 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
             Fix For: 1.20.0


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)