[ https://issues.apache.org/jira/browse/TRAFODION-2440?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15828597#comment-15828597 ]
ASF GitHub Bot commented on TRAFODION-2440: ------------------------------------------- Github user sandhyasun commented on a diff in the pull request: https://github.com/apache/incubator-trafodion/pull/915#discussion_r96711995 --- Diff: core/sql/exp/ExpLOBaccess.h --- @@ -515,7 +515,7 @@ class ExLob public: - char lobDataFile_[MAX_LOB_FILE_NAME_LEN]; + string lobDataFile_; // TODO: change to NAString when ExLobCursor is allocated off of an NAHeap --- End diff -- Can this not be allocated from NAString now ? The ExLob class which contains this is allocated from the executor heap. > Accessing a Hive table with long names results in error 8436 > ------------------------------------------------------------ > > Key: TRAFODION-2440 > URL: https://issues.apache.org/jira/browse/TRAFODION-2440 > Project: Apache Trafodion > Issue Type: Bug > Components: -exe, sql-exe > Affects Versions: 2.1-incubating > Reporter: David Wayne Birdsall > Assignee: David Wayne Birdsall > > If we use a long Hive database name and a long Hive table name, attempts to > select from that table from Trafodion fail with SQL error 8436. > Example: Use the following hive script to create a table via the Hive shell: > drop database if exists > Trafodion2434abcdabcdefghijabcdefghij01234567890123456789012345678901234567890123456789012345678901234567890123456789 > cascade; > create database > Trafodion2434abcdabcdefghijabcdefghij01234567890123456789012345678901234567890123456789012345678901234567890123456789 > ; > use > Trafodion2434abcdabcdefghijabcdefghij01234567890123456789012345678901234567890123456789012345678901234567890123456789 > ; > drop table if exists > ProblemTableSTR1abcdefabcdefghijabcdefghij01234567890123456789012345678901234567890123456789012345678901234567890123456789; > create table > ProblemTableSTR1abcdefabcdefghijabcdefghij01234567890123456789012345678901234567890123456789012345678901234567890123456789 > ( > Column01 int, > Column02 string > ) clustered by (Column01) sorted by (Column01) into 4 buckets row format > delimited fields terminated by '|'; > insert into > ProblemTableSTR1abcdefabcdefghijabcdefghij01234567890123456789012345678901234567890123456789012345678901234567890123456789 > values > (1,'one'); > > insert into > ProblemTableSTR1abcdefabcdefghijabcdefghij01234567890123456789012345678901234567890123456789012345678901234567890123456789 > values > (2,'two'); > insert into > ProblemTableSTR1abcdefabcdefghijabcdefghij01234567890123456789012345678901234567890123456789012345678901234567890123456789 > values > (3,'three'); > insert into > ProblemTableSTR1abcdefabcdefghijabcdefghij01234567890123456789012345678901234567890123456789012345678901234567890123456789 > values > (4,'four'); > select * from > ProblemTableSTR1abcdefabcdefghijabcdefghij01234567890123456789012345678901234567890123456789012345678901234567890123456789 > ; > exit; > Next, do the following in sqlci: > control query default HIVE_MAX_STRING_LENGTH '10'; > set schema > hive.Trafodion2434abcdabcdefghijabcdefghij01234567890123456789012345678901234567890123456789012345678901234567890123456789 > ; > showddl > ProblemTableSTR1abcdefabcdefghijabcdefghij01234567890123456789012345678901234567890123456789012345678901234567890123456789 > ; > select * from > ProblemTableSTR1abcdefabcdefghijabcdefghij01234567890123456789012345678901234567890123456789012345678901234567890123456789 > ; > This will fail as follows: > >>control query default HIVE_MAX_STRING_LENGTH '10'; > --- SQL operation complete. > >> > >>set schema > >>hive.Trafodion2434abcdabcdefghijabcdefghij01234567890123456789012345678901234567890123456789012345678901234567890123456789 > +>; > --- SQL operation complete. > >> > >>showddl > >>ProblemTableSTR1abcdefabcdefghijabcdefghij01234567890123456789012345678901234567890123456789012345678901234567890123456789 > +>; > /* Hive DDL */ > CREATE TABLE > PROBLEMTABLESTR1ABCDEFABCDEFGHIJABCDEFGHIJ01234567890123456789012345678901234567890123456789012345678901234567890123456789 > ( > COLUMN01 int > , COLUMN02 string > ) > stored as textfile > ; > --- SQL operation complete. > >> > >>select * from > >>ProblemTableSTR1abcdefabcdefghijabcdefghij01234567890123456789012345678901234567890123456789012345678901234567890123456789 > +>; > *** ERROR[8436] Mismatch detected between compiletime and runtime hive table > definitions. DataModMismatchDetails: > --- 0 row(s) selected. > >> -- This message was sent by Atlassian JIRA (v6.3.4#6332)