[
https://issues.apache.org/jira/browse/TRAFODION-275?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Atanu Mishra closed TRAFODION-275.
----------------------------------
Resolution: Fixed
Assignee: (was: Suresh Subbiah)
Fix Version/s: 1.0 (pre-incubation)
> 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
> Priority: Critical
> Fix For: 1.0 (pre-incubation)
>
>
> - 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@[email protected]
> 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)
