[
https://issues.apache.org/jira/browse/DRILL-7978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17440303#comment-17440303
]
ASF GitHub Bot commented on DRILL-7978:
---------------------------------------
dzamo edited a comment 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? The goal is to get to something terse and consistent with
what we do for other text formats.
```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.
There's also a part of that wonders whether we could have justified adding
our fixed width functionality to the existing delimited text format reader.
--
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)
