csv - ParseException Missing TABLE -
i created mytable
table in mydb, , when show tables on db see mytable
.
however, when do:
load data inpath '/my/hdfs/path/myfile.csv' overwrite mydb.mytable;
i
parseexception line 1:73 missing table @ 'mydb' near '<eof>'
i can describe on table, , see headers.
but how data myfile.csv
hive table?
in query table key missing.so,instead of
load data inpath '/my/hdfs/path/myfile.csv' overwrite mydb.mytable;
use this---->
use mydb; load data inpath '/my/hdfs/path/myfile.csv' overwrite table mytable;
Comments
Post a Comment