[
https://issues.apache.org/jira/browse/TRAFODION-1453?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14715226#comment-14715226
]
Selvaganesan Govindarajan commented on TRAFODION-1453:
------------------------------------------------------
The table in option 1 was not created with correct encoding for some columns
and that resulted in junk or null characters to be seen in textnputHiveTable.
Fixed the correct mapping and we are able to see proper values from this table
in hive. But select * from hive.hive.textInputHiveTable in Trafodion didn't see
any rows. This was due to null byte in string column values. Hive can skip past
the null byte in String columns but Trafodion didn't
> A null character in hive TEXTFILE format is not reported as an error
> --------------------------------------------------------------------
>
> Key: TRAFODION-1453
> URL: https://issues.apache.org/jira/browse/TRAFODION-1453
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Affects Versions: 0.6 (pre-incubation)
> Reporter: Selvaganesan Govindarajan
> Fix For: 2.0-incubating
>
>
> Trafodion engine expects the data in hive TEXTFILE format shouldn't have any
> null character. Currently, Trafodion supports only ISO88591 and UTF8
> character set string data only. When there is a null characterthe engine
> continues to read all the data without producing any output.
> An error should be reported instead.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
