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
3 answers

How does resource manager acquire resource in HAWQ?

In HAWQ, how does resource manager acquire resource? And what kind of granularity of resource can be specific by user?
Chunling Wang
  • 21
  • 6
0
votes
6 answers

How to configure HAWQ memory?

Can I configure the amount of memory available to all HAWQ segment instances and the amount of memory available for each segment?
Chunling Wang
  • 21
  • 6
0
votes
3 answers

What is the different between "hawq stop -M immediate" and "hawq stop -M fast"?

When I stop a HAWQ instance which is still connected to some sessions, it can not stop with "hawq stop -a". $ hawq stop cluster -a 20160701:10:02:09:032804 hawq_stop:ChunlingdeMacBook-Pro:wangchunling-[INFO]:-Prepare to do 'hawq…
Chunling Wang
  • 21
  • 6
0
votes
2 answers

"Insert into a table" operation fails in Hawq

I have 5 node Hortonworks cluster(Version - 2.4.2) in which I have installed Hawq 2.0.0. These 5 nodes are: edge master ( Name node) node1(Data Node1) node2(Data Node2) node3(Data Node3) I followed this link to install Hawq in HDP -…
Vik
  • 1
  • 2
0
votes
2 answers

How to understand entryDB in HAWQ

What is entryDB in HAWQ? What are the differences between entryDB process in master and Query Executor process in segment? And what kind of queries are running on entryDB?
Chunling Wang
  • 21
  • 6
0
votes
4 answers

How can I get DEBUG messages HAWQ in log?

Are there any GUCs or commands which I can get debug messages in HAWQ log? Now, I can only get ERROR or FATAL message but can not get any DEBUG messages. How to print these DEBUG messages in Log file?
Chunling Wang
  • 21
  • 6
0
votes
2 answers

How do i create and read External table in GPDB

We have small gpdb cluster. When i am trying to create and read on my first External table using gpfdist protocol. Getting error at reading of external table : that is prod=# select * from ext_table prod-# ; ERROR: connection with gpfdist failed…
NEO
  • 389
  • 8
  • 31
0
votes
1 answer

Error at Prompt:How Do I create New user based Filespace in GPDB

We have small gpdb cluster. When i am trying to create New user based Filespace. that is Calling gpfilespace utility $gpfilespace -o gpfilespace_config Getting following error at prompt:At the time of creation of filespace . [gpadmin@mdw dfs]$…
NEO
  • 389
  • 8
  • 31
0
votes
1 answer

HAWQ service check Fails From Ambari

We have small Hadoop-Hawq Cluster. In that, once of slave host service fails When I am executing the check of HAWQ services. Getting following error From Ambari UI: **stderr:** Traceback (most recent call last): File…
NEO
  • 389
  • 8
  • 31
0
votes
1 answer

How do implement CDC in greenplum?

We have small array of gpdb and pivotal hadoop.We are trying to do CDC Using gpdb. WE are using SQL server 2012 as external Data source. we have read only access of SQL SERVER from client's END. Hence ,SQL server does not allow to capture CDC…
NEO
  • 389
  • 8
  • 31
0
votes
5 answers

Hawq init failed -- "postgres" is needed by initdb

After I build incubator-hawq on Centos7.1, I tried to init it. But the error below occurs: 20160516:18:10:43:002036 hawqinit.sh:host-172-16-0-105:hawqadmin-[INFO]:-Loading hawq_toolkit... ALTER ROLE 20160516:18:10:44:001766…
louis lau
  • 161
  • 3
  • 11
0
votes
3 answers

There are some issues when we test hawq on our hadoop cluster

The hawq ssh'port is default 22. How can I specify other port, such as 333, 222? When we built pxf plugins(hdfs, service hbase, hive), I got itself rpm package, but when I rpm the pxf-service package, I got some errors: Failed dependencies:…
muling
  • 1
  • 1
0
votes
3 answers

Failed dependencies when install pxf service

When I rpm pxf service in hawq, I got some errors: error: Failed dependencies: hadoop >= 2.6.0 is needed by pxf-service-0:3.0.0-root.noarch hadoop-hdfs >= 2.6.0 is needed by pxf-service-0:3.0.0-root.noarch What's your advice here ?
muling
  • 1
  • 1
0
votes
2 answers

How Can I specify hawq ssh port?

How can I specify the ssh port ,my ssh port is 333.When I ssh remote host,the hawq ssh port is 22. Thanks
muling
  • 1
  • 1
0
votes
1 answer

I want to send a custom type value to a C-language function, but I can't get the value?

Anyone can help give a C-language function example that use a custom type as one of the parameters? Today, I tried to follow the documentation, but I was not able to get the correct values of my custom type. here is the…
Songjs
  • 13
  • 2
1 2 3
…
8
9