But when I run thisDELETE statements support subqueries and joins, which is useful for deleting values in a table
based on values that are stored in other tables. See the Examples section below.
Code: Select all
delete aa.* from account_metric_agg aa
inner join metric_agg_stg_csi c on c.csi = account_metric_agg.csi and c.accmess = 1
where aa.updatetime < '2015-02-06 11:31:36'
Code: Select all
DELETE FROM aa. not successful
An error occurred when executing the SQL command:
delete aa.* from account_metric_agg aa
inner join metric_agg_stg_csi c on c.csi = account_metric_agg.csi and c.accmess = 1
where aa.updatetime < '2015...
[Vertica][VJDBC](4856) ERROR: Syntax error at or near "aa" [SQL State=42601, DB Errorcode=4856]
Execution time: 0.01s
1 statement failed.