想在mysql中存储一些hadoop的配置,整个过程如下:create table conf (name text,path text);
load data infile '/home/ljw/core-site.txt' into table conf (path);
之后得出的结果如下:
mysql> select * from conf;
+------+-----------------------------------------------------------------+
| name| path |
+------+-----------------------------------------------------------------+
| NULL | hdfs-site.xml
| NULL | |
| NULL | dfs.replication |
| NULL | 1 |
| NULL | |
| NULL | |
| NULL | dfs.namenode.name.dir |
| NULL | file:/usr/local/hadoop/tmp/dfs/name |
+------+-----------------------------------------------------------------+
请教下大神 如何才能将其修改成如下格式??
+------+-----------------------------------------------------------------+
| name| path |
+------+-----------------------------------------------------------------+
| hdfs-site.xml | |
dfs.replication |
1 |
|
|
dfs.namenode.name.dir |
file:/usr/local/hadoop/tmp/dfs/name |
|
+------+-----------------------------------------------------------------+
就是在name这一列只显示hdfs-site.xml, path则显示hdfs-site.xml的文件内容