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

Reply via email to