Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hive vs Beeline for join queries

avatar
Rising Star

Hi guys, Need help..currently I am using HDP2.2 when I am running join queries in Hive shell with auto convert mapjoin true configuration where I am able to get the results...but the same query when I am running in beeline it is failing ..when I turn off mapjoin it is working fine..anyone know what could be the reason..

1 ACCEPTED SOLUTION

avatar
Super Guru
@ammu chCan you please share the error logs your getting while running query through beeline? Also please try to increase the Hiveserver2 heap size and see if you face similar issue.

View solution in original post

2 REPLIES 2

avatar
Super Guru
@ammu chCan you please share the error logs your getting while running query through beeline? Also please try to increase the Hiveserver2 heap size and see if you face similar issue.

avatar
Rising Star

Hi Jitendra attached error screen shot..

4520-hvoat.png