Search found 13 matches

by kyle
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: 5592

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 ...
by kyle
Thu Nov 14, 2013 2:33 am
Forum: Vertica SQL
Topic: counting the number of consecutive number in multiple rows.
Replies: 3
Views: 7280

Re: counting the number of consecutive number in multiple ro

Hi sKwa and knicely87,

Both suggestions work like charm :D Thank you very much!!
by kyle
Wed Nov 13, 2013 8:11 pm
Forum: Vertica SQL
Topic: counting the number of consecutive number in multiple rows.
Replies: 3
Views: 7280

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 ...
by kyle
Tue Nov 12, 2013 11:58 pm
Forum: Vertica User Defined Functions (UDFs)
Topic: a method to reset PartitionReaer
Replies: 2
Views: 14860

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...
by kyle
Tue Nov 12, 2013 8:43 pm
Forum: Vertica User Defined Functions (UDFs)
Topic: a method to reset PartitionReaer
Replies: 2
Views: 14860

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...
by kyle
Tue Nov 12, 2013 3:11 pm
Forum: Vertica SQL
Topic: using group by with range restriction
Replies: 2
Views: 6297

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...
by kyle
Mon Nov 11, 2013 11:32 pm
Forum: Vertica SQL
Topic: using group by with range restriction
Replies: 2
Views: 6297

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...

Go to advanced search