Options
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
HIVE script execution issue
Labels:
- Labels:
-
Apache Hive
Explorer
Created on ‎06-16-2017 02:13 AM - edited ‎09-16-2022 04:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi all,
i am learning hadoop
while i am working on hive , i wanto execute hive script
i am getting the following error
can any one help me with this
3 REPLIES 3
Champion
Created ‎06-16-2017 11:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
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.
Explorer
Created ‎06-16-2017 11:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i am getting this warning Hive CLI is deprecated and migration to Beeline
is recommended
is recommended
Champion
Created ‎06-16-2017 11:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
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.
