[jira] [Work started] (TRAFODION-2006) hive table structure and data modification is not detected

["Anoop Sharma (JIRA)" <ji...@apache.org>]

     [ 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)