You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:15:27 UTC

[jira] [Created] (TRAFODION-275) LP Bug: 1320344 - delete from hive table fails with ERROR[2235]

Alice Chen created TRAFODION-275:
------------------------------------

             Summary: LP Bug: 1320344 - delete from hive table fails with ERROR[2235]
                 Key: TRAFODION-275
                 URL: https://issues.apache.org/jira/browse/TRAFODION-275
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
            Reporter: Julie Thai
            Assignee: Suresh Subbiah
            Priority: Critical


- following an insert into hive table from sqlci or trafci, select count(*) may not report accurate row count and 
- subsequent attempt to delete row fails with:
*** ERROR[2235] Compiler Internal Error: Pass one skipped, but cannot produce a plan in pass two, originated from file ../optimizer/opt.cpp at line 6813.

Encountered on workstation, datalake_64_1 v40596:MY_SQROOT=/opt/home/thaiju/datalake_64_1
who@host=thaiju@g4t3029.houston.hp.com
JAVA_HOME=/opt/home/tools/jdk1.7.0_09_64
linux=2.6.32-279.el6.x86_64
redhat=6.3
Release 0.7.0 (Build release [40596], branch 40596-project/datalake_64_1, date 16May14)


*** ERROR[8822] The statement was not prepared.


>>select count(*) from hive.hive.nation;

(EXPR)
--------------------

                  25

--- 1 row(s) selected.
>>
>>insert into hive.hive.nation values (999, 'nines name', 8888, 'eights comment');

--- 1 row(s) inserted.
>>
>>select count(*) from hive.hive.nation;

(EXPR)
--------------------

                  25

--- 1 row(s) selected.
>>
>>select n_nationkey from hive.hive.nation order by n_nationkey asc;

N_NATIONKEY
-----------

          0
          1
          2
          3
          4
          5
          6
          7
          8
          9
         10
         11
         12
         13
         14
         15
         16
         17
         18
         19
         20
         21
         22
         23
         24
        999

--- 26 row(s) selected.
>>
>>delete from hive.hive.nation where n_nationkey = 999;

*** ERROR[2235] Compiler Internal Error: Pass one skipped, but cannot produce a plan in pass two, originated from file ../optimizer/opt.cpp at line 6813.

*** ERROR[8822] The statement was not prepared.

To reproduce, see attachment, hive_del.tar:
1. in hive, create and load table nation; see hive_setup and nation.tbl files
2. in sqlci or trafci, obey traf.sql



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)