Search found 13 matches
- Wed Dec 11, 2013 6:11 pm
- Forum: Vertica Database Administration
- Topic: error happens while adding a new disk to an existing DB
- Replies: 2
- Views: 5628
error happens while adding a new disk to an existing DB
Hi. I got an below error message while adding new disk space to the existing working Vertica. Can anyone help regarding this error message? vertica=> SELECT ADD_LOCATION ('/hdd_mnt/storage/', 'v_vertica_node0001'); ERROR 3457: Function ADD_LOCATION(unknown, unknown) does not exist, or permission is ...
- Thu Nov 14, 2013 2:33 am
- Forum: Vertica SQL
- Topic: counting the number of consecutive number in multiple rows.
- Replies: 3
- Views: 7344
Re: counting the number of consecutive number in multiple ro
Hi sKwa and knicely87,
Both suggestions work like charm Thank you very much!!
Both suggestions work like charm Thank you very much!!
- Wed Nov 13, 2013 8:11 pm
- Forum: Vertica SQL
- Topic: counting the number of consecutive number in multiple rows.
- Replies: 3
- Views: 7344
counting the number of consecutive number in multiple rows.
Hi, I want to count the number of consecutive int value spread through out multiple rows. For example. => select * from kyle order by value; value ------- 1 2 5 6 7 10 12 13 (8 rows) In the table, I want to count the number of consecutive value tuple - (1,2) (5,6,7) (12,13) with the final output as ...
- Tue Nov 12, 2013 11:58 pm
- Forum: Vertica User Defined Functions (UDFs)
- Topic: a method to reset PartitionReaer
- Replies: 2
- Views: 15140
Re: a method to reset PartitionReaer
Hi sKwa, What I tried to do is that in the first do-while loop, I scan the entire rows to create the overall data-distribution. In the second do-while loop, I do a real computation using the input rows and data-distribution calculated in the first do-while block. For the time-being, I do it by stori...
- Tue Nov 12, 2013 8:43 pm
- Forum: Vertica User Defined Functions (UDFs)
- Topic: a method to reset PartitionReaer
- Replies: 2
- Views: 15140
a method to reset PartitionReaer
Hi I got a question while writing a UDF with C++ language. Is there a API to reset the PartitionReader iterator? In the below code, virtual void processPartition(ServerInterface &srvInterface, PartitionReader &input_reader, PartitionWriter &output_writer) { do{ // do something with input_reader } wh...
- Tue Nov 12, 2013 3:11 pm
- Forum: Vertica SQL
- Topic: using group by with range restriction
- Replies: 2
- Views: 6703
Re: using group by with range restriction
Thanks for the reply, sKwa. I didn't know about "decode", and it seems to be very helpful for general purpose. You are right, the group by is not possible for a range of values, but I could find out another trick to do that using width_bucket function in Vertica. In the above example, I can do the f...
- Mon Nov 11, 2013 11:32 pm
- Forum: Vertica SQL
- Topic: using group by with range restriction
- Replies: 2
- Views: 6703
using group by with range restriction
Hi, I have a question regarding aggregation using group by. Assuming I have a below table start | end | value 1 | 2 | 10 2 | 4 | 6 4 | 5 | 4 5 | 8 | 8 8 | 10 | 5 In the above table, I want to get sum of (1~5) and (5~10) of start and end value assuming that start and end value represents time interva...