Hi,
I am using Apache Drill 10.0. Currently, I am trying to test an application
using JDBC and Drill.
I build a MOngoDB database (called HR) and a Collection called EMPLOYEES.
But I have problemes retrieving the column's metadata.
When I call DataBaseMetaData.getColumns(); I retrieve only 1 row (with the
correct values in TABLE_SCHEM ("mongo.HR"), TABLE_CAT ("DRILL") and
TABLE_NAME ("EMPLOYEES")), but the COLUMN_NAME is "*".
The collections has several columns, these are shown when I query the
MongoDB via the Drill Web Console.
Is it not possible to retrieve the columns metadata via JDBC?
Thanks a lot in advance for your help.
Kind regards,
Alex