Hello, I need to change Partition on table in Vertica 5.1. According to manual in Vertica 6, it can be done like: alter table event PARTITION BY ((((date_part('year', event at timezone 'UTC') * 10000) + (date_part('month', event at timezone 'UTC') * 100)) + date_part('day', event at timezone 'UTC'))...

Hi, i'm trying to find any information about locks for table. i'm interested in next case - will select queries work if we inserting data from csv file to Vertica. CSV file will have ~100000 rows. if not, is it possible to avoid this lock? case question if we will do something like: insert into sche...

Hi, i'm looking for the way(best way :) ) to get last day in the current year and last day in current quarter. for last year I created next SQL: SELECT TO_TIMESTAMP('31 Dec ' || TO_CHAR(my_date, 'YYYY') || ' 23:59:59', 'DD Mon YYYY HH:MI:SS') as dt_last_year_day FROM my_table. where my_date is a col...

Hi, i'm trying to get last/ first value from column A, but I need to do it per value in column B. e.g. I have next table (select * from test1): Id Conv_id Agent_id Channnel_id 1 1 1 1 2 1 2 1 3 1 1 2 6 2 1 1 7 2 2 1 8 2 3 1 4 1 3 2 5 1 4 2 9 2 2 2 I need to find last Agent_id per Conv_id. I understa...

Hi guys,
thank you for your help!

Jim, i'm interested in your answer.
could you please explain why do you add
FROM tables
CROSS JOIN columns
as I see I can use only FROm table which will give ne the same result.

Hi Rick, not exactly, I want to same a table (system or virtual) with will have date from last 2 years till future(e.g. 2 years). and if last date < 1 year in table, Vertica will automatically create new rows for 2 year more. and the second condition is - DATEDIFF should be 15 min between records. i...

Hello, i'm new vertica. Correctly i'm resorting possibly to create a system table (table which will be automatically add new row) for time periods. time difference between records for example 30 min. the general view if table like: date/time in 24H format; date/time in 12 H format; hours ; minute,.....