Hello all, Hive is complaning when I try to import a csv into a table I created called "stocks." The table is set up as follows: hive> describe stocks; OK exchng string symbol string ymd string price_open float price_high float price_low float price_close float volume int price_adj_close float Then I try to load data from a csv as follows: hive> load data inpath '/user/data/stocks/stocks.csv' > overwrite into table human_resources.stocks; I then get the following error: Loading data to table human_resources.stocks Failed with exception Unable to move source hdfs://quickstart.cloudera:8020/user/data/stocks/stocks.csv to destination hdfs://quickstart.cloudera:8020/user/data/stocks/stocks.csv FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask hive> describe table stocks; FAILED: SemanticException [Error 10001]: Table not found table I don't think that the file is corrupted. You can see the file in the link below and it's just a normal csv file - in fact, it was provided by the author of the Hive book I'm working through. http://www.vaughn-s.net/hadoop/stocks.csv The image file I'm using is cloudera-quickstart-vm-5.10.0-0-vmware, I'm not sure if I need to update or not.
... View more
