Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Hive CLI

Hi Rahul

Is there a reason why u use Hive CLI  ?

I have aliases defined that I use, so I never had to use Hive CLI again

alias hivescript='hive -e '
alias hivescriptd='hive -hiveconf hive.root.logger=INFO,console -e '

So when I want to run hive commands from Linux  I just type

hivescript "select colA, colB, colC from TableN where partitionA='somval1' limit 100"

Good luck

From: rahul kavale <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Date: Monday, July 8, 2013 11:26 PM
Subject: Re: Hive CLI

Sorry My bad, it was my bad as Ctrl-a was screen binding which is why I was not able to use it for moving cursor. This had nothing to do with Hive or its configuration. My bad

Thanks & Regards,
On 9 July 2013 11:00, rahul kavale <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
Hey there,
I have been using HIVE(0.7) for a while now using CLI and bash scripts.
But its a pain to move cursor in the CLI i.e. once you enter a very long query then you cant go to start of the query (like you do using Ctrl+A/Ctrl+E in terminal). Does anyone know how to do it?

Thanks & Regards,
=====================This email message and any attachments are for the exclusive use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message along with any attachments, from your computer system. If you are the intended recipient, please be advised that the content of this message is subject to access, review and disclosure by the sender's Email System Administrator.