Issues on dbKoda drill and Storage data

Adinan Aguiar shared this question 7 months ago
Answered

Hi team, hope you are all well.

I'm starting my study on dbKoda and MongoDB and I'm having some difficults to set up drill because when the IDe should download plugins and stuff generate error on the process.

I have downloaded drill directly from apache and started on my system (Linux Mint) all went well there, but when try to use on dbKoda the editor won't start.


About the storage graphic I was able to use in one of my servers but note in others. Hope you can help me solve those issues.

I have attached the logs for your analysis

Thanks in advance.

Comments (7)

photo
1

Hi Adinan,


Sorry for letting you know that currently we only support Apache Drill version 1.11.0 which you can download from here.

http://archive.apache.org/dist/drill/drill-1.11.0/apache-drill-1.11.0.tar.gz

By looking at the logs, I think another issue is that you will have to configure the Apache Drill Path as '/opt/apache-drill-1.11.0‘ Instead of '/opt/apache-drill-1.11.0/bin’

We will be releasing a new version soon with the support of latest version of Apache Drill. I will update you once it is out.

Thanks for sending us the logs to analyse.

Wahaj from dbKoda

photo
1

Thanks for the reply team!


I downloaded the recommended version but still have the same issue, please refer to the screenshot


/wE6FherheaGKQAAAABJRU5ErkJgggA=


Here are the configuration of drill:


/QEAhCAAAQgAAEIQMC+wPgzjVvbWu0XxVEIQAACEIAABCAAAQj4tADGfX368qHxEIAABCAAAQhAAAIuCPxfQkXX1tIH61EAAAAASUVORK5CYIIA


I believe I had the correct permissions on the folder:


/AQFCxjklS3KrAAAAAElFTkSuQmCCAA==


And the controller log:


/EFhRJBEBEQERAREBEQERAREBEQERgf8JBCI3ZvqfUFtUUkRAREBEQERAREBEQERAREBEQETghiDwf8FPEmWwNFuSAAAAAElFTkSuQmCCAA==


Hope to hear from you team, thanks in advance!

photo
1

Hi Adinan,

Sorry that you have to go through such inconvenience due to our Auto-Downloader/Setup being broken for Apache Drill. But you can download the dbKoda Drill Controller from this link

https://s3-ap-southeast-2.amazonaws.com/asiapac-sydney.release.dbkoda/dbkoda-java-controller-latest.jar

After downloading, you will have to configure the path of it manually in this file. "/home/adinan.aguiar/.dbKoda/config.yml"

The top three lines of config.yml file should look like this.

mongoCmd: /usr/local/bin/mongo

drillCmd: /opt/apache-drill-1.11.0


drillControllerCmd: /opt/dbkoda-java-controller-latest.jar

You just need to configure drillControllerCmd to the path where you have download the controller from above link.


Hope this will solve the issue.

I have already filled a ticket for this issue and it will be solved in the next release.

Thanks again for getting back to us and identifying this issue.

photo
1

Hi to the Koda team!


Please let me know when you update DBKoda to support apache-drill-1.13.0.

In addition is it possible to setup apache-drill-1.13.0 to interact with dbkoda just setting up the drill path in dbkoda for Windows 10?

I installed separately drill on C:\drill\apache-drill-1.13.0\

Cheers

photo
2

Hi Carlos!


We've just release version 1.0 of dbKoda, this should fix your issue as we've added support for apache-drill 1.13.0 a long with a whole range of improvements that you can view here: https://medium.com/dbkoda/dbkoda-1-0-is-released-w00t-45ea64f25a13


You can download the latest version of dbKoda for your chosen platform at http://www.dbkoda.com


Cheers,

Mike from dbKoda.

photo
1

Hi DbKoda Team.

Is it possible to download the Sakila database in Json or bson format from your site as it was possible before?

The web page https://www.dbkoda.com/blog/2017/08/22/SampleCollections gives an error (not found).

Thanks.

photo
1

Hi Carlos,


You can find that blog post here now:

https://medium.com/dbkoda/mongodb-sample-collections-52d6a7745908


We moved the blog to Medium in March, but it looks like there is an issue with the old blogs which broke the redirect for that post.


Thanks,

Chris from dbKoda