[TAJO-431] HCatalogStore can't write any data using INSERT OVERWRITE clause.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.8.0
• Fix Version/s: 0.8.0
• Component/s: Catalog
• Assignee: JaeHwa Jung
• Reporter: JaeHwa Jung
• Created: 19/Dec/13 03:05
• Updated: 22/Dec/13 05:36
• Resolved: 22/Dec/13 03:52

Description

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 :

scan table

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

insert query

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

target table

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>