Asura7969 commented on PR #8251: URL: https://github.com/apache/arrow-datafusion/pull/8251#issuecomment-1821139081
> I believe another way is to generate custom-delimited (or escaped) .csv while configuring test context -- reference example might be [csv generation](https://github.com/apache/arrow-datafusion/blob/f310db31b801553bae16ac6a3ef9dc76de7b016a/datafusion/sqllogictest/src/test_context.rs#L104) for `joins.slt` This PR also involves two attribute（`escape` and `quote`） configurations of the csv file,when creating a table using sql，For example： ```sql CREATE EXTERNAL TABLE custom_escape ( c1 VARCHAR DEFAULT NULL, c2 VARCHAR DEFAULT NULL ) STORED AS CSV WITH HEADER ROW DELIMITER ',' OPTIONS ('escape' '\') -- this LOCATION '../core/tests/data/custom_escape.csv'; ``` Using the API to create similar tables supports `escape` and `quote`, but SQL does not support it. Your tip may not cover the SQL method. Thanks again for the tips. -- 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]
