Thank you for your answer.
I’m using ORC transactional table right now. But i’m not stuck with that. When
I send an SQL statement like the following, where old_5sek_agg and new_5sek_agg
are registered temp tables, I’ll get an exception in spark. Same without
subselect.
sqlContext.sql("DELETE FROM old_5sek_agg WHERE Sec in (SELECT Sec FROM
new_5sek_agg)")
When I execute the statement directly in hive ambari view, I don’t get
exceptions, indeed I get a success info, but the pointed row won’t be deleted
or updated by UPDATE statement.
I’m not familiar with your op_type and op_time approach and couldn’t find any
useful resources by quickly asking google, but it sounds promising.
Unfortunately your answer seems to be cut off in the middle of your example.
Would you really update the value of those two additional columns and if so,
how would you do this when it’s not a ORC transactional table.
Thanks again!
Am 25.08.2016 um 01:24 schrieb Mich Talebzadeh
<mich.talebza...@gmail.com<mailto:mich.talebza...@gmail.com>>:
Dr Mich Talebzadeh
