Issue while accessing hive -

[srini8881]

Hi,

I am very new to Dremio and I am trying to integrate Dremio (standalone version) with the existing Hive 2.3.3 (on top of Hadoop 2.7) setup.

Strangely, while I am able to access few of the tables, I am not able to access other tables as I am facing the following error:

master:8020 failed on connection exception: java.net.ConnectException

I have attached all the screenshots, artifacts in this thread.

Any inputs will definely be of great help!

Thank you.

dremio_screen_shots.zip (117.6 KB)

[balaji.ramaswamy]

@srini8881

Wondering if you can share us with the Dremio Profile

Thanks
Bali

[srini8881]

Thanks Balaji. I am attaching the downloaded profile. I am also attaching the profile of the succeeded profile.

Failed
b6f2e343-6490-469c-9714-47cbf2d75daa.zip (14.4 KB)

Succeeded
f7718eec-4a20-4ece-a239-711c44fcb19e.zip (19.4 KB)

[srini8881]

hi, just a gentle reminder about this case. I have tried all the possible alternatives, but still the request goes to master:8020 instead of my configured master port.

[balaji.ramaswamy]

Hi @srini8881

Have answered the below post

Dremio always connecting to master:8020

@srini8881 Have you also tried to copy hive-site.xml to the <DREMIO_HOME>/conf folder, also if this is Dremio 4.2 and above please do the below too If Hive 2.x source then cd <DREMIO_HOME>/plugins/connectors mkdir hive2.d cd hive2.d ln -s <DREMIO_HOME>/conf <DREMIO_HOME>/plugins/conectors/hive2.d If Hive 3.x source then cd <DREMIO_HOME>/plugins/connectors mkdir hive3.d cd hive3.d ln -s <DREMIO_HOME>/conf <DREMIO_HOME>/plugins/conectors/hive3.d Thanks Bali

Kindly let me know if you still have an issue

Thanks
Bali

[srini8881]

@Dremio always connecting to master:8020 Dremio University

<DREMIO_HOME>/plugins/conectors/hive2.d

Hi Balaji, thanks for your reply.

We are still facing the same issue. Kindly find the screen capture of the changes made:(hives-site and core-site files same as the ones attached earlier in the thread)