0

I am trying to update an iceberg table on Athena joined with another table

My script:

UPDATE sampledb.icbg_tenure_20220905 a INNER JOIN sampledb.cit_update b ON a.msisdn_hash = b.msisdn_hash SET a.activation_date = b.activationdate

Getting error message:

line 1:38: mismatched input 'a'. Expecting: '.', 'SET'

Update iceberg table on athena joined with another table

c0ng111
  • 31
  • 3
  • What values you are planning to update? you should have set keyword immediately after update table and you need to pass the SQL statement with join condition to a sub query or later part of the query – Prabhakar Reddy Sep 09 '22 at 15:40
  • I would like to update the activation_date value from icbg_tenure_20220905 to activation_date value of cit_update – c0ng111 Sep 11 '22 at 23:20

0 Answers0