[
https://issues.apache.org/jira/browse/TRAFODION-2006?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Work on TRAFODION-2006 started by Anoop Sharma.
-----------------------------------------------
> hive table structure and data modification is not detected
> ----------------------------------------------------------
>
> Key: TRAFODION-2006
> URL: https://issues.apache.org/jira/browse/TRAFODION-2006
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: Anoop Sharma
> Assignee: Anoop Sharma
>
> If a hive table ddl structure changes or data is inserted/deleted
> after a query has been compiled, then that change is not detected.
> That results in inconsistent behavior or incorrect data to be returned.
> Examples:
> Inserted data is not returned:
> >>select * from hive.hive.th;
> --- 0 row(s) selected.
> >>insert into hive.hive.th values (1);
> --- 1 row(s) inserted.
> >>select * from hive.hive.th;
> --- 0 row(s) selected.
> Example 2: Table definition change is not detected:
> From hive shell:
> hive> drop table th;
> OK
> Time taken: 0.196 seconds
> hive> create table th (a int);
> OK
> Time taken: 0.087 seconds
> hive> insert into th values (1);
> From sqlci session:
> >>select * from hive.hive.th;
> A
> -----------
> 1
> --- 1 row(s) selected.
> Table definition is now changed from hive shell:
> hive> drop table th;
> OK
> Time taken: 0.109 seconds
> hive> create table th (a int, b int);
> OK
> Time taken: 0.091 seconds
> hive>
> Back to the previous sqlci session.
> Error is returned when the select stmt is reissued.
> It doesn't detect that table definition has changed.
> >>select * from hive.hive.th;
> *** ERROR[8442] Unable to access HDFS interface. Call to
> ExpLOBInterfaceSelectCursor/open returned error
> LOB_DATA_FILE_OPEN_ERROR(508). Error detail 0.
> --- 0 row(s) selected.
> >>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
