HiveServer2 via a proxy

Team, Any ideas on how to connect to HiveServer2 from Beeline via a proxy server. I have tried everything I can think of and am using http as a transport mode, but it still doesn't work. Thanks, Andy

Use of functions in the WHERE clause.

Team, Looks like Hive doesn't like functions in the WHERE clause. Any ideas on how to deal with this? Also, I feel like this used to be supported in the past. Am I missing something? SELECT y, m, d FROM emp_table WHERE concat(y, m, d) > '20181216' limit 10; FAILED: SemanticException InvalidObject

ODBC-hiveserver2 question

Team, Is ADD JAR from HDFS (ADD JAR hdfs:///hive_jars/hive-contrib-2.1.1.jar;) supported in hiveserver2 via an ODBC connection? Some relevant points: - I am able to do it in Hive 2.1.1 via JDBC (beeline), but not via an ODBC client. - In Hive 1.2.1, I can add a jar from the local node,

Hive update question

Hi Team, Whats the best way to do an update on one table from another? Variations of this syntax below doesn't seem to work: UPDATE table_x SET column_1 = B.column_1 FROM table_y B WHERE column_2 = B.column_2 ; Thanks, Andy

Error with insert overwrite to s3n

Team, I am hitting this error discussed below and I am on Hive 1.2: http://qnalist.com/questions/6161150/hive-error-when-trying-to-write-data-to-s3n Gopal says in that thread: "Looks like the insert overwrite isn't triggering the CopyTask - MoveTask is the wrong operation for cross-FS operations.

Metastore and SerDe jars

Team, I know I can do a "ADD JAR" on the Hive CLI to use SerDe and UDF jars. If I am using the metastore thrift API, is there a way to add/register SerDe jars via the API? Basically, whats the metastore API equivalent of CLI's "ADD JAR "? I tried setting the hive.aux.jars.path property in the hive

Re: UDF reflect

2.5), reflect("java.lang.Math", "exp", 1.0), reflect("java.lang.Math", "floor", 1.9) FROM src LIMIT 1; 1 true 3 2 3 2.7182818284590455 1.0 Thanks, Andy On Thu, Apr 3, 2014 at 11:22 AM, Andy Srine wrote: > Thanks Szehon and Peyman, I wan

Re: UDF reflect

w. Makese udf reflect much less useful. > > > On Thu, Apr 3, 2014 at 2:22 PM, Andy Srine wrote: > >> Thanks Szehon and Peyman, I want to call hashCode() on the UUID object. >> This object is stored in the table as a string, but I can convert it to >> UUID. Thats not the

Re: UDF reflect

() >> >> Thanks >> Szehon >> >> >> >> >> On Wed, Apr 2, 2014 at 2:13 PM, Andy Srine wrote: >> >>> Hi guys, >>> >>> >>> I am trying to use the reflect UDF for an UUID method and am getting an >>> exce

UDF reflect

Hi guys, I am trying to use the reflect UDF for an UUID method and am getting an exception. I believe this function should be available in java 1.6.0_31 the system is running. select reflect("java.util.UUID", "hashCode", uid_str) my_uid, ... My suspicion is, this is because the hive column I