Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

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


Copy link to this message
-
Running commands at hive cli or hive thirft startup
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!
+
विनोद सिंह 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
+
Navis류승우 2012-12-14, 14:41
+
Vivek Mishra 2012-12-14, 10:05
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB