Hi All, Normal table out put; x | y ----------+---------- 12:40:23 | 12:40:23 14:40:25 | 14:45:00 | 14:49:55 | | 14:00:00 (5 rows) Full outer join with interpolation: SELECT * FROM t FULL OUTER JOIN t1 ON t.x INTERPOLATE PREVIOUS VALUE t1.y; x | y ----------+---------- 12:40:23 | 12:40:23 12:40:23 |...

Thank you

Hi All, 1)Why vertica is called Hybrid Storage Model. All because it has Wos and Ros. Is it so ? 2) We have K safe levels in Vertica. K-level Number of Nodes Required 0 1+ 1 3+ 2 5+ K (K+1)/2 What is K here? Does it mean the levels(0,1,2,3...k). if subsitute 2 to k then (2+1)/2 , how is it possible ...

Thanks

This post helped to acheive my goal.

HI all, How to access the database and quries through the procedures. The following one i tried to access , but I couldnt get the exact out put. ShellScript: #!/bin/bash vsql -c "select MFR_PART_KEY from vmro.DIM_ATA limit 10;" exit 0 Creating procedure: dbadmin=> create procedure query(arg1 varchar...

HI dbadmin=> select * from dim_period where dater= '2013-05-01 00:00:00'; DAY | MONTH | YEAR | DATER | QUARTER -----+-------+------+---------------------+--------- 1 | May | 2013 | 2013-05-01 00:00:00 | Q2 (1 row) The above query returns the output according to the condition pre-specified. But I wan...

Hi ,

Thanks a lot.

But i need some clarification here.

in the line which i have posted contain floor,cast, convert , datediff.
Does ageinyears meet all the requirement . we have datediff and ageinyears as different functions in vertica.

pls explain.

Thanks,
Malar