需要按行记录按列输出

6yoyoihd  于 2021-06-02  发布在  Hadoop
关注(0)|答案(1)|浏览(283)
2015 Apr 20  15:29:49.128  [00]  0xB112  Reserved
    This packet is currently not supported.

我想要这样


**timestamps**            |**hexstring**|  **message**

2015 Apr 20  15:29:49.128   |0xB112         |  Reserved This packet is currently not supported.
vu8f3i0k

vu8f3i0k1#

Use concat_ws() to concatenate any delimiter (e.g. '|') as given below in the query.

输入:2015年4月20日15:29:49.128[00]0xb112保留当前不支持此数据包。

select concat_ws('|', timestamps, hexstring, message) from tableName;

输出:2015年4月20日15:29:49.128 |[00]0xb112 |保留当前不支持此数据包。

相关问题