You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tajo.apache.org by "JaeHwa Jung (JIRA)" <ji...@apache.org> on 2013/12/19 05:39:06 UTC

[jira] [Work started] (TAJO-431) HCatalogStore can't write any data using INSERT OVERWRITE clause

     [ https://issues.apache.org/jira/browse/TAJO-431?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Work on TAJO-431 started by JaeHwa Jung.

> HCatalogStore can't write any data using INSERT OVERWRITE clause
> ----------------------------------------------------------------
>
>                 Key: TAJO-431
>                 URL: https://issues.apache.org/jira/browse/TAJO-431
>             Project: Tajo
>          Issue Type: Bug
>    Affects Versions: 0.8-incubating
>            Reporter: JaeHwa Jung
>            Assignee: JaeHwa Jung
>             Fix For: 0.8-incubating
>
>
> If I write INSERT OVERWRITE INTO clause using HCatalogStore, HCatalogStore can't write any data even though scan table has data. I found this bug as follows :
> {code:title=scan table |borderStyle=solid}
> tajo> select * from table1;
> Progress: 100%, response time: 1.402 sec
> final state: QUERY_SUCCEEDED, response time: 1.402 sec
> result: hdfs://localhost:9010/tmp/tajo-blrunner/staging/q_1387366394043_0002/RESULT, 5 rows (60 B)
> id,  name,  score,  type
> -------------------------------
> 1,  ooo,  1.1,  a
> 2,  ppp,  2.3,  b
> 3,  qqq,  3.4,  c
> 4,  rrr,  4.5,  d
> 5,  xxx,  5.6,  e
> {code}
> {code:title=insert query |borderStyle=solid}
> tajo> insert overwrite into table3 select * from table1;
> Progress: 0%, response time: 1.975 sec
> Progress: 100%, response time: 3.69 sec
> final state: QUERY_SUCCEEDED, response time: 3.69 sec
> OK
> {code}
> {code:title=target table | borderStyle=solid}
> tajo> select * from table3;
> Progress: 100%, response time: 0.216 sec
> final state: QUERY_SUCCEEDED, response time: 0.216 sec
> result: hdfs://localhost:9010/tmp/tajo-blrunner/staging/q_1387366394043_0004/RESULT, 0 rows (0 B)
> id,  name,  score,  type
> -------------------------------
> tajo> 
> {code}



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)