[
https://issues.apache.org/jira/browse/CALCITE-4460?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17277524#comment-17277524
]
Julian Hyde commented on CALCITE-4460:
--------------------------------------
I'd approach this by creating (extending) a "file format specification" that
includes field delimiters, record delimiters, escapes, whitespace handling, and
so forth. There are several formats in the industry that go by the name "CSV",
with subtle differences.
Maybe there would be a mapping from file suffix to format (e.g. ".csv" -> CSV
variant 1, ".tsv" -> tab-separated values), so you would not have to specify
the format for each table (file) individually.
> Support custom delimiter when parsing CSV tables
> ------------------------------------------------
>
> Key: CALCITE-4460
> URL: https://issues.apache.org/jira/browse/CALCITE-4460
> Project: Calcite
> Issue Type: Improvement
> Components: csv-adapter, file-adapter
> Reporter: Stamatis Zampetakis
> Assignee: Stamatis Zampetakis
> Priority: Major
>
> Currently the CSV and file adapter can only handle CSV files with the default
> delimiter (i.e, comma character ',').
> The goal of this issue is to provide a way to set explicitly the desired
> delimiter for a given CSV table.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
