Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Querying Hive Data using HAWQ and PXF

Querying Hive Data using HAWQ and PXF

New Contributor

Hello,

I have configured a 4 node Cluster and installed ambari and required tools. Configure the basic tools (Hive, Oozie, Spark, zookeeper, etc) i installed PXF and Hawq with 3 segments. But now i want to query Data store in hive, i know that i can use Hcatalog and avoid creating PXF external tables. What i dont know is how to access Hawq, i see that it has to be through postgreSQL, but when i try to access sql it always give me this: psql: FATAL: no pg_hba.conf entry for host "[local]", user "gpadmin", database "gpadmin", SSL off (loged as gpadmin). If im loged in with other user the same happens... Can you tell me how to access psql correctlyin order to query hive data? Another thing ive seen that some foruns say that if we use hcatalog we only use one node to query data, is this true? If this is true i would be obligated to create external tables

1 REPLY 1
Highlighted

Re: Querying Hive Data using HAWQ and PXF

New Contributor

Here are some sample entries from my pg_hba.conf for HAWQ master

local all all ident
host all all 127.0.0.1/28 trust
host all gpadmin ::1/128 trust
Don't have an account?
Coming from Hortonworks? Activate your account here