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