The data types are the same. In fact, the statement works the first time, but not the second (I change a WHERE constraint to give different data).
I presume it is some invalid data, but is there any way to find a clue in a log file? On 9 January 2013 13:21, Nitin Pawar <nitinpawar...@gmail.com> wrote: > can you give table definition of both the tables? > > are both the columns of same type ? > > > On Wed, Jan 9, 2013 at 5:15 AM, Krishna Rao <krishnanj...@gmail.com>wrote: > >> Hi all, >> >> On running a statement of the form "INSERT INTO TABLE tbl1 PARTITION(p1) >> SELECT x1 FROM tbl2", I get the following error: >> >> "Failed with exception java.lang.ClassCastException: >> org.apache.hadoop.hive.metastore.api.InvalidOperationException cannot be >> cast to java.lang.RuntimeException" >> >> How can I find out what is causing this error? I.e. which logs should I >> look at? >> >> Cheers, >> >> Krishna >> >> >> > > > -- > Nitin Pawar >