score:1

Accepted answer

i found the answer by myself actually the :

row format delimited fields terminated by ' ';

determinate the format of the rows in the "file.txt" that we are going to load in the table and hive’s default record and field delimiters list is :

\n

^a

^b

^c

press ^v^a could insert a ^a in vim.

or you can just do: create table tablename (key int, value string) row format delimited fields terminated by ' ';

and the 'file.txt' should be like this:

value1 value2
value3 value4

in this example value1 and value3 represent the key and value4 and value5 represent the value


Related Query

More Query from same tag