Support Questions

Find answers, ask questions, and share your expertise

HIVE script execution issue

avatar
Explorer

hi all,

i am learning hadoop 

while i am working on hive , i wanto execute hive script

 

i am getting the following error 

Spoiler
 

hiveissue.PNG

 

can any one help me with this 

3 REPLIES 3

avatar
Champion
The semicolon is needed after each HQL statement not at the end of the script name. Remove it and try again.

Please share the contents of the script as well.

If I recall correctly, if you don't use 'exit' in the HQL script it will dump you into the Hive shell. Without knowing the rest of the script I'd say it is behaving as expected.

avatar
Explorer
i am getting this warning Hive CLI is deprecated and migration to Beeline
is recommended

avatar
Champion
Yeah, that is normal. Beeline is another client that connects to HS2 where the Hive cli connects directly to HMS. The latter has some security issues and is not scalable.

In Hive 2.x the Hive cli will be a wrapper around beeline.

You can ignore the message for now or start using beeline right out the gate.