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

Re: how to run queries on HIVE LLAP? sometimes stop

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.

Re: how to run queries on HIVE LLAP? sometimes stop

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.