blackerby commented on issue #2899: URL: https://github.com/apache/drill/issues/2899#issuecomment-2080889935
Alright, got your fork up and running on my machine. Borrowing a little syntax from the added test (I'm still learning Drill), this worked perfectly: ```sql apache drill> select * from table(dfs.`/Users/wm/Desktop/sitemap.xml` (type => 'xml', dataLevel => 2)) limit 5; +------------+--------------------------------------------------------------------+--------------------------+------------+----------+ | attributes | loc | lastmod | changefreq | priority | +------------+--------------------------------------------------------------------+--------------------------+------------+----------+ | {} | https://www.govinfo.gov/bulkdata/PLAW/118/public/PLAW-118publ1.xml | 2024-03-28T00:10:00.074Z | monthly | 1.0 | | {} | https://www.govinfo.gov/bulkdata/PLAW/118/public/PLAW-118publ2.xml | 2023-06-20T23:44:00.215Z | monthly | 1.0 | | {} | https://www.govinfo.gov/bulkdata/PLAW/118/public/PLAW-118publ3.xml | 2023-07-03T14:32:01.529Z | monthly | 1.0 | | {} | https://www.govinfo.gov/bulkdata/PLAW/118/public/PLAW-118publ4.xml | 2023-08-29T19:17:07.501Z | monthly | 1.0 | | {} | https://www.govinfo.gov/bulkdata/PLAW/118/public/PLAW-118publ5.xml | 2023-12-11T20:04:05.659Z | monthly | 1.0 | +------------+--------------------------------------------------------------------+--------------------------+------------+----------+ 5 rows selected (0.151 seconds) ``` No such luck with a [MODS file](https://www.govinfo.gov/metadata/pkg/PLAW-106publ246/mods.xml) though ```sql apache drill> select * from dfs.`/Users/wm/Desktop/mods.xml`; +------------+------+----------------+-------+----------+-----------+-----------+------------+---------------------+----------------+------------+------------+-----------------+-----------------+--------------------+---------------+---------+---------+-------+----------+ | attributes | name | typeOfResource | genre | language | extension | titleInfo | originInfo | physicalDescription | classification | identifier | recordInfo | accessCondition | isAppropriation | legislativeHistory | congCommittee | section | chapter | pages | location | +------------+------+----------------+-------+----------+-----------+-----------+------------+---------------------+----------------+------------+------------+-----------------+-----------------+--------------------+---------------+---------+---------+-------+----------+ No rows selected (0.147 seconds) ``` Happy to add this as comment on #2908, but wanted to comment here in case there's something I'm missing as a brand new Drill user. -- 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