En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post

HIVE_UNKNOWN_ERROR: Path is not absolute: s3://u2b-cleansed-data

0

I have converted a json format file in parquet, I can see the parquet file and the columns, but while querying with Athena getting error. HIVE_UNKNOWN_ERROR: Path is not absolute: s3://u2b-cleansed-data This query ran against the "u2b_cleansed_data" database, unless qualified by the query. While doing "show create table", I am able to see location is 's3://u2b-cleansed-data' what can be the issue here?

Sujets
AnalytiqueSans serveurCalculBase de données
Balises
Amazon AthenaAWS LambdaAWS GlueExtraire, transformer et charger des donnéesAmazon Redshift
Langue
English
Divyanshu
demandé il y a 7 mois275 vues
1 réponse
0
Réponse acceptée

You should not put the table files directly under the bucket, all these systems assume there is a DataWarehouse path under which there is a folder for each table (even if you have one).
In your case the table path is null and that is problematic for many tools, that's why I think it means that "not absolute error" in this tool, on others you can just get a null path error.

profile pictureAWS
EXPERT
Gonzalo Herreros
répondu il y a 7 mois
  • Divyanshu
    il y a 7 mois

    Hi thanks, it worked, I just created a folder under that bucket and loaded my parquet there.

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents