You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I'm using presto version 0.257-df401fd.The hive metastore is on RDS Postgres. I tried to create a table on presto with the csv data on S3 using the following query
create table testing.csv_test (a varchar,b varchar)
WITH ( partitioned_by=ARRAY['b'],
external_location = 's3a://s3-bucket/path/to/folder/',
format = 'CSV')
The create table is successful but when tried to sync the partition
We are getting an error SQL Error [16777216]: Query failed (#20220708_071959_02186_pzp9i): org.apache.hadoop.hive.metastore.SerDeStorageSchemaReader class not found
After searching with few blogs as suggested edited the metasore-site.xml with the following property
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
I'm using presto version 0.257-df401fd.The hive metastore is on RDS Postgres. I tried to create a table on presto with the csv data on S3 using the following query
The create table is successful but when tried to sync the partition
call system.sync_partition_metadata ('testing','csv_test','full')
We are getting an error
SQL Error [16777216]: Query failed (#20220708_071959_02186_pzp9i): org.apache.hadoop.hive.metastore.SerDeStorageSchemaReader class not found
After searching with few blogs as suggested edited the metasore-site.xml with the following property
metastore.storage.schema.reader.impl=org.apache.hadoop.hive.metastore.SerDeStorageSchemaReader
Still getting the same error. Any idea/suggestion on how to proceed further?
Beta Was this translation helpful? Give feedback.
All reactions