Member since 
    
	
		
		
		01-05-2016
	
	
	
	
	
	
	
	
	
	
	
	
	
	
			
      
                22
            
            
                Posts
            
        
                4
            
            
                Kudos Received
            
        
                3
            
            
                Solutions
            
        My Accepted Solutions
| Title | Views | Posted | 
|---|---|---|
| 3021 | 01-08-2017 07:51 PM | |
| 1203 | 12-15-2016 03:08 PM | |
| 2215 | 11-22-2016 05:55 PM | 
			
    
	
		
		
		02-13-2017
	
		
		10:09 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 If necessary, set the  pxf_service_address  global 
configuration property to a hostname or IP address and port where you 
have installed the PXF Hive plug-in. By default, the value is set to  localhost:51200 .
  SET pxf_service_address TO "hivenode:51200"
   
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		02-13-2017
	
		
		04:39 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi Shikhar ,   Can you confirm the below   1.Are you able to query a normal pxf table (other than hctalog or hive one ) .You can create an external table in hdfs  2.Please stop the pxf services in all the nodes and kill if there are any orphan processes to the 51200 port .We need to see why the tomcat server is not spawning up .  3.Once you clear all the processes start pxf services in all the nodes and query the table back .  4.Please make sure you have installed hive-clients in all the pxf nodes to access hive data .  5.Also see whether you need to set pxf_service_address point to the hive metstore 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		01-08-2017
	
		
		07:51 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							 Hi Piyush ,   You can login to the hawq segment server and can stop the segment with the following   ssh hawq-segment  su - gpadmin   source /usr/local/hawq/greenplum_path.sh  hawq stop segment   If it still not getting stopped ,look for the orphan segment process in the server and manually kill it (ps -ef|grep postgres ) .It would be good to the  check segment logs in the server for the details .  Thanks   Pratheesh Nair 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		12-15-2016
	
		
		03:08 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi Yong ,   There are certain rpm dependencies in hawq 2.x and the same has to be met as a prerequisite for the installation .Please install required packages in the cluster and move forward with the installation  .  Following are the list of rpm prerequisite      json-c   =0.9"}">>=0.9  MIT  rhel-6-server-eus-rpms  Redhat  HDB  json support    krb5-libs  default  MIT  rhel-6-server-rpms    Redhat  HDB  kerberos    libicu   default  MIT and UCD and Public Domain  rhel-6-server-rpms  Redhat  HDB  unicode support    openssl  0.9.8  OpenSSL  rhel-6-server-rpms    Redhat  HDB  security    libgsasl    default  LGPLv2+  epel  Fedora  HDB  security    net-snmp-libs  default  BSD  rhel-6-server-rpms    Redhat  HDB  snmp     Please let me know how it goes !  Thanks 
Pratheesh Nair 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		12-08-2016
	
		
		05:54 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Here is the requested info   http://hdb.docs.pivotal.io/210/hawq/clientaccess/ldap.html  http://hdb.docs.pivotal.io/210/hawq/clientaccess/kerberos.html 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		12-06-2016
	
		
		05:05 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							 You can install and configure Hawq using AMBARI .Please have a look into the below document for the same.  http://hdb.docs.pivotal.io/210/hdb/install/install-ambari.html  Ranger integration is in roadmap and is in progress .  https://issues.apache.org/jira/browse/HAWQ-256 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		12-06-2016
	
		
		05:05 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 You can install and configure Hawq using AMBARI .Please have a look into the below document for the same.  http://hdb.docs.pivotal.io/210/hdb/install/install-ambari.html  Ranger integration is in roadmap and is in progress .   https://issues.apache.org/jira/browse/HAWQ-256  Thanks  Pratheesh Nair 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		11-22-2016
	
		
		05:55 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							 Kerberos and ssl are both protocols, Kerberos is an authentication protocol, but SSL is an encryption protocol.Having said that if you really want to secure your data at motion ,you may need to consider SSL option and for better authentication of clients kerberos would be the best .Also you can have both (ssl & kerberos ) set it up for hawq . 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		08-25-2016
	
		
		05:54 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Yep .It will resolve the issue .Also please make sure you can do a "ssh localhost" as well after the key exchange  
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		 
        




