[
https://issues.apache.org/jira/browse/DRILL-7978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17440300#comment-17440300
]
ASF GitHub Bot commented on DRILL-7978:
---------------------------------------
dzamo commented on pull request #2282:
URL: https://github.com/apache/drill/pull/2282#issuecomment-962939201
@MFoss19 @estherbuchwalter following some [recent
chat](https://github.com/apache/drill/pull/2359#issuecomment-962673076) with
@paul-rogers and my last comment here, how about a reduced format config such
as the following?
```json
"fixedwidth": {
"type": "fixedwidth",
"extensions": [
"fwf"
],
"extractHeader": true,
"trimStrings": true,
"columnOffsets": [1, 11, 21, 31],
"columnWidths": [10, 10, 10, 10]
}
```
Column names and types can already come from a provided schema or aliasing
after calls to `CAST()`. Incidentally, the settings above can be overriden per
query using a provided schema too.
--
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]
> Fixed Width Format Plugin
> -------------------------
>
> Key: DRILL-7978
> URL: https://issues.apache.org/jira/browse/DRILL-7978
> Project: Apache Drill
> Issue Type: New Feature
> Components: Storage - Other
> Reporter: Megan Foss
> Priority: Major
>
> Developing format plugin to parse fixed width files.
> Fixed Width Text File Definition:
> https://www.oracle.com/webfolder/technetwork/data-quality/edqhelp/Content/introduction/getting_started/configuring_fixed_width_text_file_formats.htm
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
