UPDATE

    1. UPDATE users SET name = 'Francisco' WHERE id=1;
    • Right now only Hive Connector and transactional ORC table support UPDATE.
    • Direct column reference is supported, but NOT expression with column reference.
    • cannot be applied to view.
    • UPDATE dose not support implicitly data type conversion, please use CAST when value does not match target column’s data type.