Skip to content

Add quote & escape for create external table #8310

@Asura7969

Description

@Asura7969

Is your feature request related to a problem or challenge?

1、Add quote & escape for create external table
2、In addition, the DELIMITER attribute is only used in csv. Can it also be moved to option?

Describe the solution you'd like

CREATE EXTERNAL TABLE custom(
    c1  VARCHAR DEFAULT NULL,
    c2  VARCHAR DEFAULT NULL
)
STORED AS CSV
WITH HEADER ROW
OPTIONS ('delimiter' ',','read.escape' '\', 'read.quote' '~')
LOCATION 'custom.csv';

read.escape & read.quote from https://github.com/apache/arrow-datafusion/pull/8251 comment

Describe alternatives you've considered

No

Additional context

Related: #8251

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions