Team, A leap second will be added on June 30, 2015 23:59:60 UTC. A leap second is a second which is added to Coordinated Universal Time (UTC) in order to synchronize atomic clocks with astronomical time to within 0.9 seconds. The last leap second was added at 23:59:60 UTC on June 30, 2012. More info...

Guys,
Could someone help me with SQL query to retrieve all days of the previous month?

Regards,
Bugs.

dbadmin=> SELECT COUNT( DISTINCT PARTITION_KEY) FROM PARTITIONS WHERE table_schema='XXX' AND PROJECTION_NAME LIKE '%CALL_DETAIL%';
COUNT
-------
111
(1 row)

It's 111.

Regards,
Bhagat

Guys, We've altered the partition granularity of one of our tables to Daily, which was earlier partitioned by month. The reorganization of the table post the partition alteration failed on one of the projections. The results of the SQL below shows the operation_status as "ABORTED" for the projection...

Guys, Could you please advise the way around to cause the COPY statement to reject the record instead of aborting it. CREATE TABLE XXX_VOIP_DB_STAGE.TEMP (DATETIME TIMESTAMP); ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ COPY XXX_VOIP_DB_STAGE.TEMP ( TIME FILLER VARCHAR(10240) ,DATETIME AS TO_T...

Guys,
Could someone please suggest a resolution for the COPY statement error below:
ERROR 2559: Cannot use subquery in expressions within COPY

The problematic line in question is below:
COPY...

,NE_VERSION AS (SELECT NE_VERSION FROM <lookup table> WHERE EMS_NAME = 'xxx')

Regards,
Bugs.

select TO_TIMESTAMP_TZ('20131714001400','YYYYMMDDHH24MISS') AT TIME ZONE 'UTC'; timezone --------------------- 2014-05-16 07:14:00 (1 row) Could someone advise as to why Vertica is not failing as the Date is invalid ? "MM" component value is 17, however Vertica still transforms it to an inexplicable...