You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by naveen mahadevuni <nm...@gmail.com> on 2016/09/14 10:25:12 UTC

Hive ACID table error

Hi,

I'm using Hive 1,.2. From a non-ACID hive session, I performed the
following operations and Hive reports 'serious problem'.

CREATE TABLE test5(
  i int,
  j int)
CLUSTERED BY (i) INTO 8 BUCKETS
STORED AS ORC
TBLPROPERTIES ('transactional'='true');

insert into test5 values(1,2);
insert into test5 values(3,4);

select * from test5; -- Fails reporting serious problem.

*-->Failed with exception java.io.IOException:java.lang.RuntimeException:
serious problem*

Hive documents "Reading/writing to an ACID table from a non-ACID session is
not allowed.". Can a better message be reported rather than 'serious
problem'?

Thanks,
Naveen

Re: Hive ACID table error

Posted by naveen mahadevuni <nm...@gmail.com>.
Looks like this has been addressed in HIVE-11716
<https://issues.apache.org/jira/browse/HIVE-11716>.

Thanks,
Naveen

On Thu, Sep 15, 2016 at 5:41 AM, Eugene Koifman <ek...@hortonworks.com>
wrote:

> There should be a full stack trace somewhere either in the client side log
> on the job logs.
> ³serious error² is usually ORC complaining about some sort of data
> corruption.
>
> On 9/14/16, 11:16 AM, "naveen mahadevuni" <nm...@gmail.com> wrote:
>
> >Hi Wei,
> >I'm using the hive shell.
> >
> >Thanks,
> >Naveen
> >
> >On Wed, Sep 14, 2016 at 8:01 PM, Wei Zheng <wz...@hortonworks.com>
> wrote:
> >
> >> Hi Naveen,
> >>
> >> Which client are you using? Beeline?
> >>
> >> Thanks,
> >> Wei
> >>
> >> On 9/14/16, 18:25, "naveen mahadevuni" <nm...@gmail.com> wrote:
> >>
> >>     Hi,
> >>
> >>     I'm using Hive 1,.2. From a non-ACID hive session, I performed the
> >>     following operations and Hive reports 'serious problem'.
> >>
> >>     CREATE TABLE test5(
> >>       i int,
> >>       j int)
> >>     CLUSTERED BY (i) INTO 8 BUCKETS
> >>     STORED AS ORC
> >>     TBLPROPERTIES ('transactional'='true');
> >>
> >>     insert into test5 values(1,2);
> >>     insert into test5 values(3,4);
> >>
> >>     select * from test5; -- Fails reporting serious problem.
> >>
> >>     *-->Failed with exception java.io.IOException:java.lang.
> >> RuntimeException:
> >>     serious problem*
> >>
> >>     Hive documents "Reading/writing to an ACID table from a non-ACID
> >> session is
> >>     not allowed.". Can a better message be reported rather than 'serious
> >>     problem'?
> >>
> >>     Thanks,
> >>     Naveen
> >>
> >>
> >>
>
>

Re: Hive ACID table error

Posted by Eugene Koifman <ek...@hortonworks.com>.
There should be a full stack trace somewhere either in the client side log
on the job logs.
³serious error² is usually ORC complaining about some sort of data
corruption.

On 9/14/16, 11:16 AM, "naveen mahadevuni" <nm...@gmail.com> wrote:

>Hi Wei,
>I'm using the hive shell.
>
>Thanks,
>Naveen
>
>On Wed, Sep 14, 2016 at 8:01 PM, Wei Zheng <wz...@hortonworks.com> wrote:
>
>> Hi Naveen,
>>
>> Which client are you using? Beeline?
>>
>> Thanks,
>> Wei
>>
>> On 9/14/16, 18:25, "naveen mahadevuni" <nm...@gmail.com> wrote:
>>
>>     Hi,
>>
>>     I'm using Hive 1,.2. From a non-ACID hive session, I performed the
>>     following operations and Hive reports 'serious problem'.
>>
>>     CREATE TABLE test5(
>>       i int,
>>       j int)
>>     CLUSTERED BY (i) INTO 8 BUCKETS
>>     STORED AS ORC
>>     TBLPROPERTIES ('transactional'='true');
>>
>>     insert into test5 values(1,2);
>>     insert into test5 values(3,4);
>>
>>     select * from test5; -- Fails reporting serious problem.
>>
>>     *-->Failed with exception java.io.IOException:java.lang.
>> RuntimeException:
>>     serious problem*
>>
>>     Hive documents "Reading/writing to an ACID table from a non-ACID
>> session is
>>     not allowed.". Can a better message be reported rather than 'serious
>>     problem'?
>>
>>     Thanks,
>>     Naveen
>>
>>
>>

Re: Hive ACID table error

Posted by naveen mahadevuni <nm...@gmail.com>.
Hi Wei,
I'm using the hive shell.

Thanks,
Naveen

On Wed, Sep 14, 2016 at 8:01 PM, Wei Zheng <wz...@hortonworks.com> wrote:

> Hi Naveen,
>
> Which client are you using? Beeline?
>
> Thanks,
> Wei
>
> On 9/14/16, 18:25, "naveen mahadevuni" <nm...@gmail.com> wrote:
>
>     Hi,
>
>     I'm using Hive 1,.2. From a non-ACID hive session, I performed the
>     following operations and Hive reports 'serious problem'.
>
>     CREATE TABLE test5(
>       i int,
>       j int)
>     CLUSTERED BY (i) INTO 8 BUCKETS
>     STORED AS ORC
>     TBLPROPERTIES ('transactional'='true');
>
>     insert into test5 values(1,2);
>     insert into test5 values(3,4);
>
>     select * from test5; -- Fails reporting serious problem.
>
>     *-->Failed with exception java.io.IOException:java.lang.
> RuntimeException:
>     serious problem*
>
>     Hive documents "Reading/writing to an ACID table from a non-ACID
> session is
>     not allowed.". Can a better message be reported rather than 'serious
>     problem'?
>
>     Thanks,
>     Naveen
>
>
>

Re: Hive ACID table error

Posted by Wei Zheng <wz...@hortonworks.com>.
Hi Naveen,

Which client are you using? Beeline?

Thanks,
Wei

On 9/14/16, 18:25, "naveen mahadevuni" <nm...@gmail.com> wrote:

    Hi,
    
    I'm using Hive 1,.2. From a non-ACID hive session, I performed the
    following operations and Hive reports 'serious problem'.
    
    CREATE TABLE test5(
      i int,
      j int)
    CLUSTERED BY (i) INTO 8 BUCKETS
    STORED AS ORC
    TBLPROPERTIES ('transactional'='true');
    
    insert into test5 values(1,2);
    insert into test5 values(3,4);
    
    select * from test5; -- Fails reporting serious problem.
    
    *-->Failed with exception java.io.IOException:java.lang.RuntimeException:
    serious problem*
    
    Hive documents "Reading/writing to an ACID table from a non-ACID session is
    not allowed.". Can a better message be reported rather than 'serious
    problem'?
    
    Thanks,
    Naveen