DBVisualizer configuration with hive in kerberos env

2016-06-22 Thread Kumar Jayapal
Hi All, Did any one integrate DBVisualizer with hive in a KRB cluster. I followed the steps given at the site still not able to make a connection to hive. https://community.hortonworks.com/articles/32586/integrating-dbvisualizer-with-kerberized-hive.html I am using hive 0.13.1+cdh5.3.3+350 2

How does this work

2015-12-23 Thread Kumar Jayapal
Hi, My environment has Kerbros and Senry for authentication and authorisation. we have the following permission on drwxrwx--- - hive hive */user/hive/warehouse* Now When I login through Hue/Beeline how am able to acccess the data inside this directory. When I dont belong to hive gr

Re: Unable to connect to beeline after kerberos is installed

2015-11-24 Thread Kumar Jayapal
principle > Use "!connect > jdbc:hive2://:/;principal=”. > > > Please make sure it is the hive’s principal, not the user's. > > Restart the affected services. And it should work. > > Regards, > Arpan > On 24 Nov 2015 1:55 am, "Kumar Jayapal" wrote: &g

Unable to connect to beeline after kerberos is installed

2015-11-23 Thread Kumar Jayapal
Unable to connect to beeline after kerberos is installed I am getting this error. Let me know if an one has resolution for it. *Error: Could not open client transport with JDBC Uri: jdbc:hive2://hiven001.np.mmc.com:1/ : Peer indicated failure: Unsupported mec

Fwd: Hive showing SemanticException [Error 10002]: Line 3:21 Invalid column reference 'mbdate

2015-10-28 Thread Kumar Jayapal
Hello, Can some please help. When I execute hive query with as case statement I get this error " Error while compiling statement: FAILED: SemanticException [Error 10002]: Line 3:21 Invalid column reference 'mbdate' Here is the query : select a.mbcmpy, a.mbwhse, a.mbdept, a.mbitem, (CASE WHEN t