Re: Questions about HIVE-20508

Hi Julien, See my answers below: > On Sep 19, 2019, at 21:55, Julien Phalip wrote: > > Hi, > > I'm interested in a new config property that was added as part of HIVE-20508 > , and had a few questions: > > 1) The update was merged >

Re: Questions about hive authorization under hdfs permissions.

I hope you don't mind me cc'ing user-group so that this q&a is available for others as well. The grant/revoke based authorization models (including the new sql-standards based authorization in hive 0.13) does not automatically ensure that the user has necessary privileges on hdfs dirs and files. T

Re: Questions about Hive

Yes, Hive is meant for batch processing on a very large data set. It's very latent when compared to other "databases" such as, MySQL, but excels where other databases faulter. For example, running analysis on several terabytes of data is not unusual in Hive. It was mentioned to consider HBase,

Re: Questions about Hive

I believe Hive is not for web users, since it takes several minutes or even hours to do one query. But I managed to provide a web service via THRIFT and php. http://nousefor.net/55/2011/12/php/hbase-and-hive-thrift-php-client/ On Mon, Sep 17, 2012 at 10:42 PM, Hamilton, Robert (Austin) wrote: > He

RE: Questions about Hive

Hello, something :) Regarding jdbc style: I understand this approach has some limitations, but here is an example. You will need to make sure the hive service is running: https://cwiki.apache.org/Hive/hiveserver.html Here is a sample code that I've used for testing. It is not the best java in th

Re: Questions about Hive

I don't think Hive is intended for web request scoped operations... that would be a rather unusual case from my understanding. HBase sounds more like the Hadoop equivalent that you might be looking for, but you need to look at your search patterns to see if HBase is a good fit (you need to manage

Re: Questions about Hive

Thank you both for the answers. We are trying to find out if Hive can be used as a replacement of Netezza, but if there are no indexes then I don't see how it will beat Netezza in terms of performance. Sounds like it certainly can't be used to do a quick lookup from a webapp - like Netezza can.

Re: Questions about Hive

> > Note: I am a newbie to Hive. > > Can someone please answer the following questions? > > 1) Does Hive provide APIs (like HBase does) that can be used to retrieve > data from the tables in Hive from a Java program? I heard somewhere that > the data can be accessed with JDBC (style) APIs. True

RE: Questions about Hive

Regarding usage of APIs to work on HIVE, here is a tip: Try using a JDBC connector (like 'hive-jdbc-0.7.1-cdh3u1.jar') as a plugin in any querying tool such as DbVisualizer. I am connecting to hive using the above setup as well as using SQL Explorer plugin in Eclipse. Regards Anand B Fro