SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software Kodyaz Development Resources
Development resources, articles, tutorials, code samples and tools and downloads for ASP.Net, SQL Server, R Script, Windows, Windows Phone, AWS, SAP HANA and ABAP, like SAP UI5, Screen Personas, etc.

Software Development



HIVE_UNKNOWN_ERROR: The specified bucket does not exist

While I was trying to create an AWS Athena table to query data from an Amazon S3 bucket where data is stored in parquet format files, I got following error message:

Your query has the following error(s):
HIVE_UNKNOWN_ERROR: The specified bucket does not exist (Service: Amazon S3; Status Code: 404; Error Code: NoSuchBucket;


I later realized that the error is caused because of the format of the S3 bucket and subfolder where the content files are stored
In table creation wizard, there is a hint message for AWS Athena users for identifying the S3 bucket and folders

s3://us-east-1.elasticmapreduce.samples/elb-access-logs/data/

On the other hand, the S3 location should be provided in the format of:
s3://input-data-set/logs/

Published Wednesday, August 12, 2020 5:05 PM

Comments

No Comments
Anonymous comments are disabled

About eralper

SQL Server administrator and T-SQL developer including BI components Web programming with HTML, HTML5 and ASP, ASP.NET and .NET Framework developer SAP ABAP and SAPUI5 development, Web Dynpro and Smart Form Siemens HiPath Center CTI development
Copyright © 2004 - 2020 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems