Re: Using HiveJDBC interface

2013-02-21 Thread Aditya Rao
Thanks for the tips. I would think #2 works well when you are setting hiveconf variables that are isolated to your query. I have instances in my scripts where I need to set hadoop properties before executing a query. For example setting the number of reducers using set mapred.reduce.tasks=50 With

Re: Using HiveJDBC interface

2013-02-18 Thread Edward Capriolo
I personally do not find it a large problem. 1) have multiple backend hive thrift servers with ha-proxy in front 2) don't use varaible names like "x" use "myprocess1.x" to remove possible collisions 3) experiment with hivethrift2 4) dont use zk locking + thrift (it leaks as far as I can tell (olde

Using HiveJDBC interface

2013-02-18 Thread Aditya Rao
Hi, I've just recently started using Hive and I'm particularly interested about the capabilities of the HiveJDBC interface. I'm writing an simple application that aims to use the Hive JDBC driver to submit hive queries. My end goal is to be able to create multiple connections using the Hive JDBCdr