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

Popular posts from this blog

java - WARN : org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/board/] in DispatcherServlet with name 'appServlet' -

android - How to create dynamically Fragment pager adapter -

1111. appearing after print sequence - php -