cgivre commented on issue #2910: URL: https://github.com/apache/drill/issues/2910#issuecomment-2088570939
@kevinlo Welcome to Drill. To answer your question, yes Drill can query multiple files at once. Let's say you have a directory of JSON files called `my_files`. You could write a query like the examples below which would query the JSON files in that directory. For instance: ```sql -- Query all JSON files in a path SELECT * FROM dfs.`/path/to/my/files/*.json` -- Query all files in a given folder SELECT * FROM dfs.`my_files/` -- Query files with a given file name SELECT * FROM dfs.`my_files/data**.csv` ``` Drill supports globs in file paths so you can use your imagination. With respect to UPDATING data, more recent versions of Drill support `INSERT` queries but only to external systems such as RDBMS, Splunk etc. I hope this helps. -- 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: dev-unsubscr...@drill.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
