Member since
01-05-2016
22
Posts
4
Kudos Received
3
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2358 | 01-08-2017 07:51 PM | |
892 | 12-15-2016 03:08 PM | |
1710 | 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