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

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 <[EMAIL PROTECTED]> 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

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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>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
>