Skip to content

OWN permissions not handled #558

@fannijako

Description

@fannijako

OWN permissions fail during 02-apply-permissions-tobackup-groups for view, table and schema as well

16:26:10 ERROR [databricks.labs.ucx.framework.parallel] {ThreadPoolExecutor-0_2} apply backup group permissions task failed: Action OWN cannot be granted on table `hive_metastore`.`ucx_test`.`sample_view`
Traceback (most recent call last):
  File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.10/site-packages/databricks/labs/ucx/framework/parallel.py", line 108, in inner
    return func(*args, **kwargs), None
  File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.10/site-packages/databricks/labs/ucx/framework/crawlers.py", line 133, in execute
    self._spark.sql(sql)
  File "/databricks/spark/python/pyspark/instrumentation_utils.py", line 47, in wrapper
    res = func(*args, **kwargs)
  File "/databricks/spark/python/pyspark/sql/session.py", line 1702, in sql
    return DataFrame(self._jsparkSession.sql(sqlQuery, litArgs), self)
  File "/databricks/spark/python/lib/py4j-0.10.9.7-src.zip/py4j/java_gateway.py", line 1322, in __call__
    return_value = get_return_value(
  File "/databricks/spark/python/pyspark/errors/exceptions/captured.py", line 194, in deco
    raise converted from None
pyspark.errors.exceptions.captured.AnalysisException: Action OWN cannot be granted on table `hive_metastore`.`ucx_test`.`sample_view`
16:26:10 ERROR [databricks.labs.ucx.framework.parallel] {ThreadPoolExecutor-0_5} apply backup group permissions task failed: Action OWN cannot be granted on table `hive_metastore`.`dbpentest_dev`.`test`
Traceback (most recent call last):
  File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.10/site-packages/databricks/labs/ucx/framework/parallel.py", line 108, in inner
    return func(*args, **kwargs), None
  File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.10/site-packages/databricks/labs/ucx/framework/crawlers.py", line 133, in execute
    self._spark.sql(sql)
  File "/databricks/spark/python/pyspark/instrumentation_utils.py", line 47, in wrapper
    res = func(*args, **kwargs)
  File "/databricks/spark/python/pyspark/sql/session.py", line 1702, in sql
    return DataFrame(self._jsparkSession.sql(sqlQuery, litArgs), self)
  File "/databricks/spark/python/lib/py4j-0.10.9.7-src.zip/py4j/java_gateway.py", line 1322, in __call__
    return_value = get_return_value(
  File "/databricks/spark/python/pyspark/errors/exceptions/captured.py", line 194, in deco
    raise converted from None
pyspark.errors.exceptions.captured.AnalysisException: Action OWN cannot be granted on table `hive_metastore`.`dbpentest_dev`.`test`

Metadata

Metadata

Assignees

Labels

migrate/groupsCorresponds to Migrate Groups Step of go/uc/upgrade

Type

No type

Projects

Status

No status

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions