Column-oriented DBMS for decision support and complex processing.
Questions tagged [paraccel]
23 questions
0
votes
0 answers
How to update PADB Paraccel Postgres 8.0.1 stv_partitions failed status after disk change
I have been receiving Disk Full errors in my Postgres 8.0.1 cluster.
While troubleshooting, I ran:
select failed, mount point, diskno from stv_partitions;
One node had a failed RAID 0 drive a while ago, but has been replaced and that drive has…
Joseph
- 3
- 2
0
votes
0 answers
How to import data from ParAccel to HDFS
ParAccel is Analytical database (PADB). We have huge amount of data to be imported from ParAccel (PADB) to HDFS. Appreciate if someone share if any work around to export the data from PADB
0
votes
2 answers
How can I order my data as indicated?
Suppose I have some customer IDs and dates of transactions.
ID DATE
1 OCT 1
1 OCT 2
1 OCT 3
1 OCT 31
What I would like is one column showing their previous transaction date, and another showing their next transaction date (shown below).
ID…
Demetri Pananos
- 6,770
- 9
- 42
- 73
0
votes
1 answer
Get all the missing dates in a sequence of dates
I am trying to get all the missing dates in a sequence of dates which are in an ascending order. How can I do it using a simple sql without using any functions or udfs.
Input :-
2016-09-01
2016-09-02
2016-09-05
2016-09-10
Output…
Teja
- 13,214
- 36
- 93
- 155
0
votes
2 answers
How to run a single process multiple times in parallel using a UNIX shell script?
I am working on one of the MPP databases and would like to run a single SQL query using multiple sessions in python or UNIX shell script. Can somebody share your thoughts on spawning a SQL in python/UNIX utility. Any inputs would be appreciated.…
Teja
- 13,214
- 36
- 93
- 155
0
votes
1 answer
What encodings exist in ParAccel?
Anybody has a link to ParAccel documentation where I can find all column encodings that ParAccel has with description and examples for each?
Thanks!
diemacht
- 2,022
- 7
- 30
- 44
0
votes
1 answer
ASP.net Paraccel connection string
I am wondering if anyone knows how to connect an ASP.net application to paraccel? I am very new to ASP.net development, just installed visual studio. However I am tasked with creating a web service that connects to paraccel in order for another non…
user2524908
- 861
- 4
- 18
- 46
-2
votes
1 answer
How to calculate count of records between several dates
I have a table that looks like:
date name lookback_date
1995-01-31 T1 1994-10-24
1995-01-30 T1 1994-10-23
1995-01-29 T1 1994-10-22
1995-01-31 T2 1994-10-24
1995-01-30 T2 1994-10-23
1995-01-29 T2 …
user3652316
- 13
- 2