Configuring Dremio on offline system


#1

Hi, We have VED without internet connection. I have configured dremio, but its not working and its not allowing me the option to open dremio where its disabled.

Dremio will not working in offline system where we dont have internet?


#2

Hi @Satvikjayasimha_Mola,

Can you describe your Dremio configuration in more detail? Where is the Dremio coordinator installed? Are you trying to access the Dremio Web UI from the same host or a different host?


#3

I am trying to use dremio from same host inside VED, where i dont have internet.

Have dremio coordinator installed on VED where i dont have internet


#4

Forgive, but I’m not familiar with VED. Is this a Linux or Windows system?
How did you install Dremio (https://docs.dremio.com/quickstart/)

If you can start Dremio, please go to http://localhost:9047 on your web browser on the host with the coordinator. It should bring you to the Dremio UI


#5

Window, where its a premise network we will not have any internet access, have installed and started the Dremio, but it doesnt run after clicking on start.

Is internet required to run dremio?


#6

@Satvikjayasimha_Mola: By VED, do you mean the VMWare Virtual Engineering Desktop?


#7

Yes correct…


#8

Any updates on this?


#9

@Satvikjayasimha_Mola: How did you deploy/install Dremio on the VED? Have you attempted to open a browser and point it at http://localhost:9047 on the Dremio host after starting the service?

You don’t need an internet connection to run Dremio, but you do need a network connection to the Dremio host.


#10

Have deployed using internal tool, and ran it over their here is the screen i see

image


#11

Please let me know your availability to have quick call on this


#12

@Satvikjayasimha_Mola,

The logs may have more information about what’s going on. Can you attach the logs to this ticket? In the windows environment, they can be found in <USER_HOME>/AppData/Dremio/log. Please attach server.log and server.out
https://docs.dremio.com/advanced-administration/log-files.html


#13

couldnt able to upload the files, as its allowing only JPG format (or) image format


#14

Please share your email id, so, that i can send it via email


#15

@Satvikjayasimha_Mola, ben@dremio.com. You should also be able to put the files in a folder, zip that, and attach it here.


#16

Log files.zip (2.4 KB)

Attached files,


#17

On the same i have some question how can i filter the data in custom SQL.

Example select * from Test.“logstash-niq*”.logs where “time” >= (2018-12-01’)


#18

Try using the GUI and Keep Only to filter based on time. Then you can look at the SQL that is generated to capture the syntax.


#19

Can you share the screen shot how to do that


#20

Lot’s of examples here: https://www.dremio.com/tutorials/data-curation-with-dremio/

Also, check out the courses on university.dremio.com.