Stack Overflow
Stack Overflow

Questions tagged [hawq]

This tag is for questions about Pivotal HAWQ, a SQL on Hadoop implementation

Pivotal HAWQ supports low-latency analytic SQL queries, coupled with massively parallel machine learning capabilities, to shorten data-driven innovation cycles for the enterprise. HAWQ enables discovery-based analysis of large data sets and rapid, iterative development of data analytics applications that apply deep machine learning. It reads data from and writes data to HDFS natively. Using HAWQ functionality, you can interact with petabyte range data sets. HAWQ provides users with a complete, standards-compliant SQL interface to Hadoop.

Homepage

Official Documentation

126 questions
0
votes
2 answers

Error when installing "hawq init cluster" on Docker, ,"internal_load_library","dfmgr.c",208

I've been trying to install a hawq cluster via these instructions on the github page. They mostly work fine, until I get up to the last command hawq init cluster. The last part of the error log is…
Jerry Londergaard
  • 45
  • 6
0
votes
1 answer

Not able to Install HAWQ DB successfully in Centos 7.x version

I am installing HAWQ DB on Linux Centos 7.X version, it is giving following issue in make install step as mentioned in link https://cwiki.apache.org/confluence/display/HAWQ/Build+and+Install#tab-yum make[2]: *** [install] Error 1 make[2]: Leaving…
VikashKumar
  • 1
0
votes
1 answer

GPDB:Out of memory at segment

we re facing OOM error when trying to execute multiple SQL query session via scheduled job . Detailed error: The error message is: org.postgresql.util.PSQLException:ERROR: Out of memory (seg6 slice5 sungpmsh0:40002 pid=13610) Detail: VM protect…
viju sylphes
  • 13
  • 5
0
votes
2 answers

Acessing Hive Data on HAWQ/PXF with HCatalog

I've configured Hortonworks HDP with ambari services, later I add HAWQ and PXF. Through some research i've seen that is possible to query data stored in Hive through HCatalog and since i already loaded the dataset to hive it would easy the work, but…
Mário Rodrigues
  • 31
  • 1
  • 8
0
votes
1 answer

Querying hive schema with HAWQ and PXF

I know it's possible to query data managed by Hive with HAWQ, and HCatalog, I have installed Hortonworks ambari that installs all the tools needed. To query the hive i schema followed pivotal instructions where it says to enter PostgreSQL and do the…
Mário Rodrigues
  • 31
  • 1
  • 8
0
votes
0 answers

Greenplum - Out of memory

When trying to query from gpdb cluster. getting Out of memory error with error code 53400. System Related information TOTAL RAM =30G SWAP =15G gp_vmem_protect_limit=8192MB TOTAL segment = 8 Primary, 8 mirror = 16 SEGMENT HOST=2 Getting error…
vs0731
  • 17
  • 1
  • 8
0
votes
0 answers

HDP- Datanodes are crashing

We have 4 nodes Hadoop cluster. 2 Master nodes 2 data nodes After sometimes we found that our data nodes are failing. then, we go and see the log section it always tell cannot allocate memory. ENV HDP 2.3.6 VERSION HAWQ 2.0.0 VERSION linux os…
vs0731
  • 17
  • 1
  • 8
0
votes
1 answer

Greenplum Delete statement not working

We have a scenario in that, We need to compare staging table with Destination table.Finally, want to delete the record at destination table We tried DELETE FROM DestTable FROM DestTable d LEFT JOIN StagingTable s ON d.ID = s.ID WHERE …
vs0731
  • 17
  • 1
  • 8
0
votes
1 answer

Select query not working on external table

We have a small array of Greenplum cluster. In that we installed Hadoop. and trying to access external table using GPHDFS protocol. ENV GPDB VERSION 4.3.10 HDP VERSION 2.3.6 JAVA VERSION 1.8 acroos master /segments Getting error prod=# select…
vs0731
  • 17
  • 1
  • 8
0
votes
1 answer

Cant create ORC external tables on Hawq PXF

I'm using Pivotal Hawq with ambari and now I'm trying to run some queries over ORC hive tables with hawq. Previously I was able to create the external queries on pqsql using SELECT * FROM hcatalog.hive-db-name.hive-table-name distributed randomly;…
Mário Rodrigues
  • 31
  • 1
  • 8
0
votes
0 answers

Greenplum issue - HDFS Protocol Installation for GPHDFS access to HDP 2.x cluster

When i am trying to read external table using GPHDFS Protocol. Additionally, I am not able to access HDP2.X files via greenplum cluster. Getting Error devdata=# select count(*) from schema.ext_table; ERROR: external table gphdfs protocol command…
NEO
  • 389
  • 8
  • 31
0
votes
0 answers

Greenlum - How to create Indexed view

I am trying to design a DW Process and I heard about Indexed views. Actually I want to create a view and it should update automatically when base tables are changed. Basically, all I need to do is: Want to create a regular view Then, Want to…
NEO
  • 389
  • 8
  • 31
0
votes
0 answers

Hawq Queries Very Slow

Im trying Pivotal Hawq with ambari and now im trying to run some queries over hive tables with hawq. From what i have seen Hawq can query hive tables through HCatalog…
Mário Rodrigues
  • 31
  • 1
  • 8
0
votes
2 answers

Cant Fully Install Hawq on Ambari

Im trying to run Pivotal Hawq with Ambari. I add the Hawq repository and install the Hawq and PXF through ambari. I have 4 nodes and so the configuration would be 1 Hawq master and 3 segment. The master is started correctly, but i only can start 2…
Mário Rodrigues
  • 31
  • 1
  • 8
0
votes
0 answers

Greenplum - Update statement failing on timestamp column

We have source and target table in greenplum database. we are comparing both the table using sql script. But Update is not working here. and it is not updating the timestamp column of target table with respect to source table. Input - Source/target…
NEO
  • 389
  • 8
  • 31
1 2 3
…
8 9