The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
One or more scalar/tabular user defined functions are declared in a lakehouse.
Connection established via Microsoft SQL Server JDBC driver to a lakehouse end point.
When DatabaseMetadata.getFunctions is called.
It returns an empty Resultset (cannot find functions) for the specified catalog, schema (name or pattern), function (name or pattern).
Is this a known limitation/defect?
System.out.println("Get functions");
int i = 0;
try (ResultSet rsFunctions = dbMeta.getFunctions("xxyyzz", "%", "F%");) {
while (rsFunctions.next()) {
System.out.println(rsFunctions.getString(1) + "." + rsFunctions.getString(2) + "."
+ rsFunctions.getString(3));
++i;
}
}
System.out.println("Functions found " + i);
User | Count |
---|---|
16 | |
15 | |
8 | |
7 | |
5 |
User | Count |
---|---|
33 | |
32 | |
25 | |
15 | |
11 |