Hi Manish, Thank you for your response. I can't really see why this would happen as we used the same format in an other cluster that worked well. Is this a version problem? We do actually have a date field in the rows.
Best regards, Robin Verlangen *Software engineer* * * W http://www.robinverlangen.nl E ro...@us2.nl Disclaimer: The information contained in this message and attachments is intended solely for the attention and use of the named addressee and may be confidential. If you are not the intended recipient, you are reminded that the information remains the property of the sender. You must not use, disclose, distribute, copy, print or rely on this e-mail. If you have received this message in error, please contact the sender immediately and irrevocably delete this message and any copies. 2012/9/17 Manish.Bhoge <manish.bh...@target.com> > Robin,**** > > ** ** > > I think this is type casting issue with date column. Can you send the > table definition and sample data then it would be easy to figure out where > it is giving datatype issue?**** > > ** ** > > My suggestion is to create a staging table first where you dump the data > considering all the column as STRING and run some data profiling to > identify how my final table should look like, I mean what would be datatype > in final table. Does this make sense ?**** > > ** ** > > Thanks,**** > > Manish**** > > ** ** > > *From:* Robin Verlangen [mailto:ro...@us2.nl] > *Sent:* Monday, September 17, 2012 3:17 PM > *To:* user@hive.apache.org > *Subject:* Problem importing data**** > > ** ** > > Hi there,**** > > ** ** > > We're trying to load in lots of data into Hive, however the import command > fails:**** > > ** ** > > *WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. > Please use org.apache.hadoop.log.metrics.EventCounter in all the > log4j.properties files.***** > > *Logging initialized using configuration in > jar:file:/usr/lib/hive/lib/hive-common-0.8.1-cdh4.0.1.jar!/hive-log4j.properties > ***** > > *Hive history file=/tmp/root/hive_job_log_root_201209171144_892417749.txt* > **** > > *Copying data from file:/root/tmpdatasiphon/1347875082.txt***** > > *Copying file: file:/root/tmpdatasiphon/1347875082.txt***** > > *Loading data to table mytable.standard_feed partition (bdate=2012-09-14)* > **** > > *Failed with exception java.lang.ClassCastException: > org.apache.hadoop.hive.metastore.api.InvalidOperationException cannot be > cast to java.lang.RuntimeException***** > > *FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.MoveTask***** > > *Oops, exit with status 9***** > > ** ** > > Does anyone have a clue? Permissions are like this:**** > > ** ** > > *[root@mymachine ~]# hdfs dfs -ls /user/hive/***** > > *Found 2 items***** > > *drwxrwxrwx - hdfs supergroup 0 2012-09-17 11:15 /user/hive/tmp > ***** > > *drwxrwxrwx - hdfs supergroup 0 2012-09-17 11:18 > /user/hive/warehouse***** > > > Best regards, **** > > ** ** > > Robin Verlangen**** > > *Software engineer***** > > ** ** > > W http://www.robinverlangen.nl**** > > E ro...@us2.nl**** > > ** ** > > Disclaimer: The information contained in this message and attachments is > intended solely for the attention and use of the named addressee and may be > confidential. If you are not the intended recipient, you are reminded that > the information remains the property of the sender. You must not use, > disclose, distribute, copy, print or rely on this e-mail. If you have > received this message in error, please contact the sender immediately and > irrevocably delete this message and any copies.**** > > ** ** >
