gpt4 book ai didi

hadoop - 需要从行记录中逐列输出

转载 作者:行者123 更新时间:2023-12-02 21:39:00 25 4
gpt4 key购买 nike

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.

最佳答案

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

输入:2015 Apr 20 15:29:49.128 [00] 0xB112保留当前不支持此数据包。
select concat_ws('|', timestamps, hexstring, message) from tableName;

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

关于hadoop - 需要从行记录中逐列输出,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/30094774/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com