Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-431

HCatalogStore can't write any data using INSERT OVERWRITE clause.

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.8.0
    • Fix Version/s: 0.8.0
    • Component/s: Catalog
    • Labels:
      None

      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> 
      

        Attachments

        1. TAJO-431_2.patch
          6 kB
          Jaehwa Jung
        2. TAJO-431.patch
          3 kB
          Jaehwa Jung

          Activity

            People

            • Assignee:
              blrunner Jaehwa Jung
              Reporter:
              blrunner Jaehwa Jung
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: