Hello, I was able to setup 2nd Hiveserver2 and able to connect to Hive through beeline and zookeeper. I am able to connect using kerbfqdh as _HOST through Beeline. But for the some reason, Hortonworks ODBC driver is giving error 34 if I provide _HOST in krbhostfqdn field. I am using service discovery mode = Zookeeper, hosts =<zookeeper quorom>, authentication method = kerberos service name = Hive kerb hostfqdn = _HOST Regards Pranay Vyas ... View more

Hi, We have mainframe files being FTP'ed to HDFS and needs to be loaded into Hive. The FTP'ed files have many columns in packed decimal (comp-3) Is there any build in function to convert the gibberish values to Hive float or string? ... View more

Hello Hive SME's, I am setting up Hive tables for ACID Transactions. There are fair(not high) number of inserts/ updates expected on each tables. Should the compactions be scheduled every day? or let Hive manage compaction? Are there any pros/cons on hive managed compactions? Hive Version 0.14 Thank You Pranay Vyas ... View more

Hello, Hiveserver2 is non-responsive and the log reveals below error. Cluster is Kerberos enabled and there is no HA on Hive. hive.cluster.delegation.token.store.class - org.apache.hadoop.hive.thrift.ZooKeeperTokenStore Ambari V 2.0 HDP V 2.2.4.2 2016-01-19 23:20:18,466 ERROR [HiveServer2-Handler-Pool: Thread-159]: metadata.Hive (Hive.java:getDelegationToken(291 0)) - java.lang.UnsupportedOperationException: getDelegationToken() can be called only in thrift (non local) mode at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.getDelegationToken(HiveMetaStoreClient.java:1664) at sun.reflect.GeneratedMethodAccessor72.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:90) at com.sun.proxy.$Proxy12.getDelegationToken(Unknown Source) at org.apache.hadoop.hive.ql.metadata.Hive.getDelegationToken(Hive.java:2908) at org.apache.hive.service.cli.CLIService.getDelegationTokenFromMetaStore(CLIService.java:467) at org.apache.hive.service.cli.thrift.ThriftCLIService.getDelegationToken(ThriftCLIService.java:340) at org.apache.hive.service.cli.thrift.ThriftCLIService.getSessionHandle(ThriftCLIService.java:321) at org.apache.hive.service.cli.thrift.ThriftCLIService.OpenSession(ThriftCLIService.java:235) at org.apache.hive.service.cli.thrift.TCLIService$Processor$OpenSession.getResult(TCLIService.java:1253) at org.apache.hive.service.cli.thrift.TCLIService$Processor$OpenSession.getResult(TCLIService.java:1238) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) at org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge20S$Server$TUGIAssumingProcessor.process(HadoopThriftA uthBridge20S.java:679) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:206) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Appreciate your help! Regards Pranay VYas ... View more