hadoop - Hive - 使用不包括行终止符的文本文件创建外部表

Question

我想用一组文本文件创建一个外部表。每行应该是一个文本文件。一个文本文件的示例如下，可以有多个文本文件。(文件存储在HDFS中)

thanking 
you 
for 
the 
participation 

行由 /n 终止。我想用上面的文本文件创建一个外部表，文本文件中的数据应该在一行(一个单元格)中。

我尝试了以下创建表语句。

Create External table if not exists sample_email(
  email STRING
)
STORED AS TEXTFILE
LOCATION '/tmp/txt/sample/';

它会给出创建表如下。

+--------------------------------------+
+   email                              +
+--------------------------------------+
+ thanking                             +
+--------------------------------------+
+ you                                  +
+--------------------------------------+
+ for                                  +
+--------------------------------------+
+ the                                  +
+--------------------------------------+
+participation                         +
+--------------------------------------+
+please                                +
+--------------------------------------+
+find                                  +
+--------------------------------------+
+the                                   +
+--------------------------------------+
+discussed                             +
+--------------------------------------+
+points                                +
+--------------------------------------+

但我想要如下。

+--------------------------------------+
+   email                              +
+--------------------------------------+
+ thanking you for the participation   +
+--------------------------------------+
+ please find the discussed points     +
+--------------------------------------+

如何解决我的问题？提前谢谢你

Answer 1

select      concat_ws(' ',collect_list(email))  as emails
from        sample_email
group by    input__file__name

---

+------------------------------------+
|               emails               |
+------------------------------------+
| thanking you for the participation |
| please find the discussed points   |
+------------------------------------+