假设我有一个名为test
的表,它包含多列[id, name, age]
CREATE TEMPORARY VIEW binary_test AS select binary(*) AS binary_str FROM test
Function binary accepts only one argument
出错
我知道我可以调用像select binary(id) from test
这样的二进制函数,它为这一列调用它,但有没有办法从表中获取所有数据并将其放入二进制函数中?
在调用binary
之前,可以将所有列转换为单个字符串,例如,使用to_json
:
CREATE TEMPORARY VIEW binary_test AS select binary(to_json(struct(*))) AS binary_str FROM test