Support Questions

Find answers, ask questions, and share your expertise

how to run queries on HIVE LLAP? sometimes stop

Expert Contributor

Hi,

i just enabled hive interactive querying on hdp 2.5.3, i notice hive cli is automaticlaly disabled, i am not able to login regularly with hive cli. I can only do a jdbc login through beeline....

but i am not sure how to run queries on hive llap? how is running a query or writing scripts to run some jobs is done with hive llap?

Please help.

2 REPLIES 2

Master Collaborator

When you enabled Interactive Query, a new service was started Hive Server Interactive. It has its own JDBC url, that is what you will use when connecting through beeline. You can use -f argument in beeline to run query from a file.

Expert Contributor
@Deepesh

thanks for the informaiton. How do you use it or run queries? just like hive? how does it work behind the scenes? it will be helpful if you can provide details about it.

Thanks.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.