cgivre commented on issue #2466: URL: https://github.com/apache/drill/issues/2466#issuecomment-1043746876
@pseudomo I'm going to fix this, but we're in the middle of a release cycle right now and I'm not sure if we can get it into the next release. If we can't get it into Drill 1.20, we'll do a 1.20.1 in the next few months with a bunch of other bug fixes. However there may be a slightly ugly workaround which would at least let you read the data. If you provide the schema, Drill should be able to read the file. You can do this either with a `CREATE SCHEMA` query, or by providing the schema inline. [1] That can be done as follows: ```sql SELECT * FROM table(dfs.tmp.`somefile.sas7dat`( schema => 'inline=(col1 int, col2 varchar, col3 float8) )) ``` [1]: https://drill.apache.org/docs/plugin-configuration-basics/#specifying-the-schema-as-table-function-parameter -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
