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

Switch to Plain View
Hive, mail # user - Running commands at hive cli or hive thirft startup


+
John Omernik 2012-12-09, 16:55
+
विनोद सिंह 2012-12-10, 01:56
+
John Omernik 2012-12-10, 16:01
+
विनोद सिंह 2012-12-10, 16:36
+
Mark Grover 2012-12-14, 09:41
+
Dean Wampler 2012-12-14, 14:31
Copy link to this message
-
Re: Running commands at hive cli or hive thirft startup
Navis류승우 2012-12-14, 14:41
I've booked it on https://issues.apache.org/jira/browse/HIVE-3797

2012/12/14 Dean Wampler <[EMAIL PROTECTED]>:
> What about using "hive -i ~/.hiverc -f script"? I haven't tried it, but I
> assume it reads the specified "rc" file in the batch mode case. True?
>
>
> On Fri, Dec 14, 2012 at 3:41 AM, Mark Grover <[EMAIL PROTECTED]>
> wrote:
>>
>> No, .hiverc only works for CLI.
>>
>> UDFs are tricky. The only way I can think of is to add them to the
>> function registry
>>
>> (https://github.com/apache/hive/blob/trunk/ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java)
>> and recompile Hive.
>>
>> On Mon, Dec 10, 2012 at 8:01 AM, John Omernik <[EMAIL PROTECTED]> wrote:
>> > Will that work for my thrift server connections?
>> >
>> >
>> > On Sun, Dec 9, 2012 at 7:56 PM, विनोद सिंह <[EMAIL PROTECTED]> wrote:
>> >>
>> >> Put a .hiverc file in your home directory containing commands, Hive CLI
>> >> will execute all of them at startup.
>> >>
>> >> Thanks,
>> >> Vinod
>> >>
>> >> On Sun, Dec 9, 2012 at 10:25 PM, John Omernik <[EMAIL PROTECTED]> wrote:
>> >>>
>> >>> I am looking for ways to streamline some of my analytics. One thing I
>> >>> notice is that when I use hive cli, or connect to my hive thrift
>> >>> server,
>> >>> there are a some commands I always end up running for my session.  If
>> >>> I have
>> >>> multiple CLIs or connections to Thrift, then I have to run it each
>> >>> time. If
>> >>> I lose a connection to hive thrift, I have to run them.  Etc etc.
>> >>>
>> >>> My thought was, is there a way that upon opening a hive cli or
>> >>> connection
>> >>> to a hive thrift server, could I have certain commands be executed?
>> >>>
>> >>> These commands include a use command to get me to a specific database
>> >>> (perhaps there is a default database config variable?) or loading up
>> >>> all the
>> >>> temporary functions I use (UDFs) .
>> >>>
>> >>> For example, I have a UDF to do URL decoding:
>> >>>
>> >>> CREATE TEMPORARY FUNCTION uridecode AS
>> >>> 'org.domain.analytics.URIDECODE;
>> >>>
>> >>> Can I get this to run auto magically at hive cli start or thrift
>> >>> server
>> >>> connection?
>> >>>
>> >>> If not, could we build it in that we can add UDFs to hive without
>> >>> doing a
>> >>> recompile that stay in permanently?
>> >>>
>> >>> I would welcome discussion on this!
>> >>>
>> >>>
>> >>
>> >
>
>
>
>
> --
> Dean Wampler, Ph.D.
> thinkbiganalytics.com
> +1-312-339-1330
>
>
+
Vivek Mishra 2012-12-14, 10:05