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' -

html - Outlook 2010 Anchor (url/address/link) -

javascript - Why does running this loop 9 times take 100x longer than running it 8 times? -