Syntax for SHOW TABLE EXTENDED

2015-10-15 Thread Subroto Sanyal
ittle change is made to the query: SHOW TABLE EXTENDED LIKE 'sampledb.custom_table' PARTITION (test_partition='0'); I would like to know if the syntax of previous query is incorrect or there exist a problem in Hive with query parsing? Cheers, Subroto Sanyal

Re: HiveMetaStoreClient

2015-08-26 Thread Subroto Sanyal
ri and the credentials to talk to the > thrift server? > > On Wed, Aug 26, 2015 at 10:20 AM, Alan Gates wrote: > >> Yes, sorry, I wasn't clear. As others have stated, HiveMetaStoreClient >> uses the thrift API. So using that should be fine. >> >> Alan.

Re: HiveMetaStoreClient

2015-08-26 Thread Subroto Sanyal
Hi Jerrick, HiveMetastoreClient will be using thrift communication internally via the connection. IMO It is no different from using thrift api. Cheers, Subroto Sanyal On Wed, Aug 26, 2015 at 6:44 PM, Jerrick Hoang wrote: > Ok, I'm super confused now. The hive metastore is a RDBMS dat

Re: HiveMetaStoreClient

2015-08-26 Thread Subroto Sanyal
hi Jerrick Yes, thats the correct way to interact with HiveMetastore(provided you are only interested to play around metadata and Hive Metastore Service is accessible from the java client). Further, you can try the Hive JDBC driver or Hive Server2 thrift API (couldn't find the documentation for th

Re: Hive with Kerberos and a Remote Metastore

2013-09-04 Thread Subroto
Hi Christopher, I am running hive metastore as user "hive" (hive/ip-10-151-109-165.ec2.internal@EC2.INTERNAL) and then I configure hadoop.proxyuser.hive.hosts and hadoop.proxyuser.hive.groups to '*'. This works. On Sep 3, 2013, at 6:39 PM, Subroto wrote: > I am also

Re: Hive with Kerberos and a Remote Metastore

2013-09-03 Thread Subroto
I am also facing the same problem…. Any idea?? Cheers, Subroto Sanyal On Sep 3, 2013, at 3:04 PM, Christopher Penney wrote: > I'm new to hive and trying to set it up in a relatively secure manner for a > test environment. I want to use a remote metastore so MR jobs can access th

Re: A question goes on my mind : Can we (other applications) use HDFS without MapReduce ?

2013-07-15 Thread Subroto
Hi, HDFS is just a FileSystem. You can use the FileSystem API to use it as you wish. No dependency with MR operation. One can use MR with other fileSystems also. Cheers, Subroto Sanyal On Jul 15, 2013, at 12:10 PM, Matouk IFTISSEN wrote: > Hello, > Can we (other applications) use HDFS w

Socket Leaks in Hive 0.8

2012-08-09 Thread Subroto
Hi,When I try to close my HiveMetaStoreClient, it fails. Following is the code snippet from Hive code base which is responsible for closing the connection.public void close() {    isConnected = false;    if ((transport != null) && transport.isOpen()) {      transport.close();    }    try {      if

org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out

2012-07-27 Thread Subroto
Hi,I am using Hive 0.9 and try to execute a simple API: IMetaStoreClient metastoreClient = HiveUtil.getMetastoreClient(HiveUtil.createHiveConf(_metastoreUri, _hadoopProperties));            try {                metastoreClient.tableExists("anyTableName");            } catch (Throwable e) {