HIVE_UNSUPPORTED_FORMAT: Table StorageDescriptor is null

0

Hi, I am trying to run an SQL query from sagemaker R kernel notebook. I have connected to db using rJDBC and this works:

show_databases <- dbGetQuery(conn, "show databases")
show_databases

However running the following SQL query fails:

fetch <- dbGetQuery(conn,"select * from <db>.<table> limit 10")

with the error:

Error in dbSendQuery(conn, statement, ...): Unable to retrieve JDBC result set
  JDBC ERROR: [Simba][AthenaJDBC](100071) An error has been thrown from the AWS Athena client. HIVE_UNSUPPORTED_FORMAT: Table StorageDescriptor is null for table '<db>.<table>' {Name: o_interaction_event_90days,DatabaseName: <db>,Description: ,Owner: ,Retention: 0,ViewOriginalText: ,ViewExpandedText: ,TableType: ,Parameters: {___lake_formation_authorized_columns___={
  "authorizedColumns" : [ ]
}, ___table_owner_account_id___=<accID>, ___use_lakeformation_credentials___=false, __athena_nested_field_filter_enabled=true, ___use_lakeformation_row_column_security___=false},CreatedBy: ,IsRegisteredWithLakeFormation: false,TargetTable: {CatalogId: <catalogID>,DatabaseName: amevents,Name: <table>,},CatalogId: 882103560896,IsRowFilteringEnabled: false,DatabaseId: ,}

But when I run the same query in Athen it succeeds.

Any help is appreciated and I am happy to provide further details if needed.

  • Fixed the issue by adding my IAM role as Data lake administrator in the LakeFormation console.

Nessuna risposta

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande