sql - How to load data into Hive table -

sql - How to load data into Hive table -

i'm using hortonworks's hue (more gui interface connects hdfs, hive, pig together)and want load info within hdfs current created table. suppose table's name "test", , file contains data, path is: /user/hdfs/test/test.txt"

but i'm unable load info table, tried:

load info local inpath '/user/hdfs/test/test.txt' table test

but there's error said can't find file, there's no matching path.

i'm still confused. suggestions?

thanks

as said "load info within hdfs current created table". in command using :

load info local inpath '/user/hdfs/test/test.txt' table test

using local keyword looks file in local filesystem. file in hdfs.

i think need remove local keyword command.

hope helps...!!!

sql hive