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)