Re: Find out what's causing an InvalidOperationException

2013-01-09 Thread Krishna Rao
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 wrote: > can you give ta

Re: Find out what's causing an InvalidOperationException

2013-01-09 Thread Nitin Pawar
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 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 ex

Find out what's causing an InvalidOperationException

2013-01-09 Thread Krishna Rao
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