- Community Home
- >
- Software
- >
- HPE Ezmeral Software platform
- >
- Re: JDBC DatabaseMeta Implementation for Mapr Dril...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-14-2021 07:58 AM
04-14-2021 07:58 AM
JDBC DatabaseMeta Implementation for Mapr Drill DB
We have launched a 6.1.0.20180926230239.GA version MapR cluster on one of our GCP compute engines. We are using this cluster for multiple Hadoop tasks and also DrillDB.
We are building a JDBC plugin for one of our softwares, for which we are internally using the jdbc-all mapr jar provided by the MapR repository.
The JDBC driver works fine for raw SQL queries, but fails to behave as expected for internal methods. For example the getTables DatabaseMeta implementation should return the list of tables in a given connection. However, this returns an empty list. I know why it behaves this way., internally it fetches rows from the information_schema table. However MapRDB does not keep table information directly in the information_schema table. We will have to write a different implementation for fetching files and tables from MapRDB.
Has anyone come across this ? Am I doing something wrong here ? Is there any other JDBC implementation that can work as expected ?
Let me know if you need more details.
Thanks!
- Tags:
- Mapr Drill
- MapRDB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-02-2021 06:25 PM
06-02-2021 06:25 PM
Re: JDBC DatabaseMeta Implementation for Mapr Drill DB
Can you let me know below:
1) What is the version of JAR being used for drill-jdbc-all?
Are you using 1.16 version.
Also are you using documentation listed below:
If yes, can you tell me what values you are passing for below:
(String catalog, String schemaPattern, String tableNamePattern, String[] types)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-15-2021 11:18 AM
06-15-2021 11:18 AM
Re: JDBC DatabaseMeta Implementation for Mapr Drill DB
Can you let us know if your problem got solved or it is still existing?
Can you answer my questions above?