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)