Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-13013

Table not found after CONVERT TO ICEBERG in load-data

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Duplicate
    • Impala 4.4.0
    • None
    • None
    • None
    • ghx-label-12

    Description

      load-data fails with

      17:02:44 CREATE TABLE IF NOT EXISTS functional_parquet.iceberg_lineitem_sixblocks
      17:02:44 LIKE PARQUET '/test-warehouse/lineitem_sixblocks_iceberg/lineitem_sixblocks.parquet'
      17:02:44 STORED AS PARQUET
      17:02:44 LOCATION '/test-warehouse/lineitem_sixblocks_iceberg/'
      17:02:44 Summary: Returned 1 rows
      17:02:44 Success: True
      17:02:44 Took: 0.172425031662(s)
      17:02:44 Data:
      17:02:44 Table has been created.
      17:02:44 
      17:02:44 ALTER TABLE functional_parquet.iceberg_lineitem_sixblocks CONVERT TO ICEBERG
      17:02:44 Summary: Returned 1 rows
      17:02:44 Success: True
      17:02:44 Took: 1.37302303314(s)
      17:02:44 Data:
      17:02:44 Table has been migrated.
      17:02:44 
      17:02:44 ERROR: ALTER TABLE functional_parquet.iceberg_lineitem_sixblocks SET TBLPROPERTIES ('format-version'='2')
      17:02:44 Traceback (most recent call last):
      17:02:44   File "/data/jenkins/workspace/impala-cdw-master-staging-core/repos/Impala/bin/load-data.py", line 196, in exec_impala_query_from_file
      17:02:44     result = impala_client.execute(query)
      17:02:44   File "/data/jenkins/workspace/impala-cdw-master-staging-core/repos/Impala/tests/beeswax/impala_beeswax.py", line 191, in execute
      17:02:44     handle = self.__execute_query(query_string.strip(), user=user)
      17:02:44   File "/data/jenkins/workspace/impala-cdw-master-staging-core/repos/Impala/tests/beeswax/impala_beeswax.py", line 382, in __execute_query
      17:02:44     handle = self.execute_query_async(query_string, user=user)
      17:02:44   File "/data/jenkins/workspace/impala-cdw-master-staging-core/repos/Impala/tests/beeswax/impala_beeswax.py", line 376, in execute_query_async
      17:02:44     handle = self.__do_rpc(lambda: self.imp_service.query(query,))
      17:02:44   File "/data/jenkins/workspace/impala-cdw-master-staging-core/repos/Impala/tests/beeswax/impala_beeswax.py", line 539, in __do_rpc
      17:02:44     raise ImpalaBeeswaxException(self.__build_error_message(b), b)
      17:02:44 ImpalaBeeswaxException: ImpalaBeeswaxException:
      17:02:44  INNER EXCEPTION: <class 'beeswaxd.ttypes.BeeswaxException'>
      17:02:44  MESSAGE: AnalysisException: Could not resolve table reference: 'functional_parquet.iceberg_lineitem_sixblocks'
      

      IMPALA-12330 might help avoid this problem

      boroknagyz assigning to you for triage, please distribute as appropriate
       

      Attachments

        Issue Links

          Activity

            People

              boroknagyz Zoltán Borók-Nagy
              asherman Andrew Sherman
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: