126 questions
0
votes
1
answer
84
views
Compile error when I install HAWQ on Centos7:
I want to install HAWQ on my Centos7.5
When I run: ./configure and make -j8
I got this one:
g++ --shared -o cwrapper.o cwrapper.cpp -Lformat -lorc_format
/usr/bin/ld: /tmp/ccjv719I.o: relocation ...
- 1
0
votes
0
answers
44
views
what are the Hadoop requirements for hawq 2.4
Using HAWQ 2.2 with HDP 2.5.3 on Centos 7.3.
Planing to upgrade to new HAWQ version 2.4.
What are the requirements for HAWQ 2.4?
0
votes
1
answer
88
views
why HAWQ Initialization error sync hawq-site.xml failed
the apache-hawq-src-2.3.0.0 ,build form source. install is sucessfuly.but
when I init hawq, like this "bin/hawq init master",
20180830:13:44:15:084023 hawq_init:office-hadoop02:web-[INFO]:-Check:
...
- 1
1
vote
3
answers
1k
views
HAWQ PostgreSQL - Increment row based on previous row
I need to create a table2 from this table1 trying to update the below table :
TABLE1:
ID Rank Event
123456 1 178
123456 2
123456 3
123456 4 155
123456 5
123456 6 192
123456 ...
- 15
1
vote
0
answers
331
views
Greenplum's pg_dump cannot support lock statement
I'm using pg_dump to backup and recreate a database's structure. To that end I'm calling pg_dump -scf backup.sql for the backup. But it fails with the following error:
pg_dump: [archiver (db)] query ...
- 1,693
0
votes
1
answer
96
views
HAWQ installation error
I am not able to install Hawq even after following the steps on HAWQ website ,
for reference : https://github.com/apache/incubator-hawq
I am getting this error when i run :
./configure --without-...
0
votes
1
answer
98
views
verify whether an id passes through all stages
id current stage previous stages
1 06 05
1 06 03
2 04 03
2 04 02
suppose there are 5 stages of an id.(02,03 etc)
An id should ...
- 49
0
votes
1
answer
337
views
Is it possible to collocate similar data on the same segment in Greenplum?
Suppose I have 12 segments in my system, then suppose I create a table where I distribute by a column based on month of the year. Now suppose I have a second table and I do likewise with that table, ...
- 2,233
0
votes
0
answers
206
views
HAWQ - Error while querying external HDFS table (PXF)
I have a problem with PXF and external table in HAWQ.
I have seven data nodes in cluster (and seven HAWQ segments) and I installed PXF on each of them. I created table based on "Test PXF" on this ...
- 502
1
vote
1
answer
95
views
HAWQ - how to choose a node to install segments
I have six-node cluster and I want to install HAWQ database and PXF on it. My cluster looks like that:
Node1 - NameNode, ResourceManager, HiveMetastore, HiveClient
Node2 - SNameNode, NodeManager
...
- 502
0
votes
2
answers
145
views
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 ...
0
votes
1
answer
68
views
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
...
1
vote
1
answer
1k
views
GPDB : SSH permission denied (public key)
When trying to ssh (from greenplum system user) one of datanode from Master gpdb host.
env - gpdb 4.3.10
Getting error
[gpadmin@mdw ~]$ ssh datanode
Permission denied (publickey,gssapi-keyex,...
- 13
0
votes
1
answer
3k
views
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 ...
- 13
-1
votes
1
answer
130
views
How to connect spark from HAWQ via JDBC/ODBC driver?
Nice to meet you all. I'm Anqing,a trainee working in China.
I'm trying to connect spark from HAWQ via JDBC driver. I know that there is a problem looks like as mine, but I have not solved my issues....
- 23
