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:17:11 UTC
[jira] [Created] (TRAFODION-498) LP Bug: 1352564 - select from hive
reurn an error when hive table ctreated with Lines terminted by is
specified
Alice Chen created TRAFODION-498:
------------------------------------
Summary: LP Bug: 1352564 - select from hive reurn an error when hive table ctreated with Lines terminted by is specified
Key: TRAFODION-498
URL: https://issues.apache.org/jira/browse/TRAFODION-498
Project: Apache Trafodion
Issue Type: Bug
Components: sql-exe
Reporter: Apache Trafodion
Assignee: Apache Trafodion
Priority: Critical
Fix For: 0.9 (pre-incubation)
select from hive reurn an error when hive table created with Lines terminted by is specified
example :
select * from time_dim2: will retun and error when LINES TERMINATED BY '\n' is specified
CREATE TABLE time_dim2(T_TIME_SK INT,
T_TIME_ID STRING,
T_TIME INT,
T_HOUR INT,
T_MINUTE INT,
T_SECOND INT,
T_AM_PM STRING,
T_SHIFT STRING,
T_SUB_SHIFT STRING,
T_MEAL_TIME STRING,
SCALE INT)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n';
if we create the table without specifying LINES TERMINATED BY '\n' the query succeeds
Assigned to LaunchPad User khaled Bouaziz
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)