如何从 HIVE 表中进行选择并使用分隔符分隔列

How to select from HIVE tables and separate columns with a delimitator?

本文关键字：分隔符分隔选择行选 HIVE | 更新日期: 2023-09-27

文件"，我想知道是否可以从这个表格中进行选择并用";"分隔每一列？

$sqlSearchByString = "SELECT fileName as name, description, dimension
                      FROM {$tableName}
                      WHERE fileName LIKE '%{$searchedWord}%'
                      OR description LIKE '%{$searchedWord}%'";
$this->client->execute($sqlSearchByString);
$result = $this->client->fetchAll();

文档很糟糕，或者我只是没有看到他们在哪里列出方法，但这应该是正确的轨道：

foreach($this->client->fetchAll() as $row) {
    $result[] = implode(';', $row);
}