FAILED: ParseException line 1:65 cannot recognize input near 'row' 'formatted' 'delimited' in table row format specification

hive报FAILED: ParseException line 1:65 cannot recognize input near 'row' 'formatted' 'delimited' in table row format specification

?

1 2 3 4

错误语句： insert overwrite local directory '/home/ljpbd/datas/student' row formatted delimited fields terminated by '\t' select id,name from student; 正确语句： insert overwrite local directory '/home/ljpbd/datas/student' row format delimited fields terminated by '\t' select id,name from student;

 

?

1 2 3 4 5 6 7

正确语法：INSERT OVERWRITE [LOCAL] DIRECTORY directory   [ROW FORMAT row_format] [STORED AS file_format] select_statement; <strong>注意事项：保存的文件夹中不可有其他文件，会被清空；</strong>   例子：可以将数据保存成json格式 insert overwrite local directory '/opt/module/datas/student' ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.JsonSerDe' select id,name from student;<br>输出格式：<br>{"_col0":1001,"_col1":"student1"}<br>{"_col0":1002,"_col1":"student2"}<br>{"_col0":1003,"_col1":"student3"}<br>{"_col0":1004,"_col1":"student4"}<br>{"_col0":1005,"_col1":"student5"}<br>{"_col0":1006,"_col1":"student6"}<br>{"_col0":1007,"_col1":"student7"}<br>{"_col0":1008,"_col1":"student8"}<br>{"_col0":1009,"_col1":"student9"}<br><br>