Hi All, I am a hive newbie. LOAD DATA *LOCAL* INPATH 'filepath' [OVERWRITE] INTO TABLE tablename
When I use LOCAL keyword does hive create a hdfs file for it? I used above statement to put data into a hive table. But I could not see any hdfs file in my hive.metastore.warehouse.dir (which comes from hive-default.xml /user/hive/warehouse/ ). Although when I did FROM a INSERT OVERWRITE TABLE b PARTITION(dt='2011-01-06') SELECT * I see hdfs file is created. Am I missing something? Can somebody please explain?
