andygrove opened a new issue, #6147:
URL: https://github.com/apache/arrow-datafusion/issues/6147

   ### Describe the bug
   
   I have CSV files with extension `.tbl` and it is not possible to query them 
through SQL. This is quite the barrier to running TPC-H benchmarks with the 
generated files.
   
   ### To Reproduce
   
   ## Querying a CSV file with `.csv` extension works
   
   ```
   $ echo bob > customer.csv
   $ datafusion-cli
   
   DataFusion CLI v23.0.0
   ❯ CREATE EXTERNAL TABLE customer STORED AS CSV LOCATION 'customer.csv';
   0 rows in set. Query took 0.008 seconds.
   ❯ SELECT * FROM customer;
   +----------+
   | column_1 |
   +----------+
   | bob      |
   +----------+
   1 row in set. Query took 0.001 seconds.
   ```
   
   :smile: 
   
   ## Cannot query CSV file with `.tbl` extension
   
   ```
   $ echo bob > customer.tbl
   $ datafusion-cli
   
   DataFusion CLI v23.0.0
   ❯ CREATE EXTERNAL TABLE customer STORED AS CSV LOCATION 'customer.tbl';
   0 rows in set. Query took 0.001 seconds.
   ❯ SELECT * FROM customer;
   0 rows in set. Query took 0.001 seconds.
   ```
   
   :cry: 
   
   ### Expected behavior
   
   _No response_
   
   ### Additional context
   
   _No response_


-- 
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]

Reply via email to