You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/05/18 22:31:12 UTC
[jira] [Commented] (TRAFODION-2002) Missing column checks when
inserting into Hive table
[ https://issues.apache.org/jira/browse/TRAFODION-2002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15289991#comment-15289991 ]
ASF GitHub Bot commented on TRAFODION-2002:
-------------------------------------------
GitHub user zellerh opened a pull request:
https://github.com/apache/incubator-trafodion/pull/490
TRAFODION-2002 check columns for Hive inserts
Also TRAFODION-1904 column list in insert/select into Hive table is ignored
Added checks for matching number and data types, so that the
data to be inserted matches the column layout of the Hive target
table.
Using a column list for insert into a Hive table now will raise
SQL error 4223 instead of being ignored (so it is still not supported).
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/zellerh/incubator-trafodion bug/1910
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/490.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #490
----
commit 3205c6a2470146297ea5215a3e82eab6b74c1541
Author: Hans Zeller <hz...@apache.org>
Date: 2016-05-18T22:25:21Z
TRAFODION-2002 check columns for Hive inserts
Also TRAFODION-1904 column list in insert/select into Hive table is ignored
Added checks for matching number and data types, so that the
data to be inserted matches the column layout of the Hive target
table.
Using a column list for insert into a Hive table now will raise
SQL error 4223 instead of being ignored (so it is still not supported).
----
> Missing column checks when inserting into Hive table
> ----------------------------------------------------
>
> Key: TRAFODION-2002
> URL: https://issues.apache.org/jira/browse/TRAFODION-2002
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmp
> Affects Versions: 1.2-incubating
> Environment: Any
> Reporter: Hans Zeller
> Assignee: Hans Zeller
> Fix For: 2.1-incubating
>
>
> Anoop found this problem: There are no checks when we insert into Hive tables, the SELECT list could have more or fewer columns than the Hive target table, and the types of the columns could be incompatible. Example:
> -- in Hive:
> drop table tph;
> create table tph (a int, b int);
> -- in Trafodion
> insert into hive.hive.tph values (1,1,1);
> select * from tph;
> -- shows two columns
> insert into hive.hive.tph values(1);
> select * from tph;
> -- those may cause a core dump
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)