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

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

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

Getting gateway time-out Rails app with Nginx + Puma running on Digital Ocean -