mysql - hive 使用从另一个表中选择的内容更新表列

Question

所有，这在 hive 中是否可能，如果可以的话，这是最好的方法是什么？谢谢!

    UPDATE t1
    SET
    Y = SQRT(Y_w)*(Y-(SELECT v FROM t2 WHERE ID=1)),
    X1 = SQRT(Y_w)*(X1-(SELECT v1 FROM t2 WHERE ID=1)),
    X2 = SQRT(Y_w)*(X2-(SELECT v2 FROM t2 WHERE ID=1)),
    X3 = SQRT(Y_w)*(X3-(SELECT v3 FROM t2 WHERE ID=1)),
    X4 = SQRT(Y_w)*(X4-(SELECT v4 FROM t2 WHERE ID=1)),
    X5 = SQRT(Y_w)*(X5-(SELECT v5 FROM t2 WHERE ID=1)),
    X6 = SQRT(Y_w)*(X6-(SELECT v6 FROM t2 WHERE ID=1)),
    X7 = SQRT(Y_w)*(X7-(SELECT v7 FROM t2 WHERE ID=1)),
    X8 = SQRT(Y_w)*(X8-(SELECT v8 FROM t2 WHERE ID=1));

Answer 1

请验证您的查询。仅当 t1 具有 w 列且 t2 具有 id 列时，它才有效。