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 04:06:08 UTC

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

JaeHwa Jung created TAJO-431:
--------------------------------

             Summary: 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)