Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

HIve issue with query exectuion.

Highlighted

HIve issue with query exectuion.

Hi I am usning HDP 2.5.

I am trying to run select * from table_name query through beeline. but is taking around 5 min for 33860. but on hive query it is running in 3.3 second.

Please suggest me if I can tune hive.

2 REPLIES 2
Highlighted

Re: HIve issue with query exectuion.

Expert Contributor

I assume you are trying to same query on beeline & hive cli. Are you using Tez for both ?

Can you share yarn logs for both hive-cli & beeline using below command

yarn logs -applicationId <application ID>

Can you share 'set -v' command output of both environment

Highlighted

Re: HIve issue with query exectuion.

@ Naresh P R

slect * from table with only show the output on screen.

Please find the output of set -v on both server.

set -v printf "\033]0;%s@%s:%s\007" "${USER}" "${HOSTNAME%%.*}" "${PWD/#$HOME/~}"

Don't have an account?
Coming from Hortonworks? Activate your account here