Is there any way to access MAPRDB without using maprClient through jdbc or any other possible way? have a limitation of installing the client so want to explore ways thorough which this can be done.
Hi Sam M,
May be it is beneficial to check out MapR-DB Sample C Application for reference.
is there any reference to do in JAVA and what all libraries would be needed?
Please check out How Do I Connect to MapR-DB from a Java Client?
If you want to use JDBC you would need to set up a thrift client to give you access. Note that there are some issues with the thrift service (e.g. security). This is a listener so that your client app can connect w the cluster via JDBC.
If you're writing your own code, then you would need to include the MapRDB / HBase jars (which is the maprClient libraries) so that you can pick up the required files. Here its a Java app and its not using JDBC to connect.
I believe you may be able to use Drill as your JDBC thrift service to MapRDB, I think someone from MapR may have done this already.
Thanks for your response, I had one more question with using drill as jdbc thrift service - can we use it to update the MapRDB table?
Per the Apache Docs found here: https://drill.apache.org/docs/supported-sql-commands/
There is no insert in to an existing data set. So the syntax has no way to insert/update in to MapRDB.
Note that you can create a new table or view but once the table/view is created, it looks like the set is immutable.
Perhaps someone with more Drill experience can confirm?
Does the details mentioned @ http://maprdocs.mapr.com/home/MapR-DB/JSON_DB/getting_started_json_ojai_build_java_app.html help?
Retrieving data ...