Jefffrey opened a new issue, #9224: URL: https://github.com/apache/arrow-datafusion/issues/9224
### Is your feature request related to a problem or challenge? Be able to have `~` in paths in datafusion-cli resolve to user's home directory. (I'm not certain if this change can be localized to datafusion-cli only, or would need support in actual datafusion codebase :thinking: ) ### Describe the solution you'd like Have both queries succeed from cli: ```shell ❯ select count(*) from '/home/jeffrey/Code/arrow-datafusion/benchmarks/data/tpch_sf1/part/part-0.parquet'; +----------+ | COUNT(*) | +----------+ | 16839 | +----------+ 1 row in set. Query took 0.005 seconds. ❯ select count(*) from '~/Code/arrow-datafusion/benchmarks/data/tpch_sf1/part/part-0.parquet'; Error during planning: table 'datafusion.public.~/Code/arrow-datafusion/benchmarks/data/tpch_sf1/part/part-0.parquet' not found ❯ ``` ### Describe alternatives you've considered _No response_ ### Additional context Not sure how this should be handled for Windows? FYI duckdb supports this (tested on my Linux PC): ```shell D select count(*) from '/home/jeffrey/Code/arrow-datafusion/benchmarks/data/tpch_sf1/part/part-0.parquet'; ┌──────────────┐ │ count_star() │ │ int64 │ ├──────────────┤ │ 16839 │ └──────────────┘ D select count(*) from '~/Code/arrow-datafusion/benchmarks/data/tpch_sf1/part/part-0.parquet'; ┌──────────────┐ │ count_star() │ │ int64 │ ├──────────────┤ │ 16839 │ └──────────────┘ D ``` -- 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]
